I am trying to create tests for a model class that contains a foreign
key. When I run the tests that include the use of
turbogears.testutil.DBTest, the tests fail with the following trace:
Traceback (most recent call last):
File "C:\Python24\lib\site-packages\turbogears-1.0.4.4-py2.4.egg
\turbogears\testutil.py", line 197
, in tearDown
item.dropTable(ifExists=True)
File "c:\python24\lib\site-packages\SQLObject-0.10.0-py2.4.egg
\sqlobject\main.py", line 1343, in d
ropTable
conn.dropTable(cls.sqlmeta.table, cascade)
File "c:\python24\lib\site-packages\SQLObject-0.10.0-py2.4.egg
\sqlobject\dbconnection.py", line 48
3, in dropTable
self.query("DROP TABLE %s" % tableName)
File "c:\python24\lib\site-packages\SQLObject-0.10.0-py2.4.egg
\sqlobject\dbconnection.py", line 68
2, in query
return self._dbConnection._query(self._connection, s)
File "c:\python24\lib\site-packages\SQLObject-0.10.0-py2.4.egg
\sqlobject\dbconnection.py", line 33
4, in _query
self._executeRetry(conn, conn.cursor(), s)
File "c:\python24\lib\site-packages\SQLObject-0.10.0-py2.4.egg
\sqlobject\mysql\mysqlconnection.py"
, line 125, in _executeRetry
raise IntegrityError(msg)
IntegrityError: Cannot delete or update a parent row: a foreign key
constraint fails
This is obviously because I have the foreign key in my table and MySQL
won't drop the table. Is there a work around for to using DBTest in
my scenario, or do I need to come up with another testing strategy?
Would using sqlite for testing solve the problem?
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"TurboGears" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/turbogears?hl=en
-~----------~----~----~----~------~----~------~--~---
