Commit | Line | Data |
ad93b3e9 |
1 | package TestApp::Model::TestApp; |
2 | |
3 | use base qw/Catalyst::Model::DBIC::Schema/; |
4 | use strict; |
5 | |
3581e90f |
6 | my @deployment_statements = split /;/, q{ |
7 | CREATE TABLE user ( |
8 | id INTEGER PRIMARY KEY, |
9 | username TEXT, |
10 | email TEXT, |
11 | password TEXT, |
12 | status TEXT, |
13 | role_text TEXT, |
14 | session_data TEXT |
15 | ); |
16 | CREATE TABLE role ( |
17 | id INTEGER PRIMARY KEY, |
18 | role TEXT |
19 | ); |
20 | CREATE TABLE user_role ( |
21 | id INTEGER PRIMARY KEY, |
22 | user INTEGER, |
23 | roleid INTEGER |
24 | ); |
25 | |
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); |
b3c995e9 |
30 | INSERT INTO user VALUES (5, 'mark', 'b@con.com', 'secret', 'active', NULL, NULL); |
31 | INSERT INTO user VALUES (6, 'graeme', 'gr@e.me', 'supersecret', 'active', 'superadmin', NULL); |
3581e90f |
32 | INSERT INTO role VALUES (1, 'admin'); |
33 | INSERT INTO role VALUES (2, 'user'); |
b3c995e9 |
34 | INSERT INTO role VALUES (3, 'superadmin'); |
3581e90f |
35 | INSERT INTO user_role VALUES (1, 3, 1); |
36 | INSERT INTO user_role VALUES (2, 3, 2); |
b3c995e9 |
37 | INSERT INTO user_role VALUES (3, 4, 2); |
38 | INSERT INTO user_role VALUES (4, 5, 3) |
3581e90f |
39 | }; |
ad93b3e9 |
40 | |
41 | __PACKAGE__->config( |
42 | schema_class => 'TestApp::Schema', |
3581e90f |
43 | connect_info => [ |
44 | "dbi:SQLite:dbname=:memory:", |
45 | '', |
46 | '', |
47 | { AutoCommit => 1 }, |
48 | { on_connect_do => \@deployment_statements }, |
49 | ], |
ad93b3e9 |
50 | ); |
51 | |
52 | # Load all of the classes |
53 | #__PACKAGE__->load_classes(qw/Role User UserRole/); |
54 | |
55 | |
56 | 1; |