Massimo,
I think it is very simple to support schemas: you should simply allow a .
(dot) in table name.
So that we can define a table like this:
db.define_table('myschema.mytable', Field(....), ...)
This syntax now raises an exception:
SyntaxError: only [0-9a-zA-Z_] allowed in table and field names, receiving
myschema.mytable
In this way generated sql query will be like:
select * from myschema.mytable
which is exactly what I need.
I think that also joins between tables from different schemas will work
well.
Thank you.
Il giorno sabato 24 marzo 2012 00:51:56 UTC+1, Massimo Di Pierro ha scritto:
>
> I am not sure if this can be done or not. If not supported, we can add
> support. Can you open a ticket and post an example of how to do it in SQL?
>
>
>
