Fixing Deployment Issues , Improvements

[jrmartin]

• [x] Sort results, exact match on top
• [x] Exact match, true/false, missing on results returned for /properties endpoints
• [x] If exact=true passed as parameter on URL, only return exact matches. If none, then return zero
• [x] Truncate table names passed as properties and returned as results
• [x] Remove CIDS from /properties results, only leave the one

[enicolasgomez]

@jrmartin we need to add XSS filtering to anything that get's feed and concatenated into SQL

https://stackoverflow.com/questions/901369/python-library-for-xss-filtering

[jrmartin]

@rgerkin @enicolasgomez The requests made during the last call have been deployed.

We can now use a query parameter to only get the exact match results: Examples: https://pubchem.olfactory.dev.metacell.us/molecules/mesh/chlorin?exactMatch=True https://pubchem.olfactory.dev.metacell.us/molecules/mesh/chlorin/properties/synonym_filtered,title,iupac?exactMatch=True

By default, not using the query parameter will return all results regardless of exact match. E.g. https://pubchem.olfactory.dev.metacell.us/molecules/mesh/chlorin https://pubchem.olfactory.dev.metacell.us/molecules/mesh/chlorin?exactMatch=False

A more detailed documentation can be found on the main page ReadMe