Example #1
0
 def test_with_alt_name(self):
     sql, bind_vars = sql_builder.build_in('col', [2, 4],
                                           alt_name='alt_col')
     self.assertEqual(sql, 'col IN (%(alt_col_1)s, %(alt_col_2)s)')
     self.assertEqual(bind_vars, dict(alt_col_1=2, alt_col_2=4))
Example #2
0
 def test_with_counter(self):
     counter = itertools.count(5)
     sql, bind_vars = sql_builder.build_in('col', [2, 4], counter=counter)
     self.assertEqual(sql, 'col IN (%(col_5)s, %(col_6)s)')
     self.assertEqual(bind_vars, dict(col_5=2, col_6=4))
Example #3
0
 def test_two_columns(self):
     sql, bind_vars = sql_builder.build_in('col', [2, 4])
     self.assertEqual(sql, 'col IN (%(col_1)s, %(col_2)s)')
     self.assertEqual(bind_vars, dict(col_1=2, col_2=4))
Example #4
0
 def test_with_counter(self):
   counter = itertools.count(5)
   sql, bind_vars = sql_builder.build_in('col', [2, 4], counter=counter)
   self.assertEqual(sql, 'col IN (%(col_5)s, %(col_6)s)')
   self.assertEqual(bind_vars, dict(col_5=2, col_6=4))
Example #5
0
 def test_with_alt_name(self):
   sql, bind_vars = sql_builder.build_in('col', [2, 4], alt_name='alt_col')
   self.assertEqual(sql, 'col IN (%(alt_col_1)s, %(alt_col_2)s)')
   self.assertEqual(bind_vars, dict(alt_col_1=2, alt_col_2=4))
Example #6
0
 def test_two_columns(self):
   sql, bind_vars = sql_builder.build_in('col', [2, 4])
   self.assertEqual(sql, 'col IN (%(col_1)s, %(col_2)s)')
   self.assertEqual(bind_vars, dict(col_1=2, col_2=4))
Example #7
0
 def test_with_alt_name(self):
     sql, bind_vars = sql_builder.build_in("col", [2, 4], alt_name="alt_col")
     self.assertEqual(sql, "col IN (%(alt_col_1)s, %(alt_col_2)s)")
     self.assertEqual(bind_vars, dict(alt_col_1=2, alt_col_2=4))