Some SQL testing scripts.

2 files changed, 72 insertions, 0 deletions

diff --git a/test/kill.sql b/test/kill.sql
new file mode 100644
index 00000000..66e3733f
--- /dev/null
+++ b/test/kill.sql
@@ -0,0 +1,10 @@
+--
+-- Clean up the DB
+--
+
+delete from users;
+delete from tenants;
+delete from groups;
+delete from user_group_association;
+delete from user_tenant_association;
+delete from token;
diff --git a/test/test_setup.sql b/test/test_setup.sql
new file mode 100644
index 00000000..882c3e14
--- /dev/null
+++ b/test/test_setup.sql
@@ -0,0 +1,62 @@
+--
+--  Test Setup
+--
+
+-- Users
+
+insert into users (id, password, email, enabled) values
+       ("joeuser", "secrete", "joe@rackspace.com", 1);
+
+insert into users (id, password, email, enabled) values
+       ("admin", "secrete", "admin@rackspace.com", 1);
+
+insert into users (id, password, email, enabled) values
+       ("disabled", "secrete", "disable@rackspace.com", 0);
+
+-- Tenants
+
+insert into tenants (id, "desc", enabled) values
+       ("1234", "This is a tenant", 1);
+
+insert into tenants (id, "desc", enabled) values
+       ("0000", "This one is disabled", 0);
+
+-- Groups
+
+insert into groups (id, "desc", tenant_id) values
+       ("Admin", "Andmin users", "1234");
+
+insert into groups (id, "desc", tenant_id) values
+       ("Default", "Standard users", "1234");
+
+
+-- User Group Associations
+
+insert into user_group_association values
+       ("joeuser", "Default");
+
+insert into user_group_association values
+       ("disabled", "Default");
+
+insert into user_group_association values
+       ("admin", "Admin");
+
+-- User Tenant Associations
+
+insert into user_tenant_association values
+       ("joeuser", "1234");
+
+insert into user_tenant_association values
+       ("disabled", "1234");
+
+insert into user_tenant_association values
+       ("admin", "1234");
+
+-- Token
+
+insert into token values
+       ("887665443383838", "joeuser", "1234", datetime("2012-02-05T00:00"));
+
+insert into token values
+       ("999888777666", "admin", "1234", datetime("2015-02-05T00:00"));
+