Closed mvesper closed 7 years ago
Certain usecases in invenio-circulation
require the ability to search in old revisions of items.
This is a WIP PR to show one way, which would be utilizing postgres ability to search directly in JSON fields.
There seem to be some issues, though:
sqlalchemy_utils.types.JSONType
certain niceties seem to be missing, which is why the current PR creates a plain SQL query.Let me hear your thoughts :)
Looks good to me :)
This looks good to me. About using the date in the tests, should not be a problem unless there's something really wrong on the host that runs the tests, so ok for me too.