Analytics Service APIs - Refence implementation for Workflow Service

[NGrech]

Implement a database-backed reference of WorkflowService for local testing and to support integration with the execution and trigger services. This will mirror the architecture of DBBackedStudyDataService.

✅ Tasks

• Design database schema for storing Workflow and WorkflowMetadata.
• Create SQL migration / table creation scripts
• Define a WorkflowRepository interface with needed operations
• Implement a database-backed class DBBackedWorkflowService that satisfies WorkflowService
• Add mapping functions between domain models and DB rows
• Write unit tests for all service methods
  • createWorkflow
  • updateWorkflow
  • getWorkflow
  • deleteWorkflow
  • listWorkflows
• Validate implementation with a test workflow run

[Whathecode]

@NGrech It sounds like this doesn't belong to CARP core, but to CAWS, no?

[NGrech]

This is a refence/test implementation of the service like that of the in-memory service for the Data service.
So yes there will be a more robust version of this implemented in the Web Services