mirror of
https://gitlab.com/davical-project/davical.git
synced 2026-04-30 16:00:25 +00:00
7c47658bee
This allows us to have more complex test files where an action is taken, then we test something, then another action is taken, etc. Changes to test files are required so that URL is defined after all the required settings are set. Changes to the result files are either whitespace changes due to above logic changes, or printing out a SQL Result header before each result. I figured it was useful.
149 lines
4.0 KiB
Plaintext
149 lines
4.0 KiB
Plaintext
SQL executed successfully.
|
|
UPDATE dav_principal
|
|
SET default_privileges = privilege_to_bits(ARRAY['schedule-deliver'])
|
|
WHERE dav_name = '/user1/'
|
|
|
|
HTTP/1.1 204 No Content
|
|
Date: Dow, 01 Jan 2000 00:00:00 GMT
|
|
DAV: 1, 2, 3, access-control, calendar-access, calendar-schedule
|
|
DAV: extended-mkcol, bind, addressbook, calendar-auto-schedule, calendar-proxy
|
|
|
|
|
|
SQL Query 1 Result:
|
|
caldav_type: >VEVENT<
|
|
dav_name: >/manager1/home/E1A13F04-iCal-schedule.ics<
|
|
logged_user: >20<
|
|
summary: >Meeting with User1<
|
|
user_no: >20<
|
|
vcalendar: >BEGIN:VCALENDAR
|
|
VERSION:2.0
|
|
PRODID:-//Apple Inc.//iCal 4.0.4//EN
|
|
CALSCALE:GREGORIAN
|
|
BEGIN:VTIMEZONE
|
|
TZID:Pacific/Auckland
|
|
BEGIN:DAYLIGHT
|
|
TZOFFSETFROM:+1200
|
|
RRULE:FREQ=YEARLY;BYMONTH=9;BYDAY=-1SU
|
|
DTSTART:20070930T020000
|
|
TZNAME:GMT+13:00
|
|
TZOFFSETTO:+1300
|
|
END:DAYLIGHT
|
|
BEGIN:STANDARD
|
|
TZOFFSETFROM:+1300
|
|
RRULE:FREQ=YEARLY;BYMONTH=4;BYDAY=1SU
|
|
DTSTART:20080406T030000
|
|
TZNAME:GMT+12:00
|
|
TZOFFSETTO:+1200
|
|
END:STANDARD
|
|
END:VTIMEZONE
|
|
BEGIN:VEVENT
|
|
CREATED:20111018T195845Z
|
|
UID:E1A13F04-iCal-schedule
|
|
DTEND;TZID=Pacific/Auckland:20111019T110000
|
|
ATTENDEE;CN=Manager 1;CUTYPE=INDIVIDUAL;PARTSTAT=ACCEPTED:
|
|
mailto:manager1@example.net
|
|
ATTENDEE;CN=user1@example.net;CUTYPE=INDIVIDUAL;EMAIL=user1@example.net;
|
|
PARTSTAT=NEEDS-ACTION;ROLE=REQ-PARTICIPANT;RSVP=TRUE;SCHEDULE-STATUS=1.2
|
|
:mailto:user1@example.net
|
|
TRANSP:OPAQUE
|
|
SUMMARY:Meeting with User1
|
|
DTSTART;TZID=Pacific/Auckland:20111019T100000
|
|
DTSTAMP:20111018T200107Z
|
|
ORGANIZER;CN=Manager 1:mailto:manager1@example.net
|
|
SEQUENCE:5
|
|
END:VEVENT
|
|
END:VCALENDAR
|
|
<
|
|
|
|
caldav_type: >VEVENT<
|
|
dav_name: >/user1/.in/E1A13F04-iCal-schedule.ics<
|
|
logged_user: >20<
|
|
summary: >Meeting with User1<
|
|
user_no: >10<
|
|
vcalendar: >BEGIN:VCALENDAR
|
|
VERSION:2.0
|
|
PRODID:-//Apple Inc.//iCal 4.0.4//EN
|
|
CALSCALE:GREGORIAN
|
|
METHOD:REQUEST
|
|
BEGIN:VTIMEZONE
|
|
TZID:Pacific/Auckland
|
|
BEGIN:DAYLIGHT
|
|
TZOFFSETFROM:+1200
|
|
RRULE:FREQ=YEARLY;BYMONTH=9;BYDAY=-1SU
|
|
DTSTART:20070930T020000
|
|
TZNAME:GMT+13:00
|
|
TZOFFSETTO:+1300
|
|
END:DAYLIGHT
|
|
BEGIN:STANDARD
|
|
TZOFFSETFROM:+1300
|
|
RRULE:FREQ=YEARLY;BYMONTH=4;BYDAY=1SU
|
|
DTSTART:20080406T030000
|
|
TZNAME:GMT+12:00
|
|
TZOFFSETTO:+1200
|
|
END:STANDARD
|
|
END:VTIMEZONE
|
|
BEGIN:VEVENT
|
|
CREATED:20111018T195845Z
|
|
UID:E1A13F04-iCal-schedule
|
|
TRANSP:OPAQUE
|
|
ORGANIZER;CN=Manager 1:mailto:manager1@example.net
|
|
DTSTAMP:20111018T200107Z
|
|
SEQUENCE:5
|
|
DTSTART;TZID=Pacific/Auckland:20111019T100000
|
|
DTEND;TZID=Pacific/Auckland:20111019T110000
|
|
SUMMARY:Meeting with User1
|
|
ATTENDEE;CN=Manager 1;CUTYPE=INDIVIDUAL;PARTSTAT=ACCEPTED:
|
|
mailto:manager1@example.net
|
|
ATTENDEE;CN=user1@example.net;CUTYPE=INDIVIDUAL;EMAIL=user1@example.net;
|
|
PARTSTAT=NEEDS-ACTION;ROLE=REQ-PARTICIPANT;RSVP=TRUE:mailto:user1@exampl
|
|
e.net
|
|
END:VEVENT
|
|
END:VCALENDAR
|
|
<
|
|
|
|
caldav_type: >VEVENT<
|
|
dav_name: >/user1/home/E1A13F04-iCal-schedule.ics<
|
|
logged_user: >20<
|
|
summary: >Meeting with User1<
|
|
user_no: >10<
|
|
vcalendar: >BEGIN:VCALENDAR
|
|
VERSION:2.0
|
|
PRODID:-//Apple Inc.//iCal 4.0.4//EN
|
|
CALSCALE:GREGORIAN
|
|
BEGIN:VTIMEZONE
|
|
TZID:Pacific/Auckland
|
|
BEGIN:DAYLIGHT
|
|
TZOFFSETFROM:+1200
|
|
RRULE:FREQ=YEARLY;BYMONTH=9;BYDAY=-1SU
|
|
DTSTART:20070930T020000
|
|
TZNAME:GMT+13:00
|
|
TZOFFSETTO:+1300
|
|
END:DAYLIGHT
|
|
BEGIN:STANDARD
|
|
TZOFFSETFROM:+1300
|
|
RRULE:FREQ=YEARLY;BYMONTH=4;BYDAY=1SU
|
|
DTSTART:20080406T030000
|
|
TZNAME:GMT+12:00
|
|
TZOFFSETTO:+1200
|
|
END:STANDARD
|
|
END:VTIMEZONE
|
|
BEGIN:VEVENT
|
|
CREATED:20111018T195845Z
|
|
UID:E1A13F04-iCal-schedule
|
|
TRANSP:OPAQUE
|
|
ORGANIZER;CN=Manager 1:mailto:manager1@example.net
|
|
DTSTAMP:20111018T200107Z
|
|
SEQUENCE:5
|
|
DTSTART;TZID=Pacific/Auckland:20111019T100000
|
|
DTEND;TZID=Pacific/Auckland:20111019T110000
|
|
SUMMARY:Meeting with User1
|
|
ATTENDEE;CN=Manager 1;CUTYPE=INDIVIDUAL;PARTSTAT=ACCEPTED:
|
|
mailto:manager1@example.net
|
|
ATTENDEE;CN=user1@example.net;CUTYPE=INDIVIDUAL;EMAIL=user1@example.net;
|
|
PARTSTAT=NEEDS-ACTION;ROLE=REQ-PARTICIPANT;RSVP=TRUE:mailto:user1@exampl
|
|
e.net
|
|
END:VEVENT
|
|
END:VCALENDAR
|
|
<
|
|
|