lib,test: replace connection query() method with sync_exec{,_params}.
[mailshears.git] / 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);