GV

GeezerVison

The World Wide Web, restored to 800 pixels of glory.

Home|About|Gaming cabinet|Archives|How it works|Starter sites

On this site

  • Sign in
  • ActionsCI/CD and automation
  • CodespacesCloud development environments
  • All Features
  • Documentation
  • Training
  • Certifications
  • Build with Copilot
  • Customize Copilot
  • Integrations
  • Trending repos
  • GitHub Sponsors
  • Developer articles
  • Enterprises

This view

  • Original page
  • New address

GeezerVison is showing github.com — [O2B-1545] Create GAQ summary tables by isaachilly · Pull Request #2173 · AliceO2Group/Bookkeeping

Conversation

@isaachilly

@isaachilly isaachilly commented Jun 19, 2026 •
edited
Loading

Uh oh!

There was an error while loading. Please reload this page.

Copy link
Copy Markdown
Collaborator

I have a JIRA ticket

  • branch and/or PR name(s) include(s) JIRA ID
  • issue has "Fix version" assigned
  • issue "Status" is set to "In review"
  • PR labels are selected

Notable changes for users:

  • N/A

Notable changes for developers:

  • N/A

Changes made to the database:

  • New table to store GAQ summaries and if and when they are invalidated.

Sorry, something went wrong.

Uh oh!

There was an error while loading. Please reload this page.

All reactions
isaachilly added 13 commits March 5, 2026 14:51
@isaachilly
[O2B-1545] Add GAQ summary models, adapters and migration
bb5a9c3
@isaachilly
[O2B-1545] Add GAQ summary repositories and timestamps
4fade0f
Add GaqSummaryRepository and GaqSummaryInvalidationRepository and export them from the repositories index.

Update migration to replace the previous invalidated_at field with created_at and add updated_at to mirror default Sequelize tables.
@isaachilly
[O2B-1545] Use default Sequelize createdAt/updatedAt instead of compu…
15afdaa
…tedAt
@isaachilly
[O2B-1545] Use mcReproducibleCoverage float instead of boolean
363f09b
Rename and change mcReproducible to be the coverage float not the boolean.
@isaachilly
[O2B-1545] Remove mcReproducible field
002f301
Forgot to remove.
@isaachilly
[O2B-1545] Rename GAQ summary coverage fields
16d3563
@isaachilly
Add calculationFailed to GAQ summaries
c2ccbd4
Add a calculation_failed boolean column to gaq_summaries. This allows us to know whether a summary has been attempted to be calculated but unsuccessful due to limited data etc.
@isaachilly
[O2B-1545] Make GAQ summary columns nullable
35112e5
Remove not-null constraints from several GAQ summary columns in the migration to allow NULL when values are unavailable.
@isaachilly
[O2B-1545] Add invalidatedAt to gaq_summaries, remove invalidation table
5059082
Store invalidation timestamp directly on gaq_summaries instead of a separate gaq_summary_invalidations table.
@isaachilly
[O2B-1545] Rename calculationFailed to notComputable
9893667
@isaachilly
[O2B-1545] Remove unused GaqSummaryInvalidation files and imports
47449a7
@isaachilly
[O2B-1545] Add index on gaq_summaries.invalidated_at
772a96c
Create an index on invalidated_at column of gaq_summaries table to improve query performance, as it is commonly used to fetch the invalidated summary queue.
@isaachilly
[O2B-1545] Add a composite primary key on GAQSummary table
f5f686c
Sequelize model omitted the primaryKey that migration file defines.
@isaachilly
isaachilly requested a review from graduta June 19, 2026 15:51
@isaachilly isaachilly self-assigned this Jun 19, 2026
@isaachilly isaachilly added the DB label Jun 19, 2026
@codecov

codecov Bot commented Jun 19, 2026 •
edited
Loading

Uh oh!

There was an error while loading. Please reload this page.

Copy link
Copy Markdown

Codecov Report

❌ Patch coverage is 82.75862% with 5 lines in your changes missing coverage. Please review.
✅ Project coverage is 46.10%. Comparing base (838e6a8) to head (5fee0a4).
⚠️ Report is 7 commits behind head on main.

Files with missing lines Patch % Lines
lib/database/adapters/GaqSummaryAdapter.js 50.00% 3 Missing ⚠️
...ons/v1/20260223120000-create-gaq-summary-tables.js 66.66% 2 Missing ⚠️
Additional details and impacted files
@@            Coverage Diff             @@
##             main    #2173      +/-   ##
==========================================
+ Coverage   45.82%   46.10%   +0.28%     
==========================================
  Files        1039     1042       +3     
  Lines       17189    17201      +12     
  Branches     3138     3136       -2     
==========================================
+ Hits         7877     7931      +54     
+ Misses       9312     9270      -42     

☔ View full report in Codecov by Harness.
📢 Have feedback on the report? Share it here.

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

Sorry, something went wrong.

Uh oh!

There was an error while loading. Please reload this page.

isaachilly added 2 commits June 19, 2026 18:05
@isaachilly
Merge branch 'main' into feature/O2B-1545/Create-GAQ-Summary-Tables
f2f5f79
@isaachilly
Update ca-certificates version in Dockerfile (#2138)
5fee0a4
@graduta
graduta force-pushed the main branch from 544a0ee to 1758c68 Compare July 29, 2026 09:49

This branch has not been deployed

No deployments
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Reviewers

@graduta graduta Awaiting requested review from graduta

At least 1 approving review is required to merge this pull request.

Uh oh!

There was an error while loading. Please reload this page.

Assignees

@isaachilly isaachilly

Labels

DB

Milestone

No milestone

Development

Successfully merging this pull request may close these issues.

Uh oh!

There was an error while loading. Please reload this page.

1 participant

@isaachilly
Add this suggestion to a batch that can be applied as a single commit.This suggestion is invalid because no changes were made to the code.Suggestions cannot be applied while the pull request is closed.Suggestions cannot be applied while viewing a subset of changes.Only one suggestion per line can be applied in a batch.Add this suggestion to a batch that can be applied as a single commit.Applying suggestions on deleted lines is not supported.You must change the existing code in this line in order to create a valid suggestion.Outdated suggestions cannot be applied.This suggestion has been applied or marked resolved.Suggestions cannot be applied from pending reviews.Suggestions cannot be applied on multi-line comments.Suggestions cannot be applied while the pull request is queued to merge.Suggestion cannot be applied right now. Please check back later.
You are visitor 01402520 — GeezerVison does not store the pages you look up.
Best viewed with Netscape Navigator 4.7 or Internet Explorer 6 at 800×600. No cookies required.