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;