[storm] Storm, sqlite, and lists

Edward Page eopage at gmail.com
Thu Jul 26 23:56:09 BST 2007


I've been implementing my own thing similar to an orm, but decided to
give up on reinventing the wheel.  That was at about the time that
Storm was released, and I have to say, I'm impressed.

I have run into a bit of a problem.  From what I've gleamed, my
included script is what I'm suppose to do, but I get this error (with
print statements in Connection._raw_execute for statements and params
to help

Two warnings:
I'm fairly novice in sql though I've been programming for years
I have been unable to find any storm examples using lists

=======================
CREATE TABLE test (id INTEGER PRIMARY KEY, name TEXT, fields BLOB)
INSERT INTO test (fields, name) VALUES (?, ?)
([], u'Blank')
Traceback (most recent call last):
  File "./bug_example.py", line 20, in <module>
    store.commit()
  File "/media/data/Personal/Development/FamilyHistory/src/storm/store.py",
line 66, in commit
    self.flush()
  File "/media/data/Personal/Development/FamilyHistory/src/storm/store.py",
line 274, in flush
    self._flush_one(obj_info)
  File "/media/data/Personal/Development/FamilyHistory/src/storm/store.py",
line 313, in _flush_one
    result = self._connection.execute(expr)
  File "/media/data/Personal/Development/FamilyHistory/src/storm/database.py",
line 139, in execute
    raw_cursor = self._raw_execute(statement, params)
  File "/media/data/Personal/Development/FamilyHistory/src/storm/database.py",
line 128, in _raw_execute
    raw_cursor.execute(statement, params)
pysqlite2.dbapi2.InterfaceError: Error binding parameter 0 - probably
unsupported type.
=======================

Is this a bug on my part or on Storm's?

Thanks
Ed Page

ps Any good feel for when to use AutoReload?
-------------- next part --------------
A non-text attachment was scrubbed...
Name: bug_example.py
Type: text/x-python
Size: 513 bytes
Desc: not available
Url : https://lists.ubuntu.com/archives/storm/attachments/20070726/ffd33540/attachment.py 


More information about the storm mailing list