testing/tests/regression-suite/0514-iCal-PUT-VTODO.test

   1 #
   2 # PUT an iCal style event into the database
   3 #
   4 TYPE=PUT
   5 URL=http://regression.host/caldav.php/user1/6E20BB7C-EFD9-4F0F-9BDC-5335E04D47E0/E6BC62F3-77C6-4FB7-BDD3-6882E2F1BE74.ics
   6 HEADER=Content-Type: text/calendar
   7 HEADER=User-Agent: DAVKit/2.0 (10.5.1; wrbt) iCal 3.0.1
   8 HEAD
   9
  10
  11 BEGINDATA
  12 BEGIN:VCALENDAR
  13 VERSION:2.0
  14 PRODID:-//Apple Inc.//iCal 3.0//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:VTODO
  34 PRIORITY:5
  35 SEQUENCE:7
  36 DESCRIPTION:Organise a party
  37 UID:E6BC62F3-77C6-4FB7-BDD3-6882E2F1BE74
  38 DTSTART;TZID=Pacific/Auckland:20040101T120000
  39 DTSTAMP:20071124T220925Z
  40 SUMMARY:Celebrate a significant birthday
  41 CREATED:20071124T220749Z
  42 X-APPLE-SORT-ORDER:2147483647
  43 DUE;VALUE=DATE:20100217
  44 END:VTODO
  45 END:VCALENDAR
  46 ENDDATA
  47
  48
  49 QUERY
  50 SELECT caldav_data.user_no, caldav_data.dav_etag, caldav_type, logged_user,
  51        uid, dtstamp, dtstart at time zone olson_name as dtstart, dtend at time zone olson_name as dtend, due at time zone olson_name as due, summary, location,
  52        description, priority, class, transp, rrule, url,
  53        percent_complete, tz_id, status,
  54        caldav_data AS " CalDAV Data", calendar_item.last_modified
  55 FROM caldav_data JOIN calendar_item USING(dav_name) JOIN timezones ON (tz_id=tzid)
  56 WHERE caldav_data.dav_name =
  57 '/user1/6E20BB7C-EFD9-4F0F-9BDC-5335E04D47E0/E6BC62F3-77C6-4FB7-BDD3-6882E2F1BE74.ics';
  58 ENDQUERY
  59