from test.integration.base import DBTIntegrationTest, use_profile


class TestBaseCaching(DBTIntegrationTest):
    @property
    def schema(self):
        return "caching_038"

    @property
    def models(self):
        return "models"

    @use_profile('postgres')
    def test_postgres_adapter_methods(self):
        self.run_dbt()
        self.assertTablesEqual('model', 'expected')

    @use_profile('redshift')
    def test_redshift_adapter_methods(self):
        self.run_dbt()
        self.assertTablesEqual('model', 'expected')

    @use_profile('snowflake')
    def test_snowflake_adapter_methods(self):
        self.run_dbt()
        self.assertTablesEqual('MODEL', 'EXPECTED')

    @use_profile('bigquery')
    def test_bigquery_adapter_methods(self):
        self.run_dbt()
        self.assertTablesEqual('model', 'expected')