Angelo Fausti added a comment - 30/Jul/18 4:52 PM - edited Example of query: Return metrics and specifications for a given job_id and dataset_name, look for metrics tagged as photometry and with measurements on filter_name r only. http://localhost:5000/kpms?job_id=2&dataset_name=validation_data_cfht&metric_tag=photometry&filter_name=r Return metrics for a given job_id and dataset_name look for metrics tagged as astrometry and design specifications only. http://localhost:5000/kpms?job_id=2&dataset_name=validation_data_cfht&metric_tag=astrometry&specification_tag=design   Return metrics and specifications for a given job_id and dataset_name, look for metrics tagged as photometry, with measurements on filter_name r and design specifications only. http://localhost:5000/kpms?job_id=2&dataset_name=validation_data_cfht&metric_tag=photometry&specification_tag=design&filter_name=r

Angelo Fausti added a comment - 30/Jul/18 5:01 PM - edited SQLAlchemy works well for querying JSON fields on MySQL 5.7. For filtering based on a key/value pair the sintax looks like: expr = Specification.metadata_query[ 'filter_name' ] = = filter_name queryset = queryset. filter (expr) For filtering based on data contained in arrays: expr = func.json_contains(Metric.tags, '"{}"' .format(metric_tag)) queryset = queryset.filter(expr) Note the weird syntax for the candidate value, it must be within double quotes. More information here: https://dev.mysql.com/doc/refman/5.7/en/json-search-functions.html https://stackoverflow.com/questions/33513625/invalid-json-text-in-argument-2-json-contains-in-mysql-5-7-8

Angelo Fausti added a comment - 30/Jul/18 5:52 PM See PR https://github.com/lsst-sqre/squash-restful-api/pull/25