diff options
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; |