def test_bigquery_sqla_column_label(self): label = BigQueryEngineSpec.make_label_compatible(column("Col").name) label_expected = "Col" self.assertEqual(label, label_expected) label = BigQueryEngineSpec.make_label_compatible(column("SUM(x)").name) label_expected = "SUM_x__5f110" self.assertEqual(label, label_expected) label = BigQueryEngineSpec.make_label_compatible(column("SUM[x]").name) label_expected = "SUM_x__7ebe1" self.assertEqual(label, label_expected) label = BigQueryEngineSpec.make_label_compatible(column("12345_col").name) label_expected = "_12345_col_8d390" self.assertEqual(label, label_expected)
def test_bigquery_sqla_column_label(self): label = BigQueryEngineSpec.make_label_compatible(column('Col').name) label_expected = 'Col' self.assertEqual(label, label_expected) label = BigQueryEngineSpec.make_label_compatible(column('SUM(x)').name) label_expected = 'SUM_x__5f110' self.assertEqual(label, label_expected) label = BigQueryEngineSpec.make_label_compatible(column('SUM[x]').name) label_expected = 'SUM_x__7ebe1' self.assertEqual(label, label_expected) label = BigQueryEngineSpec.make_label_compatible( column('12345_col').name) label_expected = '_12345_col_8d390' self.assertEqual(label, label_expected)
def test_bigquery_sqla_column_label(self): label = BigQueryEngineSpec.make_label_compatible(column('Col').name) label_expected = 'Col' self.assertEqual(label, label_expected) label = BigQueryEngineSpec.make_label_compatible(column('SUM(x)').name) label_expected = 'SUM_x__5f110b965a993675bc4953bb3e03c4a5' self.assertEqual(label, label_expected) label = BigQueryEngineSpec.make_label_compatible(column('SUM[x]').name) label_expected = 'SUM_x__7ebe14a3f9534aeee125449b0bc083a8' self.assertEqual(label, label_expected) label = BigQueryEngineSpec.make_label_compatible( column('12345_col').name) label_expected = '_12345_col_8d3906e2ea99332eb185f7f8ecb2ffd6' self.assertEqual(label, label_expected)
def test_bigquery_sqla_column_label(self): test_cases = { "Col": "Col", "SUM(x)": "SUM_x__5f110", "SUM[x]": "SUM_x__7ebe1", "12345_col": "_12345_col_8d390", } for original, expected in test_cases.items(): actual = BigQueryEngineSpec.make_label_compatible(column(original).name) self.assertEqual(actual, expected)