2 # Testing for iCal accepting an invitation
5 URL=http://regression.host/user1/home/E1A13F04-iCal-schedule.ics
7 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)
8 HEADER=If-Match: "905cdcc0d1a76ef63ef8d238575c3856"
9 HEADER=Content-Type: text/calendar
11 # REPLACE=#<creationdate>\d{8}T\d{6}</creationdate>#<creationdate>YYYYMMDDThhmmss</creationdate>#
12 # REPLACE=/^DTSTAMP:\d{4}[01]\d[0123]\dT[012]\d[0-5]\d[0-6]\dZ\r?$/DTSTAMP:yyyymmddThhmmssZ/
20 PRODID:-//Apple Inc.//iCal 4.0.4//EN
26 RRULE:FREQ=YEARLY;BYMONTH=9;BYDAY=-1SU
27 DTSTART:20070930T020000
33 RRULE:FREQ=YEARLY;BYMONTH=4;BYDAY=1SU
34 DTSTART:20080406T030000
40 CREATED:20111018T195845Z
41 UID:E1A13F04-iCal-schedule
42 DTEND;TZID=Pacific/Auckland:20111019T110000
43 ATTENDEE;CN="Manager 1";CUTYPE=INDIVIDUAL;PARTSTAT=ACCEPTED:mailto:manag
45 ATTENDEE;CN="user1@example.net";CUTYPE=INDIVIDUAL;EMAIL="user1@example.n
46 et";PARTSTAT=ACCEPTED;ROLE=REQ-PARTICIPANT:mailto:user1@example.net
48 SUMMARY:Meeting with User1
49 DTSTART;TZID=Pacific/Auckland:20111019T100000
50 DTSTAMP:20111018T200107Z
51 ORGANIZER;CN="Manager 1":mailto:manager1@example.net
59 SELECT caldav_data.user_no, caldav_data.dav_name,
60 caldav_type, logged_user, caldav_data.caldav_data AS "vcalendar",
62 FROM caldav_data JOIN calendar_item USING(dav_name) LEFT JOIN timezones ON (tz_id=tzid)
63 WHERE calendar_item.uid = 'E1A13F04-iCal-schedule'
64 ORDER BY caldav_data.dav_id