just when I was getting over "I would have used ``{{=rows}}``:template"
Mart ;) On Apr 29, 9:43 am, Massimo Di Pierro <massimo.dipie...@gmail.com> wrote: > Or in one line ;-) > > def deleteRecords(): [db[tbl].truncate() for tbl in db.tables if not > tbl.startswith('auth_') and not tbl in > ('local__user','local_history')] > > On Apr 29, 12:43 am, mart <msenecal...@gmail.com> wrote: > > > > > > > > > yup, that did it! AND... only those tables not in _tables! this is > > great! Thanks Massimo! :) > > > Mart :) > > > if anyone interested, this empties tables NOT specified in a list: > > > def deleteRecords(): > > _tables=['auth_user', > > 'auth_group', > > 'auth_membership', > > 'auth_permisssion', > > 'auth_event', > > 'local_user', > > 'local_history'] > > for tbl in db.tables: > > if not tbl in _tables:emptyTable(tbl) > > > def emptyTable(tbl): > > for mTbl in db.tables: > > if tbl in mTbl: > > if mTbl.startswith(tbl):db[tbl].truncate() > > > On Apr 29, 12:12 am, Massimo Di Pierro <massimo.dipie...@gmail.com> > > wrote: > > > > Instead of > > > > db(db[tbl].id>0).delete() > > > > you can use > > > > db[tbl].truncate() > > > > which is faster but does not work on GAE. > > > > On Apr 28, 8:18 pm, mart <msenecal...@gmail.com> wrote: > > > > > Hi, > > > > > I'm thinking this should work... its done through script. Should I be > > > > doing it differently? > > > > > thanks, > > > > Mart :) > > > > > def deleteRecords(): > > > > _tables=['auth_user', > > > > 'auth_group', > > > > 'auth_membership', > > > > 'auth_permisssion', > > > > 'auth_event', > > > > 'local_user', > > > > 'local_history'] > > > > for tbl in db.tables: > > > > if not tbl in _tables: > > > > db(db[tbl].id>0).delete()