From 9c44a251a2744a082168173dfbabc01a87bd6ec6 Mon Sep 17 00:00:00 2001 From: Masfehico Date: Mon, 23 Nov 2020 17:35:02 +0100 Subject: Minor testing changes --- README.md | 41 ----------------------------------------- 1 file changed, 41 deletions(-) (limited to 'README.md') diff --git a/README.md b/README.md index 398489e..c98ba9f 100644 --- a/README.md +++ b/README.md @@ -1,42 +1 @@ OOP project in Java done in my first year, first semester at ESIEA. - -#Personal notes -At the end, I'll be using an extraction of my Ampache (ampache.adjutor.xyz) MySQL DB for my CSV files. -Resulting in many musics. -The genres have been added randomly to the songs. - -##Commands used on my DB -Albums : -``` -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; -``` - -Songs: -``` -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; -``` - -Playlists : -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; -- cgit v1.2.3