Project

Profile

Help

Story #5402

As a developer, Package content allows ORDER_BY in postgres based on EVR comparisons

Added by ggainey about 1 year ago. Updated 2 months ago.

Status:
CLOSED - CURRENTRELEASE
Priority:
Normal
Assignee:
Sprint/Milestone:
Start date:
Due date:
% Done:

100%

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

Description

In order to be able to do things like ORDER BY (EVR) in postgres on the Package content unit, we need to have a type and a comparison method available. Some examples of this include:

Debian:

Spacewalk:

VMaaS:

We should probably adopt one of the existing methods for the Package model.


Related issues

Blocks RPM Support - Story #5367: As a user, I can have a sync option that retains the latest N packages of the same nameCLOSED - CURRENTRELEASE

<a title="Actions" class="icon-only icon-actions js-contextmenu" href="#">Actions</a>

Associated revisions

Revision ce6c3644 View on GitHub
Added by dalley 3 months ago

Add database support for comparing EVR

closes: #5402 https://pulp.plan.io/issues/5402

[nocoverage]

History

#1 Updated by bmbouter about 1 year ago

  • Subject changed from As Pulp3, I need to be able to do ORDER_BY in postgres based on EVR comparisons to As a developer, Package content allows ORDER_BY in postgres based on EVR comparisons
  • Description updated (diff)

Is the idea that there will be a field on the model and a DB trigger would populate it?

#2 Updated by ggainey about 1 year ago

bmbouter wrote:

Is the idea that there will be a field on the model and a DB trigger would populate it?

Depends on the exact approach - VMaaS, for example, creates the evr_t array and inserts it directly:

https://github.com/RedHatInsights/vmaas/blob/master/reposcan/database/package_store.py#L45

#3 Updated by bmbouter about 1 year ago

ggainey wrote:

bmbouter wrote:

Is the idea that there will be a field on the model and a DB trigger would populate it?

Depends on the exact approach - VMaaS, for example, creates the evr_t array and inserts it directly:

https://github.com/RedHatInsights/vmaas/blob/master/reposcan/database/package_store.py#L45

I see thank you. So we could do it either way.

#4 Updated by ttereshc 7 months ago

  • Priority changed from Normal to High
  • Sprint/Milestone set to Priority items (outside of planned milestones/releases)

Priority is high assuming this is blocking support of "keep N versions of RPMs in a repo"

#5 Updated by ttereshc 7 months ago

  • Blocked by Story #5950: Add database support for comparing EVRs added

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

#7 Updated by ttereshc 4 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 4 months ago

  • Priority changed from High to Normal

#9 Updated by dalley 3 months ago

  • Blocked by deleted (Story #5950: Add database support for comparing EVRs)

#10 Updated by dalley 3 months ago

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

#11 Updated by dalley 3 months ago

  • Status changed from POST to MODIFIED
  • % Done changed from 0 to 100

#12 Updated by ttereshc 2 months ago

  • Status changed from MODIFIED to CLOSED - CURRENTRELEASE

#13 Updated by ttereshc 2 months ago

  • Sprint/Milestone changed from Pulp 3.x RPM (Katello 4.1) to Pulp RPM 3.5.0

Please register to edit this issue

Also available in: Atom PDF