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.
