Merge branch 'master' of github.com:DAViCal/davical into github
[davical.git] / testing / tests / regression-suite / 0310-Chandler-PUT-1.test
blob04292f6115909b79ea78e11a95f4aa7eafffb3dc
2 # PUT request like Chandler does it.
4 TYPE=PUT
5 URL=http://regression.host/caldav.php/user1/home/71e2ae82-7870-11db-c6d6-f6927c144649.ics
6 HEADER=Content-Type: text/calendar
7 HEAD
10 # Somewhat atypical Chandler data since I insisted it use a timezone on this occasion
11 BEGINDATA
12 BEGIN:VCALENDAR\r
13 VERSION:2.0\r
14 PRODID:-//PYVOBJECT//NONSGML Version 1//EN\r
15 BEGIN:VTIMEZONE\r
16 TZID:Pacific/Auckland\r
17 BEGIN:STANDARD\r
18 DTSTART:20000319T030000\r
19 RRULE:FREQ=YEARLY;BYDAY=3SU;BYMONTH=3\r
20 TZNAME:Pacific/Auckland\r
21 TZOFFSETFROM:+1300\r
22 TZOFFSETTO:+1200\r
23 END:STANDARD\r
24 BEGIN:DAYLIGHT\r
25 DTSTART:20001001T020000\r
26 RRULE:FREQ=YEARLY;BYDAY=1SU;BYMONTH=10\r
27 TZNAME:Pacific/Auckland\r
28 TZOFFSETFROM:+1200\r
29 TZOFFSETTO:+1300\r
30 END:DAYLIGHT\r
31 END:VTIMEZONE\r
32 BEGIN:VEVENT\r
33 UID:71e2ae82-7870-11db-c6d6-f6927c144649\r
34 DTSTAMP:20060511T043751Z\r
35 DTSTART;TZID=Pacific/Auckland:20061103T160000\r
36 DTEND;TZID=Pacific/Auckland:20061103T174500\r
37 DESCRIPTION:\r
38 LOCATION:Level 3\r
39 RRULE:FREQ=WEEKLY;INTERVAL=2;UNTIL=20071222T235900\r
40 STATUS:CONFIRMED\r
41 SUMMARY:Beer O'Clock\r
42 END:VEVENT\r
43 END:VCALENDAR\r
44 ENDDATA
46 QUERY
47 SELECT caldav_data.user_no, caldav_type, logged_user, 
48        uid, dtstamp, dtstart at time zone olson_name as dtstart,
49        dtend at time zone olson_name as dtend, due, summary, location,
50        description, priority, class, transp, rrule, url,
51        percent_complete, tz_id, status,
52        calendar_item.last_modified,
53        caldav_data AS "A1 CalDAV DATA"
54 FROM caldav_data JOIN calendar_item USING(dav_name) LEFT JOIN timezones ON (tz_id=tzid)
55 WHERE caldav_data.dav_name =
56  '/user1/home/71e2ae82-7870-11db-c6d6-f6927c144649.ics';
57 ENDQUERY