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

refactor database usage #346

Closed Godley closed 7 years ago

Godley commented 8 years ago

I'd like to abstract away from using sql queries, probably using SQLAlchemy. Reasons:

Godley commented 7 years ago

Closed with last PR, moved to using SQLAlchemy's query objects. Not using the ORM because it can't handle 3 way joins (such as instruments-clefs-pieces). I've also made it raise an exception if each piece doesn't have a clef or key, which may or may not be a good thing, but just simplifies the process of adding instruments and clefs/keys.