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)
Exemplo n.º 2
0
    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)
Exemplo n.º 3
0
    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)
Exemplo n.º 4
0
 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)