testing/tests/binding/1030-PUT-whole-subcalendar.test

   1 #
   2 # Attempt to put an event into a bound location, where
   3 # the binding does confer write privileges
   4 #
   5 TYPE=PUT
   6 URL=http://regression.host/caldav.php/user4/base/newcalendar/
   7
   8 HEADER=Content-Type: text/calendar; charset=utf-8
   9 AUTH=user4:user4
  10 HEAD
  11
  12 BEGINDATA
  13 BEGIN:VCALENDAR\r
  14 PRODID:-//Open Source Applications Foundation//NONSGML Chandler Server//E\r
  15  N\r
  16 VERSION:2.0\r
  17 CALSCALE:GREGORIAN\r
  18 BEGIN:VTIMEZONE\r
  19 TZID:America/Los_Angeles\r
  20 X-TZINFO:America/Los_Angeles[2007g/Partial@883612800000]\r
  21 BEGIN:DAYLIGHT\r
  22 TZOFFSETTO:-0700\r
  23 TZOFFSETFROM:-0800\r
  24 TZNAME:America/Los_Angeles(DST)\r
  25 DTSTART:19980405T020000\r
  26 RRULE:FREQ=YEARLY;UNTIL=20060403T100000Z;BYMONTH=4;BYDAY=1SU\r
  27 END:DAYLIGHT\r
  28 BEGIN:STANDARD\r
  29 TZOFFSETTO:-0800\r
  30 TZOFFSETFROM:-0700\r
  31 TZNAME:America/Los_Angeles(STD)\r
  32 DTSTART:19981025T020000\r
  33 RRULE:FREQ=YEARLY;UNTIL=20061030T100000Z;BYMONTH=10;BYDAY=-1SU\r
  34 END:STANDARD\r
  35 BEGIN:DAYLIGHT\r
  36 TZOFFSETTO:-0700\r
  37 TZOFFSETFROM:-0800\r
  38 TZNAME:America/Los_Angeles(DST)\r
  39 DTSTART:20070311T020000\r
  40 RRULE:FREQ=YEARLY;BYMONTH=3;BYDAY=2SU\r
  41 END:DAYLIGHT\r
  42 BEGIN:STANDARD\r
  43 TZOFFSETTO:-0800\r
  44 TZOFFSETFROM:-0700\r
  45 TZNAME:America/Los_Angeles(STD)\r
  46 DTSTART:20071104T020000\r
  47 RRULE:FREQ=YEARLY;BYMONTH=11;BYDAY=1SU\r
  48 END:STANDARD\r
  49 END:VTIMEZONE\r
  50 BEGIN:VEVENT\r
  51 LAST-MODIFIED:20100125T214235Z\r
  52 SEQUENCE:1\r
  53 UID:73d1f980-ec28-012c-11f9-002421a2359e\r
  54 SUMMARY:HELLO\r
  55 DESCRIPTION:\r
  56 DTSTART;VALUE=DATE-TIME;TZID=America/Los_Angeles:20100105T140000\r
  57 CREATED:20100125T214226Z\r
  58 DTSTAMP:20100125T214235Z\r
  59 DURATION:PT1H\r
  60 LOCATION:\r
  61 END:VEVENT\r
  62 BEGIN:VEVENT\r
  63 LAST-MODIFIED:20100311T220844Z\r
  64 SEQUENCE:18\r
  65 URL;VALUE=URI:http://www.macwfc.org\r
  66 UID:939afe30-0f86-012d-1259-002421a2359e\r
  67 SUMMARY:Youngberg Hill @ McMinniville Wine & Food Festival\r
  68 DESCRIPTION:March 12-14th McMinniville Wine & Food Festival\nCome visit Y\r
  69  oungberg Hill at this wonderful festival. \nwww.macwfc.org\n\n\r
  70 DTSTART;TZID=America/Los_Angeles:20100312T110000\r
  71 CREATED:20100311T215422Z\r
  72 DTSTAMP:20100311T220844Z\r
  73 DURATION:P2DT5H\r
  74 LOCATION:\r
  75 X-VENUE:Evergreen Aviation\, McMnnville OR\r
  76 END:VEVENT\r
  77 BEGIN:VEVENT\r
  78 LAST-MODIFIED:20100311T222451Z\r
  79 SEQUENCE:11\r
  80 URL;VALUE=URI:http://www.theoregonwineandartauction.org/\r
  81 UID:12cbff90-0f8a-012d-1259-002421a2359e\r
  82 SUMMARY:Youngberg Hill @ Uncorked\, Oregon Wine & Art Auction \r
  83 DESCRIPTION:July 10th - Uncorked\, Oregon Wine & Art Auction\n\nCome join\r
  84   Youngberg Hill for this wonderful event.\r
  85 DTSTART;TZID=America/Los_Angeles:20100710T160000\r
  86 CREATED:20100311T221924Z\r
  87 DTSTAMP:20100311T222451Z\r
  88 DURATION:PT4H30M\r
  89 LOCATION:11400 Westland Lane\, Dayton OR\r
  90 X-VENUE:The Methven Family Vineyards\r
  91 END:VEVENT\r
  92 BEGIN:VEVENT\r
  93 LAST-MODIFIED:20100311T231118Z\r
  94 SEQUENCE:7\r
  95 UID:242afc80-0f8c-012d-1259-002421a2359e\r
  96 SUMMARY:Pre- IPNC Winemaker Dinner @ Youngberg Hill\r
  97 DESCRIPTION:July 22nd - PRE-IPNC Winemaker Dinner @ Youngberg Hill.\n\nDe\r
  98  tails to follow.\r
  99 DTSTART;TZID=America/Los_Angeles:20100722T183000\r
 100 CREATED:20100311T223412Z\r
 101 DTSTAMP:20100311T231118Z\r
 102 DURATION:PT30M\r
 103 LOCATION:\r
 104 END:VEVENT\r
 105 BEGIN:VEVENT\r
 106 LAST-MODIFIED:20100311T220308Z\r
 107 SEQUENCE:8\r
 108 URL;VALUE=URI:http://www.stephanie-inn.com\r
 109 UID:950ca060-0f87-012d-1259-002421a2359e\r
 110 SUMMARY:Youngberg Hill Winemaker Dinner @ The Stephanie Inn\r
 111 DESCRIPTION:May 2 - Stephanie Inn Winemaker Dinner @ Cannon Beach\nCome j\r
 112  oin Youngberg Hill Vineyards & Inn for this wonderful experience. Detail\r
 113  s at \nwww.stephanie-inn.com\n\n\r
 114 DTSTART;TZID=America/Los_Angeles:20100502T180000\r
 115 CREATED:20100311T220134Z\r
 116 DTSTAMP:20100311T220308Z\r
 117 DURATION:PT3H30M\r
 118 LOCATION:Cannon Beach\, OR\r
 119 X-VENUE:The Stephanie Inn\r
 120 END:VEVENT\r
 121 BEGIN:VEVENT\r
 122 LAST-MODIFIED:20100311T231101Z\r
 123 SEQUENCE:0\r
 124 UID:4887b3b0-0f91-012d-1259-002421a2359e\r
 125 SUMMARY:New Event\r
 126 DESCRIPTION:\r
 127 DTSTART;TZID=America/Los_Angeles:20100716T150000\r
 128 CREATED:20100311T231101Z\r
 129 DTSTAMP:20100311T231101Z\r
 130 DURATION:PT1H\r
 131 LOCATION:\r
 132 END:VEVENT\r
 133 BEGIN:VEVENT\r
 134 LAST-MODIFIED:20100311T223312Z\r
 135 SEQUENCE:9\r
 136 URL;VALUE=URI:http://www.mcminnvilleava.org/event.htm\r
 137 UID:ed3beb90-0f8a-012d-1259-002421a2359e\r
 138 SUMMARY:Discover McMinnville AVA\r
 139 DESCRIPTION:July 17th - Discover McMinnville AVA\n\nParticipating Winerie\r
 140  s Include:\nBrittan Vineyards\, Coeur de Terre Vineyard\, Coleman Vineya\r
 141  rd\, Maysara Vineyard\, Seufert Winery\, Stony Mountain Vineyard\, Yamhi\r
 142  ll Valley Vineyards and Youngberg Hill Vineyard\r
 143 DTSTART;TZID=America/Los_Angeles:20100717T100000\r
 144 CREATED:20100311T222531Z\r
 145 DTSTAMP:20100311T223312Z\r
 146 DURATION:PT7H\r
 147 LOCATION:16250 SW Oldsville Rd\, McMinnville OR\r
 148 X-VENUE:Yamhill Valley Vineyards\r
 149 END:VEVENT\r
 150 BEGIN:VEVENT\r
 151 LAST-MODIFIED:20100312T064055Z\r
 152 SEQUENCE:9\r
 153 URL;VALUE=URI:http://www.youngberghill.com\r
 154 UID:626c1f10-0f91-012d-1259-002421a2359e\r
 155 SUMMARY:Linfield Chamber Benefit @ Youngberg Hill\r
 156 DESCRIPTION:August 12th - Linfield Chamber Benefit @ Youngberg Hill\n\nDe\r
 157  tails to follow\r
 158 DTSTART;TZID=America/Los_Angeles:20100812T180000\r
 159 CREATED:20100311T231144Z\r
 160 DTSTAMP:20100312T064055Z\r
 161 DURATION:PT2H30M\r
 162 LOCATION:10660 SW Youngberg Hill Road\, McMinniville OR\r
 163 X-VENUE:Youngberg Hill\r
 164 END:VEVENT\r
 165 BEGIN:VEVENT\r
 166 LAST-MODIFIED:20100311T221206Z\r
 167 SEQUENCE:8\r
 168 URL;VALUE=URI:http://www.youngberghill.com\r
 169 UID:b0362430-0f88-012d-1259-002421a2359e\r
 170 SUMMARY:Youngberg Hill Vineyard & Inn - Memorial Weekend\r
 171 DESCRIPTION:Memorial Weekend\nYoungberg Hill will be open from 11:00 to 5\r
 172  :00 on Saturday\, Sunday\, & Monday. We will be highlighting our 2007 Jo\r
 173  rdan & Natasha Block Pinot Noir as well as our newly released 2009 Pinot\r
 174   Gris. We will have cheeses\, breads\, and treats available\, plus the g\r
 175  reatest view.\n\nTasting fee of $5\, complimentary tastings for our Wine\r
 176   Club members. \n\r
 177 DTSTART;TZID=America/Los_Angeles:20100529T110000\r
 178 CREATED:20100311T220929Z\r
 179 DTSTAMP:20100311T221206Z\r
 180 DURATION:P2DT6H\r
 181 LOCATION:10660 SW Youngberg Hill Road\r
 182 X-VENUE:McMinnville\, OR\r
 183 END:VEVENT\r
 184 END:VCALENDAR\r
 185 ENDDATA
 186
 187 QUERY
 188 SELECT caldav_data.dav_name, caldav_data.dav_etag, dtstart, summary
 189   FROM caldav_data JOIN calendar_item USING(dav_name)
 190   WHERE caldav_data.dav_name ~ '/user4/base/newcalendar/'
 191   ORDER BY caldav_data.dav_name
 192 ENDQUERY
 193