text: # Licensed to the Apache Software Foundation (ASF) under one
  # or more contributor license agreements.  See the NOTICE file
  # distributed with this work for additional information
  # regarding copyright ownership.  The ASF licenses this file
  # to you under the Apache License, Version 2.0 (the
  # "License"); you may not use this file except in compliance
  # with the License.  You may obtain a copy of the License at
  #
  #   http://www.apache.org/licenses/LICENSE-2.0
  #
  # Unless required by applicable law or agreed to in writing,
  # software distributed under the License is distributed on an
  # "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
  # KIND, either express or implied.  See the License for the
  # specific language governing permissions and limitations
  # under the License.
  # isort:skip_file
  from typing import Any
  
  import pytest
  from sqlalchemy.engine import Engine
  
  from tests.test_app import app
  
  from superset import db
  from superset.utils.core import get_example_database, json_dumps_w_dates
  
  
  CTAS_SCHEMA_NAME = "sqllab_test_db"
  ADMIN_SCHEMA_NAME = "admin_database"
  
  
  @pytest.fixture(autouse=True, scope="session")
  def setup_sample_data() -> Any:
      with app.app_context():
          setup_presto_if_needed()
  
          from superset.cli import load_test_users_run
  
          load_test_users_run()
  
          from superset import examples
  
          examples.load_css_templates()
  
      yield
  
      with app.app_context():
          engine = get_example_database().get_sqla_engine()
  
          # drop sqlachemy tables
  
          db.session.commit()
          from sqlalchemy.ext import declarative
  
          sqla_base = declarative.declarative_base()
          # uses sorted_tables to drop in proper order without violating foreign constrains
          for table in sqla_base.metadata.sorted_tables:
              table.__table__.drop()
          db.session.commit()
  
  
  def drop_from_schema(engine: Engine, schema_name: str):
      schemas = engine.execute(f"SHOW SCHEMAS").fetchall()
      if schema_name not in [s[0] for s in schemas]:
          # schema doesn't exist
          return
      tables_or_views = engine.execute(f"SHOW TABLES in {schema_name}").fetchall()
      for tv in tables_or_views:
          engine.execute(f"DROP TABLE IF EXISTS {schema_name}.{tv[0]}")
          engine.execute(f"DROP VIEW IF EXISTS {schema_name}.{tv[0]}")
  
  
  def setup_presto_if_needed():
      backend = app.config["SQLALCHEMY_EXAMPLES_URI"].split("://")[0]
      database = get_example_database()
      extra = database.get_extra()
  
      if backend == "presto":
          # decrease poll interval for tests
          extra = {
              **extra,
              "engine_params": {
                  "connect_args": {"poll_interval": app.config["PRESTO_POLL_INTERVAL"]}
              },
          }
      else:
          # remove `poll_interval` from databases that do not support it
          extra = {**extra, "engine_params": {}}
      database.extra = json_dumps_w_dates(extra)
      db.session.commit()
  
      if backend in {"presto", "hive"}:
          database = get_example_database()
          engine = database.get_sqla_engine()
          drop_from_schema(engine, CTAS_SCHEMA_NAME)
          engine.execute(f"DROP SCHEMA IF EXISTS {CTAS_SCHEMA_NAME}")
          engine.execute(f"CREATE SCHEMA {CTAS_SCHEMA_NAME}")
  
          drop_from_schema(engine, ADMIN_SCHEMA_NAME)
          engine.execute(f"DROP SCHEMA IF EXISTS {ADMIN_SCHEMA_NAME}")
          engine.execute(f"CREATE SCHEMA {ADMIN_SCHEMA_NAME}")
  