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