from config.Config import Config
from database.QueryParameters import QueryParameters
from database.db_adapter import DBAdapter
from keepass.Keepass import KeePass
from logger.logger import init_logger
from models.ExportType import ExportType
from models.Municipality import Municipality

logger = init_logger()

config = Config()

keepass = KeePass(config.kee_pass, logger)

municipalities = [
    Municipality("op_test", None, "OP", "test")
]

parameter = QueryParameters(title="Test rapport", input_path="query.sql", export_type=ExportType.XML)

db_adapter = DBAdapter(keepass, config.database, logger)
db_adapter.run_sql_file_export_to_file_multiple_schemas(municipalities=municipalities, query_parameter=parameter)

# db_adapter.run_sql_file_multiple_statements()