"""DB Fixtures."""
# flake8: noqa

SQL_SEED_CUSTOMER_MASTER = """INSERT INTO `customer_master`
(`customer_master_master_id`)
VALUES (1), (1)"""

SQL_SEED_CUSTOMER_MASTER_MASTER = """INSERT INTO `customer_master_master`
(`customer_master_master_id`, `customer_name`, `priority`, `encoding_REMOVE`, `delivery_REMOVE`, `mixed_album`)
VALUES (1, 'iTunes/Apple', 1, 'Y', 'Y', 'combined')
"""

SQL_SEED_CUSTOMER_MASTER_MASTER_AR = """INSERT INTO `customer_master_master`
(`customer_master_master_id`, `customer_name`, `ddex_party_id`)
VALUES (1, 'iTunes/Apple', 'ASDF2345234523452354')
"""

SQL_SEED_ENCODING_QUEUE_TABLE = """INSERT INTO encoding_queue
(`encoding_queue_id`, `encoding_order_type`, `encoder_id`)
VALUES
(1, 'release', 18),
(2, 'release', 18),
(3, 'harddrive', 18),
(4, 'ringtone', 18)
"""

SQL_SEED_ENCODING_QUEUE_DETAIL_TABLE = """INSERT INTO encoding_queue_detail
(`encoding_queue_detail_id`, `dms_master_master_id`, `encoding_queue_id`, `status`, `upc`)
VALUES
(1, 1, 1, "ready_to_deliver", 3452345234523),
(2, 1, 1, "ready_to_deliver", 3452345234524),
(3, 1, 1, "ready_to_deliver", 3452345234525),
(4, 1, 1, "ready_to_deliver", 3452345234526),
(5, 1, 1, "ready_to_deliver", 3452345234527),
(6, 1, 1, "ready_to_deliver", 3452345234528),
(7, 1, 1, "delivered", 3452345234529),
(8, 1, 2, "new", 3552345234520),
(9, 1, 2, "encoded", 3552345234521),
(10, 1, 2, "ready_to_deliver", 3552345234522),
(11, 1, 3, "new", 3552345234523),
(12, 1, 4, "new", 3552345234524)
"""

SQL_SEED_DMS_DELIVERY_SPEC_TABLE = """INSERT INTO dms_delivery_spec
(`connection_limit`, `dms_master_master_id`, `order_type`, `batch_delivery`,
  `encoding`, `num_per_batch`, `max_num_batches`, `delivery`)
VALUES
(10, 1, 'release', 'N', 'Y', 100, 5, 'Y'),
(10, 1, 'harddrive', 'N', 'Y', 1000, 10, 'Y'),
(10, 1, 'ringtone', 'N', 'N', 1000, 10, 'N')
"""

SQL_SEED_CUSTOMER_MASTER_MASTER_CONTACT = """INSERT INTO `customer_master_master_contact`
(`local_focus_territory`, `customer_master_master_id`, `contact_type`, `sendemail`, `contact_email`, `contact_first_name`, `contact_last_name`)
VALUES ('123,231,312', 1, 'delivery_notification', 'yes', 'contact@mail.com', 'first name', 'last name');
"""

SQL_SEED_TRACK = """INSERT INTO `track`
(`upc`, `cd`, `track_id`, `release_id`)
VALUES (123, 1, 1, 6),
(123, 1, 2, 6),
(123, 1, 3, 6),
(123, 1, 4, 6),
(123, 2, 1, 6),
(123, 2, 2, 6),
(123, 2, 3, 6),
(321, 1, 1, 2),
(321, 1, 2, 2),
(321, 1, 3, 2)
"""

SQL_SEED_BATCH_DELIVERY_JOBS_1 = """
INSERT INTO `job_priority` (`encoding_queue_detail_id`, `rule_matches`, `priority`)
VALUES (1, 1, 1), (2, 1, 2), (3, 1, 1), (4, 1, 2), (5, 1, 3), (6, 1, 3)"""

SQL_SEED_BATCH_DELIVERY_JOBS_2 = """
INSERT INTO `delivery_batch` (`delivery_batch_id`, `dms_master_master_id`, `priority`, `remote_folder`, `status`, `time_created`, `order_type`, `last_updated`)
VALUES (1, 1, 1, '20140521_0001', 'open', '2018-12-06 03:10:42', 'release', '2016-12-06 06:41:17');"""

SQL_SEED_BATCH_DELIVERY_JOBS_3 = """
INSERT INTO `delivery_batch_detail` (`delivery_batch_detail_id`, `delivery_batch_id`, `encoding_queue_detail_id`, `pid`)
VALUES (1, 1, 1, 1)"""

SQL_SEED_BATCH_DELIVERY_JOBS_4 = """
UPDATE `dms_delivery_spec` SET `batch_delivery`='Y', `delivery`='Y' WHERE `dms_delivery_spec_id`=1;
"""

SQL_SEED_NONBATCH_DELIVERY_JOBS_1 = """
INSERT INTO `job_priority` (`encoding_queue_detail_id`, `rule_matches`, `priority`)
VALUES (1, 1, 1)"""

SQL_SEED_NONBATCH_DELIVERY_JOBS_2 = """
UPDATE `dms_delivery_spec` SET `batch_delivery`='N', `delivery`='Y' WHERE `dms_delivery_spec_id`=1;
"""

