Blame t/17_createdrop.t

Packit 723767
#!/usr/bin/perl
Packit 723767
Packit 723767
# This is a skeleton test. For writing new tests, take this file
Packit 723767
# and modify/extend it.
Packit 723767
Packit 723767
use strict;
Packit 723767
BEGIN {
Packit 723767
	$|  = 1;
Packit 723767
	$^W = 1;
Packit 723767
}
Packit 723767
Packit 723767
use lib "t/lib";
Packit 723767
use SQLiteTest;
Packit 723767
use Test::More tests => 4;
Packit 723767
use Test::NoWarnings;
Packit 723767
Packit 723767
# Create a database
Packit 723767
my $dbh = connect_ok();
Packit 723767
Packit 723767
# Create a table
Packit 723767
ok( $dbh->do(<<'END_SQL'), 'CREATE TABLE' );
Packit 723767
CREATE TABLE one (
Packit 723767
    id INTEGER NOT NULL,
Packit 723767
    name CHAR (64) NOT NULL
Packit 723767
)
Packit 723767
END_SQL
Packit 723767
Packit 723767
# Drop the table
Packit 723767
ok( $dbh->do('DROP TABLE one'), 'DROP TABLE' );