testing/tests/regression-suite/0702-caldav4j-PUT.test

   1 #
   2 # PUT an caldav4j regression testing event into the database
   3 #
   4 # Note that although this event appears to refer to the NY time
   5 # zone it does not reference it, since DTSTART/DTEND are VALLUE=DATE
   6 # which may not reference a timezone.
   7 #
   8 TYPE=PUT
   9 URL=http://regression.host/caldav.php/user1/collection/All_Day_NY_JAN1.ics
  10 HEADER=Content-Type: text/calendar
  11 HEADER=User-Agent: Jakarta Commons-HttpClient/3.0
  12 HEAD
  13
  14
  15 BEGINDATA
  16 BEGIN:VCALENDAR
  17 PRODID:-//OSAF//NONSGML Scoooby Server//EN
  18 VERSION:2.0
  19 CALSCALE:GREGORIAN
  20 BEGIN:VTIMEZONE
  21 TZID:America/New_York
  22 LAST-MODIFIED:20051220T211408Z
  23 BEGIN:STANDARD
  24 DTSTART:20051030T060000
  25 TZOFFSETTO:-0500
  26 TZOFFSETFROM:+0000
  27 TZNAME:EST
  28 END:STANDARD
  29 BEGIN:DAYLIGHT
  30 DTSTART:20060402T010000
  31 TZOFFSETTO:-0400
  32 TZOFFSETFROM:-0500
  33 TZNAME:EDT
  34 END:DAYLIGHT
  35 END:VTIMEZONE
  36 BEGIN:VEVENT
  37 DTSTART;VALUE=DATE:20060101
  38 DTEND;VALUE=DATE:20060102
  39 SUMMARY:All_Day_NY_JAN1
  40 UID:C68DADAD-37CE-44F7-8A37-52E1D02E29CA
  41 SEQUENCE:4
  42 DTSTAMP:20090515T095326Z
  43 END:VEVENT
  44 END:VCALENDAR
  45 ENDDATA
  46
  47
  48 QUERY
  49 SELECT caldav_data.user_no, caldav_data.dav_etag, caldav_type, logged_user,
  50        uid, dtstamp, dtstart, 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 FROM caldav_data LEFT JOIN calendar_item USING(dav_name) LEFT JOIN timezones ON (tz_id=tzid)
  55 WHERE caldav_data.dav_name =
  56 '/user1/collection/All_Day_NY_JAN1.ics'
  57 ENDQUERY
  58