[web2py] references in sqlite3

Hello. I have 3 tables, one of them default auth_user table, and other two are: db.define_table('table_A', Field('account_user', 'reference auth_user', readable=False ), Field('username', requires=IS_NOT_EMPTY(error_message=auth.message.is_empty)),

[web2py] Re: references in sqlite3

I don't understand where is the problem? Can you describe it again or better? Web2py adds id field into all tables as primary key, field of type 'reference tablename' or db.tablename became foreign keys. This is standard behaviour. If you want/need to modify this behaviour, you should read about

[web2py] Re: references in sqlite3

I solved this by re-defining tables. пятница, 3 июня 2016 г., 13:27:29 UTC+3 пользователь botass...@gmail.com написал: > > Hello. > > I have 3 tables, one of them default auth_user table, and other two are: > db.define_table('table_A', > Field('account_user', 'reference auth_user'

[web2py] Re: reading values from request.vars

Hard to say because it's not clear (a) what kind of data are in opt1, opt2, etc. (are they multi-select widgets producing lists or just single selects?) and (b) how the form inputs map to your database fields. Anthony On Thursday, June 2, 2016 at 11:55:13 PM UTC-4, ktesr123...@gmail.com wrote:

[web2py] error starting scheduler: error retreiving status

I am trying to start web2py scheduler with python web2py.py -K myapp on a Ubuntu 16.04 server with web2py 2.14.6-stable+timestamp.2016.05.10.00.21.47 (running on nginx/1.10.0, Python 2.7.11+) db connector is psycopg2 myapp is using a remote postgres database over ssl In the app every is worki

[web2py] Re: error starting scheduler: error retreiving status

Addition: I am using several schema's in the postgres database. The scheduler tables are in schema 'scheduler' Schema 'public' does not exist. Can this cause the problem? -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code)

[web2py] Re: web2py 2.14.4 is OUT

*Great! 😇What are some of the major updates in 2.14.4 – that we users should note or be aware of?* *On Tuesday, 12 April 2016 17:29:26 UTC-4, Massimo Di Pierro wrote:* > *web2py 2.14.4 is out.* > > It fixes some a problem with CAS and some style issues with examples. > It also includes (an

[web2py] Re: error starting scheduler: error retreiving status

what happens when you try to queue a task from the app ? AFAIK I'd be eager to know how can it work if there is no "public" schema, unless you tinkered with scheduler's table definitions On Friday, June 3, 2016 at 4:57:23 PM UTC+2, Bart wrote: > > Addition: > > I am using several schema's in the

[web2py] Re: reading values from request.vars

it is a single select, the values are populated from controller into a view dynamically in jquery On Friday, June 3, 2016 at 6:32:34 AM UTC-6, Anthony wrote: > > Hard to say because it's not clear (a) what kind of data are in opt1, > opt2, etc. (are they multi-select widgets producing lists or j

[web2py] Re: Is there a way to make scheduler tasks be picked by workers up even quicker?

long story short, no. You can get better "pick-up-times" (the time that elapses from when you queue the task to when it's started) with the redis version of the scheduler but in any case the worst possible scenario won't drop under "heartbeat" which is 3 seconds. Got it, would be wonderful if

Re: [web2py] Re: web2py 1.89.5

Damn it... It very old... I do have 1.88.2 and 1.91.something... But no 1.89.5 Sorry... I can only think of Massimo's that could help you with that... Richard On Thu, Jun 2, 2016 at 4:04 PM, Roman Molotkovski wrote: > Just checked the version file. It's says Version > 2.14.6-stable+timestamp.

[web2py] Modification in version 2.14.6 not documented ?

I have just seen this modification for parameter 'exportclasses' in grids. The manual say "If you pass a dict like dict(xml=False, html=False) you will disable the xml and html export formats", but with the last version you must change you code to pass a dict like this dict(tablename = dict(xm

[web2py] Re: error starting scheduler: error retreiving status

Hi Niphlod, Normally i just put a record in the scheduler_task table with appadmin. That works fine (no errors), but nothing happens because the scheduler worker is not running. In db.py the database schema is set via db.executesql("set search_path to auth,scheduler, ... ;") In case migrate i

[web2py] Re: Is there a way to make scheduler tasks be picked by workers up even quicker?

Thanks for the response :). I want to explain my situation a bit more if that's alright with you Niphlod (I'm a newbie at web dev haha). You're right, I think I can use a simple ajax request to do it instead, however I think the task may run a bit slower/make the UI a bit unresponsive? From my

Re: [web2py] web2py 1.89.5

On 5/26/16, Roman Molotkovski wrote: > > I've been looking for old versions of python and but I can't find anything > older than 2.0.2 (on github). > A previous thread in this group mentioned this link : h > ttp://code.google.com/p/web2py/source/list >

[web2py] Re: Is there a way to make scheduler tasks be picked by workers up even quicker?

an ajax request is just like a user hitting a page. They get queued until a thread from your web-workers is free (which is usually ALWAYS the case) and it gets executed right away. It'll definitely be quicker than the IPC done by the scheduler if you want semi-realtime execution. On Friday, J

[web2py] Re: Modification in version 2.14.6 not documented ?

is this on grid or smartgrid ? On Friday, June 3, 2016 at 7:15:33 PM UTC+2, omicron wrote: > > I have just seen this modification for parameter 'exportclasses' in grids. > The manual say "If you pass a dict like > dict(xml=False, html=False) > > you will disable the xml and html export formats",

Re: [web2py] web2py 1.89.5

On 6/3/16, Ricardo Pedroso wrote: > On 5/26/16, Roman Molotkovski wrote: >> >> I've been looking for old versions of python and but I can't find >> anything >> older than 2.0.2 (on github). >> A previous thread in this group mentioned this link : h >> ttp://code.google.com/p/web2py/source/list >>

Re: [web2py] web2py 1.89.5

Thanks a lot! I'll test it when I'll get the chance. Really appreciate the help. Roman On Friday, June 3, 2016 at 9:29:23 PM UTC+3, Ricardo Pedroso wrote: > > On 6/3/16, Ricardo Pedroso > wrote: > > On 5/26/16, Roman Molotkovski > wrote: > >> > >> I've been looking for old versions of python

[web2py] Re: error starting scheduler: error retreiving status

the scheduler though doesn't know anything about the search path when it rebuilds its own model... that's why setting search_path is undocumented ^_^ you can try fiddling with the source of the scheduler (along these lines https://github.com/web2py/web2py/blob/master/gluon/scheduler.py#L948) to

[web2py] When will the next conference on web2py

everything is in the title -- 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 "we

[web2py] cloudflare SSL on pythonAnywhere

using cloudflare SSL but does not make the alias seem to be secure: http://www.engagementsquared.com/ PythonAnywhere said their browser shows above as correctly certed by clouldFlare, but my browser does not. my host nameservers correctly state the clouldFlare server name anyone have exper

[web2py] Re: Modification in version 2.14.6 not documented ?

It's on smartgrid for my application Le vendredi 3 juin 2016 20:24:41 UTC+2, Niphlod a écrit : > > is this on grid or smartgrid ? > > On Friday, June 3, 2016 at 7:15:33 PM UTC+2, omicron wrote: >> >> I have just seen this modification for parameter 'exportclasses' in >> grids. The manual say "If

[web2py] Re: Modification in version 2.14.6 not documented ?

The documentation you quote is for SQLFORM.grid, but you are using SQLFORM.smartgrid, which lets you use most of the grid parameters, but within a dictionary keyed for each table of the smartgrid. Nothing has changed. Anthony On Friday, June 3, 2016 at 3:33:36 PM UTC-4, omicron wrote: > > It's

[web2py] Re: Is there a way to make scheduler tasks be picked by workers up even quicker?

On Friday, June 3, 2016 at 12:45:19 PM UTC-4, Niphlod wrote: > > long story short, no. > You can get better "pick-up-times" (the time that elapses from when you > queue the task to when it's started) with the redis version of the > scheduler but in any case the worst possible scenario won't drop

[web2py] Issure with web2py- Problem in handling MongoDB BSON ids

I think his is an issue with web2py and mongo db and combo. When using mongodb as application's database the primary key is for some docment look like this in monogdb- *26985031207145552773431411972*. While in mongoDB it's value is something like- 57317ea0f804663444afc504. *Now the problem i

[web2py] Re: reading values from request.vars

On Friday, June 3, 2016 at 12:35:49 PM UTC-4, ktesr123...@gmail.com wrote: > > it is a single select, the values are populated from controller into a > view dynamically in jquery > OK, so what's wrong with your current approach? What are you trying to achieve? Hard to help without seeing your co

[web2py] Issue with web2py and mongodb id's

I think his is an issue with web2py and mongo db and combo. When using mongodb as application's database the primary key is for some docment look like this in monogdb- *26985031207145552773431411972*. While in mongoDB it's value is something like- 57317ea0f804663444afc504. *Now the problem is

[web2py] Re: new feature in trunk

how to pass it to the view? -- 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] Re: error starting scheduler: error retreiving status

Thanks Niphlod, It works! I added self.db_thread.executesql("set search_path to scheduler, auth, ... ;") in gluon/scheduler.py after the self.db_thread = DAL( line and before the self.define_tables( ... line I am aware of the fact that it is not supported, but the database uses a strict s

[web2py] Re: new feature in trunk

okay, got this below to work but am confused about the resulting order data is displayed in. DATA post.id post.parent_id post.body

Re: [web2py] Re: web2py deployment: LetsEncrypt Nginx auto renew deployment script

Anthony, Any idea if the ISRG root CA is included in browsers yet? https://community.letsencrypt.org/t/which-browsers-and-operating-systems-support-lets-encrypt/4394 This is the most recent article I could find but it is over 6 months old. -Mark On Fri, May 27, 2016 at 7:31 AM, Anthony wrote:

[web2py] dumbest question ever: how do you jump to line in the w2p ide

I cant find this anywhere, but Ive seen it somewhere. Say Im editing in the admin application and want to jump to line 1000. Whats the key binding for it? Feel free to heckle as long as you also provide the answer ;) -- Resources: - http://web2py.com - http://web2py.com/book (Documentation)

[web2py] Re: Is there a way to make scheduler tasks be picked by workers up even quicker?

I just tried switching to a simple ajax call and like you said and it's much faster (and there's no unresponsiveness :) ) on pythonanywhere. When I test it locally I see a bit of unresponsiveness but I think that's because pythonanywhere has webworkers while locally there's only a single non-th

[web2py] Re: Using Sphinx to document web2py based application

Hi, Did you have decorators in your code when you made it work? If I have no decorator, the generation works with the includes but as soon as I have decorators, I can't manage make them known during the generation. Regards! On Thursday, 28 April 2016 00:11:43 UTC+2, Leonel Câmara wrote: > > I