/[webpac]/trunk2/lib/WebPAC/Index.pm
This is repository of my old source code which isn't updated any more. Go to git.rot13.org for current projects!
ViewVC logotype

Diff of /trunk2/lib/WebPAC/Index.pm

Parent Directory Parent Directory | Revision Log Revision Log | View Patch Patch

revision 206 by dpavlin, Sat Jan 31 20:57:48 2004 UTC revision 226 by dpavlin, Wed Feb 11 08:33:51 2004 UTC
# Line 51  sub new { Line 51  sub new {
51    
52          $self->bench("connected to $dbd as $user");          $self->bench("connected to $dbd as $user");
53    
54            # force SQLite to support binary 0 in data (which shouldn't
55            # happend, but it did to me)
56            eval {
57                    no warnings 'all';
58                    $self->{dbh}->{sqlite_handle_binary_nulls} = 1;
59            };
60    
61          return $self;          return $self;
62  }  }
63    
# Line 66  sub delete_and_create { Line 73  sub delete_and_create {
73  # FIX: this is not a good way to check if table exists!  # FIX: this is not a good way to check if table exists!
74          if ($sth->execute() && $sth->fetchrow_hashref) {          if ($sth->execute() && $sth->fetchrow_hashref) {
75                  my $sql = "drop table $field";                  my $sql = "drop table $field";
76                  my $sth = $self->{dbh}->do($sql) || die "SQL: $sql ".$self->{dbh}->errstr();                  my $sth = $self->{dbh}->do($sql) || warn "SQL: $sql - ".$sth->errstr();
77          }          }
78          $sql = "create table $field (          $sql = "create table $field (
79                          item varchar(255),                          item varchar(255),
# Line 195  sub close { Line 202  sub close {
202    
203                  $self->{dbh}->begin_work || die $self->{dbh}->errstr();                  $self->{dbh}->begin_work || die $self->{dbh}->errstr();
204    
205                  $self->bench("Sorting ".$Table{$table}." items in $table");                  $self->bench("Sorting ".$Table{$table}." (with duplicates) items in $table");
206                  my @keys = sort keys %{$c_table->{$table}};                  my @keys = sort keys %{$c_table->{$table}};
207    
208                  $self->bench("Dumping data into $table");                  $self->bench("Dumping ".($#keys+1)." items into $table");
209                  my $sql = "insert into $table (ord,item,display,count) values (?,?,?,?)";                  my $sql = "insert into $table (ord,item,display,count) values (?,?,?,?)";
210                  my $sth = $self->{dbh}->prepare($sql) || die "sql: $sql; ".$self->{dbh}->errstr();                  my $sth = $self->{dbh}->prepare($sql) || die "sql: $sql; ".$self->{dbh}->errstr();
211    

Legend:
Removed from v.206  
changed lines
  Added in v.226

  ViewVC Help
Powered by ViewVC 1.1.26