Hi,
Back from the long holidays, I've just checked out svn revision 817.
Given the following module:
<code>
from sqlalchemy import *
engine = create_engine("sqlite://filename=trial2.sqlldb")
MASTER = Table("MASTER", engine
, Column("ID", Integer, Sequence("MASTER_ID_SEQ"), primary_key=True,
nullable=False)
, Column("NAME", String(50), nullable=False), default="")
)
class Master(object):
pass
assign_mapper(Master, MASTER)
</code>
The following code inserts a row with the values: ID=1, NAME=u''.
<code>
m = trial2.Master(NAME="Deneme")
trial2.objectstore.commit()
</code>
If I comment out the default parameter for NAME column then I get this
exception:
Traceback (most recent call last):
File "<input>", line 1, in ?
File "c:\documents and settings\murat ozsoyler\my documents\alınan
dosyalarım\sqlalchemy\lib\sqlalchemy\mapping\objectstore.py", line 65,
in commit
uow().commit(*obj)
File "c:\documents and settings\murat ozsoyler\my documents\alınan
dosyalarım\sqlalchemy\lib\sqlalchemy\mapping\objectstore.py", line 280,
in commit
commit_context.execute()
File "c:\documents and settings\murat ozsoyler\my documents\alınan
dosyalarım\sqlalchemy\lib\sqlalchemy\mapping\objectstore.py", line 395,
in execute
head.execute(self)
File "c:\documents and settings\murat ozsoyler\my documents\alınan
dosyalarım\sqlalchemy\lib\sqlalchemy\mapping\objectstore.py", line 544,
in execute
self.mapper.save_obj(self.tosave_objects(), trans)
File "c:\documents and settings\murat ozsoyler\my documents\alınan
dosyalarım\sqlalchemy\lib\sqlalchemy\mapping\mapper.py", line 572, in
save_obj
statement.execute(**params)
File "c:\documents and settings\murat ozsoyler\my documents\alınan
dosyalarım\sqlalchemy\lib\sqlalchemy\sql.py", line 374, in execute
return c.execute(*multiparams, **params)
File "c:\documents and settings\murat ozsoyler\my documents\alınan
dosyalarım\sqlalchemy\lib\sqlalchemy\sql.py", line 272, in execute
return self.engine.execute_compiled(self, params)
File "c:\documents and settings\murat ozsoyler\my documents\alınan
dosyalarım\sqlalchemy\lib\sqlalchemy\engine.py", line 520, in
execute_compiled
proxy(str(compiled), parameters)
File "c:\documents and settings\murat ozsoyler\my documents\alınan
dosyalarım\sqlalchemy\lib\sqlalchemy\engine.py", line 515, in proxy
self.execute(statement, parameters, connection=connection,
cursor=cursor)
File "c:\documents and settings\murat ozsoyler\my documents\alınan
dosyalarım\sqlalchemy\lib\sqlalchemy\engine.py", line 569, in execute
self._execute(cursor, statement, parameters)
File "c:\documents and settings\murat ozsoyler\my documents\alınan
dosyalarım\sqlalchemy\lib\sqlalchemy\engine.py", line 579, in _execute
c.execute(statement, parameters)
OperationalError: MASTER.NAME may not be NULL
My configuration is:
Win XP SP2 with latest patches
Sqlite3.2.8
Sqlalchemy svn rev 817
Python 2.4.2
I suspect it is an issue with unicode and sqlite but I'm not proficient
to pinpoint it...
Have a nice day...
Regards,
Murat Ozsoyler
-------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
for problems? Stop! Download the new AJAX search engine that makes
searching your log files as easy as surfing the web. DOWNLOAD SPLUNK!
http://ads.osdn.com/?ad_idv37&alloc_id865&op=click
_______________________________________________
Sqlalchemy-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
