GitHub - davidpanderson/scores: database representation of musical score info

Branches Tags

Name		Name	Last commit message	Last commit date
Latest commit History 110 Commits
cmi		cmi
data		data
Makefile		Makefile
Makefile.data		Makefile.data
README		README
api.cpp		api.cpp
api.h		api.h
api.inc		api.inc
api.php		api.php
api2.php		api2.php
api3.php		api3.php
api_test.cpp		api_test.cpp
api_work.php		api_work.php
arrangement.php		arrangement.php
audio.inc		audio.inc
bootstrap.inc		bootstrap.inc
bootstrap.min.css		bootstrap.min.css
bootstrap_darkly.min.css		bootstrap_darkly.min.css
custom_dark.css		custom_dark.css
db_conn.inc		db_conn.inc
digest.cpp		digest.cpp
digest.h		digest.h
digest.php		digest.php
dump_category.php		dump_category.php
dump_work.php		dump_work.php
edit_audio.php		edit_audio.php
edit_score.php		edit_score.php
edit_work.php		edit_work.php
ensemble.php		ensemble.php
get_templates.php		get_templates.php
imslp_db.inc		imslp_db.inc
imslp_util.inc		imslp_util.inc
imslp_web.inc		imslp_web.inc
index.php		index.php
inst.txt		inst.txt
lang.tags		lang.tags
make_ser.php		make_ser.php
mediawiki.inc		mediawiki.inc
parse_category.inc		parse_category.inc
parse_combo.inc		parse_combo.inc
parse_tags.inc		parse_tags.inc
parse_work.inc		parse_work.inc
person.php		person.php
populate.sh		populate.sh
populate_category.php		populate_category.php
populate_gardner.php		populate_gardner.php
populate_inst.php		populate_inst.php
populate_lang.php		populate_lang.php
populate_sample.php		populate_sample.php
populate_util.inc		populate_util.inc
populate_work.php		populate_work.php
populate_work_type.php		populate_work_type.php
publisher.php		publisher.php
queries		queries
recording.php		recording.php
schema.sql		schema.sql
score.php		score.php
search_ensemble.php		search_ensemble.php
search_person.php		search_person.php
search_work.php		search_work.php
ser.inc		ser.inc
show_category.php		show_category.php
show_work.php		show_work.php
string.php		string.php
tags.php		tags.php
temp.php		temp.php
template.inc		template.inc
test.cpp		test.cpp
test.php		test.php
tests.php		tests.php
web.inc		web.inc
work.php		work.php
work_types.tags		work_types.tags
work_types_hier.tags		work_types_hier.tags

Repository files navigation

To populate the database:

mysql < schema.sql
    create empty DB

populate_lang.php
    inputs
        lang.tags
    generates
        lang_by_code.ser
    populates
        language

populate_inst.php
    inputs
        inst.txt
    generates
        inst_by_code.ser
    populates
        instrument

populate_work_type.php
    inputs
        work_types.tags
        work_types_hier.tags
    generates
        work_type_by_code.ser
    populates
        work_type

populate_category.php
    populates
        person
        ensemble
        nationality
        period

populate_work.php
    requires
        work_type_by_code.ser
        inst_by_code.ser
        lang_by_code.ser
    populates
        work
        score_file_set, score_file
        audio_file_set, audio_file
        ensemble
        person
        copyright
        publisher
        arrangement_target (deprecated?)
        instrument_combos

make_ser.php
    generates
        nationality.ser
        period.ser
        copyright.ser
        arrangement_target.ser
        instrument.ser
        language.ser
        instrument_combo.ser