insert_data.sql - master - Askoline/Homework_DB

insert_data.sql
256 строк8 KB
Askoline
Fix: Add tracks with 'мой' and 'my' to satisfy task 2 requirement
03 авг 2026, 20:53
03 авг 2026, 20:533140b1d
-- =====================================================
-- ЗАПОЛНЕНИЕ БАЗЫ ДАННЫХ МУЗЫКАЛЬНОГО СЕРВИСА
-- =====================================================

-- =====================================================
-- 1. ЗАПОЛНЕНИЕ ТАБЛИЦЫ ЖАНРОВ (не менее 3)
-- =====================================================
INSERT INTO genre (name) VALUES 
    ('Rock'),
    ('Pop'),
    ('Jazz'),
    ('Electronic'),
    ('Hip-Hop');

-- =====================================================
-- 2. ЗАПОЛНЕНИЕ ТАБЛИЦЫ ИСПОЛНИТЕЛЕЙ (не менее 4)
-- =====================================================
INSERT INTO artist (name) VALUES 
    ('The Beatles'),
    ('Michael Jackson'),
    ('Radiohead'),
    ('Miles Davis'),
    ('Daft Punk'),
    ('Kendrick Lamar'),
    ('Queen'),
    ('Nirvana'),
    ('Billie Eilish'),
    ('Dua Lipa'),
    ('The Weeknd'),
    ('Taylor Swift'),
    ('Russian Pop Stars');

-- =====================================================
-- 3. ЗАПОЛНЕНИЕ ТАБЛИЦЫ АЛЬБОМОВ (не менее 3)
-- =====================================================
INSERT INTO album (title, year) VALUES 
    ('Abbey Road', 1969),
    ('Thriller', 1982),
    ('OK Computer', 1997),
    ('Kind of Blue', 1959),
    ('Random Access Memories', 2013),
    ('To Pimp a Butterfly', 2015),
    ('A Night at the Opera', 1975),
    ('Nevermind', 1991),
    ('When We All Fall Asleep, Where Do We Go?', 2019),
    ('Future Nostalgia', 2020),
    ('After Hours', 2020),
    ('Folklore', 2020),
    ('Collaboration Album', 2023),
    ('Russian Hits Collection', 2023);

-- =====================================================
-- 4. ЗАПОЛНЕНИЕ ТАБЛИЦЫ СВЯЗЕЙ ИСПОЛНИТЕЛЕЙ С ЖАНРАМИ
-- =====================================================
INSERT INTO artist_genre (artist_id, genre_id) VALUES 
    -- The Beatles - Rock
    (1, 1),
    -- Michael Jackson - Pop
    (2, 2),
    -- Radiohead - Rock и Pop
    (3, 1),
    (3, 2),
    -- Miles Davis - Jazz
    (4, 3),
    -- Daft Punk - Electronic и Pop
    (5, 4),
    (5, 2),
    -- Kendrick Lamar - Hip-Hop и Pop
    (6, 5),
    (6, 2),
    -- Queen - Rock и Pop
    (7, 1),
    (7, 2),
    -- Nirvana - Rock
    (8, 1),
    -- Billie Eilish - Pop
    (9, 2),
    -- Dua Lipa - Pop
    (10, 2),
    -- The Weeknd - Pop
    (11, 2),
    -- Taylor Swift - Pop
    (12, 2),
    -- Russian Pop Stars - Pop
    (13, 2);

-- =====================================================
-- 5. ЗАПОЛНЕНИЕ ТАБЛИЦЫ СВЯЗЕЙ АЛЬБОМОВ С ИСПОЛНИТЕЛЯМИ
-- =====================================================
INSERT INTO album_artist (album_id, artist_id) VALUES 
    (1, 1), -- Abbey Road - The Beatles
    (2, 2), -- Thriller - Michael Jackson
    (3, 3), -- OK Computer - Radiohead
    (4, 4), -- Kind of Blue - Miles Davis
    (5, 5), -- Random Access Memories - Daft Punk
    (6, 6), -- To Pimp a Butterfly - Kendrick Lamar
    (7, 7), -- A Night at the Opera - Queen
    (8, 8), -- Nevermind - Nirvana
    (9, 9), -- When We All Fall Asleep - Billie Eilish
    (10, 10), -- Future Nostalgia - Dua Lipa
    (11, 11), -- After Hours - The Weeknd
    (12, 12), -- Folklore - Taylor Swift
    (13, 1), -- Collaboration Album - The Beatles
    (13, 2), -- Collaboration Album - Michael Jackson
    (13, 4), -- Collaboration Album - Miles Davis
    (13, 5), -- Collaboration Album - Daft Punk
    (14, 13); -- Russian Hits Collection - Russian Pop Stars

