testing/tests/regression-suite/0236-Moz-REPORT.test

   1 #
   2 # Check for REPORT calendar-query of VTODO within time range
   3 #
   4 TYPE=REPORT
   5 URL=http://regression.host/caldav.php/user1/home/
   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
   8 HEADER=Accept-Language: en-us,en;q=0.5
   9 HEADER=Accept-Charset: utf-8,*;q=0.1
  10 HEADER=Content-Type: text/xml; charset=utf-8
  11 HEADER=Depth: 1
  12 HEAD
  13
  14 BEGINDATA
  15 <?xml version="1.0" encoding="UTF-8"?>
  16 <calendar-query xmlns:D="DAV:" xmlns="urn:ietf:params:xml:ns:caldav">
  17   <D:prop>
  18     <D:getetag/>
  19     <calendar-data/>
  20   </D:prop>
  21   <filter>
  22     <comp-filter name="VCALENDAR">
  23       <comp-filter name="VTODO">
  24         <time-range start="20071101T110000Z" end="20080104T110000Z"/>
  25       </comp-filter>
  26     </comp-filter>
  27   </filter>
  28 </calendar-query>
  29 ENDDATA
  30
  31 QUERY
  32 SELECT dtstart, due,
  33        rrule,
  34        summary
  35   FROM calendar_item JOIN caldav_data USING (dav_id)
  36  WHERE calendar_item.dav_name ~ '^/user1/home/'
  37    AND caldav_data.caldav_type = 'VTODO'
  38    AND (rrule IS NOT NULL OR dtstart IS NULL
  39         OR (
  40               (
  41                   (due IS NULL AND dtstart > '20071101T110000Z')
  42                   OR due > '20071101T110000Z'
  43               )
  44               AND  dtstart < '20080104T110000Z'
  45            )
  46     )
  47 ENDQUERY
  48