Time |
Nick |
Message |
06:02 |
pinesol |
News from qatests: Testing Success <http://testing.evergreen-ils.org/~live> |
07:23 |
|
collum joined #evergreen |
08:27 |
|
Dyrcona joined #evergreen |
08:37 |
|
mantis joined #evergreen |
08:38 |
|
mmorgan joined #evergreen |
09:04 |
|
mantis1 joined #evergreen |
09:10 |
|
jvwoolf joined #evergreen |
09:39 |
|
rfrasur joined #evergreen |
10:45 |
|
_collum joined #evergreen |
10:51 |
* gmcharlt |
claims 1303 |
10:55 |
pinesol |
[evergreen|Jason Stephenson] Lp 1922567: Limit authority.full_rec.value indexes - <http://git.evergreen-ils.org/?p=Evergreen.git;a=commit;h=53b34b3> |
10:55 |
pinesol |
[evergreen|Galen Charlton] LP#1922567: stamp schema update - <http://git.evergreen-ils.org/?p=Evergreen.git;a=commit;h=edcbf51> |
12:06 |
gmcharlt |
draft release notes are available if anybody cares to edit: https://git.evergreen-ils.org/?p=Evergreen.git;a=commit;h=936729f2b04fdf7813d2b198edf717e4fd78f058 |
12:06 |
pinesol |
gmcharlt: [evergreen|Galen Charlton] check in first draft of release notes - <http://git.evergreen-ils.org/?p=Evergreen.git;a=commit;h=936729f> |
12:07 |
pinesol |
[evergreen|Galen Charlton] check in first draft of release notes - <http://git.evergreen-ils.org/?p=Evergreen.git;a=commit;h=936729f> |
12:07 |
pinesol |
[evergreen|Galen Charlton] wipe the release note slate clean - <http://git.evergreen-ils.org/?p=Evergreen.git;a=commit;h=c534066> |
12:11 |
gmcharlt |
and here's a google doc link if anybody wants to make in place edits |
12:11 |
gmcharlt |
https://docs.google.com/document/d/1YYuN429D_HrRC-kumimsoRV8pxAbtE5pD5Yw2_Zw8Wc/edit |
12:12 |
gmcharlt |
if you edit this way, please add your name to the acknowledgements section at the end to receive credit |
12:13 |
gmcharlt |
and I have now branched rel_3_8 |
12:31 |
pinesol |
[evergreen|Galen Charlton] LP#1826759: end DB update scripts with "COMMIT", not "END" - <http://git.evergreen-ils.org/?p=Evergreen.git;a=commit;h=8085a77> |
12:43 |
mmorgan |
gmcharlt++ |
13:00 |
|
collum joined #evergreen |
13:01 |
Dyrcona |
gmcharlt++ Sorry I missed that. |
13:02 |
csharp_ |
gmcharlt++ |
13:24 |
|
jihpringle joined #evergreen |
15:50 |
* Dyrcona |
grumbles about vendors wanting update files that require some convoluted SQL.... |
15:52 |
Dyrcona |
Daily updates and deletes for a single library.... |
16:09 |
Dyrcona |
Not sure window functions are going to help, either.... |
16:17 |
Dyrcona |
Well, that does NOT do what I wanted...not even close. :) |
16:24 |
Dyrcona |
I dun' like it, but a NOT IN over a WITH query of bibs with copies seems to work. |
16:25 |
* mmorgan |
loves a game of Twister with bib and copy data :) |
16:26 |
Keith__isl |
My motto for anything technology related is, "If it's stupid and it works, then it isn't stupid." |
16:26 |
* Dyrcona |
not so much. |
16:27 |
Dyrcona |
Heh. |
16:28 |
Dyrcona |
I don't think the query is stupid, I'm just not enamored of the last line "AND bre.id NOT IN (SELECT id FROM has_copies)" |
16:28 |
mmorgan |
Keith__isl: Is that different than life in general? ;-) |
16:28 |
Dyrcona |
I suppose I can use acn.record and skip the join on bilbio.record_entry bre. I'm not checking if bibs are actually deleted or not, and I'll set them deleted on writing the deletes files anyway. |
16:30 |
Keith__isl |
mmorgan Not even a little bit. :) But I'm a function over form sort of guy. |
16:31 |
mmorgan |
:) |
16:31 |
Keith__isl |
A ham-fisted approach that gets the job done is fine by me. Plus you end up with an extra ham in your fist to eat later for a snack. |
16:32 |
* Dyrcona |
politely dissents. |
16:34 |
Dyrcona |
I wonder if I should use create_date or activate_date for new copies? I've tested both, but the data I'm using is a few days out of date. |
16:37 |
Dyrcona |
Doesn't help when both variations on the query turn up the same record in production. |
16:38 |
Dyrcona |
I suppose that I can ask the library which they prefer. |
16:46 |
Dyrcona |
I think I'll use active date. Most of this library's copies are created and activated in the same day. Only about 2.8% of there records do not. |
16:46 |
Dyrcona |
s/there/their/ |
16:46 |
Dyrcona |
English is one of those stupid things that works. :) |
16:48 |
Keith__isl |
Dyrcona++ |
16:53 |
Keith__isl |
Also, speaking of working! |
16:53 |
Keith__isl |
The 2021 Hack-A-Way registration is now (hopefully) working |
16:54 |
|
alynn26 joined #evergreen |
16:54 |
Keith__isl |
Pushing an e-mail to the general listserv presently |
16:57 |
Dyrcona |
Keith__isl++ |
16:59 |
* Dyrcona |
calls it a day. |
17:04 |
* alynn26 |
calls it a day also. |
17:06 |
pinesol |
[evergreen|Galen Charlton] 3.8 release notes copy-editing and acknowledgment updates - <http://git.evergreen-ils.org/?p=Evergreen.git;a=commit;h=d2c055c> |
17:11 |
|
mmorgan left #evergreen |
18:02 |
pinesol |
News from qatests: Testing Success <http://testing.evergreen-ils.org/~live> |
19:40 |
csharp_ |
gmcharlt++ |