/[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 201 by dpavlin, Sat Jan 17 14:00:26 2004 UTC revision 225 by dpavlin, Tue Feb 10 10:20:50 2004 UTC
# Line 44  sub new { Line 44  sub new {
44          my $user = shift || die "need dbi_user= in [global] section of configuration file";          my $user = shift || die "need dbi_user= in [global] section of configuration file";
45          my $passwd = shift || die "need dbi_passwd= in [global] section of configuration file";          my $passwd = shift || die "need dbi_passwd= in [global] section of configuration file";
46    
47            $self->{dbd} = $dbd;
48    
49          $self->{dbh} = DBI->connect("DBI:$dbd:$dsn",$user,$passwd) || die $DBI::errstr;          $self->{dbh} = DBI->connect("DBI:$dbd:$dsn",$user,$passwd) || die $DBI::errstr;
50          $Count++;          $Count++;
51    
# Line 64  sub delete_and_create { Line 66  sub delete_and_create {
66  # FIX: this is not a good way to check if table exists!  # FIX: this is not a good way to check if table exists!
67          if ($sth->execute() && $sth->fetchrow_hashref) {          if ($sth->execute() && $sth->fetchrow_hashref) {
68                  my $sql = "drop table $field";                  my $sql = "drop table $field";
69                  my $sth = $self->{dbh}->do($sql) || die "SQL: $sql ".$self->{dbh}->errstr();                  my $sth = $self->{dbh}->do($sql) || warn "SQL: $sql - ".$sth->errstr();
70          }          }
71          $sql = "create table $field (          $sql = "create table $field (
72                          item varchar(255),                          item varchar(255),
# Line 193  sub close { Line 195  sub close {
195    
196                  $self->{dbh}->begin_work || die $self->{dbh}->errstr();                  $self->{dbh}->begin_work || die $self->{dbh}->errstr();
197    
198                  $self->bench("Sorting ".$Table{$table}." items in $table");                  $self->bench("Sorting ".$Table{$table}." (with duplicates) items in $table");
199                  my @keys = sort keys %{$c_table->{$table}};                  my @keys = sort keys %{$c_table->{$table}};
200    
201                  $self->bench("Dumping data into $table");                  $self->bench("Dumping ".($#keys+1)." items into $table");
202                  my $sql = "insert into $table (ord,item,display,count) values (?,?,?,?)";                  my $sql = "insert into $table (ord,item,display,count) values (?,?,?,?)";
203                  my $sth = $self->{dbh}->prepare($sql) || die "sql: $sql; ".$self->{dbh}->errstr();                  my $sth = $self->{dbh}->prepare($sql) || die "sql: $sql; ".$self->{dbh}->errstr();
204    
# Line 211  sub close { Line 213  sub close {
213    
214                  $self->{dbh}->commit || die $self->{dbh}->errstr();                  $self->{dbh}->commit || die $self->{dbh}->errstr();
215          }          }
216    
217            if ($self->{dbd} =~ m/(Pg|SQLite)/) {
218                    $self->{dbh}->do(qq{vacuum}) || warn "vacumming failed. It shouldn't if you are using PostgreSQL or SQLite: ".$self->{dbh}->errstr();
219            }
220    
221          $self->bench("disconnecting from database");          $self->bench("disconnecting from database");
222    
223          $self->{dbh}->disconnect;          $self->{dbh}->disconnect;
Legend:
Removed from v.201  
changed lines
  Added in v.225
  ViewVC Help
Powered by ViewVC 1.1.26