Add some fixture code.

[mailshears.git] / test / sql / postfixadmin-fixtures.sql

diff --git a/test/sql/postfixadmin-fixtures.sql b/test/sql/postfixadmin-fixtures.sql
new file mode 100644 (file)
index 0000000..2ca6d59
--- /dev/null
+++ b/test/sql/postfixadmin-fixtures.sql
@@ -0,0 +1,44 @@
+/* This is a magic record, always included as the first row of the
+ * domain table.
+ */
+INSERT INTO domain (domain) VALUES ('ALL');
+
+/* Create two domains, example.com, and example.net. */
+INSERT INTO domain (domain) VALUES ('example.com');
+INSERT INTO domain (domain) VALUES ('example.net');
+
+/*
+ * Now create their mailboxes, two in one domain, and three in the
+ * other.
+ */
+INSERT INTO mailbox (username, domain, local_part)
+             VALUES ('alice@example.com', 'example.com', 'alice');
+INSERT INTO mailbox (username, domain, local_part)
+             VALUES ('bob@example.com', 'example.com', 'bob');
+
+INSERT INTO mailbox (username, domain, local_part)
+  VALUES ('adam@example.net', 'example.net', 'adam');
+INSERT INTO mailbox (username, domain, local_part)
+  VALUES ('beth@example.net', 'example.net', 'beth');
+INSERT INTO mailbox (username, domain, local_part)
+  VALUES ('carol@example.net', 'example.net', 'carol');
+
+/* Each mailbox has an alias pointing to (at least) itself. */
+INSERT INTO alias (address, goto, domain)
+  VALUES ('alice@example.com', 'alice@example.com', 'example.com');
+INSERT INTO alias (address, goto, domain)
+  VALUES ('bob@example.com', 'bob@example.com', 'example.com');
+
+INSERT INTO alias (address, goto, domain)
+  VALUES ('adam@example.net', 'adam@example.net', 'example.net');
+INSERT INTO alias (address, goto, domain)
+  VALUES ('beth@example.net', 'beth@example.net', 'example.net');
+INSERT INTO alias (address, goto, domain)
+  VALUES ('carol@example.net', 'carol@example.net', 'example.net');
+
+/* Create a domain admin for both example.com and example.net. */
+INSERT INTO domain_admins (username, domain)
+  VALUES ('admin@example.com', 'example.com');
+INSERT INTO domain_admins (username, domain)
+  VALUES ('admin@example.com', 'example.net');
+