1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
|
#
# Attempt to put an event into a bound location, where
# the binding does not confer write privileges
#
TYPE=PUT
URL=http://regression.host/caldav.php/user4/user1/thiswillnotwork.ics
HEADER=Content-Type: text/calendar; charset=utf-8
AUTH=user4:user4
HEAD
BEGINDATA
BEGIN:VCALENDAR
PRODID:-//Mozilla.org/NONSGML Mozilla Calendar V1.1//EN
VERSION:2.0
BEGIN:VTIMEZONE
TZID:Pacific/Auckland
X-LIC-LOCATION:Pacific/Auckland
BEGIN:DAYLIGHT
TZOFFSETFROM:+1200
TZOFFSETTO:+1300
TZNAME:NZDT
DTSTART:19700927T020000
RRULE:FREQ=YEARLY;BYDAY=-1SU;BYMONTH=9
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:+1300
TZOFFSETTO:+1200
TZNAME:NZST
DTSTART:19700405T030000
RRULE:FREQ=YEARLY;BYDAY=1SU;BYMONTH=4
END:STANDARD
END:VTIMEZONE
BEGIN:VEVENT
CREATED:20100318T044409Z
LAST-MODIFIED:20100318T044451Z
DTSTAMP:20100318T044451Z
UID:9f81cd8a-b1c2-4f72-9f12-1ddbddd69342
SUMMARY:Test adding an event to a bound collection
RRULE:FREQ=WEEKLY;INTERVAL=2
DTSTART;TZID=Pacific/Auckland:20100322T180000
DTEND;TZID=Pacific/Auckland:20100322T190000
LOCATION:Somewhere else
DESCRIPTION:This event is being added to a bound collection.
END:VEVENT
END:VCALENDAR
ENDDATA
QUERY
SELECT caldav_data.dav_name, caldav_data.dav_etag, dtstart, summary
FROM caldav_data JOIN calendar_item USING(dav_name)
WHERE caldav_data.dav_name ~ '/user1/.*willnotwork.ics'
ENDQUERY
|
