> I think the issue is you cant put a "task_status" ordering in your
> Task mapper since that table is not part of its mapping.
>
> http://www.sqlalchemy.org/trac/wiki/
> FAQ#ImusinglazyFalsetocreateaJOINOUTERJOINandSQLAlchemyisnotconstructing
> thequerywhenItrytoaddaWHEREORDERBYLIMITetc.whichreliesupontheOUTERJOIN
>
>
I'm a bit confused. So with a mapping as follows.
db.mapper(TaskStatus, db.sys_task_status)
db.mapper(Task, db.task,
properties = {
'status': relation(TaskStatus, lazy=False),
}
)
Is the only way for me to order by a column in sys_task_status is with
an explicit join like in this example ?
query = db.query(model.Task).select_from(
db.task.join(db.sys_task_status)
).order_by(db.sys_task_status.c.seq_no)
which results in the following SQL:
SELECT sys_task_status_cf27.*, task.*
FROM task JOIN sys_task_status ON sys_task_status.status_code =
task.status_code
LEFT OUTER JOIN sys_task_status AS sys_task_status_cf27 ON
sys_task_status_cf27.status_code = task.status_code
ORDER BY sys_task_status.seq_no, sys_task_status_cf27.status_code
I'm trying to get to the following query. It takes half the time of the
first query.
SELECT sys_task_status_cf27.*, task.*
FROM task LEFT OUTER JOIN sys_task_status AS sys_task_status_cf27 ON
sys_task_status_cf27.status_code = task.status_code
ORDER BY sys_task_status_cf27.seq_no, sys_task_status_cf27.status_code
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
