Hi,
the following simple script fails to run when using SQLObject 0.8.0.
It works fine when using SQLObject 0.7.3.
---
from sqlobject import *
sqlhub.processConnection = connectionForURI('mysql://[EMAIL PROTECTED]/test')
class Person(SQLObject):
name = StringCol()
class Shortcut(SQLObject):
person = ForeignKey('Person')
Person.dropTable(ifExists=True)
Person.createTable(ifNotExists=True)
Shortcut.dropTable(ifExists=True)
Shortcut.createTable(ifNotExists=True)
---
Traceback (most recent call last):
File "0.8.py", line 15, in <module>
Shortcut.createTable(ifNotExists=True)
File
"c:\python25\lib\site-packages\sqlobject-0.8.0-py2.5.egg\sqlobject\main.py",
line 1394, in createTable
conn.query(constraint)
File
"c:\python25\lib\site-packages\sqlobject-0.8.0-py2.5.egg\sqlobject\dbconnection.py",
line 316, in query
return self._runWithConnection(self._query, s)
File
"c:\python25\lib\site-packages\sqlobject-0.8.0-py2.5.egg\sqlobject\dbconnection.py",
line 230, in _runWithConnection
val = meth(conn, *args)
File
"c:\python25\lib\site-packages\sqlobject-0.8.0-py2.5.egg\sqlobject\dbconnection.py",
line 313, in _query
self._executeRetry(conn, conn.cursor(), s)
File
"c:\python25\lib\site-packages\sqlobject-0.8.0-py2.5.egg\sqlobject\mysql\mysqlconnection.py",
line 109, in _executeRetry
raise OperationalError(ErrorMessage(e))
sqlobject.dberrors.OperationalError: Can't create table
'.\test\#sql-2b4_b6.frm' (errno: 150)
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
sqlobject-discuss mailing list
sqlobject-discuss@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
