Changes

Add support to handle time ranges in GenerateReportQueriesUseCase
Switch to using ISO YYYY-MM-DD date format in GenerateReportQueriesUseCase
 (commit: e985fad)

Add RunReportUseCase interface to be used by ViewModels and enpdoints that need to generate data to graph.
 (commit: cfa11a1)

Add migration and generation of contextRegistrationHash.

ContextRegistrationHash is required for report generation (to count distinct number of sessions).

This requires a migration to update existing statements. It also requires new statements saved in the database to have the hash set.
 (commit: c7d424e)

Initial implementation of 'filling' report results e.g. where a report is by day/week/month, ensure that there is a row (with yAxis=0) even when there is no data in database for the given xAxis value.
 (commit: 26c5b25)

Update handling of reporting x axis and subgrouping by week.
 (commit: f558fa6)

Update handling fillIfNeeded to support weekly xAxis.
 (commit: ee5e996)

Update weekly report SQL code for Postgres.
 (commit: e0c3f4d)

Fixes to report handling of start/end time.

1) Start and end time should always be 00:00:00.000 and 23:59:59.999 as per timezone respectively (from start of day of the first day of the report until end of last day of the report).
2) Handle relative report periods accordingly (e.g. last day, week, month, etc) e.g. the last week, when run on a Tuesday is from 00:00 of the preceding Wednesday until 23:59 of that Tuesday).
 (commit: a2af54b)

Further fixes/improvements to handling report time ranges. Now works as expected for xAxis by day and by week.
 (commit: 5a86f8d)

Update report period logic to handle calendar month and year options.
 (commit: 4f0c221)

Add basic test for report by month.

Test does not check exact totals, however does ensure that we get the expected number of rows back, where each row date is the start of a month.
 (commit: 72596d4)

Handle TimeZone offset for reports.
Refactor variable names related to report period to be consistent.
 (commit: 7b6172d)

Work in progress for implementation of handling permission checks for report queries.
 (commit: ae7e957)

Initial implementation of enforcement of permission control for report query.
 (commit: e1ff616)

Add test to check implementation of permissions on report queries
 (commit: b6e12c8)

Add test to ensure that all xAxis/yAxis combination queries run without exceptions.

Fix column names on GenerateReportQueriesUseCase .
 (commit: 53ff8fa)

Update report run/query to insert results into an intermediary table (ReportQueryResult).

Report runs can be large, complex, and run over millions of rows. They may also need to run on the server when not all underlying data is available on the client.

This commit updates report related use cases to store result rows in an intermediary table such that results can be cached server side and client side as needed.
 (commit: 9caacb8)

Update RunReportUseCaseDatabaseImpl to ensure that the result order is in the same order as the report series in the request.
 (commit: 63e56e9)

Update GenerateReportQueriesUseCase to handle subgroups and add test.
 (commit: e546764)

Update RunReportUseCase to return a flow which can be observed by UI components.
 (commit: 1496840)

Update RunReportUseCase invoke to be non-suspending function as it now returns a flow.
 (commit: 61a6e59)

Implement time to live logic on RunReportUseCaseDatabaseImpl .
 (commit: 60e3c25)

Add report owner field to Report entity
 (commit: c6dd5b7)

Add initial report rest endpoint.
 (commit: 797e610)

Work in progress integration test for run report use case.
 (commit: 904b6ad)

Move statement generation for report test logic into lib-test-common such that it can be used for ReportUseCaseTest and RunReportRouteIntegration test.
 (commit: 854ed8f)

Add working integration test for RunReportUseCaseClientImpl and RunReportRoute.
Fix path used in RunReportUseCaseClientImpl
 (commit: 01c2b23)

Fix ReportQueryResultDao
 (commit: 63a35e3)

Add database json.
 (commit: be6a39c)

Handle timezone to ReportQueryResult

Report results for the same query may vary by timezone; therefor ReportQueryResult (which serves as a cache) needs to include the timezone.
 (commit: b450a15)

Fix ReportEditViewModel / ReportPeriod compilation.
 (commit: 24ac978)