Hello, I've got an application with a PostgreSQL backend that shares a small subset of tables with another application. At the moment, I have Web2Py defining all the tables and the expectation is that the other application just read information from the tables (and does what it likes with any other non Web2Py tables).
However, the other application has some fairly hard wired expectations of capitalised names for tables and fields. That isn't great for all sorts of reasons (like having to quote all the field and table names in any SQL queries): https://www.postgresql.org/docs/current/static/sql-syntax-lexical.html#SQL-SYNTAX-IDENTIFIERS What I'm trying to figure out is if there is a sensible workaround to accommodate this in the Web2Py app? Obviously, if I define the table through the DAL, then it converts everything to lower_case as the Postgres standard. That is, these two create the same table: db.define_table("Project", Field("Oid", length=64, default=uuid.uuid4), Field("contents","text")) db.define_table("project", Field("oid", length=64, default=uuid.uuid4), Field("contents","text")) >From the DB backend, I can create tables that have the required capitalisation, but one *must have* quoted identifiers. -- desired table create table "Project" (id SERIAL, "Oid" uuid, contents text); -- actually created table create table Project (id SERIAL, Oid uuid, contents text); Having tried some things I think I can answer my own question, I've found that the rname argument does seem to allow this to work! So the following Web2Py code, creates the 'desired table' as desribed in the SQL code above: db.define_table('project', Field('oid', length=64, default=uuid.uuid4, rname='"Oid"'), Field('contents','text'), rname='"Project"') I'm going to post this anyway in case anyone else runs into the issue - and in case there is a serious problem with this solution! Cheers, David -- 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 web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
