Music Streaming Platform based on full implementation of DBSM

Related tags

AudioSymphony-Music
Overview

Symphony

Music Streaming Platform based on full implementation of DBSM

List of Commands

  1. Insert User (INSERT)

Function to implement input in USER

  1. Get all Albums by a Artist (QUERY : PROJECTION)

Function to display all the albums by a particular artist

  1. Query Song by Genre (QUERY : PROJECTION)

Get all song names with a input genre say “Pop”

  1. Get Artist with max followers (QUERY : AGGREGATE)

Get the name of the artist with maximum followers

  1. Remove User By Email (DELETE)

Remove a user from the USER table who has a given email

  1. Update User Contact (UPDATE)

Update a given user's contact

  1. Insert Song (INSERT)

Insert a new song into the SONG relation

  1. Get Podcasts of greater than 1 hour duration (QUERY : SELECTION)

Get all podcasts that have a duration greater than 1 hour

  1. Get Playlist with max saves (QUERY : AGGREGATE)

Get playlist with maximum saves

  1. Get Podcast with minimum duration (QUERY : AGGREGATE)

Get the podcast with the shortest duration

  1. Get artist with over 1 lakh followers (QUERY : SELECTION)

Get all artists that have more than 1 lakh followers

  1. Query Podcast Language (QUERY : SEARCH)

Get all podcasts available in a given language

  1. Get all songs in album (QUERY : SELECTION)

Get all songs in a given album

  1. Get premium users with specific plan (QUERY : SEARCH)

Get names of all permium users with a particular pl

  1. Add an episode in a existing podcast (INSERT)

Adds a new episode in an existing podcast

  1. Analysis of popular album (QUERY : ANALYSIS)

List of popular albums based on average likes on all songs in the album

  1. User Likes Song (UPDATE + INSERT)

Increments song's likes when user likes it

  1. User Follows Artist (UPDATE + INSERT)

When a user follows a artist, update artist_followers and insert a record in FOLLOWS

  1. User Saves Playlist (UPDATE + INSERT)

When a user saves a new playlist, update playlist_saves in PLAYLIST and insert a record in SAVES

  1. Top Genres for a User (ANALYSIS)

List of top genres for a user based on song likes

  1. Exit

EXIT

Requirements

  • Python3
$ sudo apt-get update
$ sudo apt-get install python3.8
  • MySQL
  • PyMySQL
$ sudo apt-get install python3-pip
$ pip3 install pymysql

Installation

You will need to replicate the SYMPHONY databse on your local machine, for which the dump.sql file is provided herewith.

Open your MySQL server and run the following command to import the database:

$ docker exec -i mysql sh -c 'exec mysql -uroot -ppassword' < dump.sql

You might need to enter your password in the next step.

To run the CLI, change your directory to the cloned folder and run the following command:

$ python3 symphony.py
If you are using Docker to run MySQL, you might need to first change your port to 5005 (or the port you use) by replacing the following lines for connecting the database in the symphony.py file: 
con = pymysql.connect(host='localhost',
                              user=username,
                              password=password,
                              db='SYMPHONY',
                              port='5005',
                              cursorclass=pymysql.cursors.DictCursor)

near lines 674-675.

HAPPY LISTENING !!!

Owner
Parth Maradia
Parth Maradia
A voice assistant which can be used to interact with your computer and controls your pc operations

Introduction 👨‍💻 It is a voice assistant which can be used to interact with your computer and also you have been seeing it in Iron man movies, but t

Sujith 84 Dec 22, 2022
Music player - endlessly plays your music

Music player First, if you wonder about what is supposed to be a music player or what makes a music player different from a simple media player, read

Albert Zeyer 482 Dec 19, 2022
Open-Source Tools & Data for Music Source Separation: A Pragmatic Guide for the MIR Practitioner

Open-Source Tools & Data for Music Source Separation: A Pragmatic Guide for the MIR Practitioner

