testing/tests/regression-suite/2003-REPORT-expanded-nz-holidays-2007.test

   1 #
   2 # Test expanded report for NZ public holidays for 2007
   3 #
   4 TYPE=REPORT
   5 URL=http://regression.host/caldav.php/user4/nz_holidays/
   6 AUTH=user4:user4
   7
   8
   9 HEADER=User-Agent: DAViCalTester/public
  10 HEADER=Content-Type: text/xml; charset="UTF-8"
  11 HEAD
  12
  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     <calendar-data>
  19       <expand start="20061231T110000Z" end="20071231T110000Z"/>
  20     </calendar-data>
  21   </D:prop>
  22   <filter>
  23     <comp-filter name="VCALENDAR">
  24       <comp-filter name="VEVENT">
  25         <time-range start="20061231T110000Z" end="20071231T110000Z"/>
  26       </comp-filter>
  27     </comp-filter>
  28   </filter>
  29 </calendar-query>
  30 ENDDATA
  31
  32
  33 QUERY
  34 SELECT dtstart,
  35        rrule,
  36        summary
  37   FROM calendar_item
  38  WHERE dav_name ~ '^/user4/nz_holidays/'
  39    AND (rrule IS NOT NULL
  40        OR (dtstart >= '20061231T110000Z' AND dtstart < '20071231T110000Z')
  41        )
  42 ENDQUERY
  43