diff options
author | Masfehico <clyhtsuriva@gmail.com> | 2020-11-23 17:35:02 +0100 |
---|---|---|
committer | Masfehico <clyhtsuriva@gmail.com> | 2020-11-23 17:35:02 +0100 |
commit | 9c44a251a2744a082168173dfbabc01a87bd6ec6 (patch) | |
tree | e7220bb7ecdc2c10e317e71ea5c8cba3a62da74f /README.md | |
parent | 899762edf091e362639bca9bc327afcd7a0a7844 (diff) |
Minor testing changes
Diffstat (limited to 'README.md')
-rw-r--r-- | README.md | 41 |
1 files changed, 0 insertions, 41 deletions
@@ -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; |