[PR] Simplify store SQL and drop unused usage fields [airavata-custos]

["yasithdev (via GitHub)" <gi...@apache.org>]

yasithdev opened a new pull request, #612:
URL: https://github.com/apache/airavata-custos/pull/612

   - Replaced queries that were split by filter, or done in two steps, with single queries.
   - Removed joins, COALESCE, DISTINCT and dedupe steps that the schema's NOT NULL and UNIQUE constraints already make unnecessary.
   - Removed the unused ListProjects path; projects are listed only with their PI.
   - Removed the analytics usage fields the web app never shows (status, start_time, resource_type, cap, used_native, native_unit, used).
   - Removed resource_amount from the resource summary.
   - Updated the OpenAPI specs, web schemas and tests to match.


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: custos-unsubscribe@airavata.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

Re: [PR] Remove unused store and service methods [airavata-custos]

["lahirujayathilake (via GitHub)" <gi...@apache.org>]

lahirujayathilake merged PR #612:
URL: https://github.com/apache/airavata-custos/pull/612


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: custos-unsubscribe@airavata.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org