Project

Profile

Help

Refactor #2185

Refactor #2116: Migrate mongo collections to postgres tables.

Migrate repo_content_units collection to repository_content table.

Added by jortel@redhat.com about 3 years ago. Updated 6 months ago.

Status:
NEW
Priority:
Normal
Assignee:
-
Category:
-
Sprint/Milestone:
-
Start date:
Due date:
% Done:

0%

Platform Release:
Blocks Release:
Groomed:
No
Sprint Candidate:
No
Tags:
Complexity:
Verified:
No
Verification Required:
No
Sprint:

Description

The data in the repo_content_units collection needs to be migrated into the repository_content (join) table in postgres.

For each field in the repo_content_units document:

repo_content_units  =>  repository_content
____________________|____________________________
                    => id (generated)
created             => created
repo_id             => repository_id (by Foreign Key relation)
unit_id             => content_id (by Foreign Key relation)
unit_type_id        => (omitted: see [1])

[1] The master-detail modeling of content means that every content (unit) has a record in the master table and
thus a unique id. The combination of id and type is not longer needed.


Related issues

Copied from Pulp - Refactor #2140: Migrate repo_distributors collection to repository_distributor table. NEW Actions

History

#1 Updated by jortel@redhat.com about 3 years ago

  • Copied from Refactor #2140: Migrate repo_distributors collection to repository_distributor table. added

#2 Updated by bmbouter 6 months ago

  • Tags deleted (Pulp 3)

Please register to edit this issue

Also available in: Atom PDF