Upgrade StorageQuerying Zotero DB from Plone
I am setting up a Plone based website for my University. As a self-styled Zotero evangelist, I have convinced many of my colleagues to add their publications to a shared Zotero collection.
I want to go a step further.
I want to write some glue code (presumably in Python since I am using Plone) that can query that shared collection (perhaps the sqlite db) and update certain sections of the website (such as list of publications). That will make the CMS-based website even more user data driven, and well, its cool to have a single update to a shared collection, update your citation source as well as the public-facing list of publications and other bibliometric measures.
Does something like this exist?
If not, what would be a good place to start?
I want to go a step further.
I want to write some glue code (presumably in Python since I am using Plone) that can query that shared collection (perhaps the sqlite db) and update certain sections of the website (such as list of publications). That will make the CMS-based website even more user data driven, and well, its cool to have a single update to a shared collection, update your citation source as well as the public-facing list of publications and other bibliometric measures.
Does something like this exist?
If not, what would be a good place to start?
But to get you started: I really wouldn't do this by querying the database directly, but rather using the Zotero Server API, for which there is even a python wrapper:
https://github.com/urschrei/pyzotero
If you're hell bent on querying the database directly, have a look at qnotero, also written in python, which does interact with the library directly (for good reason in that case), so should give you a lot of the code you need.