mafw.db.db_configurations

Module provides default configurations for different database engines.

Module Attributes

default_conf	default configuration dictionary used to generate steering files
db_scheme	default database scheme
DEFAULT_SQLITE_PRAGMAS	Default pragma settings for SQLite connections.

mafw.db.db_configurations.DEFAULT_SQLITE_PRAGMAS = {'cache_size': -64000, 'foreign_keys': 1, 'journal_mode': 'wal', 'synchronous': 0}

Default pragma settings for SQLite connections.

mafw.db.db_configurations.db_scheme = {'mysql': 'mysql://', 'postgresql': 'postgresql://', 'sqlite': 'sqlite:///'}

default database scheme

mafw.db.db_configurations.default_conf: dict[str, dict[str, Any]] = {'mysql': {'URL': 'mysql://user:passwd@ip:port/my_db', 'authentication': {'method': 'env', 'password': 'MYSQL_PASS', 'username': 'MYSQL_USER'}, 'parameters': {'mysql': {}}}, 'postgresql': {'URL': 'postgresql://postgres:my_password@localhost:5432/my_database', 'authentication': {'method': 'env', 'password': 'POSTGRES_PASS', 'username': 'POSTGRES_USER'}, 'parameters': {'postgresql': {}}}, 'sqlite': {'URL': 'sqlite:///my_database.db', 'parameters': {'sqlite': {'pragmas': {'cache_size': -64000, 'foreign_keys': 1, 'journal_mode': 'wal', 'synchronous': 0}}}}}

default configuration dictionary used to generate steering files