October 2007 - Koha-devel - lists.koha-community.org

04 Oct '07

Hello! My name is Georgia Katsarou and I'm a librarian from Greece. It's almost 8 months since we started using Koha in our library. I've started translating it in Greek and I also want to write a User Guide in Greek. Cheers!

1 0

Set/View User Permissions
by Owen Leonard 02 Oct '07

02 Oct '07

Should a user without "set permissions" privileges be able to view /members/member-flags.pl? Should they be able to view a patron's privileges without being able to set them? Or should the page be blocked altogether? -- Owen

1 0

Koha Day - CGI::Carp error handling
by Mason James 02 Oct '07

02 Oct '07

Hi Koha-Devel, There has been a little talk recently on the koha-devel list about error handling in Koha. Chris and I spent some time on Friday(nz time) to work out a relatively small and tidy way, using CGI::Carp, to trap and redirect most runtime errors in Koha to the user's browser. We have made a System-Preference called DebugLevel, that has currently 3 values 0, 1 and 2. (more?) something like... ??? 0 is Quiet - For production 1 is Developer - For debugging 2 is Logging - Bug reporting , and additional package version info too, like Apache, MySQL, Perl,YAZ, Z9350::ZOOM MARC::Record/Charset.... The CGI::Carp stuff has been added near the start of Output.pm, so it's set up nice and early to handle (and output) any later errors. I committed the CGI::Carp stuff to dev_week, but if people like the idea, I'll commit it to rel_3 too... Here is the commit to Output.pm below. http://cvs.savannah.nongnu.org/viewvc/koha/C4/Output.pm? root=koha&r1=1.51.2.2.2.1&r2=1.51.2.2.2.2&pathrev=dev_week Using CGI::Carp with the DebugLevel syspref at '2', Koha now handles this example script's syntax error. ---------------------------------- #!/usr/bin/perl use C4::Output; ndjsnsjkcndjkscndjskcndjks exit; ------------------------------------ And sends Perl's error message back to he user's browser for either debugging further, or perhaps attaching to a bug report, or to the bottom of a koha-devel list email. Like this below.... ---------------------------------- debug level 2 Got an error: syntax error at /koha/dev_week/intranet/cgi-bin/misc/ carp_test.pl line 6, near "ndjsnsjkcndjkscndjskcndjks exit" Execution of /koha/dev_week/intranet/cgi-bin/misc/carp_test.pl aborted due to compilation errors. Koha 2.2.8 Perl 5.008008 MySQL mysql Ver 14.12 Distrib 5.0.32, for pc-linux-gnu (i486) using readline 5.2 OS Linux arwen.metavore.com 2.6.18-4-686 #1 SMP Mon Mar 26 17:17:36 UTC 2007 i686 GNU/Linux Apache Server version: Apache/2.2.3 Server built: Jun 17 2007 20:24:06 ---------------------------------- How does this sound, Any improvements suggestions or corrections? Cheers, Mason -- Mason James mason.james(a)liblime.com Programmer www.liblime.com LibLime +64 21 542 117

3 5

need for non-SQL in updater : got it !!!
by Paul POULAIN 01 Oct '07

01 Oct '07

Kados & slef, Slef asked me "could you give me an example of something that can't be ruled only by SQL during update". I answered I had found one, but could not remember it. I have got it now ! When dealing with something that depends on language and/or MARC flavour. For example, I want to add a systempref for Reserve behaviour (to fix http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=1416) If langage is french, i'll add something, otherwise i'll add something else. I add it now, but i'm afraid I won't have time to commit before the end of the day (need to merge to official branch, fix errors and send patch) -- Paul POULAIN et Henri Damien LAURENT Consultants indépendants en logiciels libres et bibliothéconomie (http://www.koha-fr.org) Tel : 04 91 31 45 19

2 1

OO-RDB mapper
by Rick Welykochy 01 Oct '07

01 Oct '07

Have the Koha developers given any thought to recoding the raw DBI calls in Koha with an OO-RDB mapper? There are a number of them available on CPAN. I've written these things, at varying levels of complexity and completeness, in the past and the advantages are numerous: (*) separate the Perl code from the SQL (*) rows in tables are represented by objects so no more errors like this: $row->{naem} -- instead: $row->name (*) the abstraction layer of an OO-RDB mapper can provide 99% database driver independence; Koha could suddenly be supported by MYSQL, Postgresql, oracle, sqlite, etc.etc. (*) the abstraction layer allows application-level hooks to be installed *anywhere* in the RDB transcation process and total global control of RBD operations is suddenly available (instead of scanning/editing 1000's of lines of source code to make a basic functional RDB change) (*) audit logging can be automated; all insert, updates and deletes can be caught in the abstraction layer -- do what you want with them (*) updating a row in a table becomes foolproof: $row = OORDB->fetch(criteria); $row->name("new name'); $row->debt(undef); $row->commit; The list of advantages does go on and on. cheers rickw -- _________________________________ Rick Welykochy || Praxis Services Q: What's the difference between a software sales person and a car sales person? A: With a car sales person there is a slight chance that he actually knows how to drive.

2 1