quay icon indicating copy to clipboard operation
quay copied to clipboard

db: Added the missing primary key constraint drops for manifestpullstatistics and tagpullstatistics table (PROJQUAY-8414)

Open deshpandevlab opened this issue 2 months ago • 1 comments

These tables were introduced in migration 7078c84d14e8_add_pull_statistics_tables.py and are used to track: tagpullstatistics: Pull statistics per repository tag manifestpullstatistics: Pull statistics per manifest digest

The tables support a pull statistics feature that tracks how often different tags and manifests are pulled from repositories.

This change fixes the failing cypress tests for the database updates

Testing

npm run quay:dump

> [email protected] quay:dump
> ${CLIENT:=docker} exec quay-db pg_dump -U quay -d quay --clean --if-exists > ./cypress/test/quay-db-data.txt && ${CLIENT:=docker} cp quay-quay:/datastorage/registry/. ./cypress/test/quay-storage-data

Successfully copied 73.2kB to /Users/shudeshp/Desktop/workspace/quay/web/cypress/test/quay-storage-data

deshpandevlab avatar Oct 08 '25 12:10 deshpandevlab

Codecov Report

:white_check_mark: All modified and coverable lines are covered by tests. :white_check_mark: Project coverage is 70.56%. Comparing base (dff9fa8) to head (456b56f). :warning: Report is 1 commits behind head on master.

Additional details and impacted files
@@            Coverage Diff             @@
##           master    #4332      +/-   ##
==========================================
- Coverage   70.56%   70.56%   -0.01%     
==========================================
  Files         447      447              
  Lines       42881    42881              
  Branches     4902     4902              
==========================================
- Hits        30260    30259       -1     
  Misses      10907    10907              
- Partials     1714     1715       +1     
Flag Coverage Δ
unit 70.56% <ø> (-0.01%) :arrow_down:

Flags with carried forward coverage won't be shown. Click here to find out more.

:umbrella: View full report in Codecov by Sentry.
:loudspeaker: Have feedback on the report? Share it here.

:rocket: New features to boost your workflow:
  • :snowflake: Test Analytics: Detect flaky tests, report on failures, and find test suite problems.
  • :package: JS Bundle Analysis: Save yourself from yourself by tracking and limiting bundle sizes in JS merges.

codecov[bot] avatar Oct 08 '25 13:10 codecov[bot]