[web2py] Problem to pack all the application without past deleted file file

2016-02-02 Thread Alessio Varalta
Hi, I have a problem with my web2py application. I have worked for three weeks online in a debian server and i have created-deleted many files. My problem is if i make now a pack all and after i ricreate the application in locale web2py i see my file but after the old file that i have deleted.

[web2py] Re: .one() and .one_or_none() in DAL

2016-02-02 Thread Anthony
On Tuesday, February 2, 2016 at 2:41:22 AM UTC-5, Niphlod wrote: > > whatever_query.first() > do you really want an exception raised if no results are found and write > > try: > whatever_query.one() > except: > didn't find anything > > instead of > > if not whatever_query.first(): > d

[web2py] Re: Nested queries

2016-02-02 Thread Alfonso Serra
Yep thats right, i edited the post. that was just an example, they arent real tables in my project. I like plurals for tables since they are collections of records and singular for field names. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web

[web2py] Re: How to keep project separate from web2py itself?

2016-02-02 Thread Anthony
On Tuesday, February 2, 2016 at 2:38:59 AM UTC-5, Niphlod wrote: > > some things in web2py are not app-dependant so I guess it'll be quite not > possible to have a per-app folder. > Presumably if there were some configuration file mapping applications to folders (perhaps even in routes.py), it c

[web2py] Re: sequence of actions / general rules for code organization

2016-02-02 Thread Pierre
hello Anthony, by action concatenation I mean something like : result=funcc(funcb(funca(data))) I would like to stick to optimization recommandations so to disable sessions Since Byte compiling the app is also required, i intend to do this as well. Howewer in such case what happens if an unexp

[web2py] Re: Auth User split by tables

2016-02-02 Thread Anthony
On Monday, February 1, 2016 at 9:40:07 PM UTC-5, Ron Chatterjee wrote: > > Come to think Anthony, the best way to do it will be similar to this. > Having hidden field and tables and once selected the user_type, all the > other fields or tables shows up. > > > https://stackoverflow.com/questions/

[web2py] Re: sequence of actions / general rules for code organization

2016-02-02 Thread Anthony
On Tuesday, February 2, 2016 at 10:30:42 AM UTC-5, Pierre wrote: > > hello Anthony, > > by action concatenation I mean something like : > > result=funcc(funcb(funca(data))) > Still not clear what you are trying to achieve. Are you saying you want the user to visit several pages in succession, or

[web2py] Re: Duplicate entries in Auth_user DB table upon sign in

2016-02-02 Thread Michael Messmer
Yes it does. Submitted: https://github.com/web2py/web2py/issues/1178 On Wednesday, January 27, 2016 at 3:08:16 PM UTC-8, Massimo Di Pierro wrote: > > Are you saying that fixes it? Please submit your patch to git and we will > improve it if necessary. Thanks. > > > On Tuesday, 26 January 2016 16:

[web2py] Granular transactions on scheduled tasks

2016-02-02 Thread Antonio Salazar
I have a scheduled task that midway should divide its work in two database transactions. It's obvious it should db.commit() after the first transaction, but how do I start the second transaction? -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web

[web2py] Re: sequence of actions / general rules for code organization

2016-02-02 Thread Pierre
Yes Yes nothing extraordinary I just want to pass variables from one controller/function to another controller/function and so on and my question was is redirect the only way to do this ? as for visiting a predefined sequence of urls automatically: isn't this called a video ? :) -- R

Re: [web2py] Re: sequence of actions / general rules for code organization

2016-02-02 Thread Richard Vézina
redirect(URL('controller', 'function', 'args', 'vars_dict_where_the_stuff_you_want_to_pass_to_other_controller_goes')) Richard On Tue, Feb 2, 2016 at 1:05 PM, Pierre wrote: > Yes Yes > > nothing extraordinary > > I just want to pass variables from one controller/function to another > controller

Re: [web2py] autocomplete widget

2016-02-02 Thread Richard Vézina
This should be a name or id html field issue... Can you have a look at the HTML and tell us what is the name and id attributes values of these two widget? On Tue, Feb 2, 2016 at 2:21 PM, Pierre wrote: > > Is it only ONE autocomplete widget allowed per table ? > > this code uses 2 widgets but th

