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, {})