[web2py] DAL: reference to FK-field causes an error

2016-03-12 Thread Val K
Hi! I have a problem - look at example: db.define_table('a_tbl', Field('name')) db.define_table('b_tbl', Field('id', 'reference a_tbl') ,Field('name'), primarykey=['id']) db.define_table('c_tbl', Field('b_tbl_id', 'reference b_tbl') ,Field('name')) *c_tbl* definition causes an error (see below

[web2py] Re: DAL: reference to FK-field causes an error

2016-03-12 Thread 黄祥
pls try : db.define_table('b_tbl', Field('a_tbl_id', 'reference a_tbl') ,Field('name') ) db.define_table('c_tbl', Field('b_tbl_id', 'reference b_tbl') ,Field('name') ) i think in b_tbl, field id is already there as the integer auto increment primary key, so when you redefine another field with

[web2py] Re: DAL and schema

2016-03-12 Thread Alex
this thread is quite old, in the meantime there is already schema support in web2py with rname. e.g. db.define_table('mytable', rname='myschema.mytable') Alex On Friday, March 11, 2016 at 8:31:07 PM UTC+1, Ben Wolski wrote: > > executing the following query after defining my db in db.p

[web2py] Re: DAL: reference to FK-field causes an error

2016-03-12 Thread Val K
I explicitly define 'id' as primary key in b_tbl, in this case web2py creates table with id as just INTEGER (not incremental) - I've checked it, - it isn't problem The problem is that web2py doesn't perform recursively search for base type of referenced field. It consider that FK-field cou

[web2py] many session files

2016-03-12 Thread Alex
I've found out that we got around 2 million session files, although I'm regularly running sessions2trash.py to clean up old sessions. We got many users and requests but the number of sessions is still way too much. When a user (who is not logged in) makes a new request a new session file is cre

[web2py] Re: many session files

2016-03-12 Thread Leonel Câmara
How are you running sessions2trash is it running for the right application? -- 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 beca

[web2py] Re: many session files

2016-03-12 Thread Alex
> web2py.py --nogui --no-banner -S $3 -M -R scripts/sessions2trash.py -A -o -x 604800 yes, it's running for the right application, the server is slowed down because the script has to traverse so many files -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://gith

Re: [web2py] Re: Optimising caching and enabling gzip for web2py on heroku?

2016-03-12 Thread Kiran Subbaraman
Sure, you can use web2py on windows (with its bundled Rocket webserver) to serve your pages. But then Rocket webserver has limited configuration options, as listed on this page: http://web2py.com/books/default/chapter/29/13/deployment-recipes#Deployment-recipes--Infrastructure A suggestion is to

Re: [web2py] many session files

2016-03-12 Thread Kiran Subbaraman
I guess you have already taken a look at the sessions related documentation here: web2py.com/books/default/chapter/29/13/deployment-recipes * You could use "sessions.forget()", for cases where you do not want a sessions file to be issued. Maybe the scenario where the user is not logged i

Re: [web2py] Multiple connections/ databases with same app

2016-03-12 Thread Shayn Raney
I would like to implement something like for a project that uses two sqlite3 databases? I've tried to create the following within a new model via the web admin gui and did not see the new tables under the 'Available Databases and Tables' appadmin page. Does the 'Available Databases and Tables'

Re: [web2py] many session files

2016-03-12 Thread Alex
Usually I don't want to use session.forget because I store things like selected language for all users. The sessions work fine also for users who are not logged in (there is only one session file created for one user) so I can't explain why there are that many files. Anyone knows about the defa

[web2py] Re: Is Opencv threadsafe in web2py?

2016-03-12 Thread eric cuver
look you are tutorial http://www.learnopencv.com/tag/web2py/ Le vendredi 11 mars 2016 18:19:51 UTC+1, RAGHIB R a écrit : > > Are opencv stuffs thread-safe and is it okay to use them in web2py? > -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2p

[web2py] Re: DAL: reference to FK-field causes an error

2016-03-12 Thread Anthony
Not sure if it's a bug, but the book does say: - Keyed tables can only reference other keyed tables. - Referencing fields must use the reference tablename.fieldname format. Anthony On Saturday, March 12, 2016 at 4:52:53 AM UTC-5, Val K wrote: > > Hi! > I have a problem - look at example: >

[web2py] Re: DAL: reference to FK-field causes an error

2016-03-12 Thread Val K
OK! Let's dance This doesn't work (with SQLite at least): db.define_table('a_tbl', Field('id', 'integer'), Field('name'), primarykey=['id'] ) # one keyed table db.define_table('b_tbl', Field('id', 'reference a_tbl.id'), Field('name'), primarykey=['id']) # another keyed table near "name": synt

[web2py] Send Mail with AppRelay Server

2016-03-12 Thread Michael M
Hello, I was recently instructed to use our internal apprelay server for sending email internally. But one of the quirks of the server is that is does not require username or password. how do I do I got about doing that because when I comment out in the db.py and appconf.ini the lines that

[web2py] Send Mail with AppRelay Server

2016-03-12 Thread Michael M
Hello, I was recently instructed to use our internal apprelay server for sending email internally. But one of the quirks of the server is that is does not require username or password. how do I do I got about doing that because when I comment out in the db.py and appconf.ini the lines that

[web2py] Send Mail with AppRelay Server

2016-03-12 Thread Michael M
Hello, I was recently instructed to use our internal apprelay server for sending email internally. But one of the quirks of the server is that is does not require username or password. how do I do I got about doing that because when I comment out in the db.py and appconf.ini the lines that

[web2py] Re: DAL: reference to FK-field causes an error

2016-03-12 Thread Val K
I've solved my problem - just additional condition in dal\pydal\adapters\base.py: 298. 299. 300. 301. 302. 303. 304. 305. 306. 307. # must be PK reference or unique if rfield.type[:10] != 'reference ' and rfield.type[:14] != 'big-reference ' and \

[web2py] Re: DAL: reference to FK-field causes an error

2016-03-12 Thread Anthony
You can submit an issue to the pyDAL repo. On Saturday, March 12, 2016 at 6:03:10 PM UTC-5, Val K wrote: > > > I've solved my problem - just additional condition > in dal\pydal\adapters\base.py: > > 298. > 299. > 300. > 301. > 302. > 303. > > 304. > 305. > 306. > 307. > > > # mus

[web2py] Scheduler as a service RHEL 7

2016-03-12 Thread Michael M
Currently I have "/etc/systemd/system/web2py-scheduler.service": - [Unit] Description=Web2py Scheduler service chedulerService] ExecStart= /usr/bin/python /opt/www-data/web2py/web2py.py -K networktools -Q & Restart=always KillSignal=SIGQUIT Type=notify NotifyAcces

