From 532cd1e395a637a5e507bc3687a4a64e50e55b30 Mon Sep 17 00:00:00 2001
From: Clyhtsuriva <aimeric@adjutor.xyz>
Date: Fri, 11 Dec 2020 09:12:05 +0100
Subject: adding Serialization interface and methods

---
 test.sql | 45 ---------------------------------------------
 1 file changed, 45 deletions(-)
 delete mode 100644 test.sql

(limited to 'test.sql')

diff --git a/test.sql b/test.sql
deleted file mode 100644
index ae8d13b..0000000
--- a/test.sql
+++ /dev/null
@@ -1,45 +0,0 @@
---album
-SELECT
-	al.id as "ID",
-	al.name as "Title",
-	ar.name as "Artist",
-	al.original_year as "Release Year",
-	SUM(s.time) as "Duration"
-FROM album al
-JOIN artist ar ON ar.id=al.album_artist
-JOIN song s ON s.album=al.id
-GROUP BY al.id
-INTO OUTFILE '/var/lib/mysql-files/albums.csv'
-FIELDS ENCLOSED BY '"'
-TERMINATED BY ';'
-ESCAPED BY '"'
-LINES TERMINATED BY '\r\n';
-
---song
-SELECT
-	s.id as "ID",
-	s.title as "Title",
-	ar.name as "Artist",
-	s.time as "Duration",
-	s.file as "Content"
-FROM song s
-JOIN artist ar ON ar.id=s.artist
-INTO OUTFILE '/var/lib/mysql-files/songs.csv'
-FIELDS ENCLOSED BY '"'
-TERMINATED BY ';'
-ESCAPED BY '"'
-LINES TERMINATED BY '\r\n';
-
---playlist
-SELECT
-	p.id as "ID",
-	p.name as "Name",
-	s.title as "Song"
-FROM playlist_data pd
-JOIN playlist p ON p.id=pd.playlist
-JOIN song s ON s.id=pd.object_id
-INTO OUTFILE '/var/lib/mysql-files/playlists.csv'
-FIELDS ENCLOSED BY '"'
-TERMINATED BY ';'
-ESCAPED BY '"'
-LINES TERMINATED BY '\r\n';
-- 
cgit v1.2.3