Python build_in Examples

Example #1

File: sql_builder_test.py Project: fengshao0907/vitess

 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

File: sql_builder_test.py Project: fengshao0907/vitess

 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

File: sql_builder_test.py Project: fengshao0907/vitess

 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

File: sql_builder_test.py Project: haoqoo/vitess

 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

File: sql_builder_test.py Project: haoqoo/vitess

 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

File: sql_builder_test.py Project: haoqoo/vitess

 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

File: sql_builder_test.py Project: hediehy/vitess

 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))