2 # PUT a Mozilla style event into the database
5 URL=http://regression.host/caldav.php/user1/home/e70576e9-c1e0-431e-a507-0386fd82f223.ics
6 HEADER=User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.8.1.8pre) Gecko/20071023 Sunbird/0.7
7 HEADER=Accept: text/xml,application/xml,application/xhtml+xml,text/html;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5
8 HEADER=Accept-Language: en-us,en;q=0.5
9 HEADER=Accept-Charset: ISO-8859-1,utf-8;q=0.7,*;q=0.7
10 HEADER=Content-Type: text/calendar; charset=utf-8
17 PRODID:-//Mozilla Calendar//NONSGML Sunbird//EN
20 TZID:/mozilla.org/20070129_1/Antarctica/McMurdo
21 X-LIC-LOCATION:Antarctica/McMurdo
26 DTSTART:19700315T030000
27 RRULE:FREQ=YEARLY;INTERVAL=1;BYDAY=3SU;BYMONTH=3
33 DTSTART:19701004T020000
34 RRULE:FREQ=YEARLY;INTERVAL=1;BYDAY=1SU;BYMONTH=10
38 CREATED:20071203T202630Z
39 LAST-MODIFIED:20071203T202834Z
40 DTSTAMP:20071203T202630Z
41 UID:e70576e9-c1e0-431e-a507-0386fd82f223
42 SUMMARY:Morning Meeting
43 RRULE:FREQ=WEEKLY;INTERVAL=1;BYDAY=TU,TH
44 DTSTART;TZID=/mozilla.org/20070129_1/Antarctica/McMurdo:20071211T074500
45 DTEND;TZID=/mozilla.org/20070129_1/Antarctica/McMurdo:20071211T083000
46 X-MOZ-LOCATIONPATH:e70576e9-c1e0-431e-a507-0386fd82f223.ics
47 LOCATION:Suzies Coffee Lounge
48 DESCRIPTION:Twice-weekly breakfast meeting
51 TRIGGER;VALUE=DURATION:-PT10M
52 DESCRIPTION:Mozilla Alarm: Morning Meeting
61 SELECT caldav_data.user_no, caldav_data.dav_etag, caldav_type, logged_user,
62 uid, dtstamp, dtstart at time zone olson_name as dtstart, dtend at time zone olson_name as dtend, due, summary, location,
63 description, priority, class, transp, rrule, url,
64 percent_complete, tz_id, status,
65 caldav_data AS " CalDAV Data",
66 ((current_timestamp AT TIME ZONE 'GMT' - calendar_item.last_modified) < '2 seconds'::interval) AS "~ Modified Now"
67 FROM caldav_data JOIN calendar_item USING(dav_name) JOIN timezones ON (tz_id=tzid)
68 WHERE caldav_data.dav_name =
69 '/user1/home/e70576e9-c1e0-431e-a507-0386fd82f223.ics';