Hi,
I need to create some tables dynamically (SQLite). Creating them is
fine, but when comes time to use, well that just isn't working...
I'm doing this to for some automation where I don't know in advance
how many tables will be created or even what they will be called...
I tried a few things, but i don't think we can use variables when
referencing tables?
For example, if I do something simple like:
lets say I'm looking for tables that contain sync logs, where the
dynamically created table name would be named using a defined
structure like <name>P4<taskName> (i.e. coreP4sync).
I can do :
define_table("{0}{1}{2}".format(name,repoType,task),
Field('fileName'),
Field('fileSize','integer'))
So, I may end up any number of of these tables. How can I simply look
up the table names, see if any of them match the pattern, then do
stuff accordingly?
seems that something like below would never work?: Is there a work
around?
for pTable in db.tables:
if 'P4Sync' in pTable:
if string.split(pTable,'P4')[0] == 'core':
db(db.pTable.id > 0) blablablabla ....
Thanks,
Mart :)
