summaryrefslogtreecommitdiff
path: root/lib/sqlalchemy/ext/sqlsoup.py
diff options
context:
space:
mode:
authorMike Bayer <mike_mp@zzzcomputing.com>2007-03-28 07:19:14 +0000
committerMike Bayer <mike_mp@zzzcomputing.com>2007-03-28 07:19:14 +0000
commite0b638a704f7f0abf88d1a80a95cf052954e048c (patch)
tree6b8717e491820322c48b5b271ec6b192fa8a86cd /lib/sqlalchemy/ext/sqlsoup.py
parentccbcbda43e74a1d09d50aa2f8212b3cb9adafd23 (diff)
downloadsqlalchemy-e0b638a704f7f0abf88d1a80a95cf052954e048c.tar.gz
- column label and bind param "truncation" also generate
deterministic names now, based on their ordering within the full statement being compiled. this means the same statement will produce the same string across application restarts and allowing DB query plan caching to work better. - cleanup to sql.ClauseParameters since it was just falling apart, API made more explicit - many unit test tweaks to adjust for bind params not being "pre" truncated, changes to ClauseParameters
Diffstat (limited to 'lib/sqlalchemy/ext/sqlsoup.py')
-rw-r--r--lib/sqlalchemy/ext/sqlsoup.py4
1 files changed, 2 insertions, 2 deletions
diff --git a/lib/sqlalchemy/ext/sqlsoup.py b/lib/sqlalchemy/ext/sqlsoup.py
index b899c043d..21c1fac51 100644
--- a/lib/sqlalchemy/ext/sqlsoup.py
+++ b/lib/sqlalchemy/ext/sqlsoup.py
@@ -187,13 +187,13 @@ If you join tables that have an identical column name, wrap your join
with `with_labels`, to disambiguate columns with their table name::
>>> db.with_labels(join1).c.keys()
- ['users_name', 'users_email', 'users_password', 'users_classname', 'users_admin', 'loans_book_id', 'loans_user_name', 'loans_loan_date']
+ [u'users_name', u'users_email', u'users_password', u'users_classname', u'users_admin', u'loans_book_id', u'loans_user_name', u'loans_loan_date']
You can also join directly to a labeled object::
>>> labeled_loans = db.with_labels(db.loans)
>>> db.join(db.users, labeled_loans, isouter=True).c.keys()
- ['name', 'email', 'password', 'classname', 'admin', 'loans_book_id', 'loans_user_name', 'loans_loan_date']
+ [u'name', u'email', u'password', u'classname', u'admin', u'loans_book_id', u'loans_user_name', u'loans_loan_date']
Advanced Use