[web2py] Re: web2py 2.6.1 is OUT - IMPORTANT READ

[Meir]

Hi Massimo!

Could describe best part: - new API jQuery('#component').reload()

Has some practical example?

And congratulations on the excellent work!

Em quinta-feira, 12 de setembro de 2013 19h27min37s UTC-3, Massimo Di 
Pierro escreveu:
>
> Web2py 2.6.1 is finally OUT. It needs some more testing.
>
> READ BELOW BEFORE UPGRADING
>
>  Attention all users: For pre 2.6 applications to work with web2py 
> >=2.6, you must copy static/js/web2py.js, controllers/appadmin.py, and 
> views/appadmin.html from the welcome app to your own apps (all of them).
>
>  Attention production users: The updated handlers and examples are in 
> handlers/ and examples/. The updated ones will not override the existing 
> ones. To use the new ones it is not sufficient to upgrade web2py, you also 
> need to copy the desired handler/example in the root web2py/ folder.
>
>  Attention MySQL users: The length of string fields changed from 255 
> to 512 bytes. If you have migrations enabled this will trigger a large 
> migration. To prevent it, first set migrate_enabled=False, upgrade, check 
> everything is ok, then add length=255 to your string Fields, then re-enable 
> migrations with migrate_enabled=True if needed.
>
> - better directory structure: handlers/ extras/ examples/
> - better MongoDb support, thanks Alan
> - better Admin editor interface, thanks Paolo, Roberto (codemirror 3), and 
> Lightdot
> - better layout.html and web2py_bootstrap.css, thanks Paolo
> - refactored web2py.js makes code more readable, thanks Niphlod
> - compute fields can depend on other compute(d) fields
> - more functions in appadmin (/manage/auth), thanks Anthony
> - support for CAST in SQL generation
> - new API jQuery('#component').reload()
> - new API rows.render()
> - new API table.field.referent, table._references
> - new API db(...).validate_and_update(...)
> - new API Wiki(..., force_render=True) renders the page source again 
> instead of using cached
> - Wiki now automatically parses named component arguments 
> @{f:a=1,b='twp',c=variable}
> - auth.get_or_create_user(login=False)
> - auth = Auth(crsf_protection = False) prevents creating sessions in 
> login/register forms.
> - enable multiple renderers in wiki, thanks Alan
> - log messages from Auth are no longer translated (for speed and 
> readability)
> - update jQuery mobile to 1.3.1
> - reduced memory footprint by conditionally loading Tk
> - faster pbkdf2 uses OpenSSL, thanks Michele
> - many speed improvements, thanks Michele
> - better session logic, prevents false positive when detecting session 
> changes.
> - scripts/import_static.py converts a static site to a web2py app 
> (experimental)
> - support for new http error code 451
> - profiler saves dump in dir, thanks Niphlod
> - upgraded pyfpdf, thanks Mariano
> - gluon/contrib/pdfinvoice.py for generating PDF invoices (assumes 
> reportlab)
> - no more double submission of forms (even without crsf protection), 
> thanks Niphlod
> - speedup for define_table, thanks Michele
> - settings.cfg to admin, thanks Paolo
> - many bugs fixed, thanks Niphlod, Michele, Roberto, Jonathan, and many 
> others
>

-- 
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/groups/opt_out.

[web2py] Re: Web2py fast introduction in Pycon Brazil

[Meir]

Hello Vinicius,

Congratulations and thanks for all the help you given me and web2py 
community!

Em terça-feira, 1 de outubro de 2013 11h57min53s UTC-3, viniciusban 
escreveu:
>
> Hi guys. 
>
> Yesterday I taught a quick introduction to Web2py here in Brazil, 
> during the first day of training in Pycon and Ploneconf event. 
>
> It was a 4 hour introduction. 
>
> I enphasized some pragmatic aspects of our beloved framework, 
> comparing it explictly with Django or Flask. 
>
> People liked particularly of: 
> - Instant "install" through unzip. 
> - A working initial Welcome application with embeded and fully 
> functional user registration and authentication and bootstrap, too. 
> - DAL syntax. 
> - Global request, response and session objects. 
> - Generic views. 
> - Embedded DB migrations. 
> - The fact we can touch the real developers in our discussion list. 
>
> Congratulations to you all, making it a wonderful framework. :-) 
>

-- 
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/groups/opt_out.

[web2py] LOAD web2py 2.5 - OK | LOAD web2py 2.6 nothing...

[Meir]

Hello community!

 

I have in my application using web2py 2.5 LOAD feature working perfectly.

I migrated my application to web2py 2.6 and stopped working LOAD, but not in 
error ...

 

Any idea?

-- 
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/groups/opt_out.

