Time Nick Message
00:01 dcook Trying to recall how to develop with DBIC when you're adding DB tables... :S
00:04 dcook Also trying to recall if we can import MARCXML into Koha...
00:04 dcook I guess that's an easy one to test
00:29 wajasu wanting to run the installer on the command line to get my db schema setup for t tests. i can't recall what script i can run.
00:31 wizzyrea koha-upgrade-schema <site>
00:31 wizzyrea (for a package)
00:32 * wajasu trying
00:48 wajasu found it. installer/debian/data/mysql/kohastructure.sql ;)
00:56 mtj hmm, i'm not sure that would work so well
00:57 mtj ...you'll be missing some stuff from your db still
00:57 dcook ^
00:58 mtj tho, having said that... i cant offer a better solution
00:59 mtj ... other than prep a clean db, and dump it - for testing
00:59 mtj (its what i do)
01:01 mtj its a bummer there is (afaik) no command-line equiv. of the web-installer
01:02 * dcook loves underdocumented CPAN modules
01:02 dcook mtj: I think that koha-upgrade-schema script works for Debian?
01:02 dcook Maybe not... maybe that's just for updates...
01:02 * dcook just uses a clean db and dumps too usually
01:03 mtj would be very handy to automate the initial web-install steps, from a script
01:03 dcook totes
01:04 mtj you could pass koha-create some args, or a config-file to make all the correct selections
01:04 dcook Probably :)
01:05 mtj koha-upgrade-schema assumes a pre-installed db, afaik
01:05 dcook Probably :)
01:06 dcook I don't use Debian at work, so I don't know much about the Debian scripts
01:07 mtj i'm talking about a script to do the inital db configuration steps (that the web-installer currently handles)
01:08 mtj ok, no probs
01:09 dcook tcohen, gmcharlt: I don't suppose either of you are around atm?
01:09 dcook Or rangi maybe?
01:10 dcook Hmm, maybe I'll just find a sample patch for DBIC..
01:12 dcook http://koha.1045719.n5.nabble.com/QA-Patches-with-database-changes-DBix-Class-td5779577.html
01:12 dcook :)
01:13 wizzyrea note I haven't tried it, can't you koha-create --populate-db <site>
01:13 wizzyrea well I mean I know you can
01:13 wizzyrea but I"m not sure what exactly it does.
01:13 wizzyrea it *seems* like it would do mostly what you're thinking of.
01:21 wajasu hooray! i built a koha package with passing tests. using docker! now i can build packages more easily, and test installs into fresh distributions more quickly.
01:24 wajasu gonna have to tweak and document this. will have to see if i can build ubunto too.
01:25 * wajasu time for dinner
01:26 dcook Dinger, I wanted to do the Docker workshop at OSDC...
01:26 dcook :/
01:28 wajasu once i tweak it, the pkg maintainer can take it and decide to run with it. i learned too much about package building. did not use pbuilder, but just dpkg-buildpackage.
01:29 wajasu so i don't need a fakeroot, since i am in a docker root with a minimum debian squeeze.
01:29 dcook I occasionally think about learning more about building RPMS, but seeing as there are at least two different types of RPMs, I decided on a big nope
01:33 wajasu i am runnign a laptop with wheezy amd64 and wheezy-backport linux kernel to get docker running.
01:33 wajasu this might be a quicker sandbox, since its using lxc.
01:35 mtj wizzyrea: populate-db does loads a default koha.sql file, but takes no options
01:36 mtj but, yeah - its a good start, afaik
01:36 wizzyrea hey, a thing to extend :)
01:37 mtj i guess its a oldish db - but can be updated with the koha-upgrade-schema script, after loading
01:40 mtj yep, a thing to extend :)
01:42 mtj hmm, but i dont think a default koha.sql exists in the repo - you might need to add one yourself
01:45 wizzyrea I would hesitate on that, I'm not super clear (it's one of those things I should look into, honestly) on the details of how the database is built up these days, but it isn't as straight forward as it used to be as far as I can tell.
01:46 * dcook is also curious about how the DB works these days
01:49 wajasu i looked at the koha-upgrade-schema and it ran updatedatabase.sql and it only had 57 tables. so i ran mysqladmin ... < installer/data/mysql/kohastructure.sql first.
01:51 mtj youll be missing some stuff wajasu
01:51 mtj sysprefs, frameworks, branches
01:53 mtj probably saner to just do a web-install, then dump/load your db, for testing
01:53 mtj that way, you know its correct
01:54 wizzyrea that's what most people do
01:54 mtj would be a bummer to waste time testing on a glitched db :/
01:54 wajasu ok.
01:54 wizzyrea nice for people to routinely check the web installer though
01:55 wizzyrea i did, once, do an install of koha using lynx
01:55 wizzyrea it seemed to work ok
01:55 mtj yeah, ive done that ok too
01:56 wajasu maybe www mechanize ...?
01:56 mtj yeah, good call wajasu - (or selenium)
01:58 wajasu i'm going to plod through to test bug 12856
01:58 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=12856 normal, P5 - low, ---, gmcharlt, Needs Signoff , koha-disable fails without disabling site
01:59 mtj this looks interesting too... -> http://phantomjs.org/
01:59 mtj (a bit off-topic)
01:59 wizzyrea \o/
02:33 * dcook wonders what the "z3950queue" is...
02:33 dcook Hmm, maybe that's a local thing
02:33 dcook And that's what I get for not using a clean DB
02:34 * wizzyrea doesn't have that one
02:34 dcook Hmm, definitely local then
02:34 dcook I remember we had a custom Z39.50 thingo
02:34 dcook Wondering about terminology for this OAI harvester...
02:35 dcook "oai_harvest", "import_oai", "oai_queue", "OAIqueue"
02:35 dcook I guess we don't use CAPS so the last one is out
02:36 dcook Mmm, "oai_harvest" it is
02:55 dcook Interesting...I can't install resolve some Perl dependencies when installing fresh... but it's not an issue when upgrading? :S
02:56 dcook Any FriBidi gurus around at the moment?
03:07 dcook Anyone else having issues installing Text::Bidi?
04:10 mtj seems to work ok on deb-stable, dcook
04:10 dcook I figured it probably would on Debian :)
04:10 mtj # apt-get install libtext-bidi-perl
04:10 dcook Oh, the perils of not using a Debian-based OS
04:13 mtj sorry to torment you, dcook
04:13 dcook No worries :p
04:13 dcook I figured there would be an uproar if it didn't work on Debian ;)
04:14 mtj hey, do peeps have a good suggestion for xml2csv.pl conversions, for koha
04:14 dcook O_o
04:14 dcook Why would you want to do xml2csv?
04:14 dcook Also, what's xml2csv.pl? :)
04:15 mtj im looking thru this at the mo.. -> https://gitorious.org/koha-toolbox/koha-migration-toolbox
04:16 mtj why?, i have a reliable workflow to convert csv to marc
04:16 mtj but no workflow to convert xml to marc
04:17 mtj so, if i can convert xml to csv - then i'm good
04:18 mtj xml2csv.pl is an imaginary name of a perl script... that converts xml to csv
04:25 jcamins mtj: use XSLT.
04:26 mtj i've been using some homemade perl scripts, using anydata - with some success...
04:26 jcamins Or, if the XML is actually equivalent to a CSV, use a regular expression.
04:26 mtj http://search.cpan.org/~sdowideit/AnyData-0.11/lib/AnyData.pm
04:26 mtj ..but, i was curious if anyone else had a better way
04:27 mtj xslt sounds a bit... labour intensive
04:28 mtj i think i would have to write the xslt myself
04:28 mtj jcamins: thanks for the reply
04:29 mtj do you know of any examples, using xslt, on the webs?
04:29 jcamins Well, yeah. If you want to take advantage of the structure of generic XML, there's no way around it. If you don't want to take advantage of the stucture, regular expressions would most likely be fine.
04:29 jcamins mods?
04:29 wahanui hmmm... mods is a zillion times more sane
04:29 jcamins mods?
04:29 wahanui mods is probably a zillion times more sane
04:30 jcamins Eh. Well, find the MODS2MARCXML stylesheet that LC has.
04:31 dcook XSLTs aren't that bad to write after you play around for a bit.
04:32 mtj fwiw, ive played with xslt a bunch - i hate it
04:32 * dcook shrugs
04:32 dcook You could use LibXML to read the data and then write it out to a MARC::Record object
04:32 dcook That would also be heaps easy
04:35 mtj hmm, ok - thanks for the suggestion guys
04:35 mtj i'll let you know how i get on
04:36 dcook :D
04:36 dcook I figured out my issue in the end as well
04:36 dcook Well, I lie
04:36 dcook Someone else figured it out for me :P
04:36 dcook Had the fribidi package installed but not fribidi-devel
04:37 dcook fribidi?
04:37 dcook Hmm, probably not relevant to anyone else really..
04:39 dcook Yay! Now I can finally install Koha again...
04:50 dcook Oh my... I didn't realize "update_dbix_class_files.pl" would refresh the whole thing...
05:17 dcook Oh DBIC...
05:32 wajasu mtj: maybe xmlstarlet can help convert your xml to csv http://www.joyofdata.de/blog/transforming-xml-document-into-csv-using-xmlstarlet/
05:37 wajasu mtj: http://stackoverflow.com/questions/13317053/how-should-i-go-about-converting-xml-into-csv
06:08 dcook DBIC grrr
06:14 dcook Interesting... I wonder how find_or_new works for DBIC...
06:17 dcook Identical content but there must be some difference... control characters or encoding or something...
06:17 dcook Neato burrito in any case
07:24 * magnuse waves
07:24 magnuse @later tell bag HI
07:24 huginn magnuse: The operation succeeded.
07:25 * cait waves at magnuse
07:25 * magnuse waves at cait
07:26 magnuse dcook: https://metacpan.org/pod/DBIx::Class::ResultSet#find_or_new ?
07:28 magnuse mtj: https://metacpan.org/pod/Catmandu::Importer::XML -> https://metacpan.org/pod/Catmandu::Exporter::MARC
07:35 reiveune hello
07:36 magnuse bonjour irma et reiveune
07:37 reiveune salut magnuse dcook and everybody
07:57 alex_a bonjour
07:57 Joubu hello
08:06 magnuse @wunder boo
08:07 huginn magnuse: The current temperature in Bodo, Norway is 2.0°C (8:50 AM CET on November 04, 2014). Conditions: Partly Cloudy. Humidity: 60%. Dew Point: -5.0°C. Windchill: -3.0°C. Pressure: 29.44 in 997 hPa (Rising).
08:28 gaetan_B hello
09:10 ashimema morning #koha
09:14 mtj thanks for the links magnuse ^
09:15 bensinober morning ashimema, still excited by the discussion on APIs from yesterday, we will continue on koha-restful but on the idea of migrating to Koha::Service in due course
09:15 mtj hey Joubu, do you think we should start to use bugzilla for the qa-tool?
09:15 bensinober please dont hesitate if you need us to test code or help in any other way
09:15 bensinober we realize its 100% focus on qa and 3.18 now..
09:16 Joubu mtj: Hi, why? :) I don't have a lot of request
09:16 mtj Joubu: i was thinking of making some :)
09:16 cait hi #koha
09:17 mtj perhaps the tool is critical enough now, that we should?
09:18 mtj i understand its a bit more work... :/ but perhaps its worth it?
09:20 ashimema What are you suggesting mtj...
09:20 ashimema integrating the qa tool into bz to autorun upon bug uploads or somthing like that?
09:20 mtj no
09:21 Joubu I think we can use github to do it
09:21 mtj we can use github, but im suggesting to use bz instead
09:22 mtj (just a suggestion)
09:23 ashimema care to explain then?
09:23 mtj ie; use bz's workflow to accept patches foe the qa-tool - rather than githubs issue-tracker
09:23 Joubu what kind of stuffs do you want to add?
09:23 ashimema rangi et al seems fairly set against moving too much workflow into github btw.. not being open soruce itself..
09:24 mtj Joubu: basically, more verbosity
09:24 ashimema there are similar efforts out there though ;)
09:25 mtj better descriptions of the FAILS, line numbers...
09:25 mtj that kind of stuff..
09:25 Joubu mtj: won't be easy to do
09:26 ashimema Is that not what Splinter Review is for?
09:26 ashimema that's what I use it for
09:26 mtj some stuff will be easy, Joubu... like line numbers
09:26 Joubu mtj: it's quite trivial to find the line numbers, just run perl -wc and perlcritic and they will give us the ln
09:26 Joubu mtj: not sure it's easy :)
09:27 Joubu but if you think it's easy, go
09:29 mtj i agree, its trival to find the line number of some errors
09:30 mtj so.. we should display that helpful info in the qa-tool's output
09:32 Joubu mtj: the problem is that we don't have the line numbers when we display le report
09:33 mtj hmm, really? but why not?
09:33 mtj perhaps i can fix that then
09:33 Joubu hum, not sure I can explain you easily.
09:34 mtj ok, no probs
09:34 Joubu but quickly: we launch perl -wc (for instance) on file.pl, before the patches applied
09:34 Joubu we kept the error message (warn XXX at line L1)
09:35 Joubu after the patches applied, perl -wc file.pl
09:35 Joubu we kept the error message (warn XXX at line L1 AND warn YYY at line L2)
09:35 Joubu we don't want to warn the XXX warning/error
09:35 Joubu it's not a new one
09:35 mtj *nod*
09:36 mtj so, we have a new YYY warn...
09:36 Joubu but if the L1 is not L1 (the patches added/removed lines before the warn)
09:36 Joubu we will warn it
09:37 Joubu so the script removes the line numbers from the messages
09:37 Joubu but maybe we can store them somewhere on the second pass
09:38 Joubu I don't remember the structure we used
09:38 mtj sure, store them in a file - for starters?
09:39 mtj but, yeah - it sounds do-able to compare the before/after errors
09:40 mtj we may get some false-positives, but thats worth it, for helpful line numbers
09:41 Joubu not sure :)
09:41 mtj anyhoo Joubu... no need for you to explain to me - ill take a look myself
09:41 mtj ...and see if i can make some improvements
09:42 mtj thanks for the explaination
09:44 mtj Joubu: i should take a look first - before i say how easy it will be!
09:45 mtj ashimema: btw whats 'Splinter Review',? i get no luck using google
09:46 mtj its something for bz?
09:46 magnuse mtj: there is a link to the right of every patch on bz
09:47 magnuse "Details | Diff | Splinter Review"
09:48 mtj aah, ok
09:49 mtj ..that looks a bit different than what we are talking about here
09:49 mtj basically, the ability for qa-tool to give line-numbers for its various errors
09:57 ashimema Sounds like you found it ;)
09:58 ashimema It's for reviewing patches inline on bz..
09:58 ashimema so your takling about he qa tool spitting out line numbers..
09:58 ashimema how does it relate to bz is my question..
09:58 ashimema just wondering as it sounds like an interesting idea :)
10:01 magnuse i think mtj wants to add the line number feature, and is asking where he should be reporting that bug/enh? in bz or on github
10:08 mtj yep, thats it magnuse
10:10 mtj ashimema: fyi, i think getting the qa-tool to autorun on newly sumbitted patches is a great idea
10:11 mtj ... but that was not what i was talking about before, (thats all)
10:13 mtj people have mentioned that (at some stage) the qa-tool code might be merged into the koha repo itself
10:22 Joubu mtj: it is: http://git.koha-community.org/gitweb/?p=qa-test-tools.git;a=summary
10:25 mtj Joubu: i mean merged into the koha.git repo - rather than hosted on the kc.org git server
10:47 ashimema I see now... i was really getting wires corssed then..
10:47 ashimema thanks for the clarifications.
10:48 cait I think i like it separate
10:49 cait becuse i am testing qa against various versions
10:49 cait and i alays want to use the most recent qa tool
10:49 cait well on the main repo, but not part of Koha is what i meant :)
11:23 magnuse bonjour khall
11:23 khall mornin!
11:24 cait morning khall!
11:24 khall morning cait!
11:25 cait khall: can I attack you with a bug fix wish?
11:26 khall sure!
11:26 cait bug 10382
11:26 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10382 critical, P5 - low, ---, kyle, Failed QA , collection not returning to null when removed from course reserves
11:27 khall ooh, that one is wicked difficult! I'll have to revisit it
11:28 cait i think it's quite an evil one tho
12:23 tcohen morning!
12:23 tcohen @wunder cordoba, argentina
12:23 huginn tcohen: The current temperature in Cordoba Aerodrome, Argentina is 14.0°C (9:00 AM ART on November 04, 2014). Conditions: Scattered Clouds. Humidity: 36%. Dew Point: 3.0°C. Pressure: 30.11 in 1020 hPa (Rising).
12:24 cait good morning tcohen :)
12:24 tcohen hi cait
12:27 cait hm hi tcohen... whenever you come back :)
12:28 cait Joubu: i think we wrote a comment almost at the same time - bug 12851
12:28 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=12851 normal, P5 - low, ---, jonathan.druart, In Discussion , order tags are not removed on claiming serials/orders
12:31 Joubu cait: yep :)
12:50 fridolin hie all
12:54 oleonard Hi #koha
13:10 magnuse bug 13194 - easiest signoff evvah!
13:10 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13194 trivial, P5 - low, ---, magnus, Needs Signoff , Tiny typo in POD for SetMessagingPreferencesFromDefaults
15:33 ashimema is the wiki down?
15:33 ashimema hmm.. appears to just be me
15:33 ashimema odd
15:37 ashimema @later tell eythian Could you take a look at bug 7904 possibly.. I'd be interested to hear your view on how it may affect packages.
15:37 huginn ashimema: The operation succeeded.
15:38 ashimema bug 7904
15:38 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7904 enhancement, P5 - low, ---, colin.campbell, Needs Signoff , SIP modules handling of @INC is confused
16:17 bag @notes khall
16:17 huginn bag: Error: I have no notes for that nick.
16:17 ashimema is anyone lese getting dns error for the wiki..
16:17 ashimema I can't for the life of me get to it at the moment.
16:18 bag khall: http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=12971
16:18 huginn 04Bug 12971: critical, P5 - low, ---, kyle, NEW , Printing member information lacks data
16:22 reiveune bye
16:31 bag @later tell gmcharlt http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11944 Is waiting for some feedback from you
16:31 huginn bag: The operation succeeded.
16:31 huginn 04Bug 11944: major, P5 - low, ---, jonathan.druart, Passed QA , Cleanup Koha UTF-8
16:41 oleonard So it looks like "Always show checkouts immediately" option means "...until the next browser session"
16:41 oleonard Not the same definition of "always" that I work with
16:48 hbraum oleonard we’ve found it’s set that way until you clear the browser cache….so if the cache is cleared on the browser closing, yep, it has to be set again after the next login.
16:54 oleonard Based on the code I don't see how that can be true hbraum. The cookie is not set with an explicit expiration, so it is created as a session cookie.
16:56 hbraum oleonard i just know what we’ve experienced with our libraries vs my computer. i don’t have the cache set to clear on chrome or firefox on my computer, and that always show setting holds, even when I have to log back in to Koha. But on all of our library computers, where the cache IS cleared on browser close, the libraries have to recheck that always show button on the next session
16:56 hbraum i’m admittedly not entirely happy about the setting…but checkouts are MUCH faster, so trying to live with it right now.
17:02 barton can someone give wiki.koha-community.org a kick? 'tis hanging.
17:11 hbraum barton I just noticed that too.
17:14 bag hbraum: we have khall working on all those bugs :) we're going to bust our butts so that feature is nice and clean in 3.18 :) (backporting as much as we can too)
17:14 bag oleonard ^^^^
17:14 oleonard Bug 13196
17:14 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13196 normal, P5 - low, ---, oleonard, ASSIGNED , "Always show checkouts immediately" cookie should persist across sessions
17:15 bag khall ^^^^
17:15 hbraum bag I know :) I’ve been pulling along others as they’ve griped about it :) once I explain why that happened, and that it was part of the way to speed up checkout…people are much happier for now.
17:16 hbraum bag I can say that checkout IS much faster across the board…we may not even have to purge datatables any more!
17:16 bag ummm heh - yes you do ;)
17:17 hbraum well…our special purging…how’s that?
17:17 hbraum not having to purge accountlines anymore will make me VERY happy.
17:18 gaetan_B bye!
17:18 bag heh hbraum - of course we shall see :D
17:18 hbraum (because I have to maintain an offline backup…for 1 library)
17:18 bag that's a pain eh
17:20 larryb hello #koha
17:20 larryb gmcharlt, do you have access to the debian.koha-community.org server?
17:21 bag larryb: I think that's catalyst perhaps
17:21 larryb it appears to be down.
17:21 bag maybe eythian controls that
17:21 bag cait do you know?
17:21 wahanui cait is probably happy about some example opacs :)
17:21 bag cait++
17:21 cait sorry, have to read back later
17:21 cait still fihgting with booking a bus ticket...
17:21 bag ah no luck larryb cait is busy
17:21 bag Joubu: do you know who hosts debian.k-c.org?
17:22 larryb according to the whois, the IP is registered to Equinox Software
17:22 bag ah there you go - larryb I think gmcharlt is on a plane to atantla
17:22 larryb damn
17:23 bag larryb: there are equinox peeps here
17:23 bag phasefx: this is jason right?
17:23 larryb hola equinox. does anyone here have access to the debian.k-c.org server? It may need a reboot.
17:24 larryb (sound of crickets chirping)
17:25 bag yeah larryb I'd hop into #evergreen on freenode
17:25 bag seeing if I can do that
17:25 larryb thanks
17:29 larryb bag, I'm txting with gmcharlt now. He's still on the ground
17:29 larryb bag, he says he can reboot it
17:30 cait great.... train strike and now the website for the bus is dead :(
17:31 oleonard cait: Ask gmcharlt to reboot it?
17:31 cait not sure that will work :(
17:31 cait and it's my dad's birthday this weekend... and he told me yesterday to get a bus ticket
17:32 barton cait -- wow, why did they route the trains through the server room? ;-)
17:32 bag ha oleonard that's funny
17:32 cait *grump*
17:39 cait no chance now for the ticket :(
17:40 oleonard svc/holds really spams the error logs... "Use of uninitialized value in string eq at svc/holds line 77" once for every hold
17:41 cait do we have all the bugs linked to the main one?
17:42 larryb woohoo, debian.k-c.org is back online
17:53 barton what day did salvation army come on line?
18:27 jcamins barton: they've been following the fold for 149 years.
18:27 barton heh. wrong window.
18:34 cait i got a bus ticket!!
18:36 bag cait: great news!!!
18:39 jcamins barton: then stray no more!
18:40 druthb cait++
18:41 bag hola druthb
18:42 bag congrats on the birthcretifate change
18:42 bag freaking spelling
18:42 druthb thanks, bag! :D
18:44 barton yeah bag, a birth certificate is definitely somewhere that you want to get the freaking spelling *right* ;-)
18:47 druthb yep. They left two very important letters off of my birth certificate, and it has taken me 46 *years* to get it fixed.
18:47 barton goodness.
18:48 druthb yah. In the box marked "Sex", they left of the "fe" at the first of the word…
18:52 cait druthb++ :)
18:55 druthb :)
19:00 rangi khall: is there somewhere other than libki.org i can get the code :) is the sourceforge git repo up to date?
19:00 khall rangi: the current canonical source is https://bitbucket.org/libki-kms/
19:01 rangi ta
19:01 khall np!
19:03 oleonard Hi rangi
19:04 rangi heya oleonard
19:04 wahanui oleonard is not really here. He said so. He did!
19:05 * druthb lols
19:05 druthb wahanui: botsnack cookie
19:05 wahanui :)
19:08 * oleonard is gaslighting wahanui
19:08 cait what?
19:10 oleonard A term which comes from the film "Gaslight" which means doing stuff to make someone think they're going crazy
19:10 druthb Oh, no need for that, oleonard. wahanui has always been about half-mad. And doesn't seem to mind.
19:10 cait he is probably happier that way :)
19:44 oleonard khall: Perhaps one solution to Bug 12971 would be to make it like slips: Have it use an html-formatted notice template?
19:44 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=12971 critical, P5 - low, ---, kyle, NEW , Printing member information lacks data
20:08 bag heya ashimema do you all have any update on this http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7736
20:08 huginn 04Bug 7736: new feature, P5 - low, ---, colin.campbell, ASSIGNED , Edifact QUOTE and ORDER functionality
20:11 cait bag: 21:00 here, he might have stopped working :)
20:11 bag yeah I will @later thanks cait
20:12 cait he shoudl have stopped working...
20:13 bag @later tell ashimema heya ashimema do you all have any update on this http://bugs.koha-comm unity.org/bugzilla3/show_bug.cgi?id=7736
20:13 huginn bag: The operation succeeded.
20:13 huginn 04Bug 7736: new feature, P5 - low, ---, colin.campbell, ASSIGNED , Edifact QUOTE and ORDER functionality
21:51 tcohen hi
21:51 wahanui bonjour, tcohen
21:54 bag hola tcohen
21:54 cait hola
22:03 tcohen hola cait
22:41 wizzyrea on a pristine database, can you replicate 12838? Just realised that the bug may only be with upgraded ones
22:41 wizzyrea this ~3.12 era one doesn't seem to have the problem
22:41 dcook bug 12838
22:41 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=12838 minor, P5 - low, ---, fridolyn.somers, Needs Signoff , Deleting a borrower orphans that borrower's lists
22:41 wizzyrea but another 3.12 does, but it was an upgrade one
22:42 dcook I should have a pristine database right here that I could quickly check..
22:43 wizzyrea another possible difference, I was testing on mariadb instead of mysql but...
22:43 dcook Hmm, we're also using mariadb
22:44 dcook If it's orphaning them, I imagine either there's a missing cascade delete in the DB or there's a code difference?
22:44 * dcook hasn't actually looked at the bug report
22:44 dcook Crap...I don't have any records to test on..
22:44 wizzyrea that's what I'm wondering, if the problem only manifests because older databases never got a cascade delete on upgrade, but new ones have it
22:45 dcook Well, I can check the db right now for that
22:45 dcook Yep, there's a cascade delete on borrowernumber for patrons_list
22:45 dcook for 3.17
22:45 * dcook checks an older version..
22:46 dcook No idea what patron_lists_patrons is..
22:46 dcook 3.14 looks ok
22:46 wizzyrea wonder when that was added.
22:46 dcook Ah, my bad
22:47 dcook patron lists isn't the right thing
22:47 wizzyrea virtualshelves
22:47 dcook borrower's lists would be virtualshelves
22:47 dcook 3.8 looks bad
22:47 dcook "set null" instead of cascade
22:47 wizzyrea YES that's exactly it then. new db's -> ok, upgraded ones -> bad
22:47 dcook Same on a 3.14 upgraded from 3.8
22:48 wizzyrea \o/
22:48 dcook Hmm
22:48 dcook My 3.17 says "set null" as well
22:49 dcook So I don't think that's it?
22:49 dcook My 3.17 is pristine
22:50 wizzyrea no cascaded delete, please see HandleDelBorrower in VirtualShelves.pm
22:50 wizzyrea ) ENGINE=InnoD
22:50 wizzyrea in the schema
22:50 wizzyrea on the virtualshelves
22:50 wizzyrea that's 3.17
22:52 wizzyrea annoying problem.
22:52 * wizzyrea keeps testing
22:52 wizzyrea thanks for looking
22:55 dcook No worries :)
23:35 dcook I don't suppose a gmcharlt, rangi, or khall_away would be around?
23:35 dcook Or anyone familiar with DBIC?
23:35 dcook Just trying to iterate through a list of results returned from a search
23:35 rangi yep
23:35 dcook \o/
23:36 dcook Or even if you can point me to some examples. The ones I found on the wiki weren't very helpful :/.
23:36 rangi my $row = $self->{rs}->next();
23:36 rangi have a look at
23:36 rangi http://git.catalyst.net.nz/gw?p=koha.git;a=blob;f=Koha/Biblio/Iterator.pm;h=fc150f433c1b68de7cada6bf22e77ffd02ef911f;hb=3e1705213116472b44fb1f0d618875db2538d34d
23:36 dcook I was thinking about doing it that way
23:36 dcook But then I noticed the thing about list context returning a list of result objects?
23:37 dcook Also thought about using the hashrefinflator?
23:37 * dcook takes a look at the link
23:42 dcook That %options bit looks neat
23:42 dcook Is that where you include the "items" option?
23:43 dcook Thanks for that, rangi. That's helpful :)
23:44 rangi *nod*
23:44 rangi cool
23:44 rangi thats what we use to index stuff for elasticsearch
23:44 dcook Yeah, I recall eythian mentioning it a while ago :)
23:45 dcook How's the ES stuff coming along?
23:45 rangi hows osdc going?
23:45 rangi pretty good
23:45 rangi http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=12478#c13
23:45 huginn 04Bug 12478: enhancement, P5 - low, ---, robin, NEW , Elasticsearch support for Koha
23:46 dcook I ended up cancelling my OSDC trip so I could be at home with the wife
23:46 dcook Disappointed to miss some of the sessions, but oh well
23:46 rangi ahhh
23:46 dcook Disappointed not to meet eythian in the flesh as well, but there's always next time :)
23:47 rangi yep, there will be others
23:47 dcook :)
23:58 dcook Interesting... it looks like if you use list context, it does return a list of objects and you can just iterate through those using foreach
23:58 dcook I wonder which is faster..