diff options
author | Mike Bayer <mike_mp@zzzcomputing.com> | 2007-03-28 07:19:14 +0000 |
---|---|---|
committer | Mike Bayer <mike_mp@zzzcomputing.com> | 2007-03-28 07:19:14 +0000 |
commit | e0b638a704f7f0abf88d1a80a95cf052954e048c (patch) | |
tree | 6b8717e491820322c48b5b271ec6b192fa8a86cd /lib/sqlalchemy/ext/sqlsoup.py | |
parent | ccbcbda43e74a1d09d50aa2f8212b3cb9adafd23 (diff) | |
download | sqlalchemy-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.py | 4 |
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 |