This script will connect to the Sierra database and use the SQL feature to collect required information from the database views for use with the CollectionHQ service.
This application will also export data from the Sierra ILS, and cache it for purpose of feeding collection analysis tools
https://collection-analysis.cincy.pl/
Files and configurations for running the server can be found here:
For the purpose of hosting an instance of Datasette, we can build an SQLite database from the Jupyter Notebook : collection-analysis.cincy.pl_gen_db.ipynb
Run the notebook in the terminal like this:
jupyter nbconvert \
--execute --to notebook \
--output output \
collection-analysis.cincy.pl_gen_db.ipynb