[storm] This is a noob question: storing lists
chandramouli s
naruvimama at gmail.com
Thu May 7 07:09:32 BST 2009
What I would like to do is store a set of data values, 400 or so in a
sqlite database (instead of a flatfile as it is normally done). And I
tried to run following the examples, but I wonder if the list storage
is right. Any help is much appreciated
The program:
############################################################
from storm.locals import *
class Personner(object):
__storm_table__="personner"
id= Int(primary=True)
name=Unicode()
marks=List()
database=create_database("sqlite:///fort")
store=Store(database)
store.execute("CREATE TABLE IF NOT EXISTS personner (id INTEGER
PRIMARY KEY, name VARCHAR,marks TEXT)")
for x in xrange(200):
d=Personner()
d.name=unicode(str(x))
d.marks=[x,2*x,x-1,x*6] # d.marks=unicode(str([x,2*x,x-1,x*6]))
store.add(d)
store.flush()
print 'success'
store.commit()
print 'done'
#####################################################################
The error msg:
Traceback (most recent call last):
File "testStorm.py", line 16, in <module>
store.flush()
File "/usr/lib64/python2.6/site-packages/storm/store.py", line 486, in flush
self._flush_one(obj_info)
File "/usr/lib64/python2.6/site-packages/storm/store.py", line 523,
in _flush_one
result = self._connection.execute(expr)
File "/usr/lib64/python2.6/site-packages/storm/database.py", line
203, in execute
raw_cursor = self.raw_execute(statement, params)
File "/usr/lib64/python2.6/site-packages/storm/databases/sqlite.py",
line 153, in raw_execute
return Connection.raw_execute(self, statement, params)
File "/usr/lib64/python2.6/site-packages/storm/database.py", line
284, in raw_execute
self._check_disconnect(raw_cursor.execute, *args)
File "/usr/lib64/python2.6/site-packages/storm/database.py", line
325, in _check_disconnect
return function(*args, **kwargs)
pysqlite2.dbapi2.InterfaceError: Error binding parameter 0 - probably
unsupported type.
More information about the storm
mailing list