After updating to HEAD this morning I got an error. This code has
worked with many versions of SA and I've never seen anything like
this error before. Here's the relevant code (modified from its
original version to fit your screen):
import sqlalchemy as sa
class Version(object):
table = sa.Table("version", meta,
sa.Column("id", mu.String, primary_key=True),
sa.Column("number", mu.String),
)
def assign_mapper(class_, *args, **kw):
class_.mapper = sa.mapper(class_, class_.table, *args, **kw)
assign_mapper(Version)
def verify(version, session=None):
"""Verify the connection and the version of the database"""
if session is None:
session = sa.create_session()
ver = session.query(Version).get('schema')
if ver.number != version:
raise WrongDatabaseVersionError("got %r expected %r" %
(ver.number, version))
And here's the error:
Traceback (most recent call last):
File "/Users/daniel/Code/PyOE/src/orderentry/app.py", line 34, in
__init__
self.dbConnect()
File "/Users/daniel/Code/PyOE/src/orderentry/app.py", line 81, in
dbConnect
model.verify(__version__)
File "/Users/daniel/Code/PyOE/src/orderentry/model.py", line 33,
in verify
ver = session.query(Version).get('schema')
File "/Users/daniel/Code/SQLAlchemy/lib/sqlalchemy/orm/query.py",
line 59, in get
return self._get(key, ident, **kwargs)
File "/Users/daniel/Code/SQLAlchemy/lib/sqlalchemy/orm/query.py",
line 372, in _get
return self._select_statement(statement, params=params,
populate_existing=reload, version_check=(lockmode is not None))[0]
File "/Users/daniel/Code/SQLAlchemy/lib/sqlalchemy/orm/query.py",
line 380, in _select_statement
return self.execute(statement, params=params, **kwargs)
File "/Users/daniel/Code/SQLAlchemy/lib/sqlalchemy/orm/query.py",
line 312, in execute
return self.instances(result, **kwargs)
File "/Users/daniel/Code/SQLAlchemy/lib/sqlalchemy/orm/query.py",
line 331, in instances
self.mapper._instance(context, row, result)
File "/Users/daniel/Code/SQLAlchemy/lib/sqlalchemy/orm/mapper.py",
line 1159, in _instance
identitykey = self.identity_key_from_row(row)
File "/Users/daniel/Code/SQLAlchemy/lib/sqlalchemy/orm/mapper.py",
line 750, in identity_key_from_row
return (self.class_, tuple([row[column] for column in
self.pks_by_table[self.mapped_table]]), self.entity_name)
File "/Users/daniel/Code/SQLAlchemy/lib/sqlalchemy/engine/
base.py", line 741, in __getitem__
return self.__parent._get_col(self.__row, key)
File "/Users/daniel/Code/SQLAlchemy/lib/sqlalchemy/engine/
base.py", line 634, in _get_col
rec = self._convert_key(key)
File "/Users/daniel/Code/SQLAlchemy/lib/sqlalchemy/engine/
base.py", line 618, in _convert_key
raise exceptions.NoSuchColumnError("Could not locate column in
row for column '%s'" % str(key))
NoSuchColumnError: "Could not locate column in row for column
'version.id'"
Any idea what's going on here? Thanks.
~ Daniel
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to sqlalchemy@googlegroups.com
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
-~----------~----~----~----~------~----~------~--~---
