Project

Profile

Help

Actions
Send by e-mail Copy link

Story #5950

closed

Add database support for comparing EVRs

Added by ggainey almost 5 years ago. Updated over 4 years ago.

Status:
CLOSED - DUPLICATE
Priority:
Normal
Assignee:
dalley
Sprint/Milestone:
Pulp 3.x RPM (Katello 4.1)
Start date:
Due date:
% Done:

0%

Estimated time:
Platform Release:
Groomed:
No
Sprint Candidate:
No
Tags:
Sprint:
Quarter:

Description

We have all the data for NEVRA, but for features to understand 'newer than' we need a custom type to let us compare. See examples here:

https://github.com/spacewalkproject/spacewalk/blob/master/schema/spacewalk/postgres/class/evr_t.sql

https://github.com/RedHatInsights/vmaas/blob/master/database/vmaas_db_postgresql.sql#L13

Actions
Copy link
 #1

Updated by CodeHeeler almost 5 years ago

  • Description updated (diff)

Applicability epic closed as that work is moved to Katello, but we still need the evr_t/db work for other features that will need to make the "newer than" comparison, so this story stands.

Actions
Copy link
 #2

Updated by ttereshc almost 5 years ago

  • Sprint/Milestone changed from Pulp 3.x RPM (Katello 3.16) to Priority items (outside of planned milestones/releases)

It's not needed for the nearest Katello release but it will be needed soon after that.

Actions
Copy link
 #3

Updated by ttereshc almost 5 years ago

  • Priority changed from Normal to High
  • Parent issue deleted (#5933)
Actions
Copy link
 #4

Updated by ttereshc almost 5 years ago

  • Blocks Story #5367: As a user, I can have a sync option that retains the latest N packages of the same name added
Actions
Copy link
 #5

Updated by ttereshc almost 5 years ago

  • Blocks Story #5402: As a developer, Package content allows ORDER_BY in postgres based on EVR comparisons added
Actions
Copy link
 #6

Updated by ttereshc almost 5 years ago

  • Blocks deleted (Story #5367: As a user, I can have a sync option that retains the latest N packages of the same name)
Actions
Copy link
 #7

Updated by ttereshc over 4 years ago

  • Sprint/Milestone changed from Priority items (outside of planned milestones/releases) to Pulp 3.x RPM (Katello 4.1)
Actions
Copy link
 #8

Updated by ttereshc over 4 years ago

  • Priority changed from High to Normal
Actions
Copy link
 #9

Updated by ttereshc over 4 years ago

  • Assignee deleted (ggainey)
Actions
Copy link
 #10

Updated by dalley over 4 years ago

  • Status changed from NEW to ASSIGNED
  • Assignee set to dalley
Actions
Copy link
 #11

Updated by pulpbot over 4 years ago

  • Status changed from ASSIGNED to POST
Actions
Copy link
 #12

Updated by dalley over 4 years ago

  • Blocks deleted (Story #5402: As a developer, Package content allows ORDER_BY in postgres based on EVR comparisons)
Actions
Copy link
 #13

Updated by dalley over 4 years ago

  • Status changed from POST to CLOSED - DUPLICATE
Actions
Send by e-mail Copy link

Also available in: Atom PDF