prefect_sqlalchemy.credentials
Credential classes used to perform authenticated interactions with SQLAlchemy
Classes
AsyncDriver
Known dialects with their corresponding async drivers.
Attributes:
POSTGRESQL_ASYNCPG: postgresql+asyncpgSQLITE_AIOSQLITE: sqlite+aiosqliteMYSQL_ASYNCMY: mysql+asyncmyMYSQL_AIOMYSQL: mysql+aiomysqlORACLE_ORACLEDB_ASYNC: oracle+oracledb_async
SyncDriver
Known dialects with their corresponding sync drivers.
Attributes:
POSTGRESQL_PSYCOPG2: postgresql+psycopg2POSTGRESQL_PG8000: postgresql+pg8000POSTGRESQL_PSYCOPG2CFFI: postgresql+psycopg2cffiPOSTGRESQL_PYPOSTGRESQL: postgresql+pypostgresqlPOSTGRESQL_PYGRESQL: postgresql+pygresqlMYSQL_MYSQLDB: mysql+mysqldbMYSQL_PYMYSQL: mysql+pymysqlMYSQL_MYSQLCONNECTOR: mysql+mysqlconnectorMYSQL_CYMYSQL: mysql+cymysqlMYSQL_OURSQL: mysql+oursqlMYSQL_PYODBC: mysql+pyodbcSQLITE_PYSQLITE: sqlite+pysqliteSQLITE_PYSQLCIPHER: sqlite+pysqlcipherORACLE_CX_ORACLE: oracle+cx_oracleORACLE_ORACLEDB: oracle+oracledbMSSQL_PYODBC: mssql+pyodbcMSSQL_MXODBC: mssql+mxodbcMSSQL_PYMSSQL: mssql+pymssql
ConnectionComponents
Parameters to use to create a SQLAlchemy engine URL.
Attributes:
driver: The driver name to use.database: The name of the database to use.username: The user name used to authenticate.password: The password used to authenticate.host: The host address of the database.port: The port to connect to the database.query: A dictionary of string keys to string values to be passed to the dialect and/or the DBAPI upon connect.
create_url
- The SQLAlchemy engine URL.