[HDDS-1189] Recon Aggregate DB schema and ORM

• Type: Sub-task
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.5.0
• Fix Version/s: 0.4.1
• Assignee: Siddharth Wagle
• Reporter: Siddharth Wagle
• Created: 28/Feb/19 00:17
• Updated: 05/Aug/19 14:45
• Resolved: 04/Apr/19 09:35

Description

Objectives

• Define V1 of the db schema for recon service
• The current proposal is to use jOOQ as the ORM for SQL interaction. For two main reasons: a) powerful DSL for querying, that abstracts out SQL dialects, b) Allows code to schema and schema to code seamless transition, critical for creating DDL through the code and unit testing across versions of the application.
• Add e2e unit tests suite for Recon entities, created based on the design doc

Issue Links

• causes: HDDS-1396 Recon start fails due to changes in Aggregate Schema definition (HDDS-1189).
• is blocked by: HDDS-1188 Implement a skeleton patch for Recon server with initial set of interfaces