Improvement database sqlalchemy

Godley / Music-Library

Repo for all FYP work, including meeting logs, implementation, report and any other necessary documents. Will be a mix of tex, python, word and pdf documents

GNU General Public License v2.0

5 stars 3 forks source link

Improvement database sqlalchemy #347

Closed Godley closed 7 years ago

Godley commented 7 years ago

Moved from pure SQL to some basic SQLAlchemy querying. Not using ORM because it just doesn't work for instruments-clefs-keys
added exceptions for pieces that don't have clefs or keys. Idk if this is the best decision but it clears up needing a separate table to map instruments to pieces.