def test_with_insert_value_expr(self):
timestamp = sql_builder.RawInsertValueExpr(
'FROM_UNIXTIME(%(col_b_1)s)', col_b_1=1234567890)
bind_vars = dict(col_a=1, col_b=timestamp)
sql, column_names = sql_builder.build_values_clause(
columns=['col_a', 'col_b'], bind_vars=bind_vars)
self.assertEqual(sql, '%(col_a)s, %(col_b)s')
self.assertEqual(column_names, ['col_a', 'col_b'])
self.assertEqual(sorted(bind_vars), ['col_a', 'col_b', 'col_b_1'])
self.assertEqual(bind_vars['col_a'], 1)
self.assertEqual(bind_vars['col_b_1'], 1234567890)
def test_sql_insert_value_expr(self):
expr = sql_builder.RawInsertValueExpr('UNIX_TIMESTAMP()')
sql, bind_vars = expr.build_insert_value_sql()
self.assertEqual(sql, 'UNIX_TIMESTAMP()')
self.assertEqual(bind_vars, {})