truncate with foreign-key depends on DB.

for postgresql   : 
def clear_tbls():
    str1 = ','.join(  [ t  for t in db.tables() if "auth_" not in t]   )
    if len(str1):
         db.executesql( 'truncate {} RESTART IDENTITY'.format(str1)  )


понедельник, 14 ноября 2011 г., 3:38:15 UTC+3 пользователь Archibald Linx 
написал:
>
> Dear Web2py users, 
>
> How can I reset the database of my Web2py project ? 
>
> Thanks, 
> Archibald

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to [email protected].
For more options, visit https://groups.google.com/d/optout.

Reply via email to