"""Creates required DB fixtures."""

import mysql.connector

cnx = mysql.connector.connect(
    host='json-contract-file-import-mysql',
    port='3306',
    database='royalty_accounting',
    user='db_user',
    password='db_pass'
)

cursor = cnx.cursor()
query = """
INSERT INTO royalty_accounting.run_controller (
    run_controller_id,
    run_controller_name,
    contract_type,
    created_by,
    created_at,
    last_modified_by,
    last_modified,
    deleted_by,
    deleted_at
) VALUES (
    1,
    'vztest_runcontroller',
    'distribution',
    'vz',
    '2024-12-20 14:41:15',
    'vz',
    '2024-12-20 14:41:17',
    null,
    null
)"""
cursor.execute(query)
cnx.commit()

cnx.close()

print('Fixtures were created.')