You can test it in recent DAL. It's still experimental, but well supported in PostgreSQL. Just add the following options when instantiating a new DAL object:
ignore_field_case=False, entity_quoting=True mic 2014-05-07 11:26 GMT+02:00 Álvaro J. Iradier <[email protected]>: > Back in 2011 I proposed using quoted identifiers for databases supporting > it: > > https://groups.google.com/d/msg/web2py/aSPtD_mGXdM/4Eflv-edEUEJ > > I think the check_reserved option is a valid fix, but databases like > PostgreSql that allow using any word as identifier by quoting it should use > this instead of checking for reserved words. It is a pain to hit this kind > of issue when migrating from one database to another. Could this be > rethinked again? > > Thanks. > > El martes, 6 de mayo de 2014 19:24:15 UTC+2, Rene Dohmen escribió: >> >> Hi Villas, >> >> page is a restricted word in postgres and some other DB's I think. We >> started development in web2py 1.99.1 with sqlite. >> it's a valid sqlite tableName. The problem for us is that we can't rename >> it very easing without breaking a lot of apps. >> The problem that we had with building a web2py plugin is that it's not so >> nice to overwrite db.py; and that has strict sql keyword checks in there by >> default. >> >> I will create a w2p file from it tomorrow. For now you can copy the git >> tree over an app; and it should work (when you have the needed deps) >> Online references: http://www.formatics.nl (it's 95% page module) >> >> Kind Regards >> >> Rene >> >> On Friday, February 28, 2014 1:34:50 AM UTC+1, villas wrote: >>> >>> Hi Rene >>> Is there a plugin now? >>> BTW the whole idea of using check_reserved is so you can avoid using >>> reserved names with new projects. Finding a way to avoid that so you can >>> use 'page' negates the purpose. >>> Thanks for your effort to release this work and it will be very nice to >>> see it in action! >>> Best wishes, D >>> >>> >>> On Thursday, 27 February 2014 20:07:21 UTC, Rene Dohmen wrote: >>>> >>>> This was solved a while ago :) >>>> >>>> On Friday, December 20, 2013 9:34:21 AM UTC+1, Ruud Schroen wrote: >>>>> >>>>> We are still working on a plugin. >>>>> But we are facing a problem regarding reserved keywords which prevents >>>>> us from creating a plugin. >>>>> >>>>> db = DAL('sqlite://storage.sqlite',pool_size=1,check_reserved=['all']) >>>>> check_reserved=['all'] needs to be removed in order for it to work >>>>> right now, the problem is you can't overrule it somewhere. >>>>> If anyone knows a solution that will be greatly appreciated, and we can >>>>> finally make a plugin for it. >>>>>> >>>>>> > -- > 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. -- 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.
