| Time |
Nick |
Message |
| 06:00 |
pinesol |
News from qatests: Failed Installing Evergreen database pre-requisites <http://testing.evergreen-ils.org/~live//archive/2022-02/2022-02-23_04:00:02/test.39.html> |
| 07:12 |
JBoyer |
Ok! Finally made time to deal with the Postgres 14 complaint tripping up the live tester. (This message comes up no matter what version you install on stretch) So, until the qa tester should be happy again until it's moved beyond stretch. |
| 07:14 |
|
rjackson_isl_hom joined #evergreen |
| 07:27 |
|
collum joined #evergreen |
| 08:01 |
|
rfrasur joined #evergreen |
| 08:32 |
|
mantis joined #evergreen |
| 08:46 |
|
Dyrcona joined #evergreen |
| 09:04 |
JBoyer |
HEY. Maybe you've heard The Evergreen Project has a board that has an election each year. I daresay most of you in here qualify (do you work on / with Evergreen? seeeeems likely) |
| 09:04 |
JBoyer |
So if you want to volunteer or nominate someone to be on the board here is where that is done: https://forms.gle/Az3t1UQ8DcEL6obB8 |
| 09:11 |
|
Keith__isl joined #evergreen |
| 09:29 |
|
jvwoolf joined #evergreen |
| 10:14 |
|
mmorgan joined #evergreen |
| 10:32 |
|
collum joined #evergreen |
| 10:50 |
|
rfrasur_ joined #evergreen |
| 10:52 |
|
rfrasur joined #evergreen |
| 11:13 |
|
Keith_isl joined #evergreen |
| 11:35 |
|
Guest76 joined #evergreen |
| 11:47 |
Dyrcona |
Y'know the thing about eating pizza when you're hungry is that after eating the pizza, you're often still hungry. |
| 11:53 |
mmorgan |
Dyrcona: Doesn't that depend on what's on the pizza? |
| 11:55 |
Dyrcona |
I suppose it does. |
| 11:56 |
Dyrcona |
Today's case: Hawaiian Express. |
| 11:57 |
Dyrcona |
So, I was also going to ask a question: Has anyone ever tried looping over an array in PostgreSQL? But as I type the question, I realize that I should be able to do so with the UNNEST function, because there are places where Evergreen does that. |
| 11:58 |
Dyrcona |
I have a list of call number prefix ids to delete, but I need to remove them from call numbers first, so I thought I'd had code them into an array and loop over that. |
| 11:59 |
Dyrcona |
s/had/hard/ # I have lived in Massachusetts for too long. The accent is coming out in my typing. :) |
| 12:02 |
mmorgan |
Dyrcona: In that case, it should be 'hahd' :) |
| 12:02 |
Dyrcona |
mmorgan++ # Indeed. |
| 12:04 |
|
jihpringle joined #evergreen |
| 12:12 |
* csharp_ |
pahks his cah |
| 12:12 |
csharp_ |
harder to render southern dialects into text imo |
| 12:13 |
chreeus |
well, maybe not |
| 12:13 |
Dyrcona |
Y'all ain't from 'round here, is ya? |
| 12:14 |
chreeus |
what we have heah is a failyuh to commun-cate |
| 12:14 |
Dyrcona |
For the logs: I had to use "FOR pref_id IN SELECT UNNEST(ARRAY[...])' It didn't work without the SELECT. |
| 12:15 |
Dyrcona |
chreeus++ |
| 12:16 |
Dyrcona |
emacs++ psql++ # I can run psql inside emacs and just send SQL to a database without touching the command line. |
| 12:16 |
Dyrcona |
Which save me enough time to.... |
| 12:16 |
Dyrcona |
@praise Emacs |
| 12:16 |
* pinesol |
Emacs is one of the few who deserves to be praised |
| 12:16 |
Dyrcona |
:) |
| 12:16 |
Dyrcona |
Oh.... a bug in my SQL... |
| 12:20 |
chreeus |
http://web.archive.org/web/20120830045149/http://www.ninesys.com/fun/ - RedHat used to have Redneck localization in its installer |
| 12:22 |
Dyrcona |
:) |
| 12:22 |
Dyrcona |
Seein' as the'r bas't in Rawleh.... |
| 12:22 |
Dyrcona |
Too thick, huh? :) |
| 12:23 |
chreeus |
haha |
| 12:23 |
chreeus |
a bit like the Office episode where they're playing the murder mystery game and all trying to talk like southerners |
| 12:24 |
chreeus |
https://www.youtube.com/watch?v=EcPgG3YUivo |
| 12:24 |
Dyrcona |
I haven't seen that one. |
| 12:25 |
Dyrcona |
I'll watch that later. I have to figure out how I'm going to generate the SQL to change prefixes on a bunch of call numbers and then delete the obsolete prefixes. I think I'll arrange the data a certain way and then write some Emacs Lisp. |
| 12:26 |
Dyrcona |
Straight up deleting prefixes is easy by comparison. |
| 12:27 |
chreeus |
you might select the keepers into a temp table, delete all, then update them back into place |
| 12:27 |
chreeus |
but you're smarter than me, so :_0 |
| 12:28 |
* chreeus |
should investigate emacs more seriously sometime |
| 12:32 |
Dyrcona |
i've been given a spreadsheet with a column for the prefix to delete and the prefix to replace it with in call numbers. There's a many to one relationship, i.e. more to delete and fewer to keep. |
| 12:32 |
Dyrcona |
I was thinking of arranging the data in lines with the one to keep followed by the list of ones to delete. |
| 12:33 |
Dyrcona |
Then I could write some code to loop over the lines and write out the SQL to do the updates and delete. |
| 12:34 |
Dyrcona |
It would be bit tricky with a search and replace because the lines won't have the same number of elements. |
| 12:36 |
chreeus |
I do a lot of select 'update asset.call_number set prefix = ' || prefix || .... |
| 12:37 |
Dyrcona |
I've been asked to a lot of those, plus change labels, etc. I wrote a function to update asset.call_numbers: cwmars.update_acn(asset.call_number%ROWTYPE) |
| 12:38 |
Dyrcona |
It handles the inevitable duplicate key errors by doing updates on the copies, etc., and then deleting the call number row that I'm trying to update. |
| 12:39 |
Dyrcona |
I'm using it for these updates. |
| 12:39 |
chreeus |
oh right :-/ |
| 12:39 |
chreeus |
the dupes are super annoying |
| 12:41 |
Dyrcona |
The one field that my function can't change is the id. |
| 12:41 |
Dyrcona |
But, you wouldn't normally want to do that anyway. |
| 12:42 |
csharp_ |
pretty sure I've never changed an id |
| 12:42 |
Dyrcona |
Me neither. |
| 12:43 |
Dyrcona |
So, looks like I might be able to use a regexp search and replace. I have at most 2 call numbers to remove. I can probably handle that with regexp in Emacs. |
| 12:45 |
Dyrcona |
It will still be complicated.... |
| 12:47 |
Dyrcona |
I might just be better off writing a little interactive function and running it over each line. |
| 12:50 |
|
jihpringle joined #evergreen |
| 12:51 |
Dyrcona |
The substitution text is going to about 10 to 12 lines long, so.... function it is. |
| 13:28 |
Dyrcona |
So, think I'm gonna do this with a skeleton instead. For some reason, what I thought would be easy as a function, ain't so easy. |
| 14:03 |
JBoyer |
Bangin' that drum one more time that people interested in running for The Evergreen Project board can volunteer or nominate someone else here: https://forms.gle/Az3t1UQ8DcEL6obB8 |
| 14:06 |
Dyrcona |
No nominations, huh? |
| 14:07 |
JBoyer |
Last I knew there were some, yeah. Not sure if there are 4 or not, though. |
| 14:08 |
Dyrcona |
Hmm.. Looks like my long-running psql somehow lost its connection to the database, but neither side dropped the process. I just know that I enter stuff in psql and nothing happens.... The db side show it as idle. |
| 14:08 |
Dyrcona |
S'OK. I just assumed because you were pushing for nominations. |
| 14:09 |
Dyrcona |
Also, I stopped my client and the db shows a process still connected from my IP.... |
| 14:09 |
Dyrcona |
Not seen this happen before. |
| 14:09 |
Dyrcona |
OK, server finally realized the client is gone. |
| 14:09 |
Dyrcona |
It took a couple of minutes, though. |
| 14:10 |
Dyrcona |
Oh, no. That's the one that was actually doing something. The idle one is still there. |
| 14:12 |
Dyrcona |
Also, my update function is not working for this because the old prefix is still hanging around when there is a conflict.... |
| 14:12 |
Dyrcona |
Grr..... |
| 14:13 |
Dyrcona |
Looks like I'll have to pull the code out of the function and modify it for this specific update..... |
| 14:17 |
|
jihpringle joined #evergreen |
| 14:19 |
Dyrcona |
I'll have to set the call number preifx to -1 after deleting the call number... I suppose I could modify my update function to do that, but in most cases that feels like I'm losing information. |
| 14:20 |
Dyrcona |
Duh! *facepalm* |
| 14:21 |
Dyrcona |
I have a function to delete asset.call_number_prefix that deals with this situation.... |
| 14:31 |
Dyrcona |
Yeahp.... |
| 14:33 |
Dyrcona |
Typoed the file name, but my automated tools picked it up anyway.... :) |
| 14:36 |
csharp_ |
JBoyer: okay okay, I self-nominated :-) |
| 14:36 |
Dyrcona |
csharp_++ |
| 14:36 |
JBoyer |
csharp_++ |
| 14:38 |
csharp_ |
been a while since I volunteered for anything |
| 14:38 |
JBoyer |
Also, that was going the last time I brought it up, I just threw it on my calendar a couple times because I know not everyone uses a bouncer or hangs around at the same time. :) |
| 14:38 |
csharp_ |
2019 was the year from hell for me as I was very overcommitted, so I've been lying fallow since then |
| 14:39 |
csharp_ |
also, you know, my parents' health collapsed, pandemic, etc. |
| 14:45 |
Dyrcona |
direct-manipulation-- # I just accidentally dropped a folder with 8,000+ emails into my trash folder in my email client. I dragged it back out. Gonna be a while before IMAP sorts it all out..... *sigh* |
| 14:50 |
Dyrcona |
I guess using maildir helps... :) |
| 14:59 |
Dyrcona |
@wunder 01844 |
| 14:59 |
pinesol |
Dyrcona: https://i.imgur.com/m8EySrW.gifv |
| 14:59 |
Dyrcona |
@weather 01844 |
| 14:59 |
pinesol |
Dyrcona: Error: I could not find a valid location for: 01844 |
| 15:03 |
Dyrcona |
So, I can't figure out how the new weather plugin works, so I'll just come right out and say it: What's up with the weather today? The temperature is ridiculous for this time of year: 66 degrees Fahrenheit. (Nineteen degrees for those using that scientific system.) |
| 15:06 |
mmorgan |
... And more snow on Friday, just to make things more interesting! |
| 16:06 |
csharp_ |
every time I investigate why a supybot plugin isn't working it's due to bitrot |
| 16:06 |
csharp_ |
in @weather/@wunderground's case you have to have a personal weather device registered in order to get an API key |
| 16:06 |
csharp_ |
which must not have been true before |
| 16:09 |
Dyrcona |
Yeah, well, supybot is abandonware, IIRC. |
| 16:10 |
Dyrcona |
@dunno search opinion |
| 16:10 |
pinesol |
Dyrcona: 2 found: #20: "Yeah, well, you know, that's just, like, your..." and #22: "Yeah, well, you know, that's just like uh, your..." |
| 16:10 |
Dyrcona |
@dunno get 20 |
| 16:10 |
pinesol |
Dyrcona: Dunno #20: "Yeah, well, you know, that's just, like, your opinion, man." (added by csharp at 02:07 PM, September 30, 2013) |
| 16:12 |
csharp_ |
we do have an eg-bots server - might be time to start that migration as well |
| 16:16 |
Dyrcona |
What we need is more hands on deck. |
| 16:54 |
Dyrcona |
Also, I figured out where I was going wrong with the elisp function from earlier today. Not that it matters. |
| 16:54 |
Dyrcona |
Well, have a good evening everyone. Catch you all tomorrow! |
| 16:57 |
|
jvwoolf left #evergreen |
| 16:58 |
|
Keith_isl joined #evergreen |
| 16:59 |
|
mmorgan left #evergreen |
| 17:10 |
|
Bmagic joined #evergreen |
| 17:10 |
|
dluch joined #evergreen |
| 17:17 |
|
jihpringle joined #evergreen |
| 18:00 |
pinesol |
News from qatests: Failed Create Evergreen Database <http://testing.evergreen-ils.org/~live//archive/2022-02/2022-02-23_16:00:03/test.41.html> |
