mirror of
https://gitlab.com/davical-project/davical.git
synced 2026-04-13 13:10:13 +00:00
68 lines
1.9 KiB
Plaintext
68 lines
1.9 KiB
Plaintext
#
|
|
# Testing for iCal accepting an invitation
|
|
#
|
|
TYPE=PUT
|
|
URL=http://regression.host/user1/home/E1A13F04-iCal-schedule.ics
|
|
|
|
HEADER=User-Agent: DAVKit/4.0.3 (732.2); CalendarStore/4.0.4 (997.7); iCal/4.0.4 (1395.7); Mac OS X/10.6.8 (10K549)
|
|
HEADER=If-Match: "46e5c5b3530da1b0d6fd8a08bb38a3b3"
|
|
HEADER=Content-Type: text/calendar
|
|
|
|
# REPLACE=#<creationdate>\d{8}T\d{6}</creationdate>#<creationdate>YYYYMMDDThhmmss</creationdate>#
|
|
# REPLACE=/^DTSTAMP:\d{4}[01]\d[0123]\dT[012]\d[0-5]\d[0-6]\dZ\r?$/DTSTAMP:yyyymmddThhmmssZ/
|
|
|
|
# QUERY
|
|
# ENDQUERY
|
|
|
|
BEGINDATA
|
|
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:manag
|
|
er1@example.net
|
|
ATTENDEE;CN="user1@example.net";CUTYPE=INDIVIDUAL;EMAIL="user1@example.n
|
|
et";PARTSTAT=ACCEPTED;ROLE=REQ-PARTICIPANT: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
|
|
ENDDATA
|
|
|
|
|
|
QUERY
|
|
SELECT caldav_data.user_no, caldav_data.dav_name,
|
|
caldav_type, logged_user,
|
|
regexp_replace(caldav_data,'DTSTAMP:[0-9T]{15}Z','DTSTAMP:looks good') AS vcalendar,
|
|
summary
|
|
FROM caldav_data JOIN calendar_item USING(dav_name) LEFT JOIN timezones ON (tz_id=tzid)
|
|
WHERE calendar_item.uid = 'E1A13F04-iCal-schedule'
|
|
ORDER BY caldav_data.dav_id
|
|
ENDQUERY
|
|
|