[web2py] Grid data is not displayed on using Edit/View in case there are two grids in one view
I am using two grids in my application but I have observed that when I use
Edit/View button for GRID1, then the layout of the grid is not proper (Data
from Grid1 is not seen) and default layout doesn't seems to be loaded.
NOTE :-
Since web2py doesn't supports two grids in one view, I am using LOAD for
one gird and second grid is loaded directly.
Reason, I want to display second grid directly is that I want to customize
the edit function for the grid.
Below is the sample Code
*Views :*
{{extend 'layout.html'}}
{{if grid.view_form:}}
{{=grid}}
{{elif grid.update_form:}}
{{=grid}}
{{else:}}
{{=grid}}
{{=LOAD('default','loadGrid1',ajax=True)}}
{{pass}}
*Controller :*
@auth.requires_login()
def index():
grid =
SQLFORM.grid(query=db.person,csv=False,create=False,deletable=False,paginate=20,sortable=True)
return dict(grid=grid)
def loadGrid1():
grid1 =
SQLFORM.grid(query=db.dog,csv=False,create=False,deletable=False,paginate=20,sortable=True)
return grid1
*Model :*
db.define_table('person',
Field('name'),
Field('countyry'))
db.define_table('dog',
Field('name'),
Field('ownername'))Models :
Can someone please help me to resolve this issue.
Thanks
Sarbjit
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
[web2py] Re: Bootstrap 3
I'll be happy also when it will be available. I think today websites must be designed for mobile devices, and Bootstrap 3 fits to this requirement. Il giorno domenica 8 giugno 2014 07:48:12 UTC+2, Osswalt ha scritto: > > Any plan to embed Bootstrap 3 into web2py ? > > Greg > -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
[web2py] web2py vs others. Status of 2014
what is the status of the evolution of web2py compared with other, mainly rails /or django ? which of these including web2py has gain more improvements over the last year? Does anybody knows? Is still web2py over the others? >From the beginning Massimo used the phrase "Ideas we had , ideas we stole" I would like to know if Massimo is stealing more ideas from others. Also what new "Killer" ideas are we expecting for near future? Regards António -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
Re: [web2py] RapydScript / RapydML - impressive
I think i need something like that. cleaner is simple to read .. 2014-06-09 3:35 GMT+01:00 nick name : > Does anyone have experience with RapydScript (lightweight py-like to JS > translator) and RapydML (pythonic-template to html/xml/svg translator)? > > Have just discovered them, and from a cursory examination they seem > extremely nice and useful. RapydScript seems to bridge the JS<->Python > bridge better than other projects I've looked at (PythonJS, Skulpt, > Pyjamas, Brython) - it goes much farther than Brython, for example, but > produces very readable and debuggable javascript that still works on IE8. > > RapydML explicitly shows how to support web2py in its documents ( ... as > well as plain html and django). > > Does anyone have any experience with them? > > https://github.com/atsepkov/RapydML > > https://github.com/atsepkov/RapydScript > > -- > Resources: > - http://web2py.com > - http://web2py.com/book (Documentation) > - http://github.com/web2py/web2py (Source code) > - https://code.google.com/p/web2py/issues/list (Report Issues) > --- > You received this message because you are subscribed to the Google Groups > "web2py-users" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to web2py+unsubscr...@googlegroups.com. > For more options, visit https://groups.google.com/d/optout. > -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
Re: [web2py] RapydScript / RapydML - impressive
interesting read from RapydML.
{% extends basic.html %}
For those unfamiliar with it, the above line includes HTML from basic.html
inside of the current page. This is a useful technique to avoid unnecessary
copies of HTML that's common to multiple pages (this includes navigation
menus, website logo, etc.). The above logic, however, can also be
substituted with RapydML's importstatement, importing RapydML logic from
another page. For example, I can create a template.pyml file, declararing a
function for generating a chunk of reusable HTML inside of it, and then
invoke that function in every place I want that HTML to appear. Which
solution is better?
If you're an experienced web developer, you probably know that on most
hosting services storage space (especially for text/html) is relatively
cheap compared to bandwidth and CPU usage. The bandwidth requirements in
this case are the same, since both, template engine and RapydML logic
happens before the page is served to the client. The main difference is
that by using extends, you force your template engine to dynamically
generate that HTML content before serving it to the client (using up CPU
cycles, smart engines will probably cache this data), while by using import you
make your compiler generate that HTML once and serve it repeatedly to your
clients (using up a bit more storage space, which is not even significant
when comparing it to storage taken up by images and other multimedia
files). As a rule of thumb, I recommend using RapydML's logic over
Django/Rails/web2py unless it's something that requires information that
will not be available until runtime (i.e. news that you retrieve from the
database, interactive form that deals with user input). It's not too
different from preferring CSS over JavaScript for styling that doesn't
change dynamically.
2014-06-09 14:51 GMT+01:00 António Ramos :
> I think i need something like that.
>
> cleaner is simple to read ..
>
>
> 2014-06-09 3:35 GMT+01:00 nick name :
>
> Does anyone have experience with RapydScript (lightweight py-like to JS
>> translator) and RapydML (pythonic-template to html/xml/svg translator)?
>>
>> Have just discovered them, and from a cursory examination they seem
>> extremely nice and useful. RapydScript seems to bridge the JS<->Python
>> bridge better than other projects I've looked at (PythonJS, Skulpt,
>> Pyjamas, Brython) - it goes much farther than Brython, for example, but
>> produces very readable and debuggable javascript that still works on IE8.
>>
>> RapydML explicitly shows how to support web2py in its documents ( ... as
>> well as plain html and django).
>>
>> Does anyone have any experience with them?
>>
>> https://github.com/atsepkov/RapydML
>>
>> https://github.com/atsepkov/RapydScript
>>
>> --
>> Resources:
>> - http://web2py.com
>> - http://web2py.com/book (Documentation)
>> - http://github.com/web2py/web2py (Source code)
>> - https://code.google.com/p/web2py/issues/list (Report Issues)
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "web2py-users" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to web2py+unsubscr...@googlegroups.com.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
Re: [web2py] create a link SQLFORM to another table with id.belongs
Hi Fabiano,
Thank you for your reply. What do you mean by *"edit the registry of URL
arguments are changed. "*
Here is my code:
def query_table2():
table2_records = []
table1_inv_record = request.args(0)
row = db(db.table1.id==table1_inv_record).select()
for line in row:
joined_records = line.inv_id
query=db.table1.id.belongs(joined_records)
grid=SQLFORM.grid(query, user_signature=False)
return dict(grid=grid)
view for query_table2.html:
{{=grid}}
On Friday, June 6, 2014 3:43:12 PM UTC-4, Fabiano Almeida wrote:
>
> invalid literal for int() with base 10:
> 'edit'
>
> In some part of your code has converting string to numeric type. Probably
> you should be picking up the URL argument and doing the conversion, but
> when you edit the registry of URL arguments are changed.
>
> In my example, I use session and try...except to resolve this.
>
>
>
> 2014-06-06 15:29 GMT-03:00 Fabiano Almeida >:
>
>> Show your code
>>
>>
>> 2014-06-06 15:18 GMT-03:00 LoveWeb2py >:
>>
>> Now I get this error when I try to click edit on the query database:
>>>
>>> invalid literal for int() with base 10:
>>> 'edit'
>>>
>>> I've tried changing signature to false, but I don't think thats the
>>> problem.
>>>
>>>
>>> On Friday, June 6, 2014 1:17:39 PM UTC-4, LoveWeb2py wrote:
>>>
yes
On Fri, Jun 6, 2014 at 1:09 PM, Fabiano Almeida >>> > wrote:
> Are you logged in your app?
>
>>
>>
>> On Friday, June 6, 2014 1:03:35 PM UTC-4, Fabiano Almeida wrote:
>>>
>>> Try:
>>>
>>> grid = SQLFORM.grid(db.table, user_signature=False)
>>>
>>> Em sexta-feira, 6 de junho de 2014 13h10min34s UTC-3, LoveWeb2py
>>> escreveu:
Hi Fabiano,
I actually was already using grid= SQLFORM.grid(db.new_table). That
is when I get the error.
If I do grid='' to test it and just return the table without
SQLFORM I can see it in the view, but when I apply SQLFORM I get the
error
'Rows' object has no attribute '_db'.
I'm guessing this is because of the way SQLFORM handles the grid?
Could there be something in my model messing it up?
On Friday, June 6, 2014 12:02:05 PM UTC-4, Fabiano Almeida wrote:
>
> Hi,
>
> You send var grid (see: return dict(grid=grid)). The first var
> grid is a send var to your view, de second var grid is a local
> var of your function.
>
> Then,
> in controller use:
> grid = SQLFORM.grid(db.new_table)
> return dict(grid=grid)
>
> in the view use:
> {{=grid}}
>
> Fabiano.
>
>
> 2014-06-06 12:45 GMT-03:00 LoveWeb2py :
>
>> SQLFORM isn't working for me with
>>
>>
>> new_table = db(db.table1.id.belongs(record_ids)).select()
>> if I do {{=new_table}} in my view I can see the records which
>> belong to record_ids, but if I do:
>>
>> SQLFORM.grid(new_table)
>> return dict(grid=grid)
>>
>>
>> I get an error 'Rows' object has no attribute '_db'
>>
>> --
>> Resources:
>> - http://web2py.com
>> - http://web2py.com/book (Documentation)
>> - http://github.com/web2py/web2py (Source code)
>> - https://code.google.com/p/web2py/issues/list (Report Issues)
>> ---
>> You received this message because you are subscribed to the
>> Google Groups "web2py-users" group.
>> To unsubscribe from this group and stop receiving emails from it,
>> send an email to web2py+un...@googlegroups.com.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
> --
>> Resources:
>> - http://web2py.com
>> - http://web2py.com/book (Documentation)
>> - http://github.com/web2py/web2py (Source code)
>> - https://code.google.com/p/web2py/issues/list (Report Issues)
>> ---
>> You received this message because you are subscribed to the Google
>> Groups "web2py-users" group.
>> To unsubscribe from this group and stop receiving emails from it,
>> send an email to web2py+un...@googlegroups.com .
>>
>> For more options, visit https://groups.google.com/d/optout.
>>
>
> --
> Resources:
> - http://web2py.com
> - http://web2py.com/book (Documentation)
> - http://github.com/web2py/web2py (Source code)
> - https://code.google.com/p/web2py/issues/list (Report Issues)
> ---
> You received this message because you are subscribed to a topic in the
> Google Groups "web2py-users" group.
> To unsubscribe from this topic, visit https://groups.google.com/d/
> topic/web2py/I8aGvbVcQxk/unsubscribe.
> To unsubscribe from this group and all its topics, send
Re: [web2py] create a link SQLFORM to another table with id.belongs
Hi,
Sorry for my poor english, by lazy, sometimes I use google translate
(portuguese -> english), and don't check the translation.
table1_inv_record = request.args(0)
In this line you get de first args, but on click to edit record in grid,
the function it's called again and url change args, then first args in url
is 'edit', and this is literal, not numerical.
row = db(db.table1.id==table1_inv_record).select()
In edit mode (and changed url), get error because var table1_inv_record is
not numerical at this time. I think this is a line in your traceback error.
So I use try...except block to convert first arg in integer, if ok, use
session to store de right id sent in the original url.
> alm = None # this is for prevent error case haven't args(0)
> if request.args: alm = request.args(0)
> try:
> if alm:
> alm = int(alm)
> *session.almoxarifado*=alm# this line executes only if the
> previous line no error
> except ValueError:
> pass
> Objeto.almoxarifado_id.default = *session.almoxarifado*
2014-06-09 13:47 GMT-03:00 LoveWeb2py :
> Hi Fabiano,
>
> Thank you for your reply. What do you mean by *"edit the registry of URL
> arguments are changed. "*
>
> Here is my code:
> def query_table2():
>table2_records = []
>table1_inv_record = request.args(0)
>row = db(db.table1.id==table1_inv_record).select()
>for line in row:
> joined_records = line.inv_id
>query=db.table1.id.belongs(joined_records)
>grid=SQLFORM.grid(query, user_signature=False)
>return dict(grid=grid)
>
> view for query_table2.html:
>{{=grid}}
>
>
>
> On Friday, June 6, 2014 3:43:12 PM UTC-4, Fabiano Almeida wrote:
>
>> invalid literal for int() with base 10:
>> 'edit'
>>
>> In some part of your code has converting string to numeric type. Probably
>> you should be picking up the URL argument and doing the conversion, but
>> when you edit the registry of URL arguments are changed.
>>
>> In my example, I use session and try...except to resolve this.
>>
>>
>>
>> 2014-06-06 15:29 GMT-03:00 Fabiano Almeida :
>>
>>> Show your code
>>>
>>>
>>> 2014-06-06 15:18 GMT-03:00 LoveWeb2py :
>>>
>>> Now I get this error when I try to click edit on the query database:
invalid literal for int() with base 10:
'edit'
I've tried changing signature to false, but I don't think thats the
problem.
On Friday, June 6, 2014 1:17:39 PM UTC-4, LoveWeb2py wrote:
> yes
>
>
> On Fri, Jun 6, 2014 at 1:09 PM, Fabiano Almeida > wrote:
>
>> Are you logged in your app?
>>
>>>
>>>
>>> On Friday, June 6, 2014 1:03:35 PM UTC-4, Fabiano Almeida wrote:
Try:
grid = SQLFORM.grid(db.table, user_signature=False)
Em sexta-feira, 6 de junho de 2014 13h10min34s UTC-3, LoveWeb2py
escreveu:
>
> Hi Fabiano,
>
> I actually was already using grid= SQLFORM.grid(db.new_table).
> That is when I get the error.
>
> If I do grid='' to test it and just return the table without
> SQLFORM I can see it in the view, but when I apply SQLFORM I get the
> error
> 'Rows' object has no attribute '_db'.
>
> I'm guessing this is because of the way SQLFORM handles the grid?
> Could there be something in my model messing it up?
>
> On Friday, June 6, 2014 12:02:05 PM UTC-4, Fabiano Almeida wrote:
>>
>> Hi,
>>
>> You send var grid (see: return dict(grid=grid)). The first var
>> grid is a send var to your view, de second var grid is a local
>> var of your function.
>>
>> Then,
>> in controller use:
>> grid = SQLFORM.grid(db.new_table)
>> return dict(grid=grid)
>>
>> in the view use:
>> {{=grid}}
>>
>> Fabiano.
>>
>>
>> 2014-06-06 12:45 GMT-03:00 LoveWeb2py :
>>
>>> SQLFORM isn't working for me with
>>>
>>>
>>> new_table = db(db.table1.id.belongs(record_ids)).select()
>>> if I do {{=new_table}} in my view I can see the records which
>>> belong to record_ids, but if I do:
>>>
>>> SQLFORM.grid(new_table)
>>> return dict(grid=grid)
>>>
>>>
>>> I get an error 'Rows' object has no attribute '_db'
>>>
>>> --
>>> Resources:
>>> - http://web2py.com
>>> - http://web2py.com/book (Documentation)
>>> - http://github.com/web2py/web2py (Source code)
>>> - https://code.google.com/p/web2py/issues/list (Report Issues)
>>> ---
>>> You received this message because you are subscribed to the
>>> Google Groups "web2py-users" group.
>>> To unsubscribe from this group and stop receiving emails from
>>> it, send an email to web2py+un...@goo
[web2py] Is there a web2py plugin which lays out divs in a neat grid?
Is anyone aware of a web2py plugin which can take a bunch of divs (let's say, of the same class name) and lay them out, in sequence, in a neat grid? I'm looking for something like the following jquery plugin: http://vnjs.net/www/project/freewall/. Thank you. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
Re: [web2py] Re: Adding information to certain input before added to db?
Other way is before and after callbacks
http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#before-and-after-callbacks
If necessary, you can call function:
db.table1._before_insert.append( lambda f: my_function(f))
This way you do not need to manually enter the registry
2014-06-07 13:19 GMT-03:00 Anthony :
> Aside from the code below, somewhat simpler approaches would be to
> manipulate request.post_vars *before* calling SQLFORM, or using an
> onvalidation function (which allows you to change form.vars after
> validation but before the db insert). With those approaches, you don't have
> to manually do the db insert.
>
>
> On Friday, June 6, 2014 11:02:21 PM UTC-4, 黄祥 wrote:
>>
>> i think you can achieve it using form.validate :
>> e.g.
>> def booking():
>> form = SQLFORM(db.booking_header)
>> if form.validate():
>> db.booking_header.insert(booking_date = form.vars.booking_date,
>> buyer = form.vars.buyer,
>> notes = form.vars.notes)
>>
>
> Note, to avoid having to explicitly list each field, you can simply do:
>
> db.booking_header.insert(**db.booking_header._filter_fields(form.vars
> ))
>
> That will insert all the fields in form.vars that belong to
> db.booking_header.
>
> Anthony
>
>
>> redirect(URL('report', 'report_booking') )
>> return dict(form = form)
>>
>> ref :
>> http://web2py.com/books/default/chapter/29/07/forms-and-validators
>>
>> best regards,
>> stifan
>>
> --
> Resources:
> - http://web2py.com
> - http://web2py.com/book (Documentation)
> - http://github.com/web2py/web2py (Source code)
> - https://code.google.com/p/web2py/issues/list (Report Issues)
> ---
> You received this message because you are subscribed to the Google Groups
> "web2py-users" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to web2py+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
>
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
[web2py] Determining the height or width of an HTML object before it is rendered?
Is there a server-side way in web2py to determine the height or width of an HTML object, as it would be rendered by the browser, if the object's height, width, and style have not been explicitly assigned (i.e. the height may be dependent on inner HTML objects/content)? Thanks. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
Re: [web2py] create a link SQLFORM to another table with id.belongs
No problem at all and I appreciate you trying to respond to English.
Is Object your table name and Almoxarifado_id is your id field in Objeto?
Objeto.almoxarifado_id
On Monday, June 9, 2014 1:30:49 PM UTC-4, Fabiano Almeida wrote:
>
> Hi,
>
> Sorry for my poor english, by lazy, sometimes I use google translate
> (portuguese -> english), and don't check the translation.
>
> table1_inv_record = request.args(0)
>
> In this line you get de first args, but on click to edit record in grid,
> the function it's called again and url change args, then first args in url
> is 'edit', and this is literal, not numerical.
>
> row = db(db.table1.id==table1_inv_record).select()
>
> In edit mode (and changed url), get error because var table1_inv_record
> is not numerical at this time. I think this is a line in your traceback
> error.
>
> So I use try...except block to convert first arg in integer, if ok, use
> session to store de right id sent in the original url.
>
>> alm = None # this is for prevent error case haven't args(0)
>> if request.args: alm = request.args(0)
>> try:
>> if alm:
>> alm = int(alm)
>> *session.almoxarifado*=alm# this line executes only if the
>> previous line no error
>> except ValueError:
>> pass
>> Objeto.almoxarifado_id.default = *session.almoxarifado*
>
>
>
>
>
>
> 2014-06-09 13:47 GMT-03:00 LoveWeb2py >:
>
>> Hi Fabiano,
>>
>> Thank you for your reply. What do you mean by *"edit the registry of URL
>> arguments are changed. "*
>>
>> Here is my code:
>> def query_table2():
>>table2_records = []
>>table1_inv_record = request.args(0)
>>row = db(db.table1.id==table1_inv_record).select()
>>for line in row:
>> joined_records = line.inv_id
>>query=db.table1.id.belongs(joined_records)
>>grid=SQLFORM.grid(query, user_signature=False)
>>return dict(grid=grid)
>>
>> view for query_table2.html:
>>{{=grid}}
>>
>>
>>
>> On Friday, June 6, 2014 3:43:12 PM UTC-4, Fabiano Almeida wrote:
>>
>>> invalid literal for int() with base 10:
>>> 'edit'
>>>
>>> In some part of your code has converting string to numeric type.
>>> Probably you should be picking up the URL argument and doing the
>>> conversion, but when you edit the registry of URL arguments are changed.
>>>
>>> In my example, I use session and try...except to resolve this.
>>>
>>>
>>>
>>> 2014-06-06 15:29 GMT-03:00 Fabiano Almeida :
>>>
Show your code
2014-06-06 15:18 GMT-03:00 LoveWeb2py :
Now I get this error when I try to click edit on the query database:
>
> invalid literal for int() with base 10:
> 'edit'
>
> I've tried changing signature to false, but I don't think thats the
> problem.
>
>
> On Friday, June 6, 2014 1:17:39 PM UTC-4, LoveWeb2py wrote:
>
>> yes
>>
>>
>> On Fri, Jun 6, 2014 at 1:09 PM, Fabiano Almeida <
>> fab...@techno7.com.br> wrote:
>>
>>> Are you logged in your app?
>>>
On Friday, June 6, 2014 1:03:35 PM UTC-4, Fabiano Almeida wrote:
>
> Try:
>
> grid = SQLFORM.grid(db.table, user_signature=False)
>
> Em sexta-feira, 6 de junho de 2014 13h10min34s UTC-3, LoveWeb2py
> escreveu:
>>
>> Hi Fabiano,
>>
>> I actually was already using grid= SQLFORM.grid(db.new_table).
>> That is when I get the error.
>>
>> If I do grid='' to test it and just return the table without
>> SQLFORM I can see it in the view, but when I apply SQLFORM I get the
>> error
>> 'Rows' object has no attribute '_db'.
>>
>> I'm guessing this is because of the way SQLFORM handles the grid?
>> Could there be something in my model messing it up?
>>
>> On Friday, June 6, 2014 12:02:05 PM UTC-4, Fabiano Almeida wrote:
>>>
>>> Hi,
>>>
>>> You send var grid (see: return dict(grid=grid)). The first var
>>> grid is a send var to your view, de second var grid is a local
>>> var of your function.
>>>
>>> Then,
>>> in controller use:
>>> grid = SQLFORM.grid(db.new_table)
>>> return dict(grid=grid)
>>>
>>> in the view use:
>>> {{=grid}}
>>>
>>> Fabiano.
>>>
>>>
>>> 2014-06-06 12:45 GMT-03:00 LoveWeb2py :
>>>
SQLFORM isn't working for me with
new_table = db(db.table1.id.belongs(record_ids)).select()
if I do {{=new_table}} in my view I can see the records which
belong to record_ids, but if I do:
SQLFORM.grid(new_table)
return dict(grid=grid)
I get an error 'Rows' object has no attribute '_db'
--
Resources:
- http:
Re: [web2py] create a link SQLFORM to another table with id.belongs
Objeto it's the table
almoxarifado_id it's a FK (reference field)
2014-06-09 14:48 GMT-03:00 LoveWeb2py :
> No problem at all and I appreciate you trying to respond to English.
>
> Is Object your table name and Almoxarifado_id is your id field in Objeto?
>
> Objeto.almoxarifado_id
>
>
> On Monday, June 9, 2014 1:30:49 PM UTC-4, Fabiano Almeida wrote:
>
>> Hi,
>>
>> Sorry for my poor english, by lazy, sometimes I use google translate
>> (portuguese -> english), and don't check the translation.
>>
>> table1_inv_record = request.args(0)
>>
>> In this line you get de first args, but on click to edit record in grid,
>> the function it's called again and url change args, then first args in url
>> is 'edit', and this is literal, not numerical.
>>
>> row = db(db.table1.id==table1_inv_record).select()
>>
>> In edit mode (and changed url), get error because var table1_inv_record
>> is not numerical at this time. I think this is a line in your traceback
>> error.
>>
>> So I use try...except block to convert first arg in integer, if ok, use
>> session to store de right id sent in the original url.
>>
>>> alm = None # this is for prevent error case haven't args(0)
>>> if request.args: alm = request.args(0)
>>> try:
>>> if alm:
>>> alm = int(alm)
>>> *session.almoxarifado*=alm# this line executes only if
>>> the previous line no error
>>> except ValueError:
>>> pass
>>> Objeto.almoxarifado_id.default = *session.almoxarifado*
>>
>>
>>
>>
>>
>>
>> 2014-06-09 13:47 GMT-03:00 LoveWeb2py :
>>
>> Hi Fabiano,
>>>
>>> Thank you for your reply. What do you mean by *"edit the registry of
>>> URL arguments are changed. "*
>>>
>>> Here is my code:
>>> def query_table2():
>>>table2_records = []
>>>table1_inv_record = request.args(0)
>>>row = db(db.table1.id==table1_inv_record).select()
>>>for line in row:
>>> joined_records = line.inv_id
>>>query=db.table1.id.belongs(joined_records)
>>>grid=SQLFORM.grid(query, user_signature=False)
>>>return dict(grid=grid)
>>>
>>> view for query_table2.html:
>>>{{=grid}}
>>>
>>>
>>>
>>> On Friday, June 6, 2014 3:43:12 PM UTC-4, Fabiano Almeida wrote:
>>>
invalid literal for int() with base 10:
'edit'
In some part of your code has converting string to numeric type.
Probably you should be picking up the URL argument and doing the
conversion, but when you edit the registry of URL arguments are changed.
In my example, I use session and try...except to resolve this.
2014-06-06 15:29 GMT-03:00 Fabiano Almeida :
> Show your code
>
>
> 2014-06-06 15:18 GMT-03:00 LoveWeb2py :
>
> Now I get this error when I try to click edit on the query database:
>>
>> invalid literal for int() with base
>> 10: 'edit'
>>
>> I've tried changing signature to false, but I don't think thats the
>> problem.
>>
>>
>> On Friday, June 6, 2014 1:17:39 PM UTC-4, LoveWeb2py wrote:
>>
>>> yes
>>>
>>>
>>> On Fri, Jun 6, 2014 at 1:09 PM, Fabiano Almeida <
>>> fab...@techno7.com.br> wrote:
>>>
Are you logged in your app?
>
>
> On Friday, June 6, 2014 1:03:35 PM UTC-4, Fabiano Almeida wrote:
>>
>> Try:
>>
>> grid = SQLFORM.grid(db.table, user_signature=False)
>>
>> Em sexta-feira, 6 de junho de 2014 13h10min34s UTC-3, LoveWeb2py
>> escreveu:
>>>
>>> Hi Fabiano,
>>>
>>> I actually was already using grid= SQLFORM.grid(db.new_table).
>>> That is when I get the error.
>>>
>>> If I do grid='' to test it and just return the table without
>>> SQLFORM I can see it in the view, but when I apply SQLFORM I get
>>> the error
>>> 'Rows' object has no attribute '_db'.
>>>
>>> I'm guessing this is because of the way SQLFORM handles the
>>> grid? Could there be something in my model messing it up?
>>>
>>> On Friday, June 6, 2014 12:02:05 PM UTC-4, Fabiano Almeida wrote:
Hi,
You send var grid (see: return dict(grid=grid)). The first var
grid is a send var to your view, de second var grid is a local
var of your function.
Then,
in controller use:
grid = SQLFORM.grid(db.new_table)
return dict(grid=grid)
in the view use:
{{=grid}}
Fabiano.
2014-06-06 12:45 GMT-03:00 LoveWeb2py :
> SQLFORM isn't working for me with
>
>
> new_table = db(db.table1.id.belongs(record_ids)).select()
> if I do {{=new_table}} in my view I can see the records which
> belong to record_ids, but if I do:
>>>
[web2py] Re: Adding information to certain input before added to db?
thank you so much for showing simpler version, anthony.
best regards,
stifan
On Saturday, June 7, 2014 11:19:27 PM UTC+7, Anthony wrote:
>
> Aside from the code below, somewhat simpler approaches would be to
> manipulate request.post_vars *before* calling SQLFORM, or using an
> onvalidation function (which allows you to change form.vars after
> validation but before the db insert). With those approaches, you don't have
> to manually do the db insert.
>
> On Friday, June 6, 2014 11:02:21 PM UTC-4, 黄祥 wrote:
>>
>> i think you can achieve it using form.validate :
>> e.g.
>> def booking():
>> form = SQLFORM(db.booking_header)
>> if form.validate():
>> db.booking_header.insert(booking_date = form.vars.booking_date,
>> buyer = form.vars.buyer,
>> notes = form.vars.notes)
>>
>
> Note, to avoid having to explicitly list each field, you can simply do:
>
> db.booking_header.insert(**db.booking_header._filter_fields(form.vars
> ))
>
> That will insert all the fields in form.vars that belong to
> db.booking_header.
>
> Anthony
>
>
>> redirect(URL('report', 'report_booking') )
>> return dict(form = form)
>>
>> ref :
>> http://web2py.com/books/default/chapter/29/07/forms-and-validators
>>
>> best regards,
>> stifan
>>
>
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
Re: [web2py] create a link SQLFORM to another table with id.belongs
Hi Fabiano,
I'm still trying to get this
For your Objeto.almoxarifado_id.default = session.almoxarifado
Shouldn't there be a db.Objeto.almoxarifado_id ? If I try to just put
table2.id I get an error saying table2 isn't defined.
Here is what I have so far
def query_table2():
table1_inv_record = None
table2_records = []
table1_inv_record = request.args(0)
row = db(db.table1.id==table1_inv_record).select()
for line in row:
joined_records = line.inv_id
if table1_inv_record:
inv1_record = int(table1_inv_record)
session.table1_id = inv1_record
query=db.table1.id.belongs(joined_records)
db.table1.id.default = session.table1.id
grid=SQLFORM.grid(query, user_signature=False)
return dict(grid=grid)
Still getting the same error though
My db.model is like this: db.define_table('table2',
Field('table1_inv_record', 'list:integer')
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
[web2py] Re: Determining the height or width of an HTML object before it is rendered?
I can't imagine any good reason as for why you would want to do this. You might be better off telling us what you're trying to accomplish so we can help you find a better way to do it. That said. You could do it with selenium, see, for instance, this stackoverflow question: http://stackoverflow.com/questions/15510882/selenium-get-coordinates-or-dimensions-of-element-with-python Anyway, don't do this, this is stupid. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
Re: [web2py] create a link SQLFORM to another table with id.belongs
def query_table2():
table1_inv_record = None
table2_records = []
if request.args:
try:
session.table1_id = int(request.args(0))
except:
pass
row = db(db.table1.id==session.table1_id).select()
for line in row:
joined_records = line.inv_id
query=db.table1.id.belongs(joined_records)
db.table1.id.default = session.table1_id
grid=SQLFORM.grid(query, user_signature=False)
return dict(grid=grid)
2014-06-09 17:09 GMT-03:00 LoveWeb2py :
> Hi Fabiano,
>
> I'm still trying to get this
>
> For your Objeto.almoxarifado_id.default = session.almoxarifado
>
> Shouldn't there be a db.Objeto.almoxarifado_id ? If I try to just put
> table2.id I get an error saying table2 isn't defined.
>
> Here is what I have so far
>
> def query_table2():
>table1_inv_record = None
>
>table2_records = []
>table1_inv_record = request.args(0)
>row = db(db.table1.id==table1_inv_record).select()
>for line in row:
> joined_records = line.inv_id
>if table1_inv_record:
> inv1_record = int(table1_inv_record)
> session.table1_id = inv1_record
>query=db.table1.id.belongs(joined_records)
>db.table1.id.default = session.table1.id
>grid=SQLFORM.grid(query, user_signature=False)
>return dict(grid=grid)
>
> Still getting the same error though
>
> My db.model is like this: db.define_table('table2',
> Field('table1_inv_record', 'list:integer')
>
> --
> Resources:
> - http://web2py.com
> - http://web2py.com/book (Documentation)
> - http://github.com/web2py/web2py (Source code)
> - https://code.google.com/p/web2py/issues/list (Report Issues)
> ---
> You received this message because you are subscribed to the Google Groups
> "web2py-users" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to web2py+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
>
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
Re: [web2py] create a link SQLFORM to another table with id.belongs
My db.py:
Almoxarifado = db.define_table('almoxarifado', Field('name'))
Objeto = db.define_table('objeto', Field('name'), Field('almoxarifado_id',
db.almoxarifado))
Objeto.almoxarifado_id.requires=IS_IN_DB(db, 'almoxarifado.id', '%(nome)s')
2014-06-09 17:09 GMT-03:00 LoveWeb2py :
> Hi Fabiano,
>
> I'm still trying to get this
>
> For your Objeto.almoxarifado_id.default = session.almoxarifado
>
> Shouldn't there be a db.Objeto.almoxarifado_id ? If I try to just put
> table2.id I get an error saying table2 isn't defined.
>
> Here is what I have so far
>
> def query_table2():
>table1_inv_record = None
>
>table2_records = []
>table1_inv_record = request.args(0)
>row = db(db.table1.id==table1_inv_record).select()
>for line in row:
> joined_records = line.inv_id
>if table1_inv_record:
> inv1_record = int(table1_inv_record)
> session.table1_id = inv1_record
>query=db.table1.id.belongs(joined_records)
>db.table1.id.default = session.table1.id
>grid=SQLFORM.grid(query, user_signature=False)
>return dict(grid=grid)
>
> Still getting the same error though
>
> My db.model is like this: db.define_table('table2',
> Field('table1_inv_record', 'list:integer')
>
> --
> Resources:
> - http://web2py.com
> - http://web2py.com/book (Documentation)
> - http://github.com/web2py/web2py (Source code)
> - https://code.google.com/p/web2py/issues/list (Report Issues)
> ---
> You received this message because you are subscribed to the Google Groups
> "web2py-users" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to web2py+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
>
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
Re: [web2py] create a link SQLFORM to another table with id.belongs
It's working! Thank you so much! I actually didn't need the
db.table1.id.default = session.table1.id
I think this was the line that fixed it:
row = db(db.table1.id==session.table1_id).select()
Thank you, thank you, thank you!! Such a huge help. Have a virtual beer on
me :)
Once
On Monday, June 9, 2014 4:38:04 PM UTC-4, Fabiano Almeida wrote:
>
> My db.py:
>
>
> Almoxarifado = db.define_table('almoxarifado', Field('name'))
>
> Objeto = db.define_table('objeto', Field('name'), Field('almoxarifado_id',
> db.almoxarifado))
> Objeto.almoxarifado_id.requires=IS_IN_DB(db, 'almoxarifado.id',
> '%(nome)s')
>
>
>
> 2014-06-09 17:09 GMT-03:00 LoveWeb2py >:
>
>> Hi Fabiano,
>>
>> I'm still trying to get this
>>
>> For your Objeto.almoxarifado_id.default = session.almoxarifado
>>
>> Shouldn't there be a db.Objeto.almoxarifado_id ? If I try to just put
>> table2.id I get an error saying table2 isn't defined.
>>
>> Here is what I have so far
>>
>> def query_table2():
>>table1_inv_record = None
>>
>>table2_records = []
>>table1_inv_record = request.args(0)
>>row = db(db.table1.id==table1_inv_record).select()
>>for line in row:
>> joined_records = line.inv_id
>>if table1_inv_record:
>> inv1_record = int(table1_inv_record)
>> session.table1_id = inv1_record
>>query=db.table1.id.belongs(joined_records)
>>db.table1.id.default = session.table1.id
>>grid=SQLFORM.grid(query, user_signature=False)
>>return dict(grid=grid)
>>
>> Still getting the same error though
>>
>> My db.model is like this: db.define_table('table2',
>> Field('table1_inv_record', 'list:integer')
>>
>> --
>> Resources:
>> - http://web2py.com
>> - http://web2py.com/book (Documentation)
>> - http://github.com/web2py/web2py (Source code)
>> - https://code.google.com/p/web2py/issues/list (Report Issues)
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "web2py-users" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to web2py+un...@googlegroups.com .
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
[web2py] RBAC access configuration - giving users permission to give other users permissions
I'd like to configure RBAC so that users can give other users permission to give others access. Do I need an additional table to do this or is it a matter of defining another group in the regular auth-group, auth-membership, auth-permissions tables? Example: All U.S. states will have (a) big-super-users that can give (b) smaller-super-users rights to give (c) regular users access. - So I give big-super-users rights to authorize smaller-super-users. - There's one big-super-user for each state. - There are too many small-super-users for me to manage, so the big-super-users manage them. - Small-super-users would for example give each person in each city of the state they're responsible for, rights to access the system. All I have to worry about is the big-super-users. Thanks, Alex Glaros -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
Re: [web2py] create a link SQLFORM to another table with id.belongs
Hi, Good! db.table1.id.default = session.table1.id > This line is used to insert new record automatically by SQLFORM. For the id field is unnecessary, it is useful when you want to set a default value, eg FK. All beers!! -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
[web2py] Re: Determining the height or width of an HTML object before it is rendered?
What was the problem with the approach mentioned above? Anyway, here is what I was trying to do: my page has a bunch of divs (let's call them cells), each containing content which makes their height distinct from other cells, while the width more or less remains constant. I'd like to arrange these cells in a grid within a parent "#content" div, specifying how many columns there should be in this grid, or alternatively, how wide each column should be. I've tried jquery plugins for this, but they come with their own set of problems, and it would probably be best if the grid were created within the controller, instead of the view (i.e. through jquery). To try to level out the height of the grid columns, it would be useful to know how tall each of the cells is. Any ideas for how to go about doing that? On Monday, June 9, 2014 3:17:10 PM UTC-5, Leonel Câmara wrote: > > I can't imagine any good reason as for why you would want to do this. You > might be better off telling us what you're trying to accomplish so we can > help you find a better way to do it. > > That said. You could do it with selenium, see, for instance, this > stackoverflow question: > > > http://stackoverflow.com/questions/15510882/selenium-get-coordinates-or-dimensions-of-element-with-python > > Anyway, don't do this, this is stupid. > -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
[web2py] Re: Bootstrap 3
Is something like this too ambitious? / impossible?... This product works great for me. It is currently used by the Plone project, License is New MIT. Obviously it would take some work to make it work with and/or integrate with web2py but it works very well. It allows you to install one or more themes using zip files which are easily installable and / or upgradable in a fasion that is very similar to installing web2py applications Here are some example themes (including one for an older bootstrap version) as examples how to create themes in the real world. http://plonethemes.org/free-themes Here is some propaganda from the project... "Diazo allows you to apply a theme contained in a static HTML web page to a dynamic website created using any server-side technology. With Diazo, you can take an HTML wireframe created by a web designer and turn it into a theme for your favourite CMS, redesign the user interface of a legacy web application without even having access to the original source code, or build a unified user experience across multiple disparate systems, all in a matter of hours, not weeks." Pypi listing diazo 1.0.5 https://pypi.python.org/pypi/diazo/1.0.5 License: New BSD Wikipedia Diazo Software http://en.wikipedia.org/wiki/Diazo_%28software%29 Diazo.org Diazo theme engine guide http://docs.diazo.org/en/latest/index.html Probably a big up front integration time investment but once it is completed Bob is your Uncle. C. On Sunday, June 8, 2014 12:03:28 PM UTC-4, Massimo Di Pierro wrote: > > we did, than we reverted. There is no consensus on how to do it because > the grid is not customizable enough and hardcodes the bs2 classes. We are > working on it. > > On Sunday, 8 June 2014 00:48:12 UTC-5, Osswalt wrote: >> >> Any plan to embed Bootstrap 3 into web2py ? >> >> Greg >> > -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
[web2py] Re: web2py vs others. Status of 2014
Good questions. Web2py has changed less in the last year than in the year before and most of the changes have been small improvements and strengthening security. In my view web2py is a very mature project and users do not want big changes at this point. We have some todo items including a more flexible grid, better CSS customization. I personally did not find much to learn from Django and Rails in the last few years instead I am much more interested in the async capabilities of Python 3.4, and in some javascript libraries like Angular, Ember, and Ractive (my favorite), by hypermedia APIs, and by Semantic-UI. I think the future is a lighter web2py with a similar IDE but more client-side logic out of the box and more automatic. For example I have ported the web2py helper system (DIV, SPAN, etc.) to JS. I would like to move form generation also clients-side. I would like move away from the MVC and to a mini-MVC patter where an action is responsible for a single component (for example validation) and not for an entire page. Wherever we are going the DAL is staying! Massimo On Monday, 9 June 2014 07:01:39 UTC-5, Ramos wrote: > > what is the status of the evolution of web2py compared with other, mainly > rails /or django ? > > > which of these including web2py has gain more improvements over the last > year? > Does anybody knows? > Is still web2py over the others? > > > From the beginning Massimo used the phrase > "Ideas we had , ideas we stole" > > I would like to know if Massimo is stealing more ideas from others. > Also what new "Killer" ideas are we expecting for near future? > > Regards > > António > -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
[web2py] Re: web2py vs others. Status of 2014
On Tuesday, June 10, 2014 9:14:03 AM UTC+7, Massimo Di Pierro wrote: > > Good questions. > > Web2py has changed less in the last year than in the year before and most > of the changes have been small improvements and strengthening security. In > my view web2py is a very mature project and users do not want big changes > at this point. We have some todo items including a more flexible grid, > better CSS customization. I personally did not find much to learn from > Django and Rails in the last few years instead I am much more interested in > the async capabilities of Python 3.4 > is that mean, the web2py developers is make web2py work under python 3.x? or perhaps create the other project same like web2py that work under python 3.x > and in some javascript libraries like Angular, Ember, and Ractive (my > favorite), by hypermedia APIs, and by Semantic-UI. > > I think the future is a lighter web2py with a similar IDE but more > client-side logic out of the box and more automatic. For example I have > ported the web2py helper system (DIV, SPAN, etc.) to JS. I would like to > move form generation also clients-side. I would like move away from the MVC > and to a mini-MVC patter where an action is responsible for a single > component (for example validation) and not for an entire page. > with the movement you've mention, is it still keep the backward compatiblity for the future version of web2py? when the newer version of web2py will be released? best regards, stifan -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
Re: [web2py] Re: Virtual Fields do not show in "details" view and are not searchable
On Fri, Jun 6, 2014 at 5:51 PM, Anthony wrote:
> Virtual field shows up OK in the "table" view, but :
>>
>
>> 1. It does not appear at all when I click on "View" button
>>
>
> By default, virtual fields don't show up in readonly forms, but you can
> list them in the "fields" argument. To pass the "fields" argument to the
> view form when using the grid, you can use the "viewargs" argument. Maybe
> something like:
>
> grid = SQLFORM.grid(db.mytable,
> viewargs={'fields': [f for f in db.mytable.__dict__
> if isinstance(db.mytable[f], (
> Field, Field.Virtual))]},
> ...)
>
> We should probably add an argument to SQLFORM to automatically include
> virtual fields in readonly forms.
>
Yes, This worked. Thanks !!!
>
>
>> 2. are not used for "default" search
>>
>
> This would be difficult, as it would require selecting *all* the records
> from the database, calculating the virtual fields for all records, and then
> searching the Rows object using Python. Currently the search functionality
> works by issuing a query to the database (i.e., the database does the
> searching and returns only the matching records), and because the virtual
> fields are not stored in the database, it is not possible for search to be
> based on them. If this is important, you might consider using a computed
> field instead.
>
Yes, I am considering that.
-Mandar
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
[web2py] SQLFORM does not submit,if displayed over jQuery load
Hi, in my default.py i have a simple function: def edit_posts(): form=SQLFORM(db.postos, request.args(0)).process() return dict(form=form) On my posts page, i have a table of all posts with a button, that calls a SQLFORM with a jQuery load, like this: Edit Until here, everything works ok. But the problem is, i canot update a post over this form. SQLFORM, whic is shown ad default/edit_posts/post.id works without problem. What am I missing here? Best, Kristjan -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