-- =====================================================
-- 6. ЗАПОЛНЕНИЕ ТАБЛИЦЫ ТРЕКОВ (не менее 6)
-- =====================================================
INSERT INTO track (title, duration, album_id) VALUES 
    -- Abbey Road (album_id = 1)
    ('Come Together', 259, 1),
    ('Something', 182, 1),
    ('Here Comes the Sun', 185, 1),
    ('Let It Be', 243, 1),
    
    -- Thriller (album_id = 2)
    ('Beat It', 258, 2),
    ('Thriller', 357, 2),
    ('Billie Jean', 294, 2),
    ('Wanna Be Startin'' Somethin''', 363, 2),
    
    -- OK Computer (album_id = 3)
    ('Paranoid Android', 383, 3),
    ('Karma Police', 262, 3),
    ('No Surprises', 229, 3),
    ('Exit Music (For a Film)', 267, 3),
    
    -- Kind of Blue (album_id = 4)
    ('So What', 545, 4),
    ('Freddie Freeloader', 586, 4),
    ('Blue in Green', 337, 4),
    
    -- Random Access Memories (album_id = 5)
    ('Get Lucky', 368, 5),
    ('Around the World', 437, 5),
    ('One More Time', 316, 5),
    
    -- To Pimp a Butterfly (album_id = 6)
    ('King Kunta', 234, 6),
    ('Alright', 239, 6),
    ('The Blacker the Berry', 328, 6),
    
    -- A Night at the Opera (album_id = 7)
    ('Bohemian Rhapsody', 354, 7),
    ('Somebody to Love', 295, 7),
    
    -- Nevermind (album_id = 8)
    ('Smells Like Teen Spirit', 301, 8),
    ('Come as You Are', 219, 8),
    
    -- When We All Fall Asleep (album_id = 9)
    ('bad guy', 194, 9),
    ('when the party''s over', 196, 9),
    ('bury a friend', 193, 9),
    
    -- Future Nostalgia (album_id = 10)
    ('Don''t Start Now', 183, 10),
    ('Physical', 193, 10),
    ('Levitating', 203, 10),
    
    -- After Hours (album_id = 11)
    ('Blinding Lights', 200, 11),
    ('Save Your Tears', 215, 11),
    ('In Your Eyes', 219, 11),
    
    -- Folklore (album_id = 12)
    ('cardigan', 239, 12),
    ('exile', 285, 12),
    ('the 1', 210, 12),
    
    -- Collaboration Album (album_id = 13)
    ('Collaboration Track 1', 240, 13),
    ('Collaboration Track 2', 255, 13),
    ('Collaboration Track 3', 220, 13),
    
    -- Russian Hits Collection (album_id = 14) - НОВЫЕ ТРЕКИ
    ('Мой мир', 210, 14),
    ('Мой путь', 185, 14),
    ('My Love', 195, 14),
    ('My Heart', 200, 14);

-- =====================================================
-- 7. ЗАПОЛНЕНИЕ ТАБЛИЦЫ СБОРНИКОВ (не менее 4)
-- =====================================================
INSERT INTO compilation (title, year) VALUES 
    ('Greatest Hits of the 60s', 2000),
    ('Rock Classics', 2005),
    ('Jazz Legends', 2010),
    ('Pop Anthems', 2015),
    ('Electronic Beats', 2020),
    ('Hip-Hop Evolution', 2022),
    ('Best of the 90s', 2018),
    ('Millennium Hits', 2023);

-- =====================================================
-- 8. ЗАПОЛНЕНИЕ ТАБЛИЦЫ СВЯЗЕЙ СБОРНИКОВ С ТРЕКАМИ
-- =====================================================
INSERT INTO compilation_track (compilation_id, track_id) VALUES 
    -- Greatest Hits of the 60s (compilation_id = 1)
    (1, 1),  -- Come Together
    (1, 2),  -- Something
    (1, 3),  -- Here Comes the Sun
    (1, 4),  -- Let It Be
    
    -- Rock Classics (compilation_id = 2)
    (2, 1),  -- Come Together
    (2, 9),  -- Paranoid Android
    (2, 10), -- Karma Police
    (2, 22), -- Bohemian Rhapsody
    (2, 24), -- Smells Like Teen Spirit
    
    -- Jazz Legends (compilation_id = 3)
    (3, 13), -- So What
    (3, 14), -- Freddie Freeloader
    (3, 15), -- Blue in Green
    
    -- Pop Anthems (compilation_id = 4)
    (4, 5),  -- Beat It
    (4, 6),  -- Thriller
    (4, 7),  -- Billie Jean
    (4, 16), -- Get Lucky
    (4, 23), -- Somebody to Love
    (4, 31), -- Blinding Lights
    (4, 43), -- Мой мир (НОВЫЙ)
    (4, 45), -- My Love (НОВЫЙ)
    
    -- Electronic Beats (compilation_id = 5)
    (5, 16), -- Get Lucky
    (5, 17), -- Around the World
    (5, 18), -- One More Time
    (5, 32), -- Save Your Tears
    
    -- Hip-Hop Evolution (compilation_id = 6)
    (6, 19), -- King Kunta
    (6, 20), -- Alright
    (6, 21), -- The Blacker the Berry
    
    -- Best of the 90s (compilation_id = 7)
    (7, 9),  -- Paranoid Android
    (7, 10), -- Karma Police
    (7, 11), -- No Surprises
    (7, 24), -- Smells Like Teen Spirit
    (7, 25), -- Come as You Are
    (7, 33), -- In Your Eyes
    
    -- Millennium Hits (compilation_id = 8)
    (8, 16), -- Get Lucky
    (8, 17), -- Around the World
    (8, 19), -- King Kunta
    (8, 20), -- Alright
    (8, 31), -- Blinding Lights
    (8, 44), -- Мой путь (НОВЫЙ)
    (8, 46); -- My Heart (НОВЫЙ)