Well, I don't see the error in the code, but if the error you are getting is 'foreign key constraint' then the problem is you are trying to truncate tables that are used as foreign keys for other tables. You generally have to truncate those tables that are referencing the table in question first (the order of operations is important) and then you can truncate those tables. This is also a side effect of having the foreign key referential actions set to 'no action' or 'restrict'. You'd want it to 'cascade' if you want to delete items in this manner, otherwise, you must reorder your operations to delete the leaf rows first.
On Tuesday, October 15, 2013 10:45:57 AM UTC-7, Auden RovelleQuartz wrote: > > > when I run this function, > > *def truncate_db_tables(the_db):* > * for table_name in the_db.tables():* > * the_db[table_name].truncate()* > * the_db.commit()* > * return()* > > > I get the following error (traceback provided below) - does anyone > understand what this means? > > Traceback > > 1. > 2. > 3. > 4. > 5. > 6. > 7. > 8. > 9. > 10. > 11. > 12. > 13. > 14. > 15. > 16. > 17. > 18. > 19. > 20. > 21. > 22. > 23. > 24. > 25. > 26. > 27. > 28. > 29. > 30. > 31. > 32. > 33. > 34. > 35. > 36. > 37. > 38. > 39. > 40. > 41. > 42. > 43. > 44. > 45. > 46. > > Traceback (most recent call last): > File "/home/www-data/web2py/gluon/restricted.py", line 212, in restricted > exec ccode in environment > File "/home/www-data/web2py/applications/omniavx/controllers/developer.py" > <https://omniavx.com/admin/default/edit/omniavx/controllers/developer.py>, > line 353, in <module> > File "/home/www-data/web2py/gluon/globals.py", line 194, in <lambda> > self._caller = lambda f: f() > File "/home/www-data/web2py/applications/omniavx/controllers/developer.py" > <https://omniavx.com/admin/default/edit/omniavx/controllers/developer.py>, > line 115, in testview5 > default_database_state_dev00() > File "/home/www-data/web2py/applications/omniavx/models/res_alpha.py" > <https://omniavx.com/admin/default/edit/omniavx/models/res_alpha.py>, line > 40, in default_database_state_dev00 > default_database_state_a00() > File "/home/www-data/web2py/applications/omniavx/models/res_alpha.py" > <https://omniavx.com/admin/default/edit/omniavx/models/res_alpha.py>, line > 27, in default_database_state_a00 > default_database_state_dev99() > File "/home/www-data/web2py/applications/omniavx/models/res_alpha.py" > <https://omniavx.com/admin/default/edit/omniavx/models/res_alpha.py>, line > 46, in default_database_state_dev99 > truncate_db_tables(db) > File "/home/www-data/web2py/applications/omniavx/models/res_alpha.py" > <https://omniavx.com/admin/default/edit/omniavx/models/res_alpha.py>, line > 2718, in truncate_db_tables > the_db[table_name].truncate() > File "/home/www-data/web2py/gluon/dal.py", line 8648, in truncate > return self._db._adapter.truncate(self, mode) > File "/home/www-data/web2py/gluon/dal.py", line 1425, in truncate > self.execute(query) > File "/home/www-data/web2py/gluon/dal.py", line 1784, in execute > return self.log_execute(*a, **b) > File "/home/www-data/web2py/gluon/dal.py", line 1778, in log_execute > ret = self.cursor.execute(command, *a[1:], **b) > File "/home/www-data/web2py/gluon/contrib/pg8000/dbapi.py", line 246, in _fn > return fn(self, *args, **kwargs) > File "/home/www-data/web2py/gluon/contrib/pg8000/dbapi.py", line 317, in > execute > self._execute(operation, args) > File "/home/www-data/web2py/gluon/contrib/pg8000/dbapi.py", line 322, in > _execute > self.cursor.execute(new_query, *new_args) > File "/home/www-data/web2py/gluon/contrib/pg8000/interface.py", line 399, > in execute > self._stmt.execute(*args, **kwargs) > File "/home/www-data/web2py/gluon/contrib/pg8000/interface.py", line 169, > in execute > self._row_desc, cmd = self.c.bind(self._portal_name, > self._statement_name, args, self._parse_row_desc, kwargs.get("stream")) > File "/home/www-data/web2py/gluon/contrib/pg8000/protocol.py", line 943, in > _fn > return fn(self, *args, **kwargs) > File "/home/www-data/web2py/gluon/contrib/pg8000/protocol.py", line 1142, > in bind > return reader.handle_messages() > File "/home/www-data/web2py/gluon/contrib/pg8000/protocol.py", line 911, in > handle_messages > retval = handler(msg, *args, **kwargs) > File "/home/www-data/web2py/gluon/contrib/pg8000/protocol.py", line 1181, > in _bind_nodata > reader.handle_messages() > File "/home/www-data/web2py/gluon/contrib/pg8000/protocol.py", line 916, in > handle_messages > raise exc > P > > -- 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/groups/opt_out.
