/[webpac]/trunk/index_DBI_cache.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 /trunk/index_DBI_cache.pm

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

revision 219 by dpavlin, Thu Feb 5 10:56:55 2004 UTC revision 623 by dpavlin, Sat Jan 1 19:09:53 2005 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 62  sub delete_and_create { Line 69  sub delete_and_create {
69  #print "#### delete_and_create($field)\n";  #print "#### delete_and_create($field)\n";
70    
71          my $sql = "select count(*) from $field";          my $sql = "select count(*) from $field";
72          my $sth = $self->{dbh}->prepare($sql) || die $self->{dbh}->errstr();          my $sth = $self->{dbh}->prepare($sql);
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 && $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 95  sub insert { Line 102  sub insert {
102    
103          #$sth_cache{$field."select"}->execute($index_data) || die "cache: $field select; ".$self->{dbh}->errstr();          #$sth_cache{$field."select"}->execute($index_data) || die "cache: $field select; ".$self->{dbh}->errstr();
104    
         # XXX for some strange reason, it seems that some entries in my  
         # database produce strings which start with null byte. I suspect  
         # this to be bug in OpenIsis 0.9.0.  
         # This should fix it..  
         $index_data =~ s/^[^\w]+//;  
         $index_data = substr($index_data,0,255);  
   
105          my $uc = uc($index_data);          my $uc = uc($index_data);
106          if (! $c_table->{$field}->{$uc}) {          if (! $c_table->{$field}->{$uc}) {
107  #print stderr "in index: $index_data\n";  #print stderr "in index: $index_data\n";
Legend:
Removed from v.219  
changed lines
  Added in v.623
  ViewVC Help
Powered by ViewVC 1.1.26