SQL_SET_NON_BATCH_DELIVERY_ITEM_TO_NEW = """
UPDATE encoding_queue_detail SET `status`="new" WHERE `encoding_queue_detail_id`=1;
"""

SQL_SET_BATCH_DELIVERY_ITEM_TO_DELIVERING = """
UPDATE encoding_queue_detail SET `status`="delivering" WHERE `encoding_queue_detail_id`=1;
"""

SQL_SET_BATCH_DELIVERY_ITEM_TO_DELIVERED = """
UPDATE encoding_queue_detail SET `status`="delivered" WHERE `encoding_queue_detail_id`=1;
"""

SQL_SET_BATCH_DELIVERY_ITEMS_TO_ENCODED = """
UPDATE encoding_queue_detail SET `status`="encoded"
WHERE `encoding_queue_detail_id` IN (1, 2, 3, 4, 5, 6);
"""

SQL_SEED_PRODUCT_TYPE = """INSERT INTO `product_type`
(`id`, `product_type`)
VALUES (1, 'Music');
"""

SQL_SEED_PROJECT = """INSERT INTO `project`
(`project_id`, `vendor_id`, `subaccount_id`, `project_name`, `created_date_utc`, `updated_date_utc`)
VALUES (1, 1, 0, 'test', NOW(), NOW());
"""

SQL_SEED_RELEASES = """INSERT INTO `releases`
(`release_id`, `upc`, `artist_id`, `display_upc`, `project_id`)
VALUES (1, 452345234521, 1, '452345234521', 1),
(2, 452345234522, 1, '452345234522', 1),
(3, 452345234523, 1, '452345234523', 1),
(4, 452345234524, 1, '452345234524', 1),
(5, 452345234525, 1, '452345234525', 1),
(6, 123, 1, '123', 1);"""

SQL_SEED_ARTIST_INFO = """INSERT INTO `artist_info`
(`artist_id`, `name`, `vendor_id`, `orchard_country`)
VALUES (1, 'artist 1', 1, 1),(2, 'artist 2', 1, 1),(3, 'artist 3', 1, 1),(4, 'artist 4', 1, 1);"""

SQL_SEED_PARENT_COMPANY = """INSERT INTO `parent_company` (`id`, `name`, `uuid`, `display_name`, `date_updated`)
VALUES (1, 'sme', 'f1594122-7f99-4916-b103-08b0444c7b46', 'Sony Music', NOW());
"""

SQL_SEED_COMPANY_BRAND = """INSERT INTO `company_brand` (`id`, `name`, `uuid`, `parent_company_id`, `display_name`, `date_updated`)
VALUES (1, 'knr', '77c6c150-19f3-451f-a692-1a5d7ef30e85', 1, 'Kollective Neighbouring Rights', NOW());
"""

SQL_SEED_VENDOR = """INSERT INTO `vendor` (`vendor_id`, `company`, `company_brand_id`)
VALUES (1, 'vendor 1', 1);
"""

SQL_SEED_VEND_CONTACT = """INSERT INTO `vend_contact` (`vendor_id`, `id`, `contact_id`, `master`)
VALUES (1, 1, 1, 'Y');
"""

SQL_SEED_CONTACT = """INSERT INTO `contact` (`contact_id`, `orchard_country`)
VALUES (1, 1);
"""

SQL_SEED_RELEASE_EXCLUSIVE = """INSERT INTO release_exclusive (upc, dms_customer_id, sale_start_date, release_id)
VALUES (123, 1, '2018-08-08', 6)
"""

SQL_SEED_OPEN_BATCHES = """INSERT INTO delivery_batch (delivery_batch_id, dms_master_master_id, priority, status,
    order_type, remote_folder) VALUES (1, 1, 1, 'open', 'release', '20140521_0001'),
    (2, 1, 2, 'open', 'release', '20140521_0002'), (3, 1, 3, 'open', 'release', '20140521_0003')
"""
SQL_SEED_OPEN_BATCHES_DETAILS = """INSERT INTO delivery_batch_detail (
  delivery_batch_id, encoding_queue_detail_id) VALUES (1, 1), (1, 2), (2, 3),
  (2, 4), (3, 5), (3, 6), (1, 7)
"""

SQL_SEED_PHYSICAL_LOCATION = """
INSERT INTO `physical_location` (physical_location_id, physical_location, location_type)
VALUES (1, 'colo', 'drive');
"""

SQL_SEED_STORAGE = """
INSERT INTO storage (storage_id, storage_name, local_ip, remote_ip, physical_location_id)
VALUES (1, 'str_1', 2341234124, 2345345342, 1);
"""

SQL_SEED_STORAGE_DRIVE = """
INSERT INTO `storage_drive` (`storage_drive_id`, `storage_id`)
VALUES (1, 1);
"""

SQL_SEED_ASSET_TYPE = """
INSERT INTO `asset_type` (`asset_type_id`, `asset`, `file_type`, `extension`, `initial_folder`, `folder_structure`, `parent_asset_type_id`)
VALUES (1, 'WAV', 'directory', '.wav', 'audio/WAV/', '{upc(0,6)}/{upc(6,3)}/{upc}', null);
"""

SQL_SEED_STORAGE_DRIVE_ASSET_FOLDER = """
INSERT INTO storage_drive_asset_folder (storage_drive_id, asset_type_id, initial_folder)
VALUES (1, 1, 'wav1/');
"""