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 |
} |
} |