Hi Anthony, pbreit,
The following line of code works just fine for *rname*. I was able
to save *state*, *date*, *module*, *notify *etc in the database table as
field names. Although I will make it a practice to use different field
names than those reserved/unreserved for future projects.
Field('notify', 'boolean', label='Add Notification?', rname='"notify"',
default=True ),
Note: without double quotes within single quotes it does not work.
*check_reserved* does not seem to have an impact I removed it and still it
worked properly and gave me postgres exceptions where required.
db = DAL('postgres://postgres:<dbparams>@localhost/base', pool_size=50,
lazy_tables=False) # This declaration works with it just fine. I'll be
making lazy_tables=True for performance boost later.
I am working regression testing and fixing migration bugs in the app.
Although so far all seems to be working well. Except collecting
user_statistics for each page. I will check the app and get back if I find
anything crucial. Thank you very much for all your help .
*Sincerely,*
*Rahul*
On Wednesday, July 25, 2018 at 4:37:39 AM UTC+5:30, Anthony wrote:
>
> I believe the DAL now always double quotes table and field names when
> constructing queries, so I'm not sure you even need to use check_reserved
> anymore. What happens if you simply remove it?
>
> Anthony
>
> On Tuesday, July 24, 2018 at 4:39:05 PM UTC-4, pbreit wrote:
>>
>> Apparently if you are going to use "rname" you may need to surround the
>> column name with single and double quotes which will send the double-quotes
>> to the DB:
>>
>> Field('state', rname='"state"')
>>
>> As an aside, it always seemed to me that a DB access library would be
>> able to be structured in such a way that reserved words would be a
>> non-issue. There are quite a few words on the list that I would like to use
>> (ie, state, group).
>>
>
--
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-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
