testing/tests/regression-suite/0817-Spec-PUT.test

   1 #
   2 # PUT an iCal style event into the database
   3 #
   4 TYPE=PUT
   5 URL=http://regression.host/caldav.php/user1/home/DAYPARTY-77C6-4FB7-BDD3-6882E2F1BE74.ics
   6 HEADER=Content-Type: text/calendar
   7 HEADER=User-Agent: RFC2518 Spec Tests
   8 HEAD
   9
  10
  11 BEGINDATA
  12 BEGIN:VCALENDAR
  13 VERSION:2.0
  14 PRODID:-//davical.org//NONSGML AWL Calendar//EN
  15 CALSCALE:GREGORIAN
  16 BEGIN:VTIMEZONE
  17 TZID:Pacific/Auckland
  18 BEGIN:STANDARD
  19 TZOFFSETFROM:+1300
  20 TZOFFSETTO:+1200
  21 DTSTART:19900318T030000
  22 RRULE:FREQ=YEARLY;UNTIL=20070317T140000Z;BYMONTH=3;BYDAY=3SU
  23 TZNAME:NZST
  24 END:STANDARD
  25 BEGIN:DAYLIGHT
  26 TZOFFSETFROM:+1200
  27 TZOFFSETTO:+1300
  28 DTSTART:19901007T020000
  29 RRULE:FREQ=YEARLY;UNTIL=20060930T140000Z;BYMONTH=10;BYDAY=1SU
  30 TZNAME:NZDT
  31 END:DAYLIGHT
  32 END:VTIMEZONE
  33 BEGIN:VEVENT
  34 DESCRIPTION:Have a party. All the best parties are monthly!
  35 UID:DAYPARTY-77C6-4FB7-BDD3-6882E2F1BE74
  36 DTSTAMP:20081024T220925Z
  37 SUMMARY:Party all day!
  38 CREATED:20081024T220749Z
  39 DTSTART;TZID=Pacific/Auckland;VALUE=DATE:20081114
  40 RRULE:FREQ=MONTHLY;INTERVAL=1;BYDAY=2FR
  41 END:VEVENT
  42 END:VCALENDAR
  43 ENDDATA
  44
  45
  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,
  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        caldav_data AS " CalDAV Data", calendar_item.last_modified,
  53       dtend - dtstart AS "~Duration"
  54 FROM caldav_data JOIN calendar_item USING(dav_name) JOIN timezones ON (tz_id=tzid)
  55 WHERE caldav_data.dav_name =
  56 '/user1/home/DAYPARTY-77C6-4FB7-BDD3-6882E2F1BE74.ics';
  57 ENDQUERY
  58