[web2py] One settings file. Best practise?

2010-02-28 Thread Guido Kollerie
do want to check in db.py in my DVCS, but not the settings such as DB password, password of the SMTP user, and other potentially sensitive information. Thoughts? -- Guido Kollerie -- You received this message because you are subscribed to the Google Groups "web2py-users" group. To pos

[web2py] DAL syntax for sub-selects?

2010-02-02 Thread Guido Kollerie
Hi, Is web2py's DAL syntax rich enough to express sub-selects of the following form? select * from table_1, table_2, (select col_1 from some_table where ... group by col_1) as table_2 where -- Guido -- You received this message because you are subscri

Re: [web2py:38121] Dates

2009-12-31 Thread Guido Kollerie
On 31 dec 2009, at 09:19, Thadeus Burgess wrote: > Are dates stored in the database as UTC? Should depend on database configuration (timezone settting) I presume. > How do you convert the dates between UTC / locale ? Use pytz (http://pypi.python.org/pypi/pytz/) from datetime import datetime im

[web2py:32757] Re: strip whitespace before validating fields

2009-10-12 Thread Guido Kollerie
quot;" def __init__(self): pass def __call__(self, value): return (str(value).strip(), None) Worked well and being a validator is entirely optional. -- Guido Kollerie --~--~-~--~~~---~--~~ You received this message because you are subscribed t

[web2py:22169] Re: tools.py does not use rewrite.py wrapped URL()

2009-05-19 Thread Guido Kollerie
On 17-mei-2009, at 23:03, mdipierro wrote: Massimo, > fixed. please check trunk and let me know. Confirmed to have been fixed. Thanks for the impressive turn around time (once again) :-) -- Guido --~--~-~--~~~---~--~~ You received this message because you

[web2py:22036] tools.py does not use rewrite.py wrapped URL()

2009-05-17 Thread Guido Kollerie
gured out yet why tools.py doesn't reference the wrapped URL(). The wrapped URL() is in the environment passed to exec. I am puzzled. Anybody any idea what's going on? -- Guido Kollerie --~--~-~--~~~---~--~~ You received this message because you are su

[web2py:21585] Re: URL() does not honor routes.py AND /$c/$f syntax doesn't work

2009-05-10 Thread Guido Kollerie
id request BTW could someone reproduce the other (first) issue I described? (URL() does not honor routes.py) > Do not do > >> routes_out = [(x, y) for (y, x) in routes_in] Okay. -- Guido Kollerie --~--~-~--~~~---~--~~ You received this message be

[web2py:21570] URL() does not honor routes.py AND /$c/$f syntax doesn't work

2009-05-10 Thread Guido Kollerie
taken from web2py book with 'init' replaced by 'fubar') This time http://127.0.0.1:8000/default/data/tables does not even work! (Error: Invalid request) -- Guido Kollerie --~--~-~--~~~---~--~~ You received this message because you are subscribed

[web2py:20350] Re: Integrated Development Environment with web2py

2009-04-23 Thread Guido Kollerie
How do you get around this? > --~--~-~--~~~---~--~~ You don't. I wrote a blog post on this topic a couple of weeks ago. Shameless plug: http://kollerie.wordpress.com/2009/04/07/setting-up-your-ide-for-web2py-development/ -- Guido Kollerie --~--~-~--~~~---~--~

[web2py:19850] Re: web2py_path setting in gluon/main.py causing problems for scripts

2009-04-15 Thread Guido Kollerie
On 8-apr-2009, at 18:33, mdipierro wrote: > OK, uploading to trunk. Thanks. I see you have reverted the change: http://code.google.com/p/web2py/source/diff?spec=svn822&r=822&format=side&path=/trunk/gluon/main.py&old_path=/trunk/gluon/main.py&old=817 due to "__file__ caused problems on o

[web2py:19453] web2py_path setting in gluon/main.py causing problems for scripts

2009-04-08 Thread Guido Kollerie
In gluon/main.py somewhere around line 77 the variable web2py_path is being set as follows: web2py_path = os.environ.get('web2py_path', os.getcwd()) This variable is later used to read in the file VERSION. For simply running web2py this works beautifully. However I'm writing a small script

[web2py:19352] Form validators are being executed upon deleting a record

2009-04-07 Thread Guido Kollerie
Hi, Accidentally came across the following scenario which I suspect to have exposed a bug in Web2py. While working on an application I noticed I had identical values occurring in a particular column. E.g. given: db = SQLDB('sqlite://storage.db') db.define_table('person',SQLField('name

[web2py:17565] Re: 1.57: Can't define db in admin interface

2009-03-05 Thread Guido Kollerie
On 5-mrt-2009, at 19:56, mdipierro wrote: > This is in trunk and I think it is fixed. Can you give it a try? Seems to work just fine. Thanks! -- Guido --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "web2py Web

[web2py:17549] Re: 1.57: Can't define db in admin interface

2009-03-05 Thread Guido Kollerie
On 4-mrt-2009, at 14:49, mdipierro wrote: > I cannot reproduce this. Can you add some print statmenets to > applications/admin/controllers/default.py and try determine if is a > browser issue (as I think), a JS issue or a server side issue? I installed the Firefox plugin HttpFox to see what is

[web2py:17465] Re: 1.57: Can't define db in admin interface

2009-03-04 Thread Guido Kollerie
gn, edit db.py, if it is the first line. -- Guido Kollerie --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" group. To post to this group, send email to web2py@googlegroups.com T

[web2py:17396] Re: 1.57: Can't define db in admin interface

2009-03-03 Thread Guido Kollerie
On 2-mrt-2009, at 21:23, mdipierro wrote: > we only support 2.5. Could you please try that first? Done. Both with Python 2.5 as installed via Darwin Ports, as well as using the binary version of Web2py 1.57 that includes Python 2.5. The problem remains. However I tried something new. If I star

[web2py:17374] Re: From POST + query string turns request.vars.query into a list under Python 2.6

2009-03-03 Thread Guido Kollerie
On 3-mrt-2009, at 00:26, mdipierro wrote: Massimo, > I think I found the origin of this problem (it is a different > behaviour in the cgi module or possibly the browser). > In the appadmin.py of your app can you replace line 202 > >TR('', '', INPUT(_type='submit', _value='submit

[web2py:17342] Can't define a database [Was: [web2py:17288] web2py 1.57]

2009-03-02 Thread Guido Kollerie
On 2-mrt-2009, at 05:22, mdipierro wrote: > Lots of small bug fixes in the last week so I posted 1.57. Please give > it a try and let me know. Bought the Web2py book today from Lulu and started going through Image Blog example (section 3.6, page 51). However I can't get passed the database /mod

[web2py:17341] 1.57: Can't define db in admin interface

2009-03-02 Thread Guido Kollerie
On 2-mrt-2009, at 05:22, mdipierro wrote: > Lots of small bug fixes in the last week so I posted 1.57. Please give > it a try and let me know. Bought the Web2py book today from Lulu and started going through Image Blog example (section 3.6, page 51). However I can't get passed the database /mod

[web2py:17340] From POST + query string turns request.vars.query into a list under Python 2.6

2009-03-02 Thread Guido Kollerie
FYI, According to: http://docs.python.org/whatsnew/2.6.html#new-improved-and-deprecated-modules "The cgi module will now read variables from the query string of an HTTP POST request. This makes it possible to use form actions with URLs that include query strings such as