[sqla_testing]

requirement_cls = test.requirements:DefaultRequirements

profile_file = test/profiles.txt

# name of a "loopback" link set up on the oracle database.

# to create this, suppose your DB is scott/tiger@free. You'd create it

# like:

# create public database link test_link connect to scott identified by tiger

# using 'free';

oracle_db_link = test_link

# create public database link test_link2 connect to test_schema identified by tiger

# using 'free';

oracle_db_link2 = test_link2

# host name of a postgres database that has the postgres_fdw extension.

# to create this run:

# CREATE EXTENSION postgres_fdw;

# GRANT USAGE ON FOREIGN DATA WRAPPER postgres_fdw TO public;

# this can be localhost to create a loopback foreign table

# postgres_test_db_link = localhost

[db]

default = sqlite:///:memory:

sqlite = sqlite:///:memory:

sqlite_numeric = sqlite+pysqlite_numeric:///:memory:

sqlite_dollar = sqlite+pysqlite_dollar:///:memory:

aiosqlite = sqlite+aiosqlite:///:memory:

sqlite_file = sqlite:///querytest.db

aiosqlite_file = sqlite+aiosqlite:///async_querytest.db

pysqlcipher_file = sqlite+pysqlcipher://:test@/querytest.db.enc

postgresql = postgresql+psycopg://scott:tiger@127.0.0.1:5432/test

psycopg2 = postgresql+psycopg2://scott:tiger@127.0.0.1:5432/test

psycopg = postgresql+psycopg://scott:tiger@127.0.0.1:5432/test

psycopg_async = postgresql+psycopg_async://scott:tiger@127.0.0.1:5432/test

asyncpg = postgresql+asyncpg://scott:tiger@127.0.0.1:5432/test

pg8000 = postgresql+pg8000://scott:tiger@127.0.0.1:5432/test

postgresql_psycopg2cffi = postgresql+psycopg2cffi://scott:tiger@127.0.0.1:5432/test

mysql = mysql+mysqldb://scott:tiger@127.0.0.1:3306/test?charset=utf8mb4

pymysql = mysql+pymysql://scott:tiger@127.0.0.1:3306/test?charset=utf8mb4

aiomysql = mysql+aiomysql://scott:tiger@127.0.0.1:3306/test?charset=utf8mb4

asyncmy = mysql+asyncmy://scott:tiger@127.0.0.1:3306/test?charset=utf8mb4

mariadb = mariadb+mysqldb://scott:tiger@127.0.0.1:3306/test

mariadb_connector = mariadb+mariadbconnector://scott:tiger@127.0.0.1:3306/test

mysql_connector = mariadb+mysqlconnector://scott:tiger@127.0.0.1:3306/test

mssql = mssql+pyodbc://scott:tiger^5HHH@mssql2022:1433/test?driver=ODBC+Driver+18+for+SQL+Server&TrustServerCertificate=yes&Encrypt=Optional

mssql_async = mssql+aioodbc://scott:tiger^5HHH@mssql2022:1433/test?driver=ODBC+Driver+18+for+SQL+Server&TrustServerCertificate=yes&Encrypt=Optional

pymssql = mssql+pymssql://scott:tiger^5HHH@mssql2022:1433/test

mssql_python = mssql+mssqlpython://scott:tiger^5HHH@mssql2022:1433/test?Encrypt=No

docker_mssql = mssql+pyodbc://scott:tiger^5HHH@127.0.0.1:1433/test?driver=ODBC+Driver+18+for+SQL+Server&TrustServerCertificate=yes&Encrypt=Optional

oracle = oracle+oracledb://scott:tiger@oracle23c/freepdb1

cxoracle = oracle+cx_oracle://scott:tiger@oracle23c/freepdb1

oracledb = oracle+oracledb://scott:tiger@oracle23c/freepdb1

oracledb_async = oracle+oracledb_async://scott:tiger@oracle23c/freepdb1

docker_oracle = oracle+cx_oracle://scott:tiger@127.0.0.1:1521/?service_name=FREEPDB1