[web2py] Re: external sqlite3 database without id nor autoincrement declared

2011-02-25 Thread mart
I see. OK about to make the name change and will try it. Yeah, I guess your right about that thread and its relevance (I was probably grasping ;) ). I think, sooner or later, something will open up! If can just get passed having an empty table list (other wise I do have a DAL object, just can't

[web2py] Re: extra level of protection during delete migrations - necessary?

2011-02-25 Thread villas
Hi Carlos Before deployment I work like this: 1. Make sure that you get rid of all SQL keywords from your table and field names. Web2py has a feature for that -- use it. 2. Do your best to ensure your DB schema has become 'stable' before you go live with the system. Until the schema is stable I

[web2py] Re: web2py database administration

2011-02-25 Thread stargate
Maybe Massimo might need to jump on this. It could be a bug that we aren't even aware of. On Feb 25, 1:58 am, pbreit pbreitenb...@gmail.com wrote: I take that back. Appears to be used for approving registrations:http://web2py.com/book/default/chapter/08?search=registration_key

[web2py] Re: Creating an app with an already existing database

2011-02-25 Thread mart
thanks for the info! :) The interesting thing is... using DAL and SQLite from script (no web) works really great, and I don't know if I changed anything along the way (at least that I remember), but it seems that once the scripts are done I can not keep using the DB (which is fine because every

[web2py] Re: Table Alias

2011-02-25 Thread DenesL
Instead of using db.GlobalSettings you can assign it to a variable global_settings = db.GlobalSettings and use the var in place for all practical purposes e.g. db().select(db.GlobalSettings.ALL) becomes db().select(global_settings.ALL) On Feb 25, 11:04 am, Ross Peoples

[web2py] web2py getting some recognition

2011-02-25 Thread ron_m
https://groups.google.com/d/msg/comp.lang.python/iEV5oyLApHI/laV-P_Q6sG0J

[web2py] IS_DATE_IN_RANGE IS_NOT_IN_DB

2011-02-25 Thread greenpoise
How could I combine these two? I have a table that accepts two dates. I would not like duplicates between in those entry dates. Basically a From Date and a To Date Thanks Dan

Re: [web2py] Re: IS_DATE_IN_RANGE IS_NOT_IN_DB

2011-02-25 Thread Jonathan Lundell
On Feb 25, 2011, at 11:23 AM, greenpoise wrote: exactly, no overlapping date ranges If I were doing it, I think I'd start with a (renamed) copy of gluon.validators.IS_NOT_IN_DB in my model file, and change it to do a range check on two fields, instead of an equality check on one. I'm sort

Re: [web2py] Re: Table Alias

2011-02-25 Thread Ross Peoples
I guess this was more of a feature request, since I will soon have to tackle an application using PostgreSQL that forces case-sensitive naming. On Feb 25, 2011, at 3:03 PM, DenesL wrote: What issue?. On Feb 25, 11:32 am, Ross Peoples ross.peop...@gmail.com wrote: True, but I'd still

[web2py] Re: LOAD auth.change_password form and over-ride the Redirect on success

2011-02-25 Thread Carlos
Isn't the redirect automatically happening via auth.settings.change_password_next?, if this is the case, I believe you would need session.flash. Why are you using javascript's document.location=... instead of web2py's redirect?. The session.flash might be lost because of these javascript

[web2py] Re: IS_DATE_IN_RANGE IS_NOT_IN_DB

2011-02-25 Thread DenesL
True, and so the plot thickens... On Feb 25, 8:20 pm, Anthony abasta...@gmail.com wrote: On Friday, February 25, 2011 4:25:00 PM UTC-5, DenesL wrote: The problem is checking against all dates already in the DB. To avoid that I would have another table with the max(to_dates) and