Another option might
be
http://web2py.com/books/default/chapter/29/6#Using-DAL-without-define-tables.
Note, in that case, the table definitions will include the field names and
types, but not the non-database related web2py-specific attributes, such as
validators, labels, widgets, default values, etc.
Anthony
On Saturday, April 7, 2012 10:20:37 AM UTC-4, Massimo Di Pierro wrote:
>
> Do not se exec_environment.
>
> create a module (not a model) and in it put something like:
>
> from gluon import *
> def define_common_tables(db):
> request, response, session, cache, T = current.request,
> current.response, current.session, current.cache, current.T
> db.define_table('table1',....)
> db.define_table('table1',....)
> db.define_table('table1',....)
> db.define_table('table1',....)
>
>
> then wherever you need you import the module and call the function
> define_common_table(db) to define your tables.
>
>
> On Saturday, 7 April 2012 01:13:55 UTC-5, Ronghui Yu wrote:
>>
>> Hi, All,
>>
>> I would like to write some Python script for doing database house keeping
>> work, and I would like to reuse the table definitions defined in
>> models\db.py. But I am not able to import it since models is not a package,
>> and I was trying to use exec_environment() to do that, but it request a
>> complete setting of request, response, and session. I am just wondering if
>> there is a simple way to reuse the db definition, so that I could operate
>> on databsse in the script in the same way as that in controller.
>>
>> Thanks a lot
>>
>> --
>> ===========================
>> Regards
>> Ronghui Yu
>>
>
