def test_with_alias(self):
self.assertEqual(
sql_builder.select_clause(select_columns=['col_a', 'col_b'],
alias='mt',
table_name='my_table'),
'SELECT mt.col_a, mt.col_b FROM my_table mt')
def test_simple(self):
self.assertEqual(
sql_builder.select_clause(select_columns=['col_a', 'col_b'],
table_name='my_table'),
'SELECT col_a, col_b FROM my_table')
def test_with_alias(self):
self.assertEqual(
sql_builder.select_clause(
select_columns=['col_a', 'col_b'], alias='mt',
table_name='my_table'),
'SELECT mt.col_a, mt.col_b FROM my_table mt')
def test_simple(self):
self.assertEqual(
sql_builder.select_clause(
select_columns=['col_a', 'col_b'], table_name='my_table'),
'SELECT col_a, col_b FROM my_table')
def test_with_alias(self):
self.assertEqual(
sql_builder.select_clause(select_columns=["col_a", "col_b"], alias="mt", table_name="my_table"),
"SELECT mt.col_a, mt.col_b FROM my_table mt",
)
def test_simple(self):
self.assertEqual(
sql_builder.select_clause(select_columns=["col_a", "col_b"], table_name="my_table"),
"SELECT col_a, col_b FROM my_table",
)
