| Time |
Nick |
Message |
| 02:26 |
bshum |
Calling 0912 |
| 02:26 |
bshum |
(it's still Friday somewhere isn't it?) :) |
| 02:28 |
pinesol_green |
[evergreen|Jason Boyer] LP#121054: Add Deleted Flag to asset.copy_location - <http://git.evergreen-ils.org/?p=Evergreen.git;a=commit;h=f0a598e> |
| 02:28 |
pinesol_green |
[evergreen|Kathy Lussier] LP#121054: Adding release notes entry for copy location delete flag - <http://git.evergreen-ils.org/?p=Evergreen.git;a=commit;h=b1e8ab0> |
| 02:28 |
pinesol_green |
[evergreen|Ben Shum] LP#121054: Stamping upgrade script for asset.copy_location-delete-rule - <http://git.evergreen-ils.org/?p=Evergreen.git;a=commit;h=51d2b34> |
| 02:30 |
pinesol_green |
[evergreen|Kathy Lussier] LP1423922: Quick staff option to place another hold - <http://git.evergreen-ils.org/?p=Evergreen.git;a=commit;h=d93a8af> |
| 02:39 |
|
dreuther joined #evergreen |
| 05:10 |
pinesol_green |
Incoming from qatests: Test Success - http://testing.evergreen-ils.org/~live/test.html <http://testing.evergreen-ils.org/~live/test.html> |
| 06:55 |
|
Arlene joined #evergreen |
| 07:43 |
jonadab |
bshum: Technically, I think it will still be Friday *somewhere* for another five hours (certainly at least for four). But I don't know whether anyone in those timezones uses Evergreen. |
| 07:45 |
jonadab |
Well, not five hours from *now*. From when you said that. I think. |
| 07:48 |
jonadab |
Maybe six hours, even, from when you said that. Samoan time is UTC+13, I think, which would be 8 hours behind Eastern. |
| 07:48 |
jonadab |
In which case it's *still* Friday there, for, oh, about another eleven or twelve minutes. |
| 09:37 |
|
wlayton joined #evergreen |
| 11:27 |
|
wlayton joined #evergreen |
| 13:26 |
|
bmills joined #evergreen |
| 14:58 |
bshum |
jonadab: Heh, true. I think when I said it, it was still Friday on the west coast Americas time. More of a joking statement, but thanks for humoring me ;) |
| 16:52 |
pinesol_green |
Incoming from qatests: Test Success - http://testing.evergreen-ils.org/~live/test.html <http://testing.evergreen-ils.org/~live/test.html> |
| 18:33 |
gsams |
Not sure if this will get noticed today, but I'll put it out there. |
| 18:33 |
gsams |
I'm trying to replace some volume call numbers labels in the system via SQL |
| 18:34 |
gsams |
I'm currently pulling the list with where label LIKE 'J 92%' |
| 18:34 |
gsams |
the idea being that we'd replace all of the 920+ numbers with the string BIO |
| 18:35 |
gsams |
So I thought, why not try using regexp_replace on it? |
| 18:35 |
gsams |
so I can have it look for [0-9]+ and replace it with BIO, but the only problem I see with that idea is that there are also some sections that have decimal places |
| 18:37 |
gsams |
But if I account for the decimal, the regexp replace will miss the ones without... I just answered my own question... |
| 18:38 |
gsams |
I could just do regexp_replace on the ones with the decimal, and follow it up with another without the decimal and it should catch all of them without creating any anomolies. |
| 18:38 |
gsams |
thanks #evergreen for being the best sounding board today! |
| 18:58 |
gsams |
Of course, if someone sees this later that is much better at regular expressions than I am (because I'm not very good at them yet) please feel free to correct me or offer a better solution, I'm not jumping into this anytime soon heh |
| 19:03 |
jonadab |
gsams: If you had Perl-style regular expressions, it would be easily possible to write a single regex to match both. But I don't know if that's possible in SQL. |
| 19:06 |
jonadab |
Something like $label =~ m/^J 92[0-9](?:[.]\d+)?/ would do it in Perl. But I don' |
| 19:06 |
jonadab |
don't know if SQL has an equivalent for that last ? |
| 20:25 |
|
eeevil joined #evergreen |
| 20:25 |
|
sarabee joined #evergreen |
