Method test_quoting

test/sql/test_table_via_select.py:90–120

(self, type_: testing.Variation)

    @testing.variation("type_", ["create_table_as", "create_view"])
    def test_quoting(self, type_: testing.Variation):

        src = Table(
            "SourceTable",
            MetaData(),
            Column("Some Name", Integer),
            Column("Other Col", String),
        )
        if type_.create_table_as:
            stmt = CreateTableAs(
                select(src),
                "My Analytic Table",
                schema="Analysis",
            )
        elif type_.create_view:
            stmt = CreateView(
                select(src),
                "My Analytic View",
                schema="Analysis",
            )
        else:
            type_.fail()

        self.assert_compile(
            stmt,
            f'CREATE {"TABLE" if type_.create_table_as else "VIEW"} '
            f'"Analysis"."My Analytic '
            f'{"Table" if type_.create_table_as else "View"}" AS SELECT '
            f'"SourceTable"."Some Name", "SourceTable"."Other Col" '
            f'FROM "SourceTable"',
        )

    @testing.variation("type_", ["create_table_as", "create_view"])
    def test_blank_schema_treated_as_none(