A database that holds a list of songs and playlists from users. Users will choose their song genres and create a playlist of songs. They can create public playlists or share their private playlists. Other users can rate the private playlist.
- Download and install Python 3.9.
- Git clone this repo
https://github.com/Tooo/Playlist-Database.git- Install required python packages.
pip install -r requirement.txt- Set up a MySQL database with mySQL Installer and mySQL workbench.
- In config.py, fill in your MySQL connection settings.
DB_HOST = 'localhost'
DB_USER = 'user'
DB_PASSWORD = 'password'
DB_DATABASE = 'playlistdatabase'- Run sqlsetup.py to set up the database and import all the songs.
python3 sqlsetup.py- Run app.py.
python3 app.py- Open this URL on your web browser
localhost:5000- Save your genres and playlists in your own account.
- Create public or private playlists with passwords.
- Add from 300 songs from our song database.
- Rate each song, either upvoting or downvoting
https://www.youtube.com/watch?v=SFK4WphyL1c
https://www.youtube.com/watch?v=O42S7y5rHyQ
Song [SongID, Name, Duration, Artist, Genre]
User [Username]
Playlist [Name, Username, Date]
Public [Name, Username]
Private [Name, Username, Password]
Rate [Username, SongID, Rating]
Contains [SongID, Name]
Share [Username, Name, SuperUsername, Rating, Comment]
UserGenres [Username, Genres]
Playlist.Username references User.Username
Public.Name references Playlist.Name
Public.Username references User.Username
Private.Name references Playlist.Name
Private.Username references User.Username
Rate.Username references User.Username
Rate.SongID references Song.SongID
Contains.SongID references Song.SongID
Contains.Name references Playlist.Name
Share.Username references User.Username
Share.SuperUsername references User.Username
Share.Name references Playlist.Name
UserGenres.Username references User.Username