diff options
| author | Mike Bayer <mike_mp@zzzcomputing.com> | 2007-11-01 03:58:21 +0000 |
|---|---|---|
| committer | Mike Bayer <mike_mp@zzzcomputing.com> | 2007-11-01 03:58:21 +0000 |
| commit | 66cd772094f22e78cd044c40aa3c72ced6493d2a (patch) | |
| tree | 9887754057fea4d60ef5e78b0a77d90884ab22e4 /test/sql | |
| parent | ad9f8b8158ebd5509eb98c45179f1187f52c96d0 (diff) | |
| download | sqlalchemy-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.py | 3 | ||||
| -rw-r--r-- | test/sql/select.py | 16 |
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 |
