diff options
Diffstat (limited to 'tests/test_op.py')
-rw-r--r-- | tests/test_op.py | 22 |
1 files changed, 22 insertions, 0 deletions
diff --git a/tests/test_op.py b/tests/test_op.py index d46f001..7503abf 100644 --- a/tests/test_op.py +++ b/tests/test_op.py @@ -126,4 +126,26 @@ def test_create_table_two_fk(): "FOREIGN KEY(foo_bar) REFERENCES foo (bar))" ) +def test_inline_literal(): + context = _op_fixture() + from sqlalchemy.sql import table, column + from sqlalchemy import String, Integer + account = table('account', + column('name', String), + column('id', Integer) + ) + op.execute( + account.update().\ + where(account.c.name==op.inline_literal('account 1')).\ + values({'name':op.inline_literal('account 2')}) + ) + op.execute( + account.update().\ + where(account.c.id==op.inline_literal(1)).\ + values({'id':op.inline_literal(2)}) + ) + context.assert_( + "UPDATE account SET name='account 2' WHERE account.name = 'account 1'", + "UPDATE account SET id=2 WHERE account.id = 1" + ) |