testing/tests/regression-suite/0011-Mulberry-PUT-1b.test

   1 #
   2 # We now have a calendar so we can PUT an event into it...
   3 TYPE=PUT
   4 URL=http://regression.host/caldav.php/user1/home/F56B49B10FC923D20FE2DC92D6580340-0.ics
   5 HEADER=Content-Type: text/calendar; charset=utf-8
   6 HEADER=If-Match: "b000d7defa19ccb7cd21e546b54155ee"
   7 HEAD
   8
   9 BEGINDATA
  10 BEGIN:VCALENDAR
  11 CALSCALE:GREGORIAN
  12 PRODID:-//mulberrymail.com//Mulberry v4.0//EN
  13 VERSION:2.0
  14 X-WR-CALNAME:home
  15 BEGIN:VTIMEZONE
  16 LAST-MODIFIED:20040110T032845Z
  17 TZID:New Zealand Standard Time
  18 X-LIC-LOCATION:Pacific/Auckland
  19 BEGIN:DAYLIGHT
  20 DTSTART:20000404T020000
  21 RRULE:FREQ=YEARLY;BYDAY=1SU;BYMONTH=4
  22 TZNAME:NZDT
  23 TZOFFSETFROM:+1200
  24 TZOFFSETTO:+1300
  25 END:DAYLIGHT
  26 BEGIN:STANDARD
  27 DTSTART:20001026T020000
  28 RRULE:FREQ=YEARLY;BYDAY=1SU;BYMONTH=10
  29 TZNAME:NZST
  30 TZOFFSETFROM:+1300
  31 TZOFFSETTO:+1200
  32 END:STANDARD
  33 END:VTIMEZONE
  34 BEGIN:VEVENT
  35 DTSTAMP:20061107T031419Z
  36 DTSTART;TZID=New Zealand Standard Time:20061025T091500
  37 DURATION:PT1H
  38 SUMMARY:A first event, modified.
  39 UID:B18CBB57295D01D7661A6DD4@D76FAF7B10D9E8D2D41F779C
  40 END:VEVENT
  41 END:VCALENDAR
  42 ENDDATA
  43
  44 #   at time zone 'GMT' AS dtstamp,
  45 QUERY
  46 SELECT caldav_data.user_no, caldav_type, logged_user, uid,
  47        dtstamp,
  48        dtstart at time zone olson_name as dtstart,
  49        dtend at time zone olson_name as dtend,
  50        due, summary, location,
  51        description, priority, class, transp, rrule, url,
  52        percent_complete, tz_id, status,
  53        calendar_item.last_modified,
  54        caldav_data AS "A1 CalDAV DATA"
  55 FROM caldav_data JOIN calendar_item USING(dav_name) JOIN timezones ON (tz_id=tzid)
  56 WHERE caldav_data.dav_name ~ '^/user1/home/'
  57 ENDQUERY
  58