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 49bed6ac6a584cda93fd5ab2d636948b8c09a21d..535f02333c23d70aad20198519a23393a5440bd7 100644 (file)
--- a/test/sql/agendav-fixtures.sql
+++ b/test/sql/agendav-fixtures.sql
@@ -1,17 +1,34 @@
 /* Add an AgenDAV record for one user only. */
 INSERT INTO prefs (username, options) VALUES ('adam@example.net', 'herp');
-INSERT INTO shares (owner, calendar, with, options, rw)
+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:{}',
-         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)
+INSERT INTO shares (owner, calendar, "with", options, rw)
   VALUES ('/caldav.php/booger%40example.com/',
-          '/carol%40example.net/',
          '/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:{}',
-         1);
+         true);