package db

// SeedTagCategories contains SQL to populate initial tag categories
const SeedTagCategories = `
-- Root categories
INSERT OR IGNORE INTO tag_categories (id, name, parent_id, description) VALUES
(1, 'general', NULL, 'General uncategorized tags'),
(2, 'people', NULL, 'People-related attributes'),
(3, 'clothing', NULL, 'Clothing and wardrobe'),
(4, 'position', NULL, 'Positions and poses'),
(5, 'action', NULL, 'Actions and activities'),
(6, 'setting', NULL, 'Location and environment'),
(7, 'production', NULL, 'Production quality and style');

-- People subcategories
INSERT OR IGNORE INTO tag_categories (name, parent_id, description) VALUES
('people/count', 2, 'Number of people in scene'),
('people/ethnicity', 2, 'Ethnic background'),
('people/age_category', 2, 'Age category (teen, milf, mature, etc)'),
('people/body_type', 2, 'Body type and build'),
('people/hair', 2, 'Hair attributes'),
('people/hair/color', (SELECT id FROM tag_categories WHERE name = 'people/hair'), 'Hair color'),
('people/hair/length', (SELECT id FROM tag_categories WHERE name = 'people/hair'), 'Hair length'),
('people/eyes', 2, 'Eye attributes'),
('people/eyes/color', (SELECT id FROM tag_categories WHERE name = 'people/eyes'), 'Eye color');

-- Clothing subcategories
INSERT OR IGNORE INTO tag_categories (name, parent_id, description) VALUES
('clothing/type', 3, 'Type of clothing (lingerie, uniform, etc)'),
('clothing/color', 3, 'Clothing color'),
('clothing/specific', 3, 'Specific clothing items'),
('clothing/specific/top', (SELECT id FROM tag_categories WHERE name = 'clothing/specific'), 'Upper body clothing'),
('clothing/specific/bottom', (SELECT id FROM tag_categories WHERE name = 'clothing/specific'), 'Lower body clothing'),
('clothing/specific/footwear', (SELECT id FROM tag_categories WHERE name = 'clothing/specific'), 'Shoes and footwear'),
('clothing/specific/accessories', (SELECT id FROM tag_categories WHERE name = 'clothing/specific'), 'Accessories');

-- Position subcategories
INSERT OR IGNORE INTO tag_categories (name, parent_id, description) VALUES
('position/category', 4, 'General position category'),
('position/specific', 4, 'Specific named positions');

-- Action subcategories
INSERT OR IGNORE INTO tag_categories (name, parent_id, description) VALUES
('action/sexual', 5, 'Sexual acts'),
('action/non_sexual', 5, 'Non-sexual activities');

-- Setting subcategories
INSERT OR IGNORE INTO tag_categories (name, parent_id, description) VALUES
('setting/location', 6, 'Physical location'),
('setting/time', 6, 'Time of day'),
('setting/indoor_outdoor', 6, 'Indoor vs outdoor');

-- Production subcategories
INSERT OR IGNORE INTO tag_categories (name, parent_id, description) VALUES
('production/quality', 7, 'Video quality'),
('production/style', 7, 'Production style (POV, amateur, etc)'),
('production/camera', 7, 'Camera work and angles');
`

