aboutsummaryrefslogtreecommitdiff
path: root/README.md
diff options
context:
space:
mode:
Diffstat (limited to 'README.md')
-rw-r--r--README.md41
1 files changed, 0 insertions, 41 deletions
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;