--- lib/LDAP/Koha.pm 2009/04/29 09:03:47 50 +++ lib/LDAP/Koha.pm 2010/02/18 16:22:32 62 @@ -15,6 +15,8 @@ use Data::Dump qw/dump/; +my $debug = 0; # XXX very slow + # XXX test with: # # ldapsearch -h localhost -p 2389 -b dc=ffzg,dc=hr -x 'otherPager=200903160021' @@ -25,9 +27,10 @@ our $user = 'unconfigured-user'; our $passwd = 'unconfigured-password'; -our $max_results = 3000; # FIXME must be enough for all users +our $max_results = $ENV{MAX_RESULTS} || 3000; # FIXME must be enough for all users +our $objectclass_default = 'hrEduPerson'; -our $objectclass = 'HrEduPerson'; +our $objectclass; $SIG{__DIE__} = sub { warn "!!! DIE ", @_; @@ -45,7 +48,7 @@ 'objectGUID' => 'borrowernumber', 'displayName' => 'surname', 'sn' => 'surname', - 'pager' => 'rfid_sid', + 'pager' => 'a.attribute', # was: rfid_sid }; sub __sql_column { @@ -119,23 +122,23 @@ sub _dn_attributes { my ($row,$base) = @_; - warn "## row = ",dump( $row ); + warn "## row = ",dump( $row ) if $debug; die "no objectClass column in ",dump( $row ) unless defined $row->{objectClass}; $row->{objectClass} = [ split(/\s+/, $row->{objectClass}) ] if $row->{objectClass} =~ m{\n}; - warn "## row = ",dump( $row ); + warn "## row = ",dump( $row ) if $debug; my $dn = delete( $row->{dn} ) || die "no dn in ",dump( $row ); # this does some sanity cleanup for our data - my $base_as_domain = $base; - $base_as_domain =~ s{dn=}{.}; - $base_as_domain =~ s{^\.}{@}; - $dn =~ s{$base_as_domain$}{}; - - $dn .= ',' . $base unless $dn =~ m{,}; # add base if none present +# my $base_as_domain = $base; +# $base_as_domain =~ s{dn=}{.}; +# $base_as_domain =~ s{^\.}{@}; +# $dn =~ s{$base_as_domain$}{}; +# +# $dn .= ',' . $base unless $dn =~ m{,}; # add base if none present return ($dn, $row); } @@ -156,6 +159,7 @@ my $sql_where = ''; @values = (); + $objectclass = ''; foreach my $filter ( keys %{ $reqData->{'filter'} } ) { @@ -185,6 +189,8 @@ } + $objectclass ||= $objectclass_default; + my $sql_select = read_file( lc "sql/$objectclass.sql" ); if ( $sql_where ) { if ( $sql_select !~ m{where}i ) { @@ -195,8 +201,14 @@ } - warn "# SQL:\n$sql_select\n", $sql_where ? $sql_where : '-- no where', "\n# DATA: ",dump( @values ); - my $sth = $dbh->prepare( $sql_select . $sql_where . " LIMIT $max_results" ); # XXX remove limit? + my $sql + = $sql_select + . $sql_where +# . ( $objectclass =~ m{person}i ? " LIMIT $max_results" : '' ) # add limit just for persons + ; + + warn "# SQL:\n$sql\n# DATA: ",dump( @values ); + my $sth = $dbh->prepare( $sql ); $sth->execute( @values ); warn "# ", $sth->rows, " results for ",dump( $reqData->{'filter'} ); @@ -219,6 +231,8 @@ undef $entry; } + $dn =~ s{@[^,]+}{}; + $entry = Net::LDAP::Entry->new; $entry->dn( $dn ); @@ -237,8 +251,10 @@ } - warn "### last entry ",$entry->dump( \*STDERR ); - push @entries, $entry; + if ( $entry ) { + warn "### last entry ",$entry->dump( \*STDERR ); + push @entries, $entry; + } } else { warn "UNKNOWN request: ",dump( $reqData );