def test_order_by_cols(self):
"""This currently prepends the ORDER BY columns."""
self.assertEqual(
sql_builder.colstr(select_columns=['col_a', 'col_b', 'col_c'],
order_by=['col_b', 'col_c']),
'col_b, col_c, col_a, col_b, col_c')
self.assertEqual(
sql_builder.colstr(select_columns=['col_a', 'col_b', 'col_c'],
order_by=['col_b ASC', ('col_c', 'ASC')]),
'col_b, col_c, col_a, col_b, col_c')
def test_order_by_cols(self):
"""This currently prepends the ORDER BY columns."""
self.assertEqual(
sql_builder.colstr(select_columns=["col_a", "col_b", "col_c"], order_by=["col_b", "col_c"]),
"col_b, col_c, col_a, col_b, col_c",
)
self.assertEqual(
sql_builder.colstr(select_columns=["col_a", "col_b", "col_c"], order_by=["col_b ASC", ("col_c", "ASC")]),
"col_b, col_c, col_a, col_b, col_c",
)
def test_order_by_cols(self):
"""This currently prepends the ORDER BY columns."""
self.assertEqual(
sql_builder.colstr(
select_columns=['col_a', 'col_b', 'col_c'],
order_by=['col_b', 'col_c']),
'col_b, col_c, col_a, col_b, col_c')
self.assertEqual(
sql_builder.colstr(
select_columns=['col_a', 'col_b', 'col_c'],
order_by=['col_b ASC', ('col_c', 'ASC')]),
'col_b, col_c, col_a, col_b, col_c')
def insert(class_, cursor, **bind_variables):
values_clause, bind_list = sql_builder.build_values_clause(
class_.columns_list,
bind_variables)
if class_.columns_list is None:
raise dbexceptions.ProgrammingError("DB class should define columns_list")
query = 'INSERT INTO %s (%s) VALUES (%s)' % (class_.table_name,
sql_builder.colstr(
class_.columns_list,
bind=bind_list),
values_clause)
cursor.execute(query, bind_variables)
return cursor.lastrowid
def test_bind(self):
self.assertEqual(
sql_builder.colstr(select_columns=['col_a', 'col_b', 'col_c'],
bind=['col_c', 'col_a']), 'col_a, col_c')
def test_two_exprs(self):
self.assertEqual(
sql_builder.colstr(
select_columns=[sql_builder.Count(),
sql_builder.Min('col_a')]),
'COUNT(1), MIN(col_a)')
def test_two_columns(self):
self.assertEqual(sql_builder.colstr(select_columns=['col_a', 'col_b']),
'col_a, col_b')
def test_bind(self):
self.assertEqual(
sql_builder.colstr(
select_columns=['col_a', 'col_b', 'col_c'],
bind=['col_c', 'col_a']),
'col_a, col_c')
def test_two_exprs(self):
self.assertEqual(
sql_builder.colstr(
select_columns=[sql_builder.Count(), sql_builder.Min('col_a')]),
'COUNT(1), MIN(col_a)')
def test_two_columns(self):
self.assertEqual(
sql_builder.colstr(select_columns=['col_a', 'col_b']),
'col_a, col_b')
def test_bind(self):
self.assertEqual(
sql_builder.colstr(select_columns=["col_a", "col_b", "col_c"], bind=["col_c", "col_a"]), "col_a, col_c"
)
def test_two_columns(self):
self.assertEqual(sql_builder.colstr(select_columns=["col_a", "col_b"]), "col_a, col_b")
