-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathseed.sql
16 lines (12 loc) · 7.42 KB
/
seed.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
-- Create users
COPY auth.users (instance_id, id, aud, role, email, encrypted_password, email_confirmed_at, invited_at, confirmation_token, confirmation_sent_at, recovery_token, recovery_sent_at, email_change_token_new, email_change, email_change_sent_at, last_sign_in_at, raw_app_meta_data, raw_user_meta_data, is_super_admin, created_at, updated_at, phone, phone_confirmed_at, phone_change, phone_change_token, phone_change_sent_at, email_change_token_current, email_change_confirm_status, banned_until, reauthentication_token, reauthentication_sent_at) FROM stdin;
00000000-0000-0000-0000-000000000000 d21494ff-2472-4fc4-8f5c-ba8d388134f9 authenticated authenticated [email protected] $2a$10$2j/Jh///ezNZqZS7Em88c.6dW8HddqA0cSX/PdGwvoTIEKtVXP3wG 2022-07-10 19:44:03.845058+00 \N \N \N \N 2022-07-10 19:44:03.847051+00 {"provider": "email", "providers": ["email"]} {"username": "Peter R. de Vries"} f 2022-07-10 19:44:03.83025+00 2022-07-10 19:44:03.830254+00 \N \N \N 0 \N \N
\.
COPY public.profile (id, created_at, username, profile_picture) FROM stdin;
d21494ff-2472-4fc4-8f5c-ba8d388134f9 2022-07-10 19:44:04.096804+00 Peter R. de Vries \N
\.
COPY public.song (id, created_at, added_by, playlist, play_count, platform_id, title, song_type, query_result, artist, album, length, cover) FROM stdin;
1 2022-07-12 07:16:37.577957+00 d21494ff-2472-4fc4-8f5c-ba8d388134f9 1 0 2bJaewMbxlwnm69zvOAq3s Atje Voor De Sfeer spotify {"id": "2bJaewMbxlwnm69zvOAq3s", "uri": "spotify:track:2bJaewMbxlwnm69zvOAq3s", "href": "https://api.spotify.com/v1/tracks/2bJaewMbxlwnm69zvOAq3s", "name": "Atje Voor De Sfeer", "type": "track", "album": {"id": "6PujTxjH2gjAtGXiKZMW82", "uri": "spotify:album:6PujTxjH2gjAtGXiKZMW82", "href": "https://api.spotify.com/v1/albums/6PujTxjH2gjAtGXiKZMW82", "name": "Atje Voor De Sfeer - En Andere Sfeermakers", "type": "album", "images": [{"url": "https://i.scdn.co/image/ab67616d0000b273437e84d6f118fe0ef8e17af8", "width": 640, "height": 640}, {"url": "https://i.scdn.co/image/ab67616d00001e02437e84d6f118fe0ef8e17af8", "width": 300, "height": 300}, {"url": "https://i.scdn.co/image/ab67616d00004851437e84d6f118fe0ef8e17af8", "width": 64, "height": 64}], "artists": [{"id": "3upXQVqKZlTKRES3LQ9VjO", "uri": "spotify:artist:3upXQVqKZlTKRES3LQ9VjO", "href": "https://api.spotify.com/v1/artists/3upXQVqKZlTKRES3LQ9VjO", "name": "Rene Karst", "type": "artist", "external_urls": {"spotify": "https://open.spotify.com/artist/3upXQVqKZlTKRES3LQ9VjO"}}], "album_type": "album", "release_date": "2019-08-30", "total_tracks": 15, "external_urls": {"spotify": "https://open.spotify.com/album/6PujTxjH2gjAtGXiKZMW82"}, "release_date_precision": "day"}, "artists": [{"id": "3upXQVqKZlTKRES3LQ9VjO", "uri": "spotify:artist:3upXQVqKZlTKRES3LQ9VjO", "href": "https://api.spotify.com/v1/artists/3upXQVqKZlTKRES3LQ9VjO", "name": "Rene Karst", "type": "artist", "external_urls": {"spotify": "https://open.spotify.com/artist/3upXQVqKZlTKRES3LQ9VjO"}}], "explicit": false, "is_local": false, "popularity": 51, "disc_number": 1, "duration_ms": 198222, "is_playable": true, "preview_url": "https://p.scdn.co/mp3-preview/810813f88dd47c564279abdad0f2ea9792af9a6b?cid=2f9fc491c9e94ae0998077ea9854e9ce", "external_ids": {"isrc": "NLZ291900124"}, "track_number": 1, "external_urls": {"spotify": "https://open.spotify.com/track/2bJaewMbxlwnm69zvOAq3s"}} Rene Karst Atje Voor De Sfeer - En Andere Sfeermakers 198222 https://i.scdn.co/image/ab67616d0000b273437e84d6f118fe0ef8e17af8
2 2022-07-12 07:18:08.206756+00 d21494ff-2472-4fc4-8f5c-ba8d388134f9 1 0 4Y2glvLjQGOb4dXnwm1hQf Witchcraft spotify {"id": "4Y2glvLjQGOb4dXnwm1hQf", "uri": "spotify:track:4Y2glvLjQGOb4dXnwm1hQf", "href": "https://api.spotify.com/v1/tracks/4Y2glvLjQGOb4dXnwm1hQf", "name": "Witchcraft", "type": "track", "album": {"id": "3XtEGVx9uh7J46nBzEc1VS", "uri": "spotify:album:3XtEGVx9uh7J46nBzEc1VS", "href": "https://api.spotify.com/v1/albums/3XtEGVx9uh7J46nBzEc1VS", "name": "Immersion", "type": "album", "images": [{"url": "https://i.scdn.co/image/ab67616d0000b27330f8e0f777376780c4077507", "width": 640, "height": 640}, {"url": "https://i.scdn.co/image/ab67616d00001e0230f8e0f777376780c4077507", "width": 300, "height": 300}, {"url": "https://i.scdn.co/image/ab67616d0000485130f8e0f777376780c4077507", "width": 64, "height": 64}], "artists": [{"id": "7MqnCTCAX6SsIYYdJCQj9B", "uri": "spotify:artist:7MqnCTCAX6SsIYYdJCQj9B", "href": "https://api.spotify.com/v1/artists/7MqnCTCAX6SsIYYdJCQj9B", "name": "Pendulum", "type": "artist", "external_urls": {"spotify": "https://open.spotify.com/artist/7MqnCTCAX6SsIYYdJCQj9B"}}], "album_type": "album", "release_date": "2010-05-21", "total_tracks": 15, "external_urls": {"spotify": "https://open.spotify.com/album/3XtEGVx9uh7J46nBzEc1VS"}, "release_date_precision": "day"}, "artists": [{"id": "7MqnCTCAX6SsIYYdJCQj9B", "uri": "spotify:artist:7MqnCTCAX6SsIYYdJCQj9B", "href": "https://api.spotify.com/v1/artists/7MqnCTCAX6SsIYYdJCQj9B", "name": "Pendulum", "type": "artist", "external_urls": {"spotify": "https://open.spotify.com/artist/7MqnCTCAX6SsIYYdJCQj9B"}}], "explicit": false, "is_local": false, "popularity": 61, "disc_number": 1, "duration_ms": 252786, "is_playable": true, "preview_url": "https://p.scdn.co/mp3-preview/8bd8065d560b5d3c9b34dabfd12a7416a19171be?cid=2f9fc491c9e94ae0998077ea9854e9ce", "external_ids": {"isrc": "GBAHT1000133"}, "track_number": 12, "external_urls": {"spotify": "https://open.spotify.com/track/4Y2glvLjQGOb4dXnwm1hQf"}} Pendulum Immersion 252786 https://i.scdn.co/image/ab67616d0000b27330f8e0f777376780c4077507
3 2022-07-12 07:18:49.661186+00 d21494ff-2472-4fc4-8f5c-ba8d388134f9 1 0 22VdIZQfgXJea34mQxlt81 Can't Feel My Face spotify {"id": "22VdIZQfgXJea34mQxlt81", "uri": "spotify:track:22VdIZQfgXJea34mQxlt81", "href": "https://api.spotify.com/v1/tracks/22VdIZQfgXJea34mQxlt81", "name": "Can't Feel My Face", "type": "track", "album": {"id": "0P3oVJBFOv3TDXlYRhGL7s", "uri": "spotify:album:0P3oVJBFOv3TDXlYRhGL7s", "href": "https://api.spotify.com/v1/albums/0P3oVJBFOv3TDXlYRhGL7s", "name": "Beauty Behind The Madness", "type": "album", "images": [{"url": "https://i.scdn.co/image/ab67616d0000b2737fcead687e99583072cc217b", "width": 640, "height": 640}, {"url": "https://i.scdn.co/image/ab67616d00001e027fcead687e99583072cc217b", "width": 300, "height": 300}, {"url": "https://i.scdn.co/image/ab67616d000048517fcead687e99583072cc217b", "width": 64, "height": 64}], "artists": [{"id": "1Xyo4u8uXC1ZmMpatF05PJ", "uri": "spotify:artist:1Xyo4u8uXC1ZmMpatF05PJ", "href": "https://api.spotify.com/v1/artists/1Xyo4u8uXC1ZmMpatF05PJ", "name": "The Weeknd", "type": "artist", "external_urls": {"spotify": "https://open.spotify.com/artist/1Xyo4u8uXC1ZmMpatF05PJ"}}], "album_type": "album", "release_date": "2015-08-28", "total_tracks": 14, "external_urls": {"spotify": "https://open.spotify.com/album/0P3oVJBFOv3TDXlYRhGL7s"}, "release_date_precision": "day"}, "artists": [{"id": "1Xyo4u8uXC1ZmMpatF05PJ", "uri": "spotify:artist:1Xyo4u8uXC1ZmMpatF05PJ", "href": "https://api.spotify.com/v1/artists/1Xyo4u8uXC1ZmMpatF05PJ", "name": "The Weeknd", "type": "artist", "external_urls": {"spotify": "https://open.spotify.com/artist/1Xyo4u8uXC1ZmMpatF05PJ"}}], "explicit": false, "is_local": false, "popularity": 81, "disc_number": 1, "duration_ms": 213520, "is_playable": true, "preview_url": null, "external_ids": {"isrc": "USUG11500741"}, "track_number": 7, "external_urls": {"spotify": "https://open.spotify.com/track/22VdIZQfgXJea34mQxlt81"}} The Weeknd Beauty Behind The Madness 213520 https://i.scdn.co/image/ab67616d0000b2737fcead687e99583072cc217b
\.