i have made a hack to make the sql/echo look somewhat better - level-indented + more line-separations. it auto-applies itself over the sqlachemy at runtime. usage: just import sahack4src
e.g.
SELECT pu_human.address_id AS pu_human_address_id, ....
FROM (SELECT person.address_id AS address_id, ....
FROM human JOIN person ON person.db_id = human.db_id UNION ALL SELECT
CAST(NULL AS INTEGER) AS address_id, ....
FROM (SELECT human.age AS age, human.name AS name, ....
FROM human
WHERE human.atype = ?) AS bz4human) AS pu_human
WHERE pu_human.age > ? AND pu_human.friend_id = pu_human.db_id ORDER
BY pu_human.oid
becomes:
SELECT pu_human.address_id AS pu_human_address_id, ....
FROM (
SELECT person.address_id AS address_id, ....
FROM human JOIN person ON person.db_id = human.db_id
UNION ALL
SELECT CAST(NULL AS INTEGER) AS address_id, ....
FROM (
SELECT human.age AS age, human.name AS name, ....
FROM human
WHERE human.atype = ?
) AS bz4human
) AS pu_human
WHERE pu_human.age > ? AND pu_human.friend_id = pu_human.db_id
ORDER BY pu_human.oid
=======
Mike, are u interested in making this inside sqlalchemy?
it's something like 5-10 lines changed. i can prepare a patch..
svil
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
hacksrc.py
Description: application/python
sahack4echo.py
Description: application/python
