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