testing/tests/regression-suite/0959-REPORT-expanded.test

   1 #
   2 # Test REPORT access to a non-public calendar using a ticket.
   3 #
   4 TYPE=REPORT
   5 URL=http://regression.host/caldav.php/user2/home/
   6 AUTH=user2:user2
   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="20081101T000000Z" end="20081201T000000Z"/>
  20     </calendar-data>
  21   </D:prop>
  22   <filter>
  23     <comp-filter name="VCALENDAR">
  24       <comp-filter name="VEVENT">
  25         <time-range start="20081101T000000Z" end="20081201T000000Z"/>
  26       </comp-filter>
  27     </comp-filter>
  28   </filter>
  29 </calendar-query>
  30 ENDDATA
  31
  32
  33 QUERY
  34 SELECT dav_name,
  35        dtstart, dtstart AT TIME ZONE 'UTC' AS dtstart_utc,
  36        rrule
  37   FROM calendar_item
  38  WHERE dav_name ~ '^/user2/home/'
  39    AND rrule IS NOT NULL
  40    AND dtstart < '20081201T000000Z'
  41 ENDQUERY
  42