Project

Profile

Help

Story #5950

Add database support for comparing EVRs

Added by ggainey 10 months ago. Updated 4 months ago.

Status:
CLOSED - DUPLICATE
Priority:
Normal
Assignee:
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

History

#1 Updated by CodeHeeler 9 months 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.

#2 Updated by ttereshc 8 months 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.

#3 Updated by ttereshc 8 months ago

  • Priority changed from Normal to High
  • Parent task deleted (#5933)

#4 Updated by ttereshc 8 months ago

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

#5 Updated by ttereshc 8 months ago

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

#6 Updated by ttereshc 8 months ago

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

#7 Updated by ttereshc 5 months ago

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

#8 Updated by ttereshc 5 months ago

  • Priority changed from High to Normal

#9 Updated by ttereshc 5 months ago

  • Assignee deleted (ggainey)

#10 Updated by dalley 4 months ago

  • Status changed from NEW to ASSIGNED
  • Assignee set to dalley

#11 Updated by pulpbot 4 months ago

  • Status changed from ASSIGNED to POST

#12 Updated by dalley 4 months ago

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

#13 Updated by dalley 4 months ago

  • Status changed from POST to CLOSED - DUPLICATE

Please register to edit this issue

Also available in: Atom PDF