RES: [web2py] Re: LOAD web2py 2.5 - OK | LOAD web2py 2.6 nothing...

[Meir]

Hello master,

 

Thank you, that was exactly ...

Is the log: updated web2py, copy the files .js for application.

 

De: web2py@googlegroups.com [mailto:web2py@googlegroups.com] Em nome de
Anthony
Enviada em: quarta-feira, 2 de outubro de 2013 11:26
Para: web2py@googlegroups.com
Assunto: [web2py] Re: LOAD web2py 2.5 - OK | LOAD web2py 2.6 nothing...

 

Did you copy the new web2py.js file to your application?

On Wednesday, October 2, 2013 10:25:11 AM UTC-4, Meir wrote:

Hello community!

 

I have in my application using web2py 2.5 LOAD feature working perfectly.

I migrated my application to web2py 2.6 and stopped working LOAD, but not in
error ...

 

Any idea?

-- 
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/groups/opt_out.

-- 
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/groups/opt_out.

[web2py] Master / Detail with field value in the detail and overall value in the master

[Meir]

Hello community, all right?

 

I resolve an impasse ... I have a screen with Master / Detail. Detail is in
the SQLFORM.grid and I would like to update or insert a record in the detail
he added up the total value of a field that is in the Master.

 

What better way for this?

 

Remembering: The Detail SQLFORM.grid I use standard, non customizei nothing
...

-- 
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/groups/opt_out.

RES: [web2py] Re: Master / Detail with field value in the detail and overall value in the master

[Meir]

Thank you! I will test now!

But in the case of JavaScript that calls a delete, event exists to delete?

For this case must deduct the value in the header ...

 

De: web2py@googlegroups.com [mailto:web2py@googlegroups.com] Em nome de ??
Enviada em: quinta-feira, 3 de outubro de 2013 10:09
Para: web2py@googlegroups.com
Assunto: [web2py] Re: Master / Detail with field value in the detail and
overall value in the master

 

did you mean header detail? i think you can do it with oncreate (function
run on create event) and onupdate (function run on update event). first
create oncreate and onupdate function after then call it from your grid
function. 

e.g.

def __oncreate_function(form):

your function/query here

 

def __onupdate_function(form):

your function/query here

 

def grid_function():

grid = SQLFORM.grid(db.table_name, oncreate=__oncreate_function,
onupdate=__onupdate_function)

return locals()

 

hope this can help.

 

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/groups/opt_out.

-- 
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/groups/opt_out.

[web2py] Static column with value in query

[Meir]

Hello community,

I have a simple question about DAL: in some cases I write a query and 
create a static column has a default value, for example: 

select name, age, *'admin' as permission* from table_client

How can I set this using the DAL?

-- 
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/groups/opt_out.

RES: [web2py] Re: Static column with value in query

[Meir]

Hello!

 

I guess I was not clear in the question 

 

I wanted to replicate information that is static in the query, it does not
come from the database ...

 

Another example:

 

select name, address, phone number, 'marked' category from client   (MS-SQL)

 

In this case, the specific information 'marked' is replicated to all rows of
the query ...

 

De: web2py@googlegroups.com [mailto:web2py@googlegroups.com] Em nome de ??
Enviada em: quinta-feira, 17 de outubro de 2013 13:13
Para: web2py@googlegroups.com
Assunto: [web2py] Re: Static column with value in query

 

what do you mean about 'admin' as permission? is it user that has admin
membership or alias name for column name?

 

for query :

select name, age from table_client

you can do :

db().select(db.table_client.name, db.table_client.age)

 

ref:

http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer
 


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/groups/opt_out.

-- 
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/groups/opt_out.

Re: [web2py] Re: Static column with value in query

[Meir]

Perfect! Thanks!

Em quinta-feira, 17 de outubro de 2013 16h03min03s UTC-3, Niphlod escreveu:
>
> you can select an expression
>
> fixed_column = "'admin' as admin"
> rows = db(db.table).select(db.table.ALL, fixed_column)
> rows[0][fixed_column]  'admin'
>
> However, in python is much more easier to do then asking the db to do 
> it
>
> rows = db(db.table).select()
> for a in rows:
> a['whatever'] = 'admin'
> rows[0]['whatever'] -- 'admin'
>
>
>

-- 
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/groups/opt_out.

[web2py] LOAD e form.custom na view...

[Meir]

Hello!

I have the following questions:

I have a function(Def) that generates a FORM in my controller that invoke 
the view through the LOAD function.
But the view I used "form.custom", but the FORM LOAD brings in pure form 
generated by web2py ... I was clear in doubt?

In short: I need the LOAD respects the view of the way I rode, ie using 
"form.custo ..."

