Thread: [SQLObject] bug around datetime default value?
SQLObject is a Python ORM.
Brought to you by:
ianbicking,
phd
From: Ivan H. <i.h...@al...> - 2006-09-14 11:51:22
|
Dear All, i've downloaded 0.7.1rc1 version from svn. in my mysql table there is a datetime column, mysql sets default value as= '0000-00-00 00:00:00' - it is a string (str) when i insert a record into this table i don't specify anything for this= datetime column. the system finds out the default as str but after it fails in File "c:\python24\lib\site-packages\SQLObject-0.7.1rc1\sqlobject\col.py",= line 958, in from_python (self.name, type(value), value), value, state) Invalid: expected a datetime in the DateTimeCol 'docDone', got <type 'str'>= '0000-00-00 00:00:00' instead how to overcome this problem? Best regards, Ivan Horvath Chief Programmer Alcatel ISD PMS 2000 Product Team H-1116, Budapest Kondorfa u. 10. Tel.: +36 1 209 9546 Fax.: +36 1 209 9599 Mobil: +36 30 257 0235 VOIP: +49 511 676 478010 i.h...@al... Anyone who has never made a mistake has never tried anything new. /Albert Einstein/ |
From: Ivan H. <i.h...@al...> - 2006-09-15 12:10:54
|
Dear All, do you have any idea regarding this problem? *********** REPLY SEPARATOR *********** On 14/09/2006 at 13:48 Ivan Horvath wrote: Dear All, i've downloaded 0.7.1rc1 version from svn. in my mysql table there is a datetime column, mysql sets default value as= '0000-00-00 00:00:00' - it is a string (str) when i insert a record into this table i don't specify anything for this= datetime column. the system finds out the default as str but after it fails in File "c:\python24\lib\site-packages\SQLObject-0.7.1rc1\sqlobject\col.py",= line 958, in from_python (self.name, type(value), value), value, state) Invalid: expected a datetime in the DateTimeCol 'docDone', got <type 'str'>= '0000-00-00 00:00:00' instead how to overcome this problem? Best regards, Ivan Horvath Chief Programmer Alcatel ISD PMS 2000 Product Team H-1116, Budapest Kondorfa u. 10. Tel.: +36 1 209 9546 Fax.: +36 1 209 9599 Mobil: +36 30 257 0235 VOIP: +49 511 676 478010 i.h...@al... Anyone who has never made a mistake has never tried anything new. /Albert Einstein/ Best regards, Ivan Horvath Chief Programmer Alcatel ISD PMS 2000 Product Team H-1116, Budapest Kondorfa u. 10. Tel.: +36 1 209 9546 Fax.: +36 1 209 9599 Mobil: +36 30 257 0235 VOIP: +49 511 676 478010 i.h...@al... Anyone who has never made a mistake has never tried anything new. /Albert Einstein/ |
From: Oleg B. <ph...@ph...> - 2006-09-15 12:35:43
|
On Fri, Sep 15, 2006 at 02:07:32PM +0200, Ivan Horvath wrote: > Invalid: expected a datetime in the DateTimeCol 'docDone', got <type 'str'> '0000-00-00 00:00:00' instead Did MySQL return that instead of NULL? Oleg. -- Oleg Broytmann http://phd.pp.ru/ ph...@ph... Programmers don't die, they just GOSUB without RETURN. |
From: Ivan H. <i.h...@al...> - 2006-09-15 12:48:17
|
i've changed mysql table to use NULL as default afterwhile the insert works thank you *********** REPLY SEPARATOR *********** On 15/09/2006 at 16:35 Oleg Broytmann wrote: >On Fri, Sep 15, 2006 at 02:07:32PM +0200, Ivan Horvath wrote: >> Invalid: expected a datetime in the DateTimeCol 'docDone', got <type >'str'> '0000-00-00 00:00:00' instead > > Did MySQL return that instead of NULL? > >Oleg. >-- > Oleg Broytmann http://phd.pp.ru/ ph...@ph... > Programmers don't die, they just GOSUB without RETURN. > >------------------------------------------------------------------------- >Using Tomcat but need to do more? Need to support web services, security? >Get stuff done quickly with pre-integrated technology to make your job >easier >Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo >http://sel.as-us.falkag.net/sel?cmd=3Dlnk&kid=3D120709&bid=3D263057&dat=3D1= 21642 >_______________________________________________ >sqlobject-discuss mailing list >sql...@li... >https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss Best regards, Ivan Horvath Chief Programmer Alcatel ISD PMS 2000 Product Team H-1116, Budapest Kondorfa u. 10. Tel.: +36 1 209 9546 Fax.: +36 1 209 9599 Mobil: +36 30 257 0235 VOIP: +49 511 676 478010 i.h...@al... Anyone who has never made a mistake has never tried anything new. /Albert Einstein/ |