def test_delete_conditional(self):
where = [WhereClause('id', EqualsOperator(), 1)]
conditionals = [
ConditionalClause('f0', 'value0'),
ConditionalClause('f1', 'value1')
]
ds = DeleteStatement('table', where=where, conditionals=conditionals)
self.assertEqual(len(ds.conditionals), len(conditionals))
self.assertEqual(
six.text_type(ds),
'DELETE FROM table WHERE "id" = %(0)s IF "f0" = %(1)s AND "f1" = %(2)s',
six.text_type(ds))
fields = ['one', 'two']
ds = DeleteStatement('table',
fields=fields,
where=where,
conditionals=conditionals)
self.assertEqual(
six.text_type(ds),
'DELETE "one", "two" FROM table WHERE "id" = %(0)s IF "f0" = %(1)s AND "f1" = %(2)s',
six.text_type(ds))
def test_conditional_clause(self):
tc = ConditionalClause('some_value', 23)
tc.set_context_id(3)
self.assertEqual('"some_value" = %(3)s', six.text_type(tc))
self.assertEqual('"some_value" = %(3)s', str(tc))
def test_conditional_clause(self):
tc = ConditionalClause('some_value', 23)
tc.set_context_id(3)
self.assertEqual('"some_value" = %(3)s', six.text_type(tc))
self.assertEqual('"some_value" = %(3)s', str(tc))