// SeedCommonTags contains SQL to populate common tags
const SeedCommonTags = `
-- People count tags
INSERT OR IGNORE INTO tags (name, category_id, description) VALUES
('solo', (SELECT id FROM tag_categories WHERE name = 'people/count'), 'One person'),
('duo', (SELECT id FROM tag_categories WHERE name = 'people/count'), 'Two people'),
('threesome', (SELECT id FROM tag_categories WHERE name = 'people/count'), 'Three people'),
('foursome', (SELECT id FROM tag_categories WHERE name = 'people/count'), 'Four people'),
('orgy', (SELECT id FROM tag_categories WHERE name = 'people/count'), 'Five or more people');

-- Ethnicity tags
INSERT OR IGNORE INTO tags (name, category_id, aliases, description) VALUES
('black', (SELECT id FROM tag_categories WHERE name = 'people/ethnicity'), 'ebony,african', 'Black/African descent'),
('white', (SELECT id FROM tag_categories WHERE name = 'people/ethnicity'), 'caucasian', 'White/Caucasian'),
('asian', (SELECT id FROM tag_categories WHERE name = 'people/ethnicity'), NULL, 'Asian descent'),
('latina', (SELECT id FROM tag_categories WHERE name = 'people/ethnicity'), 'hispanic', 'Hispanic/Latina');

-- Age category tags
INSERT OR IGNORE INTO tags (name, category_id, description) VALUES
('teen', (SELECT id FROM tag_categories WHERE name = 'people/age_category'), '18-21 age range'),
('milf', (SELECT id FROM tag_categories WHERE name = 'people/age_category'), 'Mature woman (30-50)'),
('mature', (SELECT id FROM tag_categories WHERE name = 'people/age_category'), 'Mature (50+)');

-- Body type tags
INSERT OR IGNORE INTO tags (name, category_id, description) VALUES
('slim', (SELECT id FROM tag_categories WHERE name = 'people/body_type'), 'Slim build'),
('athletic', (SELECT id FROM tag_categories WHERE name = 'people/body_type'), 'Athletic/fit build'),
('curvy', (SELECT id FROM tag_categories WHERE name = 'people/body_type'), 'Curvy build'),
('bbw', (SELECT id FROM tag_categories WHERE name = 'people/body_type'), 'Big beautiful woman');

-- Hair color tags
INSERT OR IGNORE INTO tags (name, category_id, description) VALUES
('blonde', (SELECT id FROM tag_categories WHERE name = 'people/hair/color'), 'Blonde hair'),
('brunette', (SELECT id FROM tag_categories WHERE name = 'people/hair/color'), 'Brown hair'),
('redhead', (SELECT id FROM tag_categories WHERE name = 'people/hair/color'), 'Red hair'),
('black_hair', (SELECT id FROM tag_categories WHERE name = 'people/hair/color'), 'Black hair');

-- Pubic hair type tags
INSERT OR IGNORE INTO tags (name, category_id, description) VALUES
	('shaved', (SELECT id FROM tag_categories WHERE name = 'people/hair'), 'Completely shaved pubic hair'),
	('natural', (SELECT id FROM tag_categories WHERE name = 'people/hair'), 'Natural/unshaved pubic hair'),
	('trimmed', (SELECT id FROM tag_categories WHERE name = 'people/hair'), 'Trimmed pubic hair'),
	('landing_strip', (SELECT id FROM tag_categories WHERE name = 'people/hair'), 'Landing strip pubic hair'),
	('bushy', (SELECT id FROM tag_categories WHERE name = 'people/hair'), 'Full bush/pubic hair'),
	('hairy', (SELECT id FROM tag_categories WHERE name = 'people/hair'), 'Very hairy pubic hair');

-- Clothing color tags
INSERT OR IGNORE INTO tags (name, category_id, description) VALUES
('pink', (SELECT id FROM tag_categories WHERE name = 'clothing/color'), 'Pink clothing'),
('black', (SELECT id FROM tag_categories WHERE name = 'clothing/color'), 'Black clothing'),
('red', (SELECT id FROM tag_categories WHERE name = 'clothing/color'), 'Red clothing'),
('white', (SELECT id FROM tag_categories WHERE name = 'clothing/color'), 'White clothing'),
('blue', (SELECT id FROM tag_categories WHERE name = 'clothing/color'), 'Blue clothing');

-- Footwear tags
INSERT OR IGNORE INTO tags (name, category_id, aliases, description) VALUES
('heels', (SELECT id FROM tag_categories WHERE name = 'clothing/specific/footwear'), 'high heels', 'High heels'),
('boots', (SELECT id FROM tag_categories WHERE name = 'clothing/specific/footwear'), NULL, 'Boots'),
('stockings', (SELECT id FROM tag_categories WHERE name = 'clothing/specific/footwear'), 'pantyhose', 'Stockings/pantyhose');

-- Bottom clothing tags
INSERT OR IGNORE INTO tags (name, category_id, description) VALUES
('panties', (SELECT id FROM tag_categories WHERE name = 'clothing/specific/bottom'), 'Panties/underwear'),
('skirt', (SELECT id FROM tag_categories WHERE name = 'clothing/specific/bottom'), 'Skirt'),
('jeans', (SELECT id FROM tag_categories WHERE name = 'clothing/specific/bottom'), 'Jeans'),
('shorts', (SELECT id FROM tag_categories WHERE name = 'clothing/specific/bottom'), 'Shorts');

-- Position tags
INSERT OR IGNORE INTO tags (name, category_id, description) VALUES
('missionary', (SELECT id FROM tag_categories WHERE name = 'position/specific'), 'Missionary position'),
('doggy', (SELECT id FROM tag_categories WHERE name = 'position/specific'), 'Doggy style'),
('cowgirl', (SELECT id FROM tag_categories WHERE name = 'position/specific'), 'Cowgirl position'),
('standing', (SELECT id FROM tag_categories WHERE name = 'position/category'), 'Standing position');

-- Setting tags
INSERT OR IGNORE INTO tags (name, category_id, description) VALUES
('bedroom', (SELECT id FROM tag_categories WHERE name = 'setting/location'), 'Bedroom setting'),
('office', (SELECT id FROM tag_categories WHERE name = 'setting/location'), 'Office setting'),
('outdoor', (SELECT id FROM tag_categories WHERE name = 'setting/indoor_outdoor'), 'Outdoor setting'),
('indoor', (SELECT id FROM tag_categories WHERE name = 'setting/indoor_outdoor'), 'Indoor setting');

-- Production quality tags
INSERT OR IGNORE INTO tags (name, category_id, description) VALUES
('hd', (SELECT id FROM tag_categories WHERE name = 'production/quality'), 'High definition (720p+)'),
('4k', (SELECT id FROM tag_categories WHERE name = 'production/quality'), '4K resolution'),
('vr', (SELECT id FROM tag_categories WHERE name = 'production/quality'), 'Virtual reality'),
('pov', (SELECT id FROM tag_categories WHERE name = 'production/style'), 'Point of view'),
('amateur', (SELECT id FROM tag_categories WHERE name = 'production/style'), 'Amateur production'),
('professional', (SELECT id FROM tag_categories WHERE name = 'production/style'), 'Professional production');
`
