File: SetupDB.pm

package info (click to toggle)
libcatalyst-plugin-session-store-dbic-perl 0.14-4
  • links: PTS, VCS
  • area: main
  • in suites: bookworm, forky, sid, trixie
  • size: 136 kB
  • sloc: perl: 309; makefile: 2
file content (21 lines) | stat: -rw-r--r-- 391 bytes parent folder | download | duplicates (3) 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
 
package SetupDB;

use strict;
use warnings;

# Create the database
my $db_file = $TestApp::DB_FILE;
unlink $db_file if -e $db_file;

my $dbh = DBI->connect("dbi:SQLite:$db_file") or die $DBI::errstr;
my $sql = q{
    CREATE TABLE sessions (
        id      CHAR(72) PRIMARY KEY,
        data    TEXT,
        expires INTEGER
    );
};
$dbh->do($_) for split /;/, $sql;
$dbh->disconnect;

1;