Hi!
Can somebody point me why this fails?
>>> meta = MetaData(bind="sqlite:///:memory:")
>>> blocks = Table('blocks', meta,
... Column('id', Integer, primary_key=True, autoincrement=True),
... Column('lines', Integer),
... Column('lastline', Integer),
... )
>>> blocks.create()
>>> blocks.update().execute(lines = blocks.c.lines + 1)
Traceback (most recent call last):
File "<stdin>", line 1, in <module>
File
"/usr/lib/python2.5/site-packages/SQLAlchemy-0.3.10-py2.5.egg/sqlalchemy/sql.py",
line 1207, in execute
return self.compile(bind=self.bind,
parameters=compile_params).execute(*multiparams, **params)
File
"/usr/lib/python2.5/site-packages/SQLAlchemy-0.3.10-py2.5.egg/sqlalchemy/sql.py",
line 1097, in execute
return e.execute_compiled(self, *multiparams, **params)
File
"/usr/lib/python2.5/site-packages/SQLAlchemy-0.3.10-py2.5.egg/sqlalchemy/engine/base.py",
line 780, in execute_compiled
return connection.execute_compiled(compiled, *multiparams, **params)
File
"/usr/lib/python2.5/site-packages/SQLAlchemy-0.3.10-py2.5.egg/sqlalchemy/engine/base.py",
line 568, in execute_compiled
self._execute_raw(context)
File
"/usr/lib/python2.5/site-packages/SQLAlchemy-0.3.10-py2.5.egg/sqlalchemy/engine/base.py",
line 581, in _execute_raw
self._execute(context)
File
"/usr/lib/python2.5/site-packages/SQLAlchemy-0.3.10-py2.5.egg/sqlalchemy/engine/base.py",
line 599, in _execute
raise exceptions.SQLError(context.statement, context.parameters, e)
sqlalchemy.exceptions.SQLError: (InterfaceError) Error binding parameter
0 - probably unsupported type. u'UPDATE blocks SET lines=blocks.lines +
?' [<sqlalchemy.sql._BinaryExpression object at 0x847e20c>]
Seems like a bug, but may be I'm doing something wrong?
--
Paul.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---
