[web2py] Re: dynamic mysql columns

2010-04-13 Thread DenesL
Very interesting method. In theory all tables can be defined and generated this way. Tables could be defined via forms, enforcing the proper creation sequence (tables with fields that reference other tables will have to be created later in the process). Or the generation has to be controlled via a

[web2py] Re: dynamic mysql columns

2010-04-10 Thread mdipierro
In web2py you can do something like: # define a table 'meta' that describes another table 'from_meta' db.define_table('meta',Field('colname'),Field('coltype')) # make sure it contains something if not db(db.meta.id>0).count() db.meta.insert(colname='your_name',coltype='string')) # define from_m