testing/tests/regression-suite/0818-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/MICROPARTY-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 microparty. All the best parties are monthly!
  35 UID:MICROPARTY-77C6-4FB7-BDD3-6882E2F1BE74
  36 DTSTAMP:20081027T074326Z
  37 SUMMARY:Woohoo!  Time to Par-tay!
  38 CREATED:20081024T220749Z
  39 DTSTART;TZID=Pacific/Auckland:20081121T160000
  40 DURATION:PT3H
  41 RRULE:FREQ=MONTHLY;INTERVAL=1;BYDAY=3FR
  42 END:VEVENT
  43 END:VCALENDAR
  44 ENDDATA
  45
  46
  47 QUERY
  48 SELECT caldav_data.user_no, caldav_data.dav_etag, caldav_type, logged_user,
  49        uid, dtstamp, dtstart at time zone olson_name as dtstart,
  50        dtend at time zone olson_name as dtend, due, summary, location,
  51        description, priority, class, transp, rrule, url,
  52        percent_complete, tz_id, status,
  53        caldav_data AS " CalDAV Data", calendar_item.last_modified,
  54       dtend - dtstart AS "~Duration"
  55 FROM caldav_data JOIN calendar_item USING(dav_name) JOIN timezones ON (tz_id=tzid)
  56 WHERE caldav_data.dav_name =
  57 '/user1/home/MICROPARTY-77C6-4FB7-BDD3-6882E2F1BE74.ics';
  58 ENDQUERY
  59