"""Create fixture entries in db."""

import mysql.connector


def mysqlclient_docker():
    """Initialize mysql client for docker image."""
    return mysql.connector.connect(
        host='payments-generate-mysql',
        port='3306',
        database='royalty_accounting',
        user='db_user',
        password='db_pass'
    )


cnx = mysqlclient_docker()

cursor = cnx.cursor()
account_insert = """
    INSERT INTO account (
        account_id,
        account_name,
        created_by,
        created_at,
        last_modified_by,
        last_modified
    ) VALUES (1, 'Account Name', 'dana', NOW(), 'dana', NOW());
"""
cursor.execute(account_insert)
cnx.commit()

contract_insert = """
    INSERT INTO contract (
        contract_id,
        contract_name,
        reference_signing_entity_id,
        created_by,
        created_at,
        last_modified_by,
        last_modified
    ) VALUES (1, 'Contract Name', 1, 'jess', NOW(), 'jess', NOW());
"""
cursor.execute(contract_insert)
cnx.commit()

program_insert = """
    INSERT INTO reference_payoneer_program
        (payoneer_program_id, funding_currency, reference_payment_type_id) VALUES
        (1, 'USD', 1)
"""
cursor.execute(program_insert)
cnx.commit()

cursor = cnx.cursor()
account_payee_insert = """
    INSERT INTO account_payee (
        account_payee_id,
        account_id,
        payoneer_program_id,
        payoneer_payee_id,
        created_by,
        created_at,
        last_modified_by,
        last_modified
    ) VALUES (1, 1, 1, 1, 'dana', NOW(), 'dana', NOW());
"""
cursor.execute(account_payee_insert)
cnx.commit()

cursor = cnx.cursor()
abacus_state_insert = """
        INSERT INTO abacus_state(
            parent_table_id,
            parent_table_name,
            action_name,
            action_status,
            created_at,
            created_by,
            last_modified,
            last_modified_by
        ) VALUES (
            1,
            'account_payee',
            'payment_eligibility',
            'approved',
            NOW(),
            'user_id',
            NOW(),
            'user_id'
        ), (
            1,
            'account_payee',
            'tax_eligibility',
            'complete',
            NOW(),
            'user_id',
            NOW(),
            'user_id'
        );
"""
cursor.execute(abacus_state_insert)
cnx.commit()

account_payment_term_insert = """
    INSERT INTO account_payment_term(
        account_payment_term_id,
        account_id,
        currency_code,
        payment_minimum,
        payment_entity_id,
        payment_schedule,
        created_by,
        created_at,
        last_modified_by,
        last_modified
    ) VALUES (
        1,
        1,
        'USD',
        100.00,
        1,
        '60_days_after_month_end',
        'dana',
        NOW(),
        'dana',
        NOW()
    );
"""
cursor.execute(account_payment_term_insert)
cnx.commit()

cursor = cnx.cursor()
ledger_account_contract_insert = """
    INSERT INTO ledger_account_contract(
        abacus_event_id,
        account_id,
        contract_id,
        currency_code,
        currency_amount,
        previous_balance,
        current_balance,
        created_by,
        created_at,
        last_modified_by,
        last_modified
    ) VALUES (2, 1, 1, 'USD', 200.00, 0.00, 200.00, 'dana', NOW(), 'dana', NOW());
"""
cursor.execute(ledger_account_contract_insert)
cnx.commit()

cursor = cnx.cursor()
payment_hold_insert = """
    INSERT INTO payment_hold (
        is_on_hold,
        start_date,
        reason,
        created_by,
        created_at,
        last_modified_by,
        last_modified
    ) VALUES (0, NOW(), 'test', 'dana', NOW(), 'dana', NOW());
"""
cursor.execute(payment_hold_insert)
cnx.commit()

cursor = cnx.cursor()
payment_group_insert = """
    INSERT INTO payment_group (
        payment_group_id,
        group_name,
        group_criteria,
        is_reusable,
        created_by,
        created_at,
        last_modified_by,
        last_modified
    ) VALUES
    (74, 'Payment Group', '{"account_id": 1}', 0, 'dana', NOW(), 'dana', NOW());
"""
cursor.execute(payment_group_insert)
cnx.commit()

payment_group_payment_insert = """
    INSERT INTO payment_group_payment (
        payment_group_payment_id,
        payment_group_id,
        payment_name,
        created_by,
        created_at,
        last_modified_by,
        last_modified
    ) VALUES (74, 74, 'Payment Name', 'dana', NOW(), 'dana', NOW());;
"""
cursor.execute(payment_group_payment_insert)
cnx.commit()

account_tax_info_insert = """
    INSERT INTO account_tax_info (
    account_id,
    country_of_tax_residence,
    is_sba_signed,
    created_by,
    created_at,
    last_modified_by,
    last_modified) VALUES (
    1, 'USA', DEFAULT,
    'VZ', '2021-11-25 05:32:23', 'VZ', '2021-11-25 05:32:28')
"""
cursor.execute(account_tax_info_insert)
cnx.commit()

cnx.close()

print('Fixture entries were inserted')