summaryrefslogtreecommitdiff
path: root/test/sql
diff options
context:
space:
mode:
authorMike Bayer <mike_mp@zzzcomputing.com>2007-11-01 03:58:21 +0000
committerMike Bayer <mike_mp@zzzcomputing.com>2007-11-01 03:58:21 +0000
commit66cd772094f22e78cd044c40aa3c72ced6493d2a (patch)
tree9887754057fea4d60ef5e78b0a77d90884ab22e4 /test/sql
parentad9f8b8158ebd5509eb98c45179f1187f52c96d0 (diff)
downloadsqlalchemy-66cd772094f22e78cd044c40aa3c72ced6493d2a.tar.gz
- merged factor_down_bindparams branch.
- removed ClauseParameters object; compiled.params returns a regular dictionary now, as well as result.last_inserted_params()/last_updated_params(). - various code trimming, method removals.
Diffstat (limited to 'test/sql')
-rw-r--r--test/sql/query.py3
-rw-r--r--test/sql/select.py16
2 files changed, 11 insertions, 8 deletions
diff --git a/test/sql/query.py b/test/sql/query.py
index 67384073c..c4a3e9e0d 100644
--- a/test/sql/query.py
+++ b/test/sql/query.py
@@ -123,7 +123,8 @@ class QueryTest(PersistTest):
continue
try:
table.create()
- assert insert_values(table, values) == assertvalues, repr(values) + " " + repr(assertvalues)
+ i = insert_values(table, values)
+ assert i == assertvalues, repr(i) + " " + repr(assertvalues)
finally:
table.drop()
diff --git a/test/sql/select.py b/test/sql/select.py
index 56bf1d92c..ace455702 100644
--- a/test/sql/select.py
+++ b/test/sql/select.py
@@ -614,7 +614,7 @@ WHERE mytable.myid = myothertable.otherid) AS t2view WHERE t2view.mytable_myid =
self.assert_compile(
text("select * from foo where lala=:bar and hoho=:whee", bindparams=[bindparam('bar',4), bindparam('whee',7)]),
"select * from foo where lala=? and hoho=?",
- checkparams=[4, 7],
+ checkparams={'bar':4, 'whee':7},
dialect=dialect
)
@@ -921,17 +921,19 @@ EXISTS (select yay from foo where boo = lar)",
self.assert_compile(stmt, expected_positional_stmt, dialect=sqlite.dialect())
nonpositional = stmt.compile()
positional = stmt.compile(dialect=sqlite.dialect())
- assert positional.get_params().get_raw_list({}) == expected_default_params_list
- assert nonpositional.get_params(**test_param_dict).get_raw_dict({}) == expected_test_params_dict, "expected :%s got %s" % (str(expected_test_params_dict), str(nonpositional.get_params(**test_param_dict).get_raw_dict()))
- assert positional.get_params(**test_param_dict).get_raw_list({}) == expected_test_params_list
+ pp = positional.get_params()
+ assert [pp[k] for k in positional.positiontup] == expected_default_params_list
+ assert nonpositional.get_params(**test_param_dict) == expected_test_params_dict, "expected :%s got %s" % (str(expected_test_params_dict), str(nonpositional.get_params(**test_param_dict).get_raw_dict()))
+ pp = positional.get_params(**test_param_dict)
+ assert [pp[k] for k in positional.positiontup] == expected_test_params_list
# check that params() doesnt modify original statement
s = select([table1], or_(table1.c.myid==bindparam('myid'), table2.c.otherid==bindparam('myotherid')))
s2 = s.params({'myid':8, 'myotherid':7})
s3 = s2.params({'myid':9})
- assert s.compile().params.get_original_dict() == {'myid':None, 'myotherid':None}
- assert s2.compile().params.get_original_dict() == {'myid':8, 'myotherid':7}
- assert s3.compile().params.get_original_dict() == {'myid':9, 'myotherid':7}
+ assert s.compile().params == {'myid':None, 'myotherid':None}
+ assert s2.compile().params == {'myid':8, 'myotherid':7}
+ assert s3.compile().params == {'myid':9, 'myotherid':7}
# check that conflicts with "unique" params are caught