Add a test to ensure that "nonexistent" AgenDAV users' shares are removed.

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

diff --git a/test/sql/agendav-fixtures.sql b/test/sql/agendav-fixtures.sql
index 76cdba18ac79add7b19071a8875e96b11dc4f36f..535f02333c23d70aad20198519a23393a5440bd7 100644 (file)
--- a/test/sql/agendav-fixtures.sql
+++ b/test/sql/agendav-fixtures.sql
@@ -1,4 +1,34 @@
 /* Add an AgenDAV record for one user only. */
 INSERT INTO prefs (username, options) VALUES ('adam@example.net', 'herp');
-INSERT INTO shared (user_from, user_which, calendar)
-  VALUES ('adam@example.net', 'beth@example.net', 'derp');
+INSERT INTO shares (owner, calendar, "with", options, rw)
+  VALUES ('/caldav.php/adam%40example.net/',
+          '/caldav.php/adam%40example.net/calendar-default',
+          '/beth%40example.net/',
+         'a:0:{}',
+         false);
+
+/* Just kidding, here's another one! */
+INSERT INTO prefs (username, options) VALUES ('booger@example.com', 'herp');
+INSERT INTO shares (owner, calendar, "with", options, rw)
+  VALUES ('/caldav.php/booger%40example.com/',
+         '/caldav.php/booger%40example.com/calendar-default',
+          '/carol%40example.net/',
+         'a:0:{}',
+         true);
+
+/* These two are missing a prefs entry to test the removal of "shares"
+ * entries in that situation.
+*/
+INSERT INTO shares (owner, calendar, "with", options, rw)
+  VALUES ('/caldav.php/stinky%40example.com/',
+         '/caldav.php/stinky%40example.com/calendar-default',
+          '/herp%40example.net/',
+         'a:0:{}',
+         true);
+
+INSERT INTO shares (owner, calendar, "with", options, rw)
+  VALUES ('/caldav.php/goober%40example.com/',
+         '/caldav.php/goober%40example.com/calendar-default',
+          '/derp%40example.net/',
+         'a:0:{}',
+         true);