\set dev '00000000-0000-0000-0000-000000000001'

begin;

insert into venues (city_id, name, address, owner_id)

select id, v.name, v.addr, :'dev' from cities, (values

  ('The Southside Ballroom (Sample)', 'Bronzeville, Chicago, IL'),

  ('The Lakefront Ballroom (Sample)', 'Hyde Park, Chicago, IL')

) as v(name, addr) where slug = 'chicago';

insert into venues (city_id, name, address, owner_id)

select id, v.name, v.addr, :'dev' from cities, (values

  ('The Peachtree Room (Sample)', 'Old Fourth Ward, Atlanta, GA')

) as v(name, addr) where slug = 'atlanta';

insert into venues (city_id, name, address, owner_id)

select id, v.name, v.addr, :'dev' from cities, (values

  ('The Riverfront Hall (Sample)', 'Rivertown, Detroit, MI')

) as v(name, addr) where slug = 'detroit';

insert into events (city_id, title, type, description, starts_at, is_live, live_url, is_promoted, owner_id)

select id, e.title, e.type::event_type, e.descr, e.ts::timestamptz, e.live, e.lurl, e.promo, :'dev'

from cities, (values

  ('Friday Night Smooth Set', 'set',

   'Weekly grown folks'' steppers set on the South Side. Live DJ, dress code in effect.',

   '2026-07-10 21:00', true, 'https://www.youtube.com/watch?v=M3SlJHI_zYU', false),

  ('World Steppers Weekend', 'weekender',

   'Three-day Chicago steppin'' weekender: sets, workshops, and a contest. Hotel block open now.',

   '2026-08-14 18:00', false, null, true),

  ('Saturday Steppin'' Contest', 'competition',

   'Open floor contest judged on timing, turns, and smoothness.',

   '2026-09-05 19:30', false, null, false),

  ('Steppin'' Against Domestic Violence', 'special',

   'A benefit set raising awareness and funds for domestic violence survivors. All proceeds donated.',

   '2026-07-26 17:00', false, null, false)

) as e(title, type, descr, ts, live, lurl, promo) where slug = 'chicago';

insert into events (city_id, title, type, description, starts_at, owner_id)

select id, e.title, e.type::event_type, e.descr, e.ts::timestamptz, :'dev' from cities, (values

  ('Sunday Steppers Social', 'social', 'Laid-back Sunday set for steppers visiting or based in the ATL.', '2026-07-19 18:00')

) as e(title, type, descr, ts) where slug = 'atlanta';

insert into events (city_id, title, type, description, starts_at, owner_id)

select id, e.title, e.type::event_type, e.descr, e.ts::timestamptz, :'dev' from cities, (values

  ('Rivertown Steppers Set', 'set', 'Detroit''s monthly steppin'' set with a guest Chicago DJ.', '2026-07-25 21:00')

) as e(title, type, descr, ts) where slug = 'detroit';

insert into djs (city_id, name, bio, owner_id)

select id, t.n, t.b, :'dev' from cities, (values

  ('DJ Smooth Glide', 'South Side steppers'' DJ, smooth soul and steppin'' cuts.'),

  ('DJ Eight Count', 'Keeps the floor on the count all night.')

) t(n, b) where slug = 'chicago';

insert into djs (city_id, name, bio, owner_id)

select id, 'DJ Peachtree Steppin''', 'Atlanta''s go-to for Chicago-style sets.', :'dev' from cities where slug = 'atlanta';

insert into promoters (city_id, name, bio, owner_id)

select id, t.n, t.b, :'dev' from cities, (values

  ('Glideline Events', 'Throwing South Side sets and weekenders since the 90s.'),

  ('South Side Smooth Productions', 'Sets, contests, and the annual steppers weekend.')

) t(n, b) where slug = 'chicago';

insert into promoters (city_id, name, bio, owner_id)

select id, 'ATL Steppers Connection', 'Bringing Chicago steppin'' to the ATL.', :'dev' from cities where slug = 'atlanta';

insert into stepping_groups (city_id, name, bio, owner_id)

select id, g.name, g.bio, :'dev' from cities, (values

  ('Smooth Steppers Society', 'Longtime South Side steppin'' crew, sets and classes citywide.'),

  ('The Glideline Steppers', 'Community group keeping Chicago steppin'' culture moving.')

) as g(name, bio) where slug = 'chicago';

insert into stepping_groups (city_id, name, bio, owner_id)

select id, 'The Rivertown Steppers', 'Detroit''s home for Chicago-style steppin''.', :'dev'

from cities where slug = 'detroit';

insert into instructors (city_id, name, bio, owner_id)

select id, t.n, t.b, :'dev' from cities, (values

  ('Coach Renee', 'Beginner lessons on the South Side. Group classes Tuesdays, privates by appointment.'),

  ('Mr. Williams', 'Footwork and turn work for intermediate and advanced steppers.')

) t(n, b) where slug = 'chicago';

insert into instructors (city_id, name, bio, owner_id)

select id, 'Coach Dee', 'Chicago-style fundamentals for steppers in the ATL.', :'dev'

from cities where slug = 'atlanta';

insert into classes (city_id, title, instructor, schedule, is_free, owner_id)

