testing/tests/regression-suite/0234-Moz-PUT.test

   1 #
   2 # PUT a Mozilla style event into the database
   3 #
   4 TYPE=PUT
   5 URL=http://regression.host/caldav.php/user1/home/e6eb5bc9-f7f9-4a0a-94e8-8e90eefc7d08.ics
   6 HEADER=User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.8.1.8pre) Gecko/20071023 Sunbird/0.7
   7 HEADER=Accept: text/xml,application/xml,application/xhtml+xml,text/html;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5
   8 HEADER=Accept-Language: en-us,en;q=0.5
   9 HEADER=Accept-Charset: ISO-8859-1,utf-8;q=0.7,*;q=0.7
  10 HEADER=Content-Type: text/calendar; charset=utf-8
  11
  12 HEAD
  13
  14
  15 BEGINDATA
  16 BEGIN:VCALENDAR
  17 PRODID:-//Mozilla Calendar//NONSGML Sunbird//EN
  18 VERSION:2.0
  19 BEGIN:VTIMEZONE
  20 TZID:/mozilla.org/20070129_1/Antarctica/McMurdo
  21 X-LIC-LOCATION:Antarctica/McMurdo
  22 BEGIN:STANDARD
  23 TZOFFSETFROM:+1300
  24 TZOFFSETTO:+1200
  25 TZNAME:NZST
  26 DTSTART:19700315T030000
  27 RRULE:FREQ=YEARLY;INTERVAL=1;BYDAY=3SU;BYMONTH=3
  28 END:STANDARD
  29 BEGIN:DAYLIGHT
  30 TZOFFSETFROM:+1200
  31 TZOFFSETTO:+1300
  32 TZNAME:NZDT
  33 DTSTART:19701004T020000
  34 RRULE:FREQ=YEARLY;INTERVAL=1;BYDAY=1SU;BYMONTH=10
  35 END:DAYLIGHT
  36 END:VTIMEZONE
  37 BEGIN:VTODO
  38 CREATED:20071203T202915Z
  39 LAST-MODIFIED:20071203T203021Z
  40 DTSTAMP:20071203T202915Z
  41 UID:e6eb5bc9-f7f9-4a0a-94e8-8e90eefc7d08
  42 SUMMARY:Release 0.9.3
  43 STATUS:IN-PROCESS
  44 DTSTART;TZID=/mozilla.org/20070129_1/Antarctica/McMurdo:20071209T133000
  45 DUE;TZID=/mozilla.org/20070129_1/Antarctica/McMurdo:20071209T133000
  46 PERCENT-COMPLETE:95
  47 X-MOZ-LOCATIONPATH:e6eb5bc9-f7f9-4a0a-94e8-8e90eefc7d08.ics
  48 BEGIN:VALARM
  49 TRIGGER;VALUE=DURATION:-P2D
  50 DESCRIPTION:Mozilla Alarm: Release 0.9.3
  51 ACTION:DISPLAY
  52 END:VALARM
  53 END:VTODO
  54 END:VCALENDAR
  55 ENDDATA
  56
  57
  58 QUERY
  59 SELECT caldav_data.user_no, caldav_data.dav_etag, caldav_type, logged_user,
  60        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,
  61        description, priority, class, transp, rrule, url,
  62        percent_complete, tz_id, status,
  63        caldav_data AS " CalDAV Data",
  64       ((current_timestamp AT TIME ZONE 'GMT' - calendar_item.last_modified) < '2 seconds'::interval) AS "~ Modified Now"
  65 FROM caldav_data JOIN calendar_item USING(dav_name) JOIN timezones ON (tz_id=tzid)
  66 WHERE caldav_data.dav_name =
  67 '/user1/home/e6eb5bc9-f7f9-4a0a-94e8-8e90eefc7d08.ics';
  68 ENDQUERY
  69