Re: [web2py] autocomplete widget

2016-02-02 Thread Richard Vézina
And does the second widget change the selected value of the first one ? Richard On Tue, Feb 2, 2016 at 2:25 PM, Richard Vézina wrote: > This should be a name or id html field issue... > > Can you have a look at the HTML and tell us what is the name and id > attributes values of these two widget

Re: [web2py] autocomplete widget

2016-02-02 Thread Richard Vézina
The code is here : https://github.com/web2py/web2py/blob/63bb4a7e8a39f466f6269e2f98c7b741d001def9/gluon/sqlhtml.py#L643 On Tue, Feb 2, 2016 at 2:27 PM, Richard Vézina wrote: > And does the second widget change the selected value of the first one ? > > Richard > > On Tue, Feb 2, 2016 at 2:25 PM,

[web2py] Re: sequence of actions / general rules for code organization

2016-02-02 Thread Pierre
allright thanks Richard now this is clear -- 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 G

[web2py] autocomplete widget

2016-02-02 Thread Pierre
Is it only ONE autocomplete widget allowed per table ? this code uses 2 widgets but the second autocomplete field is never filled : db.define_table('person', Field('name', unique=True, requires=IS_NOT_IN_DB(db,'person.name')), Field('country'), Fi

Re: [web2py] autocomplete widget

2016-02-02 Thread Richard Vézina
Is the models you show are the exact model definition you test? You did not define the persona and personb type which is 'reference person', which may cause the issue... Richard On Tue, Feb 2, 2016 at 2:30 PM, Richard Vézina wrote: > The code is here : > https://github.com/web2py/web2py/blob/6

[web2py] Re: Auth User split by tables

2016-02-02 Thread Ron Chatterjee
So, In my application. I have two user type. User and Tutor. Once they register, if user_type = 'User', I want it to go through the registration process and create a user_profile by redirecting to "user_profile". If user_type = 'Tutor', create a tutor_profile and get redirected in my default

[web2py] Re: Granular transactions on scheduled tasks

2016-02-02 Thread Niphlod
you have only one transaction at your disposal per connection... every command you send down the pipe gets queued and the queue can be commit()ted or rollback()ed. This queue of commands (in regards of multiple write operations, (update/insert/delete)) is atomically "executed" though a transacti

[web2py] Re: autocomplete widget

2016-02-02 Thread Pierre
No the second widget doesn't change the first widget selection here is the html : 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

[web2py] Re: autocomplete widget

2016-02-02 Thread Pierre
In fact Yes the second input replaces the first : personb replaces persona and personb ends up empty -- 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) --- Yo

Re: [web2py] Re: autocomplete widget

2016-02-02 Thread Richard Vézina
Did you try to set the type to these fields? db.define_table('thing', Field('name'), Field('persona', 'reference person'), Field('personb', 'reference person')) On Tue, Feb 2, 2016 at 3:10 PM, Pierre wrote: > In fact Yes > > > the second input rep

[web2py] Re: daily scheduler task

2016-02-02 Thread Tim Richardson
> > >> But of course it would be good to know what's going on here and why this >> can happen. >> > Must be unusual. I've been doing something similar for about two years over various web2py versions (on windows and ubuntu) and haven't seen this behaviour. -- Resources: - http://web2py.com -

Re: [web2py] Re: autocomplete widget

2016-02-02 Thread Richard Vézina
Pierre, You crop the interresting part... after the etc The error is surely coming from the jQuery which for some reason don't get generated properly by the widget... Richard On Tue, Feb 2, 2016 at 3:29 PM, Richard Vézina wrote: > Did you try to set the type to these fields? > > db.define

Re: [web2py] Re: autocomplete widget

2016-02-02 Thread Richard Vézina
If you can pack a dummy app to help us reproduce the problem it could help... Richard On Tue, Feb 2, 2016 at 3:31 PM, Richard Vézina wrote: > Pierre, > > You crop the interresting part... after the etc > > The error is surely coming from the jQuery which for some reason don't get > generate

