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 <[email protected]>
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 <[email protected]> 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()
