1#
2# PUT an event with a non-standard timezone
3#
4# There is no CalDAV defined behaviour for this.
5#
6TYPE=PUT
7URL=http://regression.host/caldav.php/user1/home/PUT-eastern-time.ics
8HEADER=User-Agent: DAViCal Testing/0.9.x
9HEADER=Content-Type: text/calendar; charset=utf-8
10
11HEAD
12
13BEGINDATA
14BEGIN:VCALENDAR
15CALSCALE:GREGORIAN
16PRODID:-//Ximian//NONSGML Evolution Calendar//EN
17VERSION:2.0
18BEGIN:VTIMEZONE
19TZID:(UTC-05:00) Eastern Time (US & Canada)
20BEGIN:STANDARD
21DTSTART:16010101T020000
22TZOFFSETFROM:-0400
23TZOFFSETTO:-0500
24RRULE:FREQ=YEARLY;INTERVAL=1;BYDAY=1SU;BYMONTH=11
25END:STANDARD
26BEGIN:DAYLIGHT
27DTSTART:16010101T020000
28TZOFFSETFROM:-0500
29TZOFFSETTO:-0400
30RRULE:FREQ=YEARLY;INTERVAL=1;BYDAY=2SU;BYMONTH=3
31END:DAYLIGHT
32END:VTIMEZONE
33BEGIN:VEVENT
34UID:PUT-eastern-time
35DTSTAMP:20101009T214524Z
36SUMMARY;LANGUAGE=en-US:Psychic's Anonymous Meeting
37DTSTART;TZID="(UTC-05:00) Eastern Time (US & Canada)":20110912T110000
38DTEND;TZID="(UTC-05:00) Eastern Time (US & Canada)":20110912T113000
39LOCATION:You will know when you arrive
40CREATED:20101010T014639
41LAST-MODIFIED:20101010T014639
42END:VEVENT
43END:VCALENDAR
44ENDDATA
45
46QUERY
47SELECT caldav_data.user_no, caldav_data.dav_etag, caldav_type, logged_user,
48       uid, dtstamp, dtstart at time zone olson_name as dtstart, dtend at time zone olson_name as dtend, due, summary, location,
49       description, priority, class, transp, rrule, url,
50       percent_complete, tz_id, status,
51       caldav_data AS " CalDAV Data", calendar_item.last_modified
52FROM caldav_data JOIN calendar_item USING(dav_name) JOIN timezones ON (tz_id=tzid)
53WHERE caldav_data.dav_name =
54'/user1/home/PUT-eastern-time.ics'
55ENDQUERY
56