just when I was getting over
"I would have used ``{{=rows}}``:template"
Mart ;)
On Apr 29, 9:43 am, Massimo Di Pierro <[email protected]>
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 <[email protected]> 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 <[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()
