2 my $db_file = $ENV{TESTAPP_DB_FILE};
3 unlink $db_file if -e $db_file;
5 my $dbh = DBI->connect( "dbi:SQLite:$db_file" ) or die $DBI::errstr;
8 id INTEGER PRIMARY KEY,
17 id INTEGER PRIMARY KEY,
20 CREATE TABLE user_role (
21 id INTEGER PRIMARY KEY,
26 INSERT INTO user VALUES (1, 'joeuser', 'joeuser@nowhere.com', 'hackme', 'active', 'admin', NULL);
27 INSERT INTO user VALUES (2, 'spammer', 'bob@spamhaus.com', 'broken', 'disabled', NULL, NULL);
28 INSERT INTO user VALUES (3, 'jayk', 'j@cpants.org', 'letmein', 'active', NULL, NULL);
29 INSERT INTO user VALUES (4, 'nuffin', 'nada@mucho.net', 'much', 'registered', 'user admin', NULL);
30 INSERT INTO role VALUES (1, 'admin');
31 INSERT INTO role VALUES (2, 'user');
32 INSERT INTO user_role VALUES (1, 3, 1);
33 INSERT INTO user_role VALUES (2, 3, 2);
34 INSERT INTO user_role VALUES (3, 4, 2)
36 $dbh->do( $_ ) for split /;/, $sql;