When a model needs an order defined for creation, tg-admin sql drop doesn't do the right thing:
Model.py:
from sqlobject import *
soClasses = ('Source','Content')
class Source(SQLObject):
name = UnicodeCol()
contents = MultipleJoin('Content')
class Content(SQLObject):
body = UnicodeCol()
source = ForeignKey('Source')
kremer:testing $ tg-admin sql create
Using database URI postgres://db:passwd@localhost/testing
kremer:testing $ tg-admin sql drop
Using database URI postgres://db:passwd@localhost/testing
Traceback (most recent call last):
File "/usr/local/bin/tg-admin", line 7, in ?
sys.exit(
File "/opt/local/Library/Frameworks/Python.framework/Versions/2.4/lib/python2.4/site-packages/TurboGears-0.9a6-py2.4.egg/turbogears/command/base.py", line 275, in main
command.run()
File "/opt/local/Library/Frameworks/Python.framework/Versions/2.4/lib/python2.4/site-packages/TurboGears-0.9a6-py2.4.egg/turbogears/command/base.py", line 134, in run
command.the_runner.run(sys.argv)
File "/opt/local/Library/Frameworks/Python.framework/Versions/2.4/lib/python2.4/site-packages/SQLObject-0.7.1dev_r1675-py2.4.egg/sqlobject/manager/command.py", line 102, in run
runner.run()
File "/opt/local/Library/Frameworks/Python.framework/Versions/2.4/lib/python2.4/site-packages/SQLObject-0.7.1dev_r1675-py2.4.egg/sqlobject/manager/command.py", line 233, in run
self.command()
File "/opt/local/Library/Frameworks/Python.framework/Versions/2.4/lib/python2.4/site-packages/SQLObject-0.7.1dev_r1675-py2.4.egg/sqlobject/manager/command.py", line 604, in command
soClass.dropTable()
File "/opt/local/Library/Frameworks/Python.framework/Versions/2.4/lib/python2.4/site-packages/SQLObject-0.7.1dev_r1675-py2.4.egg/sqlobject/main.py", line 1311, in dropTable
conn.dropTable(cls.sqlmeta.table, cascade)
File "/opt/local/Library/Frameworks/Python.framework/Versions/2.4/lib/python2.4/site-packages/SQLObject-0.7.1dev_r1675-py2.4.egg/sqlobject/postgres/pgconnection.py", line 157, in dropTable
self.query("DROP TABLE %s %s" % (tableName,
File "/opt/local/Library/Frameworks/Python.framework/Versions/2.4/lib/python2.4/site-packages/SQLObject-0.7.1dev_r1675-py2.4.egg/sqlobject/dbconnection.py", line 305, in query
return self._runWithConnection(self._query, s)
File "/opt/local/Library/Frameworks/Python.framework/Versions/2.4/lib/python2.4/site-packages/SQLObject-0.7.1dev_r1675-py2.4.egg/sqlobject/dbconnection.py", line 219, in _runWithConnection
val = meth(conn, *args)
File "/opt/local/Library/Frameworks/Python.framework/Versions/2.4/lib/python2.4/site-packages/SQLObject-0.7.1dev_r1675-py2.4.egg/sqlobject/dbconnection.py", line 302, in _query
self._executeRetry(conn, conn.cursor(), s)
File "/opt/local/Library/Frameworks/Python.framework/Versions/2.4/lib/python2.4/site-packages/SQLObject-0.7.1dev_r1675-py2.4.egg/sqlobject/dbconnection.py", line 297, in _executeRetry
return cursor.execute(query)
psycopg.ProgrammingError: ERROR: cannot drop table source because other objects depend on it
HINT: Use DROP ... CASCADE to drop the dependent objects too.
DROP TABLE source
tg-admin sql drop should drop objects in the opposite order to creation.
(postgres8, OS X 10.4)
