Dr. Markus Gritsch schrieb:
> On 2/24/07, paul kölle <[EMAIL PROTECTED]> wrote:
>> Dr. Markus Gritsch schrieb:
>> > 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')
>> Can you please turn on debugging for the connection and show the
>> generated SQL? This might have something to do with changeing id's to
>> UNSIGNED...
>
> Indeed, if I remove the word UNSIGNED from
>
> def createIDColumn(self, soClass):
> if soClass.sqlmeta.idType == str:
> return '%s TEXT PRIMARY KEY' % soClass.sqlmeta.idName
> return '%s INT UNSIGNED PRIMARY KEY AUTO_INCREMENT' %
> soClass.sqlmeta.idName
>
> in mysqlconnection.py the test script works as expected again.
IMO the real solution (tm) would be to change ForeignKey() (and probably
others) to match the type of the referrenced column. Otherwise the id
code using UNSIGNED INT has to be reverted. Not sure what it buys you
anyway...
cheers
Paul
-------------------------------------------------------------------------
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