[web2py] Re: import error

2016-03-12 Thread Pierre Thibault
Is this bug fixed? Is Pygments working with web2py? Here the problem is that python modules loaded from the module folder of the app are using the key applications.xxx.module_name in sys.modules. So a lookup for module_name in sys.modules will probably result as a KeyError. Should we change the

[web2py] Re: Finnish language translator

2016-03-12 Thread Vinyl Darkscratch-Kazotetsu
My name is Vinyl Darkscratch and I am the founder of Nightwave Studios. We run a translation group known as Speak Louder (https://www.nightwave.me/speaklouder), and would be willing to help translate (for free) into any of the languages listed. Feel free to contact us here or on our form link

Re: [web2py] Re: SQLFORM.grid search with custom request.vars

2016-03-12 Thread Ashokkumar Nagarajan
Hi, I am new to Web2Py. Currently I am stuck with this issue. Any fix available for this issue ? Or anybody found any work around ? Thanks, Ashok On Friday, December 19, 2014 at 8:53:58 AM UTC-5, Paolo Valleri wrote: > > Hi, I create a PR https://github.com/web2py/web2py/pull/569 for this issue

[web2py] Update all languages not catching Markmin

2016-03-12 Thread Vinyl Darkscratch-Kazotetsu
I've been having this issue since updating to the most recent web2py version. On two of the sites I have coded, Markmin is extensively used. Unfortunately, I've noticed that calls to T.M() aren't being detected in the language file updates, which means that I am unable to obtain most of my co

[web2py] web2py tutorials?

2016-03-12 Thread Moreplavec
Greetings, looking for good Python framework to help me with my simple web apps. I tried other frameworks and their recommended tutorials, but i have problem to find any easy to follow and up-to-date for Web2Py. Please, can you help me and point me to good one? I need some simple but usefull be

Re: [web2py] combine Autocomplete widget and SELECT_OR_ADD_OPTION widget

2016-03-12 Thread narges Rezaei
> > hello dear i cant move dialog object in this code to the page center how move it? from gluon.sqlhtml import * class SELECT_OR_ADD_OPTION(object): def __init__(self, controller=None, function=None, form_title=None, button_text = None, dialog_width=500 ): if form_title == None:

[web2py] Re: About Cubaconf

2016-03-12 Thread Massimo Di Pierro
It is a bit on a short notice. I would love to attend. I will check next week if I can make it work. On Friday, 11 March 2016 07:54:51 UTC-6, Carlos Cesar Caballero wrote: > > Hi everyone!! in the next April (25-27) will be taking place a Free (Open > source) software international conference (h

[web2py] Re: for those of us who do not understand ...

2016-03-12 Thread Massimo Di Pierro
Good point. I added some ore widgets. Still working on them. Will be done tomorrow. On Thursday, 10 March 2016 20:25:04 UTC-6, Leonel Câmara wrote: > > Massimo you need to detect mouseleave in the number slider widget. > Otherwise I can click with the mouse drag a little bit, then keeping the >

[web2py] Re: Finnish language translator

2016-03-12 Thread Massimo Di Pierro
Thank you for the offer. This is fantastic. Will contact you personally. On Saturday, 12 March 2016 23:42:05 UTC-6, Vinyl Darkscratch-Kazotetsu wrote: > > My name is Vinyl Darkscratch and I am the founder of Nightwave Studios. > We run a translation group known as Speak Louder ( > https://www.n

Re: [web2py] Finnish language translator

2016-03-12 Thread Vinyl Darkscratch-Kazotetsu
Looking forward to it, Di Pierro! - VD, Nightwave Studios > On Mar 12, 2016, at 21:53, Massimo Di Pierro > wrote: > > Thank you for the offer. This is fantastic. Will contact you personally. > > On Saturday, 12 March 2016 23:42:05 UTC-6, Vinyl Darkscratch-Kazotetsu wrote: > My name is Vinyl D

[web2py] Re: Can't get rid of flash message in admin interface

2016-03-12 Thread Massimo Di Pierro
What browser? What os? On Saturday, 12 March 2016 23:42:06 UTC-6, Anh Tran wrote: > > Hi, > > I have this issue, when I logged in into the admin interface, I see this > empty flash message (see attached screenshot). > How can I get rid of that? And I can't even close the flash message (which > s

[web2py] Re: Update all languages not catching Markmin

2016-03-12 Thread Massimo Di Pierro
Most recent stable or trunk? On Saturday, 12 March 2016 23:42:06 UTC-6, Vinyl Darkscratch-Kazotetsu wrote: > > I've been having this issue since updating to the most recent web2py > version. On two of the sites I have coded, Markmin is extensively used. > Unfortunately, I've noticed that call