SQLite Create Table

[kardon33]

What i need to do is create a table and add the columns but if it already exists i do not want to create it because i get errors because there is already that table. How would i like check if the table already exists?

my code so far looks like this.

use DBI;
 
my $dbh = DBI->connect( "dbi:SQLite:../data/db/lightmon.db" ) || die "Cannot connect: $DBI::errstr";
   $dbh->do( "CREATE TABLE 'Node$node' ( id, notify_date, msg_id, msg, notes )" );

[miller]

Something like the following can help. Just note that it is subject to a race condition, so the easier route would probably be to just capture the failed sql query.

# Determine if table exists
sub isTable {
    my $tableName = shift;
 
    my %tables = ();
 
    my $name;
    my $sth = $dbh->prepare(q{SHOW TABLES});
    $sth->execute or die $dbh->errstr;
    $sth->bind_columns(\$name);
    while ($sth->fetch) {
        $tables{$name} = 1 
    }
    $sth->finish; undef $sth;
 
    return $tables{$tableName};
}
 

- Miller