1
99%
main: 96%

Ran 22 Jul 2024 02:36PM UTC

Files 26

Run time 0s

Badge

Embed ▾

Committed 22 Jul 2024 02:31PM UTC coverage: 99.461%. Remained the same

Job # 10042906642.1

Build Type

push

github

Committed by

ghukill

Commit Message

Fix bugs in volatile upserts

Why these changes are being introduced:

Two issues were noted during testing:

1. Some tables had updates for rows each daily run, even
though meaningful data had not changed. This was due to data
internal warehouse values getting included in Quickbase table that
changed daily, but were not meaningful changes.

2. Performance Reviews had some clobbering due to the merge
'Key' field not being unique.

How this addresses that need:

1. Foreign keys from data warehouse were removed from Quickbase
tables.  These provided no value, and were false flags that
data was changing.

2. Performance Reviews got the related Employee Appointment ID
as part of its merge 'Key' field hashing.  This makes them globally
unique for an employee.

Side effects of this change:
* All records were wiped from Performance Reviews and reloaded.

Relevant ticket(s):
* https://mitlibraries.atlassian.net/browse/HRQB-40

Run Details

922 of 927 relevant lines covered (99.46%)

0.99 hits per line

MITLibraries / hrqb-client / 10042906642 / 1
99%
main: 96%

README BADGES
x

Markdown

Textile

RDoc

HTML

Rst

Source Files on job 10042906642.1

MITLibraries / hrqb-client / 10042906642 / 1 99% main: 96%

README BADGES x

Markdown

Textile

RDoc

HTML

Rst

Source Files on job 10042906642.1

MITLibraries / hrqb-client / 10042906642 / 1
99%
main: 96%

README BADGES
x