From ea90fad5f2904e6d427c286f417acac4a6021005 Mon Sep 17 00:00:00 2001 From: Masfehico Date: Wed, 18 Nov 2020 21:58:16 +0100 Subject: Added CSVs I added some csvs by exracting my ampache mysql DB. Also started to write on the README file already. --- README.md | 44 ++++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 44 insertions(+) create mode 100644 README.md (limited to 'README.md') diff --git a/README.md b/README.md new file mode 100644 index 0000000..8b68bd1 --- /dev/null +++ b/README.md @@ -0,0 +1,44 @@ +OOP project in Java done in my first year, first semester at ESIEA. + +#Personal notes +I decided to be ballsy and do it fully in english. + +For the finale 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 '>
path: root/privatebin (unfollow)
Commit message (Collapse)AuthorFilesLines
2025-08-04Update Docuseal to v2.1.0, PrivateBin to v2.0.0 & Vaultwarden to v1.34.3clyhtsuriva7-96/+3
- Removed unused services: anubis-nginx, portainer, semaphore, wud - Updated versions for Docuseal, PrivateBin, and Vaultwarden
2025-07-25Update Docuseal to 2.0.8clyhtsuriva1-1/+1
2025-07-15Update Prometheus to v3.5.0 & Docuseal to 2.0.7clyhtsuriva2-2/+2
2025-07-02Update Portainer to 2.27.9 & Syncthing to 1.30.0 (and using ghcr image)clyhtsuriva2-2/+2
2025-06-30Update PrivateBin to 1.7.8 & Docuseal to 2.0.5clyhtsuriva2-2/+2
2025-06-29Update PrivateBin to 1.7.7clyhtsuriva1-1/+1
2025-06-28Update Prometheus to v3.4.2clyhtsuriva1-1/+1
2025-06-25Update Portainer to 2.27.8 & Docuseal to 2.0.4clyhtsuriva2-2/+2
2025-06-21Update Portainer to 2.27.7clyhtsuriva1-1/+1
2025-06-16Update Docuseal to v2.0.3 & cAdvisor to v0.53.0clyhtsuriva3-3/+3
2025-06-06Update Docuseal to v2.0.2 & Syncthing to 1.29.7clyhtsuriva2-2/+2
2025-06-02Update Prometheus to v3.4.1 & Vaultwarden to 1.34.1clyhtsuriva3-2/+4
2025-05-26Update Docuseal to 2.0.1clyhtsuriva1-3/+1
2025-05-24Using .env for roundcube and optimizing grafana .env usageclyhtsuriva5-37/+52
2025-05-24Add yml --- & ...clyhtsuriva8-0/+15
2025-05-24Migrating values to .env & create .env.templateclyhtsuriva2-11/+39
2025-05-24Add env file for grafanaclyhtsuriva1-0/+4