select id, c.title, c.inst, c.sched, c.free, :'dev' from cities, (values

  ('Beginner Chicago Steppin''', 'Coach Renee', 'Tuesdays 7:00pm', false),

  ('Intermediate Footwork & Turns', 'Mr. Williams', 'Thursdays 7:30pm', false),

  ('Free Community Steppin'' Practice', 'Smooth Steppers Society', 'Sundays 4:00pm', true)

) as c(title, inst, sched, free) where slug = 'chicago';

insert into travel_places (city_id, category, name, address)

select id, t.cat::travel_category, t.name, t.addr from cities, (values

  ('event_center', 'The Southside Ballroom (Sample)', 'Bronzeville, Chicago, IL'),

  ('event_center', 'The Lakefront Ballroom (Sample)', 'Hyde Park, Chicago, IL'),

  ('hotel', 'The Convention Way Hotel (Sample)', 'Near South Side, Chicago, IL'),

  ('hotel', 'The Park Row Hotel (Sample)', 'Hyde Park, Chicago, IL'),

  ('restaurant', 'The Corner Kitchen (Sample)', 'Bronzeville, Chicago, IL'),

  ('restaurant', 'The South Side Smokehouse (Sample)', 'Chatham, Chicago, IL'),

  ('mall', 'The State Street Shops (Sample)', 'The Loop, Chicago, IL'),

  ('attraction', 'The Heritage Museum (Sample)', 'Washington Park, Chicago, IL'),

  ('entertainment', 'The Rhythm Lounge (Sample)', 'South Loop, Chicago, IL'),

  ('hospital', 'South Side Medical Center (Sample)', 'Hyde Park, Chicago, IL')

) as t(cat, name, addr) where slug = 'chicago';

insert into travel_places (city_id, category, name, address)

select id, t.cat::travel_category, t.name, t.addr from cities, (values

  ('event_center', 'The Peachtree Room (Sample)', 'Old Fourth Ward, Atlanta, GA'),

  ('hotel', 'The Downtown Atlanta Hotel (Sample)', 'Downtown, Atlanta, GA'),

  ('restaurant', 'The Westside Kitchen (Sample)', 'Castleberry Hill, Atlanta, GA'),

  ('attraction', 'The Downtown Park Commons (Sample)', 'Downtown, Atlanta, GA'),

  ('hospital', 'Downtown Atlanta Medical Center (Sample)', 'Downtown, Atlanta, GA')

) as t(cat, name, addr) where slug = 'atlanta';

insert into videos (city_id, title, embed_url, platform, owner_id)

select id, v.title, v.url, v.plat::video_platform, :'dev' from cities, (values

  ('Chicago Steppin Is Freedom on the Dance Floor', 'https://www.youtube.com/watch?v=M3SlJHI_zYU', 'youtube'),

  ('The History of Chicago Steppin', 'https://www.youtube.com/watch?v=9UEqba30cCE', 'youtube'),

  ('Gliding Moves of the South Side Scene', 'https://www.youtube.com/watch?v=-Y4iTvplmmQ', 'youtube')

) as v(title, url, plat) where slug = 'chicago';

insert into videos (city_id, title, embed_url, platform, owner_id)

select id, 'Chicago Steppin'' Lesson Breakdown', 'https://www.youtube.com/watch?v=HUbSuIPJiKc', 'youtube', :'dev'

from cities where slug = 'atlanta';

insert into comments (subject_type, subject_id, body, owner_id)

select 'event', id, 'Who all coming out Friday? The floor was packed last week.', :'dev'

from events where title = 'Friday Night Smooth Set' limit 1;

insert into comments (subject_type, subject_id, body, owner_id)

select 'event', id, 'Good cause and a good time. We will be there.', :'dev'

from events where title = 'Steppin'' Against Domestic Violence' limit 1;

insert into ticket_types (event_id, name, price_cents, capacity, owner_id)

select e.id, t.name, t.cents, t.cap, :'dev'

from events e, (values

  ('Weekend Pass', 7500, 200),

  ('Single Night', 2500, NULL)

) as t(name, cents, cap)

where e.title = 'World Steppers Weekend';

insert into ticket_types (event_id, name, price_cents, owner_id)

select id, 'Cover', 1500, :'dev' from events where title = 'Friday Night Smooth Set';

insert into sponsors (city_id, name, blurb, link_url, status)

select id, 'Smooth Threads (Sample)', 'Steppers-sharp menswear on 79th', 'https://example.com', 'active'

from cities where slug = 'chicago';

insert into vendors (city_id, name, description, category, link_url, owner_id)

select id, v.n, v.d, v.c, v.l, :'dev' from cities, (values

  ('Sample Vendor: Stepping Shoes', 'Demo listing. Comfortable soles built for a long night on the floor.', 'Footwear', 'https://example.com'),

  ('Sample Vendor: Sharp Shades', 'Demo listing. Frames for stepping sharp and coming clean.', 'Accessories', NULL)

) as v(n, d, c, l) where slug = 'chicago';

insert into vendors (city_id, event_id, name, description, category, owner_id)

select c.id, e.id, 'Sample Vendor: Weekend Boutique', 'Demo listing. Purses and accessories, this event only.', 'Accessories', :'dev'

from cities c

join events e on e.city_id = c.id and e.title = 'World Steppers Weekend'

where c.slug = 'chicago';

commit;

select 'venues' c, count(*) n from venues

union all select 'events', count(*) from events

union all select 'travel', count(*) from travel_places

union all select 'videos', count(*) from videos

union all select 'instructors', count(*) from instructors

union all select 'comments', count(*) from comments;