Refactoring current database structure

Priority

Environment

None

Template

None

Description

Purpose:
In a scope of this task we need to rebuild database structure, remove unused columns, reorganize tables.

Approach

  • Write script to edit database structure
         - Remove tables: providers, packages, resources, titles 
         - Add foreign key "credentials_id" for table tags 

  • Write script to migrate data

  • Implement logic to retrieve objects by TagFilter from tags table. (remove joiners)

  • Delete all code related old tables (f.e. PackageRepository, ResourceRepository). Remove code duplications

  • Make sure unit tests are passed successful 

Development Team

Spitfire

Release

None

Story Points

Sprint

Confluence content

mentioned on

Checklist

hide

TestRail: Results

Activity

Show:

Details

RCA Group

TBD

Assignee

Reporter

TestRail: Cases

Open TestRail: Cases

TestRail: Runs

Open TestRail: Runs

Created September 14, 2022 at 7:02 AM
Updated April 19, 2023 at 4:27 PM
TestRail: Cases
TestRail: Runs

Flag notifications