[web2py] Re: Auth User split by tables

2016-02-02 Thread Anthony
auth.register() automatically does a redirect after registration, so to do your own redirect, you should either pass a callback as the onaccept argument to auth.register() or specify the callback via auth.settings.register_onaccept. Also, this condition: if (db.auth_user.user_type == 'User'):

Re: [web2py] Re: autocomplete widget

2016-02-02 Thread Richard Vézina
Error come from : https://github.com/web2py/web2py/blob/63bb4a7e8a39f466f6269e2f98c7b741d001def9/gluon/sqlhtml.py#L648 And here : https://github.com/web2py/web2py/blob/63bb4a7e8a39f466f6269e2f98c7b741d001def9/gluon/sqlhtml.py#L657 The widget can't use the same field name... There is already a ti

Re: [web2py] Re: autocomplete widget

2016-02-02 Thread Richard Vézina
You can workaround that problem like this : db.define_table('person', Field('name', unique=True, requires=IS_NOT_IN_DB(db,' person.name')), Field('country', 'string'), Field('age', 'integer')) db.define_table('thing', Field('name', '

[web2py] Re: sequence of actions / general rules for code organization

2016-02-02 Thread Anthony
On Tuesday, February 2, 2016 at 1:05:29 PM UTC-5, Pierre wrote: > > Yes Yes > > nothing extraordinary > > I just want to pass variables from one controller/function to another > controller/function and so on and my question was is redirect the only way > to do this ? > Sure, redirect is one poss

[web2py] Re: Auth User split by tables

2016-02-02 Thread Ron Chatterjee
You are the best Anthony! I did this: auth.settings.register_onaccept = lambda form: after_registration(form) in my model in my controller worked fine. Now all I want to do is append my menu with user profile (see attached). But user profile will have the same attributes like regular profile.

[web2py] Re: Granular transactions on scheduled tasks

2016-02-02 Thread Antonio Salazar
This is good for my case, basically I just need to commit whenever I want the current transaction to end, and a new one will begin. The "commit and rollback" section of the manual mentions this in the context of models, controllers, views and modules, but the scheduler is a special case of mode

[web2py] Re: Auth User split by tables

2016-02-02 Thread Anthony
> > I guess I can do this: > https://groups.google.com/forum/#!topic/web2py/AYORqIEpc9E > But that kills all the style. Then I got to custom style it. > Just look at the HTML generated by auth.navbar() and replicate that HTML, just making the changes you need in the links. Anthony -- Resourc

[web2py] Re: off topic: pg_dump syntax for pythonanywhere

2016-02-02 Thread Alex Glaros
got it to work but doesn't seem to match pythonAnywhere documentation: https://help.pythonanywhere.com/pages/RegularPostgresBackups for example, instead of "--name=" should be "--username=", and filename has extra error-causing parm ("mydb") -- Resources: - http://web2py.com - http://web2py.c

[web2py] Re: How to move Postgres apps?

2016-02-02 Thread Alex Glaros
is the correct method to do a "Pack Custom" without the "databases", then send the rest to the new site, along with the Postgres dump file? In other words would be sending 1. just code and other stuff (controller, static, db.py, etc) without data, and 2. pg_dump file separately 3.

[web2py] Re: Need method for authenticating on multiple fields

2016-02-02 Thread Cody Landry
I'm experimenting with this approach and cannot find a way to allow users that belong to different tenants to have the same username. Is this possible? On Wednesday, January 27, 2016 at 6:22:09 PM UTC-5, Massimo Di Pierro wrote: > > You could use multi-tenancy > > http://web2py.com/books/defaul

[web2py] Re: scheduler -- tracking the last time

2016-02-02 Thread Dave S
On Sunday, January 31, 2016 at 4:13:07 AM UTC-8, Niphlod wrote: > > > > On Sunday, January 31, 2016 at 7:12:41 AM UTC+1, Dave S wrote: >> >> >> >> On Saturday, January 30, 2016 at 8:50:32 PM UTC-8, Niphlod wrote: >>> >>> scheduler_run is the only way to keep track of executions. >>> >> >> And the