| Time |
Nick |
Message |
| 00:51 |
|
Mark__T joined #evergreen |
| 07:17 |
|
rlefaive joined #evergreen |
| 07:36 |
|
jwoodard_tablet joined #evergreen |
| 07:42 |
|
mrpeters joined #evergreen |
| 07:42 |
|
sarabee joined #evergreen |
| 07:46 |
|
jboyer-isl joined #evergreen |
| 08:08 |
|
ericar joined #evergreen |
| 08:37 |
|
Shae joined #evergreen |
| 08:40 |
|
jwoodard_tablet joined #evergreen |
| 08:42 |
|
mmorgan joined #evergreen |
| 08:57 |
|
Dyrcona joined #evergreen |
| 09:29 |
|
Callender joined #evergreen |
| 09:42 |
|
yboston joined #evergreen |
| 09:47 |
|
collum joined #evergreen |
| 10:15 |
jboyer-isl |
I think we need a @band plugin, because there should be a "Data-Bass" |
| 10:17 |
jboyer-isl |
Oh, wow. Google informs me this is a super old pun and an actual company name. |
| 10:17 |
jboyer-isl |
Request withdrawn. |
| 10:19 |
kmlussier |
What does the @band plugin do? |
| 10:29 |
Dyrcona |
Is Data-Bass something you catch in the Data-Stream? |
| 10:29 |
Dyrcona |
;) |
| 10:29 |
Dyrcona |
Words are punny. |
| 10:29 |
* kmlussier |
groans |
| 10:41 |
Bmagic |
I am trying to use srfsh to run open-ils.storage.action.hold_request.targetable_holds.id_list. Forgive me, what is the syntax? |
| 10:43 |
Dyrcona |
request open-ils.storage open-ils.storage.action.hold_request.targetable_holds.id_list [ args, in, a list, ] |
| 10:43 |
Dyrcona |
IIRC. |
| 10:43 |
Dyrcona |
Maybe no brackets. |
| 10:44 |
Dyrcona |
yeah, most likely no brackets. |
| 10:44 |
Bmagic |
*JSON Parser Error |
| 10:44 |
Dyrcona |
drop the brackets, then make sure the args are properly formed JSON. |
| 10:45 |
* berick |
confirms you don't need brackets |
| 10:46 |
Dyrcona |
Yeah, that was a moment of stupidity on my part: "It's a JSON list." |
| 10:48 |
Bmagic |
hmmm, still working on it, I will have to resume later, on my way to bring a new library online! |
| 10:49 |
|
gsams joined #evergreen |
| 11:02 |
|
Christineb joined #evergreen |
| 11:21 |
* bshum |
waves from Austin, TX up in the direction of gsams |
| 11:40 |
jboyer-isl |
kmlussier: I think band is a lot like dunno, I'm not sure. code4lib's bot has it. |
| 11:41 |
|
jwoodard_tablet joined #evergreen |
| 11:44 |
jeff |
mostly @band exists for "hey, that would make a great band name..." |
| 11:45 |
jeff |
you can @band add Stemmer Override |
| 11:46 |
jeff |
then @band will return one at random, or you can @band search Someterm |
| 11:46 |
jeff |
and this concludes "more than you ever wanted to know about @band) |
| 11:46 |
dbs |
@band add Snoball's Chance in Hell |
| 11:46 |
pinesol_green |
dbs: http://cat.evergreen-ils.org.meowbify.com/ |
| 11:47 |
* dbs |
hopes "@band search Snoball's" would return hits for "Snoball" and "Snoball's" :) |
| 11:47 |
* jeff |
laughs |
| 11:59 |
Dyrcona |
Snobol's Chance in Hell. :) |
| 12:00 |
jboyer-isl |
COBOL's Oops, Now You're in Hell |
| 12:03 |
jeff |
hrm. /me ponders the sanity of array_agg(row_to_json(acp)) for some bulk extraction |
| 12:04 |
Dyrcona |
jeff: That depends on what you're going to do with it. |
| 12:04 |
jeff |
yeah. |
| 12:05 |
jeff |
experimenting with denormalizing data into an external search index. |
| 12:06 |
jeff |
i could select bibs to get the marc, then do a query for each to get the acn/acp data. |
| 12:06 |
jeff |
or i could do some joins and just end up things like bre.marc appearing multiple times in the query output, but that seems a little wasteful. |
| 12:06 |
jeff |
the first seems slow but not very wasteful in terms of data across the wire. |
| 12:07 |
jeff |
the second is appealing because it's one big query that gets everything, but since there'd be so much duplication that's where the wasteful comes in. |
| 12:07 |
jeff |
so i was looking at third options like "give me all the info in one query and don't reproduce large chunks of it" |
| 12:08 |
|
jihpringle joined #evergreen |
| 12:08 |
jeff |
i could probably craft a column that included just the bits i cared about for acn/acp data, in json/similar form. |
| 12:15 |
jeff |
and there's still the chance that i'm thinking about this entirely the wrong way. |
| 12:19 |
Dyrcona |
Do you need any more information than marc_export --items puts in the record? |
| 12:35 |
jeff |
a bit, yes. also, at this point i can't use marc_export with "only" a database connection. |
| 12:36 |
jeff |
marc_export uses the "run individual select queries as needed" method. |
| 12:37 |
Dyrcona |
jeff: I'd be tempted to go with the array_agg method, though it might be nice to group by bre for acns, and by acns for acp. |
| 12:38 |
Dyrcona |
jeff: That should be doable using a with query or two. |
| 12:38 |
Dyrcona |
Herm... Maybe I'm misunderstimating things...... |
| 12:40 |
jeff |
or i'm trying to be too clever. |
| 12:40 |
Dyrcona |
Well, if you're running on a fast network, all the extra data shouldn't be a burden. |
| 12:40 |
jeff |
anyway, running one additional query per bib to get the copy data is likely the way i'll go with to start. |
| 12:40 |
Dyrcona |
I guess it depends on what part of the problem you are trying to optimize. |
| 14:07 |
|
DPearl joined #evergreen |
| 14:23 |
DPearl |
I need pointer on Staff Client patron search. Most actor.usr fields have indexes based on expressions, typically lowercase(xxx) but sometimes more elaborate (e.g. day_phone). When creating the query for patron search, the SELECT clause needs to use the same expression as the index in order to use the index (WHERE lowercase(first_given_name) LIKE lowercase('stuff_user_typed%'). Where is this formation of the query clause done? |
| 14:24 |
|
gsams joined #evergreen |
| 14:25 |
jeff |
DPearl: mostly in OpenILS::Application::Storage::Publisher::patron_search |
| 14:25 |
jeff |
DPearl: which is the method behind open-ils.storage.actor.user.crazy_search |
| 14:26 |
DPearl |
jeff: Many thanks! Sometimes this stuff is hard to track down, so I appreciate the pointer (including the emoticons!) |
| 14:26 |
jeff |
open-ils.actor.patron.search.advanced and open-ils.actor.patron.search.advanced.fleshed are both backed by OpenILS::Application::Actor::patron_adv_search, which calls that storage API |
| 14:27 |
DPearl |
jeff++ |
| 14:27 |
Dyrcona |
I was gonna suggest starting with the advanced search. |
| 14:27 |
jeff |
DPearl: I made no intentional emoticons, so perhaps your client is misinterpreting me. :-) |
| 14:28 |
Dyrcona |
It's the colons in the Perl module paths. |
| 14:28 |
Dyrcona |
I turned graphic smileys off in my client. |
| 14:28 |
jeff |
oh, and OpenILS::Application::Storage::Publisher::actor::patron_search was the first method, i omitted the "actor::" |
| 14:29 |
kmlussier |
Ha ha. Those emoticons used to display in my client too. I couldn't understand why people kept including them in odd places. ;) |
| 14:32 |
* bshum |
misses pidgin sometimes |
| 14:34 |
* Dyrcona |
uses Pidgin. |
| 14:35 |
* csharp |
uses pidgin for interoffice IM and irrsi/screen for IRC |
| 14:36 |
tsbere |
We used to have interoffice IM, but it was primarily supposed to be for being able to let our members know things that email wasn't fast enough for, and nobody wanted to have it installed |
| 14:37 |
Dyrcona |
They missed the "wall" feature of the Unix system from the previous ILS, they said. |
| 14:37 |
tsbere |
Apparently it was too much of a potential distraction at the circ desk or something. Despite the plan being to send only things like "The system is going down RIGHT NOW due to an issue".... |
| 15:13 |
|
bshum joined #evergreen |
| 15:13 |
|
kmlussier joined #evergreen |
| 15:15 |
|
mceraso joined #evergreen |
| 15:40 |
csharp |
@blame evergreener.net |
| 15:40 |
pinesol_green |
csharp: Your failure is now complete, evergreener.net. |
| 15:41 |
kmlussier |
heh |
| 15:42 |
|
mrpeters joined #evergreen |
| 15:55 |
|
gmcharlt joined #evergreen |
| 15:56 |
|
jlitrell joined #evergreen |
| 16:26 |
jboyer-isl |
I can't tell if having to look up how to determine the number of possible permutations among multiple groups to verify code is a win or a lose for the day. |
| 16:28 |
jboyer-isl |
Doing it wrong leads to some wildly inaccurate numbers and mild panic. |
| 16:35 |
|
geoffsams joined #evergreen |
| 16:40 |
|
gsams joined #evergreen |
| 16:55 |
|
jlitrell joined #evergreen |
| 17:12 |
|
mmorgan left #evergreen |
| 17:50 |
|
cfarley joined #evergreen |
| 20:01 |
|
dcook joined #evergreen |
| 20:46 |
|
phasefx joined #evergreen |
