Improvements to query API

[bourque]

The query API currently allows a user to query the FileCatalog table in the IMAP SDC database. There are some improvements we could make to this:

• Add support for querying the other database tables (e.g. UniversalSpinTable, Version, etc.)
• Enable some common queries, e.g.:
  • https://api.dev.imap-mission.com/query?today could return all files that were acquired in the last 24 hours)
  • https://api.dev.imap-mission.com/query?days_ago=N could return all files that were acquired in the last N days)
  • https://api.dev.imap-mission.com/query?version=latest could return the latest version (i.e. highest version number) of files)
  • https://api.dev.imap-mission.com/query?show_metadata could show file metadata in the results (e.g. file sizes, the start and end time that the data in the file covers, when the file was created, etc.)

[bourque]

Thank you to @joeymukherjee for some ideas on this!

[bourque]

The code that handles the API calls is under here: https://github.com/IMAP-Science-Operations-Center/sds-data-manager/tree/dev/sds_data_manager/lambda_code/SDSCode