Project

Profile

Help

Story #5950

closed

Add database support for comparing EVRs

Added by ggainey over 2 years ago. Updated almost 2 years 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

Actions #1

Updated by CodeHeeler over 2 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 #2

Updated by ttereshc about 2 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 #3

Updated by ttereshc about 2 years ago

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

Updated by ttereshc about 2 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 #5

Updated by ttereshc about 2 years ago

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

Updated by ttereshc about 2 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 #7

Updated by ttereshc almost 2 years ago

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

Updated by ttereshc almost 2 years ago

  • Priority changed from High to Normal
Actions #9

Updated by ttereshc almost 2 years ago

  • Assignee deleted (ggainey)
Actions #10

Updated by dalley almost 2 years ago

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

Updated by pulpbot almost 2 years ago

  • Status changed from ASSIGNED to POST
Actions #12

Updated by dalley almost 2 years ago

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

Updated by dalley almost 2 years ago

  • Status changed from POST to CLOSED - DUPLICATE

Also available in: Atom PDF