2 # Testing with a process similar to iPhone 5
5 URL=http://mycaldav/caldav.php/user1/home/
10 HEADER=User-Agent: iOS/10.7.2 (11C35) dataaccessd/1.0
11 HEADER=Content-Type: text/xml
16 <?xml version="1.0" encoding="UTF-8"?>
17 <C:calendar-query xmlns:C="urn:ietf:params:xml:ns:caldav">
18 <A:prop xmlns:A="DAV:">
23 <C:comp-filter name="VCALENDAR">
24 <C:comp-filter name="VEVENT">
25 <C:time-range start="20110922T000000Z"/>
34 SELECT caldav_data.dav_name, dtstart, rrule
35 FROM calendar_item JOIN caldav_data USING(dav_id)
36 WHERE caldav_data.dav_name ~ '^/user1/home/'
37 AND caldav_data.caldav_type = 'VEVENT'
38 AND (rrule IS NOT NULL OR dtstart IS NULL
39 OR ( (dtend IS NULL AND dtstart > '20110922T000000Z')
40 OR dtend > '20110922T000000Z'