5 use Data::Dump qw/dump/;
6 use Algorithm::CheckDigits;
13 my $c = DBI->connect("dbi:CSV:","","", { RaiseError => 1, f_ext => '.csv', f_encoding => 'utf-8' }) || die $dbi::errstr;
14 my $k = DBI->connect("dbi:mysql:database=koha_fer","","", { RaiseError => 1, AutoCommit => 0, mysql_enable_utf8 => 1 }) || die $DBI::errstr;
16 my $s = $c->prepare(qq{
17 select * from brucosi_2011_ISVU
21 my $user_exists = $k->prepare(qq{
22 select * from borrowers where cardnumber = ?
25 my $insert_user = $k->prepare(qq{
27 (cardnumber, categorycode, userid, firstname, surname, branchcode, email, dateexpiry)
29 (?,'S',?,?,?,'SRE',?,'2021-12-13')
32 while( my $row = $s->fetchrow_hashref ) {
34 warn "# row = ",dump($row),$/;
36 my $user = $f->getinfobycode( $row->{jmbag} );
38 warn "# user = ", dump($user), $/;
40 $user_exists->execute( 'S' . $row->{jmbag} );
42 if ( $user_exists->rows ) {
43 warn "EXISTS: ",dump($row);
46 $insert_user->execute( 'S' . $row->{jmbag}, $user->{nick}, $user->{first_name}, $user->{last_name}, $user->{email} );