I'm having trouble telling an orm query which table is the "main"
table when I
only use a single column from the main table and it is wrapped up in
an SQL
function. It's almost like SqlAlchemy can't see that I am using a
column from
that table because it is inside of a function::
# -- Schema -------------------
#
# Labor
# =====
# id
# hours
# createdBy (user ref)
# editedBy (user ref)
#
#
# User
# ====
# id
# username
# -----------------------------
# -- Code -------------------
CREATED_BY = aliased(User, name='createdBy')
EDITED_BY = aliased(User, name='editedBy')
q = query(CREATED_BY.username, func.sum(Labor.hours))
q = q.join((CREATED_BY, Labor.createdBy==CREATED_BY.id))
q.all()
This is producing a query like this::
SELECT
user_1.username, sum(labor.st)
FROM
user AS user_1
INNER JOIN user AS user_1 ON labor.createdBy = user_1.id
Which gives me a OperationalError "1066, "Not unique table/alias:
'user_1'".
I would expect this::
SELECT
createdBy.username, sum(labor.st)
FROM
labor
INNER JOIN user AS createdBy ON labor.createdBy = createdBy.id
As soon as I add a column from the Labor table to the query, and it is
not in a
function, the query works. For example, this works::
q = query(CREATED_BY.username, Labor.id, func.sum(Labor.hours))
Mysql 5
SqlAlchemy 0.5.2
--
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
sqlalchemy+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en.
