/[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 226 by dpavlin, Wed Feb 11 08:33:51 2004 UTC revision 399 by dpavlin, Fri Aug 27 17:21:00 2004 UTC
# Line 69  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) || warn "SQL: $sql - ".$sth->errstr();                  my $sth = $self->{dbh}->do($sql) || warn "SQL: $sql - ".$sth->errstr();
77          }          }

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

  ViewVC Help
Powered by ViewVC 1.1.26