-- 
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/groups/opt_out.

[web2py] SQLFORM.grid to view and using groupby clause

[Meir]

Hello,

I have the following problem: I have created a view in the legacy database.
In this view created a field ID of type integer and unique.

I used SQLFORM.grid using fields = [...] to specify the fields that wanted 
and used the groupby = ... to perform clustering.
But it returns an error stating that the database must specify the ID in 
the group by clause 
Do not understand the reason for the error. If I put the ID in the groupby 
clause SQLFORM.grid, there does not generate the error, but my grid is not 
grouped because the ID is unique  :/

Anyone have any ideas?

-- 
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/groups/opt_out.

Re: [web2py] SQLFORM.grid to view and using groupby clause

[Meir]

Hello Johann,

It's why I created this view with the concept of cube to BI. I carry a lot 
of information forlater summarize according to the parameters of the users, 
but this I do in web2py.
I'm working with web2py like my small BI ...
Then the assembly is accomplished in various ways as defined by the user.

Thanks for your time!

Em quarta-feira, 13 de novembro de 2013 10h51min52s UTC-2, 
>
>
>> Hello,
>>
>> I have the following problem: I have created a view in the legacy 
>> database.
>> In this view created a field ID of type integer and unique.
>>
>> I used SQLFORM.grid using fields = [...] to specify the fields that 
>> wanted and used the groupby = ... to perform clustering.
>> But it returns an error stating that the database must specify the ID in 
>> the group by clause 
>> Do not understand the reason for the error. If I put the ID in the 
>> groupby clause SQLFORM.grid, there does not generate the error, but my grid 
>> is not grouped because the ID is unique  :/
>>
>> Anyone have any ideas?
>>
>> -- 
>> 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/groups/opt_out.
>>
>
>
>
> -- 
> Because experiencing your loyal love is better than life itself, 
> my lips will praise you.  (Psalm 63:3)
>  

-- 
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/groups/opt_out.

Re: [web2py] SQLFORM.grid to view and using groupby clause

[Meir]

Hello Johann,

It's why I created this view with the concept of cube to BI. I carry a lot 
of information forlater summarize according to the parameters of the users, 
but this I do in web2py.
I'm working with web2py like my small BI ...
Then the assembly is accomplished in various ways as defined by the user.

Thanks for your time!

Em quarta-feira, 13 de novembro de 2013 10h51min52s UTC-2, Johann Spies 
escreveu:
>
> Why not use the 'group by' in the creation of the view and then you can 
> just view the view using the grid with no need to group by again in the 
> grid?
>
> Regards
> Johann
>
>
> On 13 November 2013 03:06, Meir >wrote:
>
>>
>> Hello,
>>
>> I have the following problem: I have created a view in the legacy 
>> database.
>> In this view created a field ID of type integer and unique.
>>
>> I used SQLFORM.grid using fields = [...] to specify the fields that 
>> wanted and used the groupby = ... to perform clustering.
>> But it returns an error stating that the database must specify the ID in 
>> the group by clause 
>> Do not understand the reason for the error. If I put the ID in the 
>> groupby clause SQLFORM.grid, there does not generate the error, but my grid 
>> is not grouped because the ID is unique  :/
>>
>> Anyone have any ideas?
>>
>> -- 
>> 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/groups/opt_out.
>>
>
>
>
> -- 
> Because experiencing your loyal love is better than life itself, 
> my lips will praise you.  (Psalm 63:3)
>  

-- 
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/groups/opt_out.

[web2py] Re: web2py 2.8.1 is OUT

[Meir]

Hello Massimo, congratulations!!!

Hello Massimo, congratulations!

What would db().select().as_tree()? Has example?


Em quarta-feira, 27 de novembro de 2013 18h31min05s UTC-2, Massimo Di 
Pierro escreveu:
>
> Changelog
>
>
> - no more winservice (use nssm instead)
> - better imap support in DAL
> - db().select().as_tree()
> - bootstrap 2.3.2
> - codemirror 3.19
> - virtual fields in grid
> - improved  mongoDB support, thanks Alan
> - support for wiki custom render function
> - Wiki(...groups=['x','y']) allows bypassing default permissions
> - fixed websocket_messaging.py to support newer Tornado
> - NDB support for GAE, thanks Quint
> - fixed major concurrecy issue with MEMDB
> - blocked generic.jsonp for security reasons
> - many bug fixes, thanks Niphlod, Michele, Anthony, Tim, and many others.
>

-- 
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/groups/opt_out.

[web2py] web2py 2.8.1 -> What would db().select().as_tree()? Has example?

[Meir]

Hello!

Someone could inform the purpose and use of the db()select()as_tree()?

-- 
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/groups/opt_out.