Karaoke Song Management System

Website: COMING SOON
Web Application.
You can make song list and keep song name, artist name, genre, minimum key, maximum key and so on.
You can manage your song list both by html page and by http API.

Requirements

• Python 3.6.1
• Django 2.1.1

Install and Run

Install Django with

pip install django

Make migration with

python manage.py makemigrations
python manage.py migrate

Run server with

python manage.py runserver

and access to http://localhost:8000/main/

Usage

API

Methods

Method	Path	Role	Type(Request)	Type(Response)
POST	/main/	create song	'text/csv' or normal	others
GET	/main/	read all songs	-	'text/csv' or others
DELETE	/main/	delete all songs	-	(no content)
GET	/main/song_id/	read specified song	-	others
PATCH	/main/song_id/	modify specified song	normal	(no content)
DELETE	/main/song_id/	delete specified song	-	(no content)

Fields

Field name	Type	Detail	Rule
name	string	song name	less than 65 characters
name_ruby	string	song name ruby	less than 129 characters
artist	string	artist name	less than 33 characters
genre_id	integer	genre	must be in the database table "Genre"
key_level_id	integer	type of tone height	must be in the database table "KeyLevel"
key_min	integer	lowest tone's key	0 corresponds to tone lowlowA
key_freq_min	integer	frequently appeared lowest tone's key	0 corresponds to tone lowlowA
key_freq_max	integer	frequently appeared highest tone's key	0 corresponds to tone lowlowA
key_max	integer	highest tone's key	0 corresponds to tone lowlowA
rank	integer	rank	1(A) or 2(B) or 3(C)
link	string	link to music or movie
check	boolean	on/off check easy to use
note	string	free note

name and name_ruby are neccessary.
Fields can be too few or too many in CSV format.

Page

Mouse Operations

Mouse	Function
Left-click	Start input-mode of cell
Right-click	Select row

Keyboard Shortcuts

Key	Function
Tab / L	Move to the next cell (horizontally)
Shift+Tab / H	Move to the previous cell (horizontally)
Enter / J	Move to the next cell (vertically)
Shift+Enter / K	Move to the previous cell (vertically)
F2 / Space / I / A	Start input-mode of cell
Esc / Ctrl+[	End input-mode of cell
V	Select row
N	Scroll window to selected row

Dependency

• tablesorter
  • the version forked by Rob Garrison (https://github.com/Mottie/tablesorter)
  • Copyright (c) 2014 Christian Bach
  • Released under the MIT license
  • https://github.com/christianbach/tablesorter/blob/master/LICENSE
• Autosize
  • Copyright (c) 2015 Jack Moore
  • Released under the MIT license
  • https://github.com/jackmoore/autosize/blob/master/LICENSE.md
• clipboard.js
  • Copyright (c) 2018 Zeno Rocha
  • Released under the MIT license
  • https://zenorocha.mit-license.org/