Hello.
SQLAlchemy 0.9.4
In this code
def unidecode_column_name(inspector, table, column_info):
column_info['key'] = unidecode(column_info['name']).replace(u' ', u'_')
engine = create_engine("mssql+pyodbc://%s:%s@RTBD" % (settings.RT_USER,
settings.RT_PWD), echo = True)
metadata = MetaData(bind = engine)
metadata.reflect(engine, only = [u"Заказы",], listeners =
[('column_reflect', unidecode_column_name)])
orders = metadata.tables[u'Заказы']
class Order(object):
pass
mapper(Order, orders)
sess = Session(engine)
q = sess.query(Order)
q.filter_by(Kod_zakazchika = u'F07301m').all()
I've got the following error
NoSuchColumnError Traceback (most recent call last)
<ipython-input-2-83aa85e1bb5a> in <module>()
----> 1 q.filter_by(Kod_zakazchika = u'F07301m').all()
local/lib/python2.7/site-packages/sqlalchemy/orm/query.pyc in all(self)
2290
2291 """
-> 2292 return list(self)
2293
2294 @_generative(_no_clauseelement_condition)
local/lib/python2.7/site-packages/sqlalchemy/orm/loading.py in
instances(query, cursor, context)
70 process[0](row, rows)
71 elif single_entity:
---> 72 rows = [process[0](row, None) for row in fetch]
73 else:
74 rows = [util.KeyedTuple([proc(row, None) for proc in
process],
local/lib/python2.7/site-packages/sqlalchemy/orm/loading.py in
_instance(row, result)
359 identitykey = (
360 identity_class,
--> 361 tuple([row[column] for column in
pk_cols])
362 )
363
local/lib/python2.7/site-packages/sqlalchemy/engine/result.pyc in
_key_fallback(self, key, raiseerr)
330 raise exc.NoSuchColumnError(
331 "Could not locate column in row for column
'%s'" %
--> 332 expression._string_or_unprintable(key))
333 else:
334 return None
NoSuchColumnError: "Could not locate column in row for column
'\\u0417\\u0430\\u043a\\u0430\\u0437\\u044b.\\u041d\\u043e\\u043c\\u0435\\u0440
\\u0437\\u0430\\u043a\\u0430\\u0437\\u0430'"
The problem is i can't really debug this error because it isn't clear what
should be in pk_cols
Previously in orm/loading.py there is a string
pk_cols = mapper.primary_key # line number 250
So, pk_cols is a list of Column() objects.
row is a list of values from query
Surely, [row[column] for column in pk_cols] raises error, because column is
a Column() object and can't be index for row. But i can't imagine how this
code may work. Is this a bug?
--
WBR,
Belegnar
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/d/optout.
