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

import os

import mysql.connector


cnx = mysql.connector.connect(
    host=os.environ.get('MYSQL_HOST', '127.0.0.1'),
    port=os.environ.get('MYSQL_PORT', '18087'),
    database=os.environ.get('MYSQL_DB', 'royalty_accounting'),
    user=os.environ.get('MYSQL_USER', 'db_user'),
    password=os.environ.get('MYSQL_PASS', 'db_pass'))

cursor = cnx.cursor()
payee_query = """INSERT INTO payee (
payee_id,
payee_name,
payee_type,
payment_agreement_type,
currency_code,
payment_schedule,
payment_minimum,
payment_method,
created_by,
created_at,
last_modified_by,
last_modified)
VALUES (1, 'test', 'Label', 'The Orchard', 'USD', '60 days after month end',
100.00, 'Check', 'test', '2020-08-31 05:04:33', 'test', '2020-08-31 05:04:37')"""
cursor.execute('SET FOREIGN_KEY_CHECKS=0')
cursor.execute('TRUNCATE payee')
cursor.execute('SET FOREIGN_KEY_CHECKS=1')
cnx.commit()
cursor.execute(payee_query)
cnx.commit()

cursor = cnx.cursor()
payee_contact_query = """INSERT INTO payee_contact (
payee_contact_id,
payee_id,
contact_name,
email,
phone_number,
address_1,
address_2,
address_3,
city,
state_province_region,
postal_code,
country_code,
created_by,
created_at,
last_modified_by,
last_modified)
VALUES (1, 1, 'test', 'test@test.com', '123123123', 'addr1', 'addr2', 'addr3',
'city', 'state', '61072', 'PL', 'test',
'2020-08-31 06:26:38', 'test', '2020-08-31 06:26:42')"""
cursor.execute('SET FOREIGN_KEY_CHECKS=0')
cursor.execute('TRUNCATE payee_contact')
cursor.execute('SET FOREIGN_KEY_CHECKS=1')
cnx.commit()
cursor.execute(payee_contact_query)
cnx.commit()

cursor = cnx.cursor()
ledger_payee_query = """INSERT INTO ledger_payee (
ledger_payee_id,
payee_id,
abacus_event_id,
ledger_type,
currency_code,
currency_amount,
previous_balance,
current_balance,
note,
created_by,
created_at,
last_modified_by,
last_modified)
VALUES (1, 1, 2, 'credit', 'USD', 200.00, 0.00, 200.00,
null, 'test', '2020-08-31 05:18:29', 'test', '2020-08-31 05:18:42')"""
cursor.execute('SET FOREIGN_KEY_CHECKS=0')
cursor.execute('TRUNCATE ledger_payee')
cursor.execute('SET FOREIGN_KEY_CHECKS=1')
cnx.commit()
cursor.execute(ledger_payee_query)
cnx.commit()

cursor = cnx.cursor()
payment_hold_query = """INSERT INTO payment_hold (
payment_hold_id,
payee_id,
is_on_hold,
start_date,
reason,
created_by,
created_at,
last_modified_by,
last_modified)
VALUES (1, 1, 0, '2020-08-31', 'test', 'test',
'2020-08-31 07:00:47', 'test', '2020-08-31 07:00:51')"""
cursor.execute('SET FOREIGN_KEY_CHECKS=0')
cursor.execute('TRUNCATE payment_hold')
cursor.execute('SET FOREIGN_KEY_CHECKS=1')
cnx.commit()
cursor.execute(payment_hold_query)
cnx.commit()


cursor = cnx.cursor()
payment_group_query = """INSERT INTO payment_group (
payment_group_id,
group_name,
group_criteria,
is_reusable,
created_at,
created_by,
last_modified,
last_modified_by,
deleted_at,
deleted_by)
VALUES (74, 'test', '{"payee_id": 1}', 0, '2020-08-28 07:11:39',
'test', '2020-08-28 07:11:42', 'test', null, null)"""
cursor.execute('SET FOREIGN_KEY_CHECKS=0')
cursor.execute('TRUNCATE payment_group')
cursor.execute('SET FOREIGN_KEY_CHECKS=1')
cnx.commit()
cursor.execute(payment_group_query)
cnx.commit()

payment_group_payment_query = """INSERT INTO payment_group_payment (
payment_group_payment_id,
payment_group_id,
payment_name,
payment_status,
created_at,
created_by,
last_modified,
last_modified_by,
deleted_at,
deleted_by)
VALUES (74, 74, 'test', 'generating_payments', '2020-08-28 07:26:44',
'test', '2020-08-28 07:26:49', 'test', null, null)"""
cursor.execute('SET FOREIGN_KEY_CHECKS=0')
cursor.execute('TRUNCATE payment_group_payment')
cursor.execute('SET FOREIGN_KEY_CHECKS=1')
cnx.commit()
cursor.execute(payment_group_payment_query)
cnx.commit()

cnx.close()

print('Fixture entries were inserted')