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'