Merge branch 'master' of github.com:DAViCal/davical into github
[davical.git] / testing / tests / regression-suite / 0904-PUT-bad-timezone.test
blob535061e90f13251acfe9289caad963038bf15176
2 # PUT an event with a non-standard timezone
4 # There is no CalDAV defined behaviour for this.
6 TYPE=PUT
7 URL=http://regression.host/caldav.php/user1/home/PUT-eastern-time.ics
8 HEADER=User-Agent: DAViCal Testing/0.9.x
9 HEADER=Content-Type: text/calendar; charset=utf-8
11 HEAD
13 BEGINDATA
14 BEGIN:VCALENDAR
15 CALSCALE:GREGORIAN
16 PRODID:-//Ximian//NONSGML Evolution Calendar//EN
17 VERSION:2.0
18 BEGIN:VTIMEZONE
19 TZID:(UTC-05:00) Eastern Time (US & Canada)
20 BEGIN:STANDARD
21 DTSTART:16010101T020000
22 TZOFFSETFROM:-0400
23 TZOFFSETTO:-0500
24 RRULE:FREQ=YEARLY;INTERVAL=1;BYDAY=1SU;BYMONTH=11
25 END:STANDARD
26 BEGIN:DAYLIGHT
27 DTSTART:16010101T020000
28 TZOFFSETFROM:-0500
29 TZOFFSETTO:-0400
30 RRULE:FREQ=YEARLY;INTERVAL=1;BYDAY=2SU;BYMONTH=3
31 END:DAYLIGHT
32 END:VTIMEZONE
33 BEGIN:VEVENT
34 UID:PUT-eastern-time
35 DTSTAMP:20101009T214524Z
36 SUMMARY;LANGUAGE=en-US:Psychic's Anonymous Meeting
37 DTSTART;TZID="(UTC-05:00) Eastern Time (US & Canada)":20110912T110000
38 DTEND;TZID="(UTC-05:00) Eastern Time (US & Canada)":20110912T113000
39 LOCATION:You will know when you arrive
40 CREATED:20101010T014639
41 LAST-MODIFIED:20101010T014639
42 END:VEVENT
43 END:VCALENDAR
44 ENDDATA
46 QUERY
47 SELECT 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
52 FROM caldav_data JOIN calendar_item USING(dav_name) JOIN timezones ON (tz_id=tzid)
53 WHERE caldav_data.dav_name =
54 '/user1/home/PUT-eastern-time.ics'
55 ENDQUERY