Yes I have tried it with VARCHAR too but with the same error .. I tried converting the list to string using: d.marks=str([x,2*x,x-1,x*6]) but the same error occurs ...
Thank you Chandra On Thu, May 7, 2009 at 7:47 AM, Hahusseau, Thomas <[email protected]> wrote: > Check if the type TEXT for your "marks" field exists in sqlite creation > process. Maybe you should replace it by a VARCHAR type. > > -----Message d'origine----- > De : [email protected] > [mailto:[email protected]] De la part de chandramouli s > Envoyé : jeudi 7 mai 2009 08:10 > À : [email protected] > Objet : [storm] This is a noob question: storing lists > > 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. > > -- > storm mailing list > [email protected] > Modify settings or unsubscribe at: > https://lists.ubuntu.com/mailman/listinfo/storm > -- storm mailing list [email protected] Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/storm
