test/sql/agendav-fixtures.sql

   1 /* Add an AgenDAV record for one user only. */
   2 INSERT INTO prefs (username, options) VALUES ('adam@example.net', 'herp');
   3 INSERT INTO shares (owner, calendar, "with", options, rw)
   4   VALUES ('/caldav.php/adam%40example.net/',
   5           '/caldav.php/adam%40example.net/calendar-default',
   6           '/beth%40example.net/',
   7           'a:0:{}',
   8           false);
   9
  10 /* Just kidding, here's another one! */
  11 INSERT INTO prefs (username, options) VALUES ('booger@example.com', 'herp');
  12 INSERT INTO shares (owner, calendar, "with", options, rw)
  13   VALUES ('/caldav.php/booger%40example.com/',
  14           '/caldav.php/booger%40example.com/calendar-default',
  15           '/carol%40example.net/',
  16           'a:0:{}',
  17           true);
  18
  19 /* These two are missing a prefs entry to test the removal of "shares"
  20  * entries in that situation.
  21 */
  22 INSERT INTO shares (owner, calendar, "with", options, rw)
  23   VALUES ('/caldav.php/stinky%40example.com/',
  24           '/caldav.php/stinky%40example.com/calendar-default',
  25           '/herp%40example.net/',
  26           'a:0:{}',
  27           true);
  28
  29 INSERT INTO shares (owner, calendar, "with", options, rw)
  30   VALUES ('/caldav.php/goober%40example.com/',
  31           '/caldav.php/goober%40example.com/calendar-default',
  32           '/derp%40example.net/',
  33           'a:0:{}',
  34           true);