IELab@ Korea University 0 Nov 12, 2021
Jarvis From Basic to Advance - make a voice assistant similar to JARVIS (in iron man movie)

JARVIS (Basic to Advance) This was my attempt to make a voice assistant similar to JARVIS (in iron man movie) Let's be honest, it's not as intelligent

codesempai 17 Dec 25, 2022
Musillow is a music recommender app that finds songs similar to your favourites.

MUSILLOW The music recommender app Check it out now!!! View Demo · Report Bug · Request Feature About The App Musillow is a music recommender app that

3 Feb 03, 2022
A python program to cut longer MP3 files (i.e. recordings of several songs) into the individual tracks.

I'm writing a python script to cut longer MP3 files (i.e. recordings of several songs) into the individual tracks called ReCut. So far there are two

Dönerspiess 1 Oct 27, 2021
An audio-solving python funcaptcha solving module

funcapsolver funcapsolver is a funcaptcha audio-solving module, which allows captchas to be interacted with and solved with the use of google's speech

Acier 8 Nov 21, 2022
F.R.I.D.A.Y. ----- Female Replacement Intelligent Digital Assistant Youth

F.R.I.D.A.Y. Female Replacement Intelligent Digital Assistant Youth--Jarvis-- the virtual assistant made by python Overview This is a virtual assistan

JIB - Just Innovative Bro 4 Feb 26, 2022
SU Music Player — The first open-source PyTgCalls based Pyrogram bot to play music in voice chats

SU Music Player — The first open-source PyTgCalls based Pyrogram bot to play music in voice chats Note Neither this, or PyTgCalls are fully

SU Projects 58 Jan 02, 2023
cross-library (GStreamer + Core Audio + MAD + FFmpeg) audio decoding for Python

audioread Decode audio files using whichever backend is available. The library currently supports: Gstreamer via PyGObject. Core Audio on Mac OS X via

beetbox 419 Dec 26, 2022
live coding in python + supercollider

live coding in python + supercollider

Zack 6 Feb 06, 2022
Audio2midi - Automatic Audio-to-symbolic Arrangement

Automatic Audio-to-symbolic Arrangement This is the repository of the project "A

Ziyu Wang 24 Dec 05, 2022
Python wrapper around sox.

pysox Python wrapper around sox. Read the Docs here. This library was presented in the following paper: R. M. Bittner, E. J. Humphrey and J. P. Bello,

Rachel Bittner 446 Dec 07, 2022
Mopidy is an extensible music server written in Python

Mopidy Mopidy is an extensible music server written in Python. Mopidy plays music from local disk, Spotify, SoundCloud, Google Play Music, and more. Y

Mopidy 7.6k Jan 05, 2023
Inner ear models for Python

cochlea cochlea is a collection of inner ear models. All models are easily accessible as Python functions. They take sound signal as input and return

98 Jan 05, 2023
A bot that can play music on Telegram Group and Channel Voice Chats

DaisyXmusic ❤ is the best and only Telegram VC player with playlists, Multi Playback, Channel play and more

TeamOfDaisyX 20 Jun 11, 2021
Reading list for research topics in sound event detection

Sound event detection aims at processing the continuous acoustic signal and converting it into symbolic descriptions of the corresponding sound events present at the auditory scene.

Soham 64 Jan 05, 2023
Python tools for the corpus analysis of popular music.

CATCHY Corpus Analysis Tools for Computational Hook discovery Python tools for the corpus analysis of popular music recordings. The tools can be used

Jan VB 20 Aug 20, 2022
Official implementation of A cappella: Audio-visual Singing VoiceSeparation, from BMVC21

Y-Net Official implementation of A cappella: Audio-visual Singing VoiceSeparation, British Machine Vision Conference 2021 Project page: ipcv.github.io

Juan F. Montesinos 12 Oct 22, 2022
Graphical interface to control granular sound synthesis.

Granular sound synthesis interface SoundGrain is a graphical interface where users can draw and edit trajectories to control granular sound synthesis

Olivier Bélanger 122 Dec 10, 2022