Story #5402: As a developer, Package content allows ORDER_BY in postgres based on EVR comparisons - RPM Support - Pulp

Agile board
Agile charts

Agile boards

Pulp 2 QE Agile Board
Pulp 2 QE Agile Board - Priority View
Pulp 3 QE Agile Board
Pulp 3 RPM Tests Agile Board
Sprint 112 Agile Board

Custom queries

[All Projects] All Test Trackers
2.21.4 - Next Bugfix Release
2.21.4 MODIFIED
2.21.5
3.14.3
Easy Fix
FIPS open
Functional Tests
Galaxy NG
Groomed
Issues for Triage
Katello Integration
Next Docs Day
POST/ASSIGNED - no Sprint - Pulp2
POST/ASSIGNED - no Sprint - Pulp3
Prioritized Bugs
Pulp 3 Docs issues
Pulp 3 Tests
Pulp RPM 3.x blockers
Pulp RPM Priority items
Pulp2 issues available for next release
SELinux related
Sprint 111
Sprint 112
Sprint Candidates (also groomed)
Un-Triaged Bugs
Verification Required

Actions

Send by e-mail Copy link

Story #5402

closed

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

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

Status:

CLOSED - CURRENTRELEASE

Priority:

Normal

Assignee:

dalley

Sprint/Milestone:

Pulp RPM 3.5.0

Start date:

Due date:

% Done:

100%

Estimated time:

Platform Release:

Groomed:

Sprint Candidate:

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:

https://packages.debian.org/sid/postgresql-11-debversion

Spacewalk:

https://github.com/spacewalkproject/spacewalk/blob/master/schema/spacewalk/postgres/class/evr_t.sql
https://github.com/spacewalkproject/spacewalk/blob/master/schema/spacewalk/postgres/packages/rpm.pkb#L194

VMaaS:

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

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 name

CLOSED - CURRENTRELEASE

Actions

Issue # Delay: days Cancel

History
Notes
Property changes
Associated revisions

Actions

Copy link

Updated by bmbouter over 4 years 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?

Actions

Copy link

Updated by ggainey over 4 years 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

Actions

Copy link

Updated by bmbouter over 4 years 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.

Actions

Copy link