[AMBARI-10212] Widgets: Add schema tables for PostgreSQL, MySQL and Oracle

• Type: Task
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.1.0
• Fix Version/s: 2.1.0
• Component/s: ambari-server
• Epic Link: Enhanced Service Dashboard
• Assignee: Siddharth Wagle
• Reporter: Siddharth Wagle
• Created: 26/Mar/15 00:21
• Updated: 26/Mar/15 02:41
• Resolved: 26/Mar/15 00:35

Description

Apart from adding new widget related table definitions in the DDL script for all the three database types, also update the upgrade catalog for Amabri-2.1.0 to create these tables on ambari upgrade.

Tasks:

• Create WidgetEntity and WidgetLayoutEntity.
• Add relationship from both entities to cluster. This will not be used to load widgets but only to find what StackVersion to use for lookup of stack widgets when requesting WidgetInfo with layouts.
• Create corresponding DAO objects with unit tests
• Create findById and findBySectionName and findByCluster

Issue Links

• links to: Review board