testing/tests/regression-suite/0902-PUT-collection.test

   1 #
   2 # PUT an entire calendar collection with one fell swoop
   3 #
   4 # There is no CalDAV defined behaviour for this.
   5 #
   6 TYPE=PUT
   7 URL=http://mycaldav/caldav.php/user1/anotherone/
   8 HEADER=User-Agent: RSCDS Testing/0.7.x
   9 HEADER=Content-Type: text/calendar; charset=utf-8
  10 AUTH=admin:nimda
  11
  12 HEAD
  13
  14 BEGINDATA
  15 BEGIN:VCALENDAR
  16 CALSCALE:GREGORIAN
  17 PRODID:-//Ximian//NONSGML Evolution Calendar//EN
  18 VERSION:2.0
  19 BEGIN:VEVENT
  20 UID:20061119T201927Z-5105-1000-5103-8@ubu
  21 DTSTAMP:20061119T201927Z
  22 DTSTART;TZID=/softwarestudio.org/Olson_20011030_5/Pacific/Auckland:
  23  20061122T130000
  24 DTEND;TZID=/softwarestudio.org/Olson_20011030_5/Pacific/Auckland:
  25  20061122T133000
  26 SUMMARY:Alan Wanston\, FudgeFactory
  27 CREATED:20061119T201929
  28 LAST-MODIFIED:20061119T201951
  29 SEQUENCE:1
  30 BEGIN:VALARM
  31 X-EVOLUTION-ALARM-UID:20061119T201927Z-5101-1000-1-17@ubu
  32 ACTION:DISPLAY
  33 TRIGGER;VALUE=DURATION;RELATED=START:-PT15M
  34 DESCRIPTION:Alan Wanston
  35 END:VALARM
  36 END:VEVENT
  37 BEGIN:VEVENT
  38 UID:20061029T195821Z-14356-1000-1-12@ubu
  39 DTSTAMP:20061029T195821Z
  40 DTSTART;TZID=/softwarestudio.org/Olson_20011030_5/Pacific/Auckland:
  41  20061030T130000
  42 DTEND;TZID=/softwarestudio.org/Olson_20011030_5/Pacific/Auckland:
  43  20061030T140000
  44 SUMMARY:???
  45 CREATED:20061029T195822
  46 LAST-MODIFIED:20061029T195822
  47 BEGIN:VALARM
  48 X-EVOLUTION-ALARM-UID:20061029T195821Z-14353-1000-1-6@ubu
  49 ACTION:DISPLAY
  50 TRIGGER;VALUE=DURATION;RELATED=START:-PT15M
  51 DESCRIPTION:???
  52 END:VALARM
  53 END:VEVENT
  54 BEGIN:VEVENT
  55 UID:20061105T211651Z-4384-1000-1-7@ubu
  56 DTSTAMP:20061105T211651Z
  57 DTSTART;TZID=/softwarestudio.org/Olson_20011030_5/Pacific/Auckland:
  58  20061107T140000
  59 DTEND;TZID=/softwarestudio.org/Olson_20011030_5/Pacific/Auckland:
  60  20061107T150000
  61 SUMMARY:James What
  62 CREATED:20061105T211656
  63 LAST-MODIFIED:20061106T213310
  64 LOCATION:Copperstuff
  65 CLASS:PUBLIC
  66 TRANSP:OPAQUE
  67 SEQUENCE:3
  68 ORGANIZER;CN=Andrew Moughtonbeigh:MAILTO:andrew@example.org
  69 DESCRIPTION:I am looking at hosting a custom Web application on a Linux
  70  Debian server. \nFrom what I understand you can provide the complete
  71  solution in terms of hosting and support. \nI am currently looking into
  72  hosting providers as well as looking for some Debian admin skilled
  73  resource.\n
  74 ATTENDEE;CUTYPE=INDIVIDUAL;ROLE=REQ-PARTICIPANT;PARTSTAT=ACCEPTED;
  75  RSVP=TRUE;CN=Andrew Moughtonbeigh;LANGUAGE=en:MAILTO:andrew@example.org
  76 ATTENDEE;CUTYPE=INDIVIDUAL;ROLE=REQ-PARTICIPANT;PARTSTAT=ACCEPTED;
  77  RSVP=TRUE;CN=Ian Winsleigh;LANGUAGE=en:MAILTO:ian@example.org
  78 ATTENDEE;CUTYPE=INDIVIDUAL;ROLE=REQ-PARTICIPANT;PARTSTAT=NEEDS-ACTION;
  79  RSVP=TRUE;CN=David Callenius;LANGUAGE=en:MAILTO:dcallenius@example.org
  80 BEGIN:VALARM
  81 X-EVOLUTION-ALARM-UID:20061106T213310Z-4382-1000-1-31@ubu
  82 DESCRIPTION:James What
  83 ACTION:DISPLAY
  84 TRIGGER;VALUE=DURATION;RELATED=START:-PT15M
  85 END:VALARM
  86 END:VEVENT
  87 BEGIN:VEVENT
  88 UID:20061031T194148Z-14356-1000-1-14@ubu
  89 DTSTAMP:20061031T194148Z
  90 DTSTART;TZID=/softwarestudio.org/Olson_20011030_5/Pacific/Auckland:
  91  20061101T133000
  92 DTEND;TZID=/softwarestudio.org/Olson_20011030_5/Pacific/Auckland:
  93  20061101T143000
  94 SUMMARY:Doctor
  95 CREATED:20061031T194149
  96 LAST-MODIFIED:20061031T194149
  97 BEGIN:VALARM
  98 X-EVOLUTION-ALARM-UID:20061031T194148Z-14353-1000-1-19@ubu
  99 ACTION:DISPLAY
 100 TRIGGER;VALUE=DURATION;RELATED=START:-PT15M
 101 DESCRIPTION:Doctor
 102 END:VALARM
 103 END:VEVENT
 104 BEGIN:VEVENT
 105 UID:20061027T005242Z-5029-1001-1-1@dolmein
 106 DTSTAMP:20061027T010232Z
 107 DTSTART;TZID=/softwarestudio.org/Olson_20011030_5/Pacific/Auckland:
 108  20061030T103000
 109 DTEND;TZID=/softwarestudio.org/Olson_20011030_5/Pacific/Auckland:
 110  20061030T113000
 111 TRANSP:OPAQUE
 112 SEQUENCE:3
 113 SUMMARY:Interview Linus Pauling
 114 CLASS:PRIVATE
 115 CREATED:20061027T022816
 116 LAST-MODIFIED:20061027T022816
 117 DESCRIPTION:I've already spoken to each of you about this\, this is just
 118  to ensure that it is in my calender :-)
 119 ORGANIZER;CN=Ian Winsleigh:MAILTO:ian@example.org
 120 ATTENDEE;CUTYPE=INDIVIDUAL;ROLE=REQ-PARTICIPANT;PARTSTAT=ACCEPTED;
 121  RSVP=TRUE;CN=Ian Winsleigh;LANGUAGE=en:MAILTO:ian@example.org
 122 ATTENDEE;CUTYPE=INDIVIDUAL;ROLE=REQ-PARTICIPANT;RSVP=TRUE;CN=Andrew
 123  Moughtonbeigh;LANGUAGE=en;PARTSTAT=ACCEPTED:MAILTO:andrew@example.org
 124 ATTENDEE;CUTYPE=INDIVIDUAL;ROLE=REQ-PARTICIPANT;PARTSTAT=NEEDS-ACTION;
 125  RSVP=TRUE;CN=David Callenius;LANGUAGE=en:MAILTO:dcallenius@example.org
 126 X-MICROSOFT-CDO-REPLYTIME:20061027T022816Z
 127 BEGIN:VALARM
 128 X-EVOLUTION-ALARM-UID:20061027T022803Z-4264-1000-1-2@ubu
 129 ACTION:DISPLAY
 130 TRIGGER;VALUE=DURATION;RELATED=START:-PT15M
 131 END:VALARM
 132 END:VEVENT
 133 BEGIN:VEVENT
 134 X-LIC-ERROR;X-LIC-ERRORTYPE=VALUE-PARSE-ERROR:No value for UID property.
 135  Removing entire property:
 136 DTSTAMP:20061025T193258Z
 137 DTSTART;TZID=/softwarestudio.org/Olson_20011030_5/Pacific/Auckland:
 138  20061026T150000
 139 DTEND;TZID=/softwarestudio.org/Olson_20011030_5/Pacific/Auckland:
 140  20061026T160000
 141 TRANSP:OPAQUE
 142 SEQUENCE:3
 143 SUMMARY:Performance Review - David C
 144 CLASS:PRIVATE
 145 ORGANIZER;CN=Ian Winsleigh:MAILTO:ian@example.org
 146 ATTENDEE;CUTYPE=INDIVIDUAL;ROLE=REQ-PARTICIPANT;PARTSTAT=ACCEPTED;
 147  RSVP=TRUE;CN=Ian Winsleigh;LANGUAGE=en:MAILTO:ian@example.org
 148 ATTENDEE;CUTYPE=INDIVIDUAL;ROLE=REQ-PARTICIPANT;RSVP=TRUE;CN=David Callenius;
 149  LANGUAGE=en;PARTSTAT=ACCEPTED:MAILTO:dcallenius@example.org
 150 ATTENDEE;CUTYPE=INDIVIDUAL;ROLE=REQ-PARTICIPANT;RSVP=TRUE;CN=Andrew
 151  Moughtonbeigh;LANGUAGE=en;PARTSTAT=ACCEPTED:MAILTO:andrew@example.org
 152 ATTENDEE;CUTYPE=INDIVIDUAL;ROLE=REQ-PARTICIPANT;RSVP=TRUE;CN=David
 153  Smith;LANGUAGE=en;PARTSTAT=ACCEPTED:MAILTO:dave2@example.org
 154 CREATED:20061025T210902
 155 LAST-MODIFIED:20061025T210902
 156 UID:20061025T210650Z-21440-1000-1-8@ubu
 157 X-MICROSOFT-CDO-REPLYTIME:20061025T210902Z
 158 BEGIN:VALARM
 159 X-EVOLUTION-ALARM-UID:20061025T210650Z-21440-1000-1-9@ubu
 160 ACTION:DISPLAY
 161 TRIGGER;VALUE=DURATION;RELATED=START:-PT15M
 162 END:VALARM
 163 END:VEVENT
 164 BEGIN:VEVENT
 165 UID:20061019T022314Z-5014-1001-1-1@dolmein
 166 DTSTAMP:20061019T022452Z
 167 DTSTART;TZID=/softwarestudio.org/Olson_20011030_5/Pacific/Auckland:
 168  20061025T150000
 169 DTEND;TZID=/softwarestudio.org/Olson_20011030_5/Pacific/Auckland:
 170  20061025T160000
 171 TRANSP:OPAQUE
 172 SEQUENCE:2
 173 SUMMARY:Performance Review - David C
 174 CLASS:PRIVATE
 175 ORGANIZER;CN=Ian Winsleigh:MAILTO:ian@example.org
 176 ATTENDEE;CUTYPE=INDIVIDUAL;ROLE=REQ-PARTICIPANT;PARTSTAT=ACCEPTED;
 177  RSVP=TRUE;CN=Ian Winsleigh;LANGUAGE=en:MAILTO:ian@example.org
 178 ATTENDEE;CUTYPE=INDIVIDUAL;ROLE=REQ-PARTICIPANT;PARTSTAT=NEEDS-ACTION;
 179  RSVP=TRUE;CN=David Callenius;LANGUAGE=en:MAILTO:dcallenius@example.org
 180 ATTENDEE;CUTYPE=INDIVIDUAL;ROLE=REQ-PARTICIPANT;RSVP=TRUE;CN=Andrew
 181  Moughtonbeigh;LANGUAGE=en;PARTSTAT=ACCEPTED:MAILTO:andrew@example.org
 182 ATTENDEE;CUTYPE=INDIVIDUAL;ROLE=REQ-PARTICIPANT;PARTSTAT=NEEDS-ACTION;
 183  RSVP=TRUE;CN=David Smith;LANGUAGE=en:MAILTO:dave2@example.org
 184 X-MICROSOFT-CDO-REPLYTIME:20061020T071245Z
 185 CREATED:20061020T071245
 186 LAST-MODIFIED:20061020T071245
 187 BEGIN:VALARM
 188 X-EVOLUTION-ALARM-UID:20061020T071222Z-7292-1000-1-2@ubu
 189 ACTION:DISPLAY
 190 TRIGGER;VALUE=DURATION;RELATED=START:-PT15M
 191 END:VALARM
 192 END:VEVENT
 193 BEGIN:VEVENT
 194 UID:20060918T011246Z-21151-1000-1-10@ubu
 195 DTSTAMP:20060918T011246Z
 196 DTSTART;TZID=/softwarestudio.org/Olson_20011030_5/Pacific/Auckland:
 197  20060928T173000
 198 DTEND;TZID=/softwarestudio.org/Olson_20011030_5/Pacific/Auckland:
 199  20060928T200000
 200 SUMMARY:Summer Festival drinks at the loaded hog
 201 CREATED:20060918T011251
 202 LAST-MODIFIED:20060918T011251
 203 BEGIN:VALARM
 204 X-EVOLUTION-ALARM-UID:20060918T011246Z-21149-1000-1-20@ubu
 205 ACTION:DISPLAY
 206 TRIGGER;VALUE=DURATION;RELATED=START:-PT15M
 207 DESCRIPTION:Summer Festival drinks at the loaded hog
 208 END:VALARM
 209 END:VEVENT
 210 BEGIN:VEVENT
 211 UID:20061029T195827Z-14356-1000-1-13@ubu
 212 DTSTAMP:20061029T195827Z
 213 DTSTART;TZID=/softwarestudio.org/Olson_20011030_5/Pacific/Auckland:
 214  20061030T160000
 215 DTEND;TZID=/softwarestudio.org/Olson_20011030_5/Pacific/Auckland:
 216  20061030T170000
 217 SUMMARY:IZPAXY
 218 CREATED:20061029T195828
 219 LAST-MODIFIED:20061029T195828
 220 BEGIN:VALARM
 221 X-EVOLUTION-ALARM-UID:20061029T195827Z-14353-1000-1-7@ubu
 222 ACTION:DISPLAY
 223 TRIGGER;VALUE=DURATION;RELATED=START:-PT15M
 224 DESCRIPTION:IZPAXY
 225 END:VALARM
 226 END:VEVENT
 227 BEGIN:VEVENT
 228 UID:20061011T232622Z-27447-1000-1-6@ubu
 229 DTSTAMP:20061011T232622Z
 230 DTSTART;TZID=/softwarestudio.org/Olson_20011030_4/Asia/Dubai:
 231  20061016T090000
 232 DTEND;TZID=/softwarestudio.org/Olson_20011030_4/Asia/Dubai:
 233  20061016T170000
 234 TRANSP:OPAQUE
 235 SEQUENCE:3
 236 SUMMARY:Dubai Day
 237 CLASS:PUBLIC
 238 CREATED:20061011T232657
 239 LAST-MODIFIED:20061011T232731
 240 BEGIN:VALARM
 241 X-EVOLUTION-ALARM-UID:20061011T232731Z-27445-1000-1-15@ubu
 242 DESCRIPTION:Dubai Day
 243 ACTION:DISPLAY
 244 TRIGGER;VALUE=DURATION;RELATED=START:-PT15M
 245 END:VALARM
 246 END:VEVENT
 247 BEGIN:VEVENT
 248 UID:86203AFD481A6C42892013E6E0C4845D039A2543@AKEXBE02.telecom.tcnz.net
 249 DTSTAMP:20061005T230724Z
 250 DTSTART:20070120T093000
 251 SUMMARY:Reminder for Mark for Absolom Livasathan's PGP WF Services cost
 252  request
 253 DESCRIPTION:From Absolom.Livasathan@example.com Fri Oct  6 12:00:02 2006\n
 254 ORGANIZER;CN=Absolom Livasathan:Absolom.Livasathan@example.com
 255 ATTENDEE;RSVP=FALSE;CN=:andrew@example.org
 256 CREATED:20061005T230724
 257 LAST-MODIFIED:20061005T230724
 258 END:VEVENT
 259 BEGIN:VEVENT
 260 UID:20061219T104451Z-28207-1000-1-8@ubu
 261 DTSTAMP:20061219T104451Z
 262 DTSTART;TZID=/softwarestudio.org/Olson_20011030_5/Pacific/Auckland:
 263  20061222T140000
 264 DTEND;TZID=/softwarestudio.org/Olson_20011030_5/Pacific/Auckland:
 265  20061222T150000
 266 TRANSP:OPAQUE
 267 SEQUENCE:2
 268 SUMMARY:Those who are left will have a drink to celebrate the new
 269  calendar
 270 LOCATION:The Boardroom
 271 CLASS:PUBLIC
 272 ORGANIZER;CN=Andrew Moughtonbeigh:MAILTO:andrew@example.org
 273 ATTENDEE;CUTYPE=INDIVIDUAL;ROLE=REQ-PARTICIPANT;PARTSTAT=ACCEPTED;
 274  RSVP=TRUE;CN=Andrew Moughtonbeigh;LANGUAGE=en:MAILTO:andrew@example.org
 275 ATTENDEE;CUTYPE=INDIVIDUAL;ROLE=REQ-PARTICIPANT;PARTSTAT=NEEDS-ACTION;
 276  RSVP=TRUE;LANGUAGE=en:MAILTO:Boardroom@example.org
 277 CREATED:20061219T104635
 278 LAST-MODIFIED:20061219T104635
 279 BEGIN:VALARM
 280 X-EVOLUTION-ALARM-UID:20061219T104635Z-23686-1000-1-22@ubu
 281 DESCRIPTION:Those who are left will have a drink to celebrate the new
 282  calendar
 283 ACTION:DISPLAY
 284 TRIGGER;VALUE=DURATION;RELATED=START:-PT15M
 285 END:VALARM
 286 END:VEVENT
 287 BEGIN:VEVENT
 288 UID:20060914T212513Z-15783-1000-1-11@ubu
 289 DTSTAMP:20060914T212513Z
 290 DTSTART;TZID=/softwarestudio.org/Olson_20011030_5/Pacific/Auckland:
 291  20060918T140000
 292 DTEND;TZID=/softwarestudio.org/Olson_20011030_5/Pacific/Auckland:
 293  20060918T150000
 294 SUMMARY:Donovan
 295 X-EVOLUTION-CALDAV-HREF:http://mycaldav:
 296  80/caldav.php/andrew/20060914T212516Z.ics
 297 X-EVOLUTION-CALDAV-ETAG:"004c7b3de49835f714ae7962e8d06d3c"
 298 X-EVOLUTION-MOVE-CALENDAR:1
 299 CREATED:20060914T213552
 300 LAST-MODIFIED:20060914T213552
 301 BEGIN:VALARM
 302 X-EVOLUTION-ALARM-UID:20060914T212513Z-15781-1000-1-18@ubu
 303 ACTION:DISPLAY
 304 TRIGGER;VALUE=DURATION;RELATED=START:-PT15M
 305 DESCRIPTION:Donovan
 306 END:VALARM
 307 END:VEVENT
 308 BEGIN:VEVENT
 309 UID:20060906T123509Z-5231-1000-1-5@ubu
 310 DTSTAMP:20060906T123509Z
 311 DTSTART;TZID=/softwarestudio.org/Olson_20011030_5/Pacific/Auckland:
 312  20060911T103000
 313 DTEND;TZID=/softwarestudio.org/Olson_20011030_5/Pacific/Auckland:
 314  20060911T120000
 315 SUMMARY:NGOP by-election readiness.
 316 X-EVOLUTION-CALDAV-HREF:http://mycaldav:
 317  80/caldav.php/andrew/20060906T123515Z.ics
 318 X-EVOLUTION-CALDAV-ETAG:"9a39bedee743f397ebeeda78a4233c8b"
 319 X-EVOLUTION-MOVE-CALENDAR:1
 320 CREATED:20060907T093748
 321 LAST-MODIFIED:20060907T093748
 322 BEGIN:VALARM
 323 X-EVOLUTION-ALARM-UID:20060906T123509Z-5254-1000-1-0@ubu
 324 ACTION:DISPLAY
 325 TRIGGER;VALUE=DURATION;RELATED=START:-PT15M
 326 DESCRIPTION:NGOP by-election readiness.
 327 END:VALARM
 328 END:VEVENT
 329 BEGIN:VEVENT
 330 UID:20060903T233851Z-31623-1000-1-5@ubu
 331 DTSTAMP:20060903T233851Z
 332 DTSTART;TZID=/softwarestudio.org/Olson_20011030_5/Pacific/Auckland:
 333  20060907T123000
 334 DTEND;TZID=/softwarestudio.org/Olson_20011030_5/Pacific/Auckland:
 335  20060907T133000
 336 SUMMARY:Murray Flenshaw @ Copperstuff
 337 CREATED:20060903T233856
 338 LAST-MODIFIED:20060903T233856
 339 BEGIN:VALARM
 340 X-EVOLUTION-ALARM-UID:20060903T233851Z-31621-1000-1-0@ubu
 341 ACTION:DISPLAY
 342 TRIGGER;VALUE=DURATION;RELATED=START:-PT15M
 343 DESCRIPTION:Murray Flenshaw @ Copperstuff
 344 END:VALARM
 345 END:VEVENT
 346 BEGIN:VEVENT
 347 UID:20060920T052705Z-28287-1000-1-5@ubu
 348 DTSTAMP:20060920T052705Z
 349 DTSTART;TZID=/softwarestudio.org/Olson_20011030_5/Pacific/Auckland:
 350  20060921T160000
 351 DTEND;TZID=/softwarestudio.org/Olson_20011030_5/Pacific/Auckland:
 352  20060921T170000
 353 SUMMARY:Really Geeky Thoughts
 354 X-EVOLUTION-CALDAV-HREF:http:
 355  //andrew@mycaldav/caldav.php/andrew/20060920T052710Z.ics
 356 X-EVOLUTION-CALDAV-ETAG:"d9a4a80a3dbc76b947a3bf0f0672359c"
 357 X-EVOLUTION-MOVE-CALENDAR:1
 358 CREATED:20060920T052722
 359 LAST-MODIFIED:20060921T012657
 360 BEGIN:VALARM
 361 X-EVOLUTION-ALARM-UID:20060920T052705Z-28285-1000-1-7@ubu
 362 ACTION:DISPLAY
 363 TRIGGER;VALUE=DURATION;RELATED=START:-PT15M
 364 DESCRIPTION:Really Geeky Thoughts
 365 END:VALARM
 366 END:VEVENT
 367 BEGIN:VEVENT
 368 UID:20060918T011217Z-21151-1000-1-9@ubu
 369 DTSTAMP:20060918T011217Z
 370 DTSTART;VALUE=DATE:20060928
 371 DTEND;VALUE=DATE:20060930
 372 SUMMARY:Summer Festival
 373 CREATED:20060918T011218
 374 LAST-MODIFIED:20060918T011218
 375 BEGIN:VALARM
 376 X-EVOLUTION-ALARM-UID:20060918T011217Z-21149-1000-1-19@ubu
 377 ACTION:DISPLAY
 378 TRIGGER;VALUE=DURATION;RELATED=START:-PT15M
 379 DESCRIPTION:Summer Festival
 380 END:VALARM
 381 END:VEVENT
 382 BEGIN:VEVENT
 383 UID:20060912T233427Z-12681-1000-1-5@ubu
 384 DTSTAMP:20060912T233427Z
 385 DTSTART;TZID=/softwarestudio.org/Olson_20011030_5/Europe/Helsinki:
 386  20060913T090000
 387 DTEND;TZID=/softwarestudio.org/Olson_20011030_5/Europe/Helsinki:
 388  20060913T143000
 389 TRANSP:OPAQUE
 390 SEQUENCE:5
 391 SUMMARY:9:am - 2:30pm in Helsinki
 392 CLASS:PUBLIC
 393 X-EVOLUTION-CALDAV-HREF:http://mycaldav:
 394  80/caldav.php/andrew/20060912T233500Z.ics
 395 X-EVOLUTION-CALDAV-ETAG:"8d8ca5e838b7e088bf17d9916032eec6"
 396 X-EVOLUTION-MOVE-CALENDAR:1
 397 CREATED:20060913T003545
 398 LAST-MODIFIED:20060913T003631
 399 BEGIN:VALARM
 400 X-EVOLUTION-ALARM-UID:20060913T003631Z-12694-1000-1-24@ubu
 401 DESCRIPTION:9:am - 2:30pm in Helsinki
 402 ACTION:DISPLAY
 403 TRIGGER;VALUE=DURATION;RELATED=START:-PT15M
 404 END:VALARM
 405 END:VEVENT
 406 BEGIN:VEVENT
 407 UID:20060803T084628Z-6040-1000-1-6@lamb
 408 DTSTAMP:20060803T084628Z
 409 DTSTART:20060801T123456
 410 DTEND:20060802T123456
 411 SUMMARY:Steve's Private Birthday
 412 CREATED:20060803T084628
 413 LAST-MODIFIED:20060803T084657
 414 CLASS:PRIVATE
 415 TRANSP:OPAQUE
 416 RRULE:FREQ=YEARLY;INTERVAL=1
 417 SEQUENCE:1
 418 BEGIN:VALARM
 419 X-EVOLUTION-ALARM-UID:20060803T084657Z-6038-1000-1-13@lamb
 420 DESCRIPTION:Steve's Birthday
 421 ACTION:DISPLAY
 422 TRIGGER;VALUE=DURATION;RELATED=START:-PT15M
 423 END:VALARM
 424 END:VEVENT
 425 BEGIN:VEVENT
 426 UID:20061210T214816Z-5064-1001-1-0@dolmein
 427 DTSTAMP:20061210T215058Z
 428 DTSTART;TZID=/softwarestudio.org/Olson_20011030_5/Pacific/Auckland:
 429  20061212T100000
 430 DTEND;TZID=/softwarestudio.org/Olson_20011030_5/Pacific/Auckland:
 431  20061212T110000
 432 TRANSP:OPAQUE
 433 SEQUENCE:3
 434 SUMMARY:Interview - Arthur Williams
 435 CLASS:PRIVATE
 436 CREATED:20061211T020841
 437 LAST-MODIFIED:20061211T020841
 438 DESCRIPTION:I think you all have had a copy of Arthur Williams's CV
 439  passed onto you.
 440 ORGANIZER;CN=Ian Winsleigh:MAILTO:ian@example.org
 441 ATTENDEE;CUTYPE=INDIVIDUAL;ROLE=REQ-PARTICIPANT;PARTSTAT=ACCEPTED;
 442  RSVP=TRUE;CN=Ian Winsleigh;LANGUAGE=en:MAILTO:ian@example.org
 443 ATTENDEE;CUTYPE=INDIVIDUAL;ROLE=REQ-PARTICIPANT;PARTSTAT=NEEDS-ACTION;
 444  RSVP=TRUE;CN=Gerrold Nimby;LANGUAGE=en:MAILTO:gerrold@example.org
 445 ATTENDEE;CUTYPE=INDIVIDUAL;ROLE=REQ-PARTICIPANT;PARTSTAT=NEEDS-ACTION;
 446  RSVP=TRUE;CN=David Callenius;LANGUAGE=en:MAILTO:dcallenius@example.org
 447 ATTENDEE;CUTYPE=INDIVIDUAL;ROLE=REQ-PARTICIPANT;RSVP=TRUE;CN=Andrew
 448  Moughtonbeigh;LANGUAGE=en;PARTSTAT=ACCEPTED:MAILTO:andrew@example.org
 449 X-MICROSOFT-CDO-REPLYTIME:20061211T020841Z
 450 BEGIN:VALARM
 451 X-EVOLUTION-ALARM-UID:20061211T020828Z-15443-1000-1-0@ubu
 452 ACTION:DISPLAY
 453 TRIGGER;VALUE=DURATION;RELATED=START:-PT15M
 454 END:VALARM
 455 END:VEVENT
 456 BEGIN:VEVENT
 457 UID:20060907T213951Z-5189-1001-1-0@dolmein
 458 DTSTAMP:20060914T042719Z
 459 DTSTART;TZID=/softwarestudio.org/Olson_20011030_5/Pacific/Auckland:
 460  20060915T100000
 461 DTEND;TZID=/softwarestudio.org/Olson_20011030_5/Pacific/Auckland:
 462  20060915T110000
 463 TRANSP:OPAQUE
 464 SEQUENCE:2
 465 SUMMARY:Sysadmin -> Development
 466 CLASS:PRIVATE
 467 ORGANIZER;CN=Ian Winsleigh:MAILTO:ian@example.org
 468 ATTENDEE;CUTYPE=INDIVIDUAL;ROLE=REQ-PARTICIPANT;PARTSTAT=ACCEPTED;
 469  RSVP=TRUE;CN=Ian Winsleigh;LANGUAGE=en:MAILTO:ian@example.org
 470 ATTENDEE;CUTYPE=INDIVIDUAL;ROLE=REQ-PARTICIPANT;RSVP=TRUE;CN=Andrew
 471  Moughtonbeigh;LANGUAGE=en;PARTSTAT=ACCEPTED:MAILTO:andrew@example.org
 472 ATTENDEE;CUTYPE=INDIVIDUAL;ROLE=REQ-PARTICIPANT;RSVP=TRUE;CN=Richard
 473  Hector;LANGUAGE=en;PARTSTAT=ACCEPTED:MAILTO:richard@example.org
 474 CREATED:20060914T051701
 475 LAST-MODIFIED:20060914T051701
 476 X-MICROSOFT-CDO-REPLYTIME:20060914T051701Z
 477 BEGIN:VALARM
 478 X-EVOLUTION-ALARM-UID:20060914T051626Z-5898-1000-1-0@ubu
 479 ACTION:DISPLAY
 480 TRIGGER;VALUE=DURATION;RELATED=START:-PT15M
 481 END:VALARM
 482 END:VEVENT
 483 BEGIN:VEVENT
 484 UID:20060905T231045Z-16025-1000-1-6@ubu
 485 DTSTAMP:20060905T231045Z
 486 DTSTART;TZID=/softwarestudio.org/Olson_20011030_5/Pacific/Auckland:
 487  20060919T090000
 488 DTEND;TZID=/softwarestudio.org/Olson_20011030_5/Pacific/Auckland:
 489  20060919T120000
 490 SUMMARY:NGOP Meeting
 491 X-EVOLUTION-CALDAV-HREF:http://mycaldav:
 492  80/caldav.php/andrew/20060905T231053Z.ics
 493 X-EVOLUTION-CALDAV-ETAG:"4d37ed48425acb9f4245539e2d2b726b"
 494 X-EVOLUTION-MOVE-CALENDAR:1
 495 CREATED:20060907T093732
 496 LAST-MODIFIED:20060911T214556
 497 CLASS:PUBLIC
 498 TRANSP:OPAQUE
 499 SEQUENCE:1
 500 BEGIN:VALARM
 501 X-EVOLUTION-ALARM-UID:20060911T214556Z-21593-1000-1-6@ubu
 502 DESCRIPTION:NGOP Meeting
 503 ACTION:DISPLAY
 504 TRIGGER;VALUE=DURATION;RELATED=START:-PT15M
 505 END:VALARM
 506 END:VEVENT
 507 BEGIN:VEVENT
 508 DTSTART;TZID=Pacific/Auckland:20061220T140000
 509 SUMMARY:Really Geeky round table
 510 UID:DC9C0944-D80A-426D-A4A4-6003C72BA7B5
 511 ORGANIZER;CN=Chris Dalgleish:mailto:chris@example.org
 512 SEQUENCE:2
 513 DTSTAMP:20061219T195427Z
 514 DURATION:PT1H
 515 TRANSP:OPAQUE
 516 X-LIC-ERROR;X-LIC-ERRORTYPE=VALUE-PARSE-ERROR:No value for ATTENDEE
 517  property. Removing entire property:
 518 X-MICROSOFT-CDO-REPLYTIME:20061219T225056Z
 519 CREATED:20061219T225056
 520 LAST-MODIFIED:20061219T225056
 521 BEGIN:VALARM
 522 X-EVOLUTION-ALARM-UID:20061219T225040Z-21169-1000-1-13@ubu
 523 ACTION:DISPLAY
 524 TRIGGER;VALUE=DURATION;RELATED=START:-PT15M
 525 END:VALARM
 526 END:VEVENT
 527 BEGIN:VEVENT
 528 UID:20061101T224855Z-5026-1001-1-0@dolmein
 529 DTSTAMP:20061101T225011Z
 530 DTSTART;TZID=/softwarestudio.org/Olson_20011030_5/Pacific/Auckland:
 531  20061102T140000
 532 DTEND;TZID=/softwarestudio.org/Olson_20011030_5/Pacific/Auckland:
 533  20061102T150000
 534 TRANSP:OPAQUE
 535 SEQUENCE:3
 536 SUMMARY:Sysadmin Interview
 537 CLASS:PRIVATE
 538 CREATED:20061101T230424
 539 LAST-MODIFIED:20061101T230424
 540 ORGANIZER;CN=Ian Winsleigh:MAILTO:ian@example.org
 541 ATTENDEE;CUTYPE=INDIVIDUAL;ROLE=REQ-PARTICIPANT;PARTSTAT=ACCEPTED;
 542  RSVP=TRUE;CN=Ian Winsleigh;LANGUAGE=en:MAILTO:ian@example.org
 543 ATTENDEE;CUTYPE=INDIVIDUAL;ROLE=REQ-PARTICIPANT;PARTSTAT=NEEDS-ACTION;
 544  RSVP=TRUE;CN=David Callenius;LANGUAGE=en:MAILTO:dcallenius@example.org
 545 ATTENDEE;CUTYPE=INDIVIDUAL;ROLE=REQ-PARTICIPANT;PARTSTAT=NEEDS-ACTION;
 546  RSVP=TRUE;CN=Gerrold Nimby;LANGUAGE=en:MAILTO:gerrold@example.org
 547 ATTENDEE;CUTYPE=INDIVIDUAL;ROLE=REQ-PARTICIPANT;RSVP=TRUE;CN=Andrew
 548  Moughtonbeigh;LANGUAGE=en;PARTSTAT=ACCEPTED:MAILTO:andrew@example.org
 549 X-MICROSOFT-CDO-REPLYTIME:20061101T230424Z
 550 BEGIN:VALARM
 551 X-EVOLUTION-ALARM-UID:20061101T230356Z-1895-1000-1-0@ubu
 552 ACTION:DISPLAY
 553 TRIGGER;VALUE=DURATION;RELATED=START:-PT15M
 554 END:VALARM
 555 END:VEVENT
 556 BEGIN:VEVENT
 557 UID:20060918T071919Z-21151-1000-1-13@ubu
 558 DTSTAMP:20060918T071919Z
 559 DTSTART;TZID=/softwarestudio.org/Olson_20011030_5/Pacific/Auckland:
 560  20060925T120000
 561 DTEND;TZID=/softwarestudio.org/Olson_20011030_5/Pacific/Auckland:
 562  20060925T133000
 563 SUMMARY:Board Meeting
 564 CREATED:20060918T071921
 565 LAST-MODIFIED:20060918T071921
 566 BEGIN:VALARM
 567 X-EVOLUTION-ALARM-UID:20060918T071919Z-21149-1000-1-51@ubu
 568 ACTION:DISPLAY
 569 TRIGGER;VALUE=DURATION;RELATED=START:-PT15M
 570 DESCRIPTION:Board Meeting
 571 END:VALARM
 572 END:VEVENT
 573 BEGIN:VEVENT
 574 UID:20061119T202229Z-5105-1000-5103-9@ubu
 575 DTSTAMP:20061119T202229Z
 576 DTSTART;TZID=/softwarestudio.org/Olson_20011030_5/Pacific/Auckland:
 577  20061120T110000
 578 DTEND;TZID=/softwarestudio.org/Olson_20011030_5/Pacific/Auckland:
 579  20061120T120000
 580 SUMMARY:IZPAXY Review
 581 CREATED:20061119T202231
 582 LAST-MODIFIED:20061119T202231
 583 BEGIN:VALARM
 584 X-EVOLUTION-ALARM-UID:20061119T202229Z-5101-1000-1-18@ubu
 585 ACTION:DISPLAY
 586 TRIGGER;VALUE=DURATION;RELATED=START:-PT15M
 587 DESCRIPTION:IZPAXY Review
 588 END:VALARM
 589 END:VEVENT
 590 BEGIN:VEVENT
 591 UID:20061026T222249Z-5029-1001-1-0@dolmein
 592 DTSTAMP:20061026T223020Z
 593 DTSTART;TZID=/softwarestudio.org/Olson_20011030_5/Pacific/Auckland:
 594  20061030T140000
 595 DTEND;TZID=/softwarestudio.org/Olson_20011030_5/Pacific/Auckland:
 596  20061030T160000
 597 TRANSP:OPAQUE
 598 SEQUENCE:3
 599 SUMMARY:ABC
 600 CLASS:PRIVATE
 601 CREATED:20061026T223700
 602 LAST-MODIFIED:20061026T223700
 603 DESCRIPTION:Mark and Tom from ABC would like to discuss the work required
 604  and estimate for the work they would like us to do - \"start to become
 605  specific about things\".  Expectations of work\, issues and solutions.
 606 ORGANIZER;CN=Ian Winsleigh:MAILTO:ian@example.org
 607 ATTENDEE;CUTYPE=INDIVIDUAL;ROLE=REQ-PARTICIPANT;PARTSTAT=ACCEPTED;
 608  RSVP=TRUE;CN=Ian Winsleigh;LANGUAGE=en:MAILTO:ian@example.org
 609 ATTENDEE;CUTYPE=INDIVIDUAL;ROLE=REQ-PARTICIPANT;RSVP=TRUE;CN=Andrew
 610  Moughtonbeigh;LANGUAGE=en;PARTSTAT=TENTATIVE:MAILTO:andrew@example.org
 611 ATTENDEE;CUTYPE=INDIVIDUAL;ROLE=REQ-PARTICIPANT;PARTSTAT=NEEDS-ACTION;
 612  RSVP=TRUE;CN=David Callenius;LANGUAGE=en:MAILTO:dcallenius@example.org
 613 ATTENDEE;CUTYPE=INDIVIDUAL;ROLE=REQ-PARTICIPANT;PARTSTAT=NEEDS-ACTION;
 614  RSVP=TRUE;CN=Andy Capp;LANGUAGE=en:MAILTO:andyc@example.org
 615 X-MICROSOFT-CDO-REPLYTIME:20061026T223700Z
 616 BEGIN:VALARM
 617 X-EVOLUTION-ALARM-UID:20061026T223608Z-4264-1000-1-0@ubu
 618 ACTION:DISPLAY
 619 TRIGGER;VALUE=DURATION;RELATED=START:-PT15M
 620 END:VALARM
 621 END:VEVENT
 622 BEGIN:VEVENT
 623 UID:20061019T022147Z-5014-1001-1-0@dolmein
 624 DTSTAMP:20061019T022247Z
 625 DTSTART;TZID=/softwarestudio.org/Olson_20011030_5/Pacific/Auckland:
 626  20061025T133000
 627 DTEND;TZID=/softwarestudio.org/Olson_20011030_5/Pacific/Auckland:
 628  20061025T143000
 629 TRANSP:OPAQUE
 630 SEQUENCE:2
 631 SUMMARY:Performance Review - Jon C
 632 CLASS:PRIVATE
 633 ORGANIZER;CN=Ian Winsleigh:MAILTO:ian@example.org
 634 ATTENDEE;CUTYPE=INDIVIDUAL;ROLE=REQ-PARTICIPANT;PARTSTAT=ACCEPTED;
 635  RSVP=TRUE;CN=Ian Winsleigh;LANGUAGE=en:MAILTO:ian@example.org
 636 ATTENDEE;CUTYPE=INDIVIDUAL;ROLE=REQ-PARTICIPANT;PARTSTAT=NEEDS-ACTION;
 637  RSVP=TRUE;CN=Jon Callenius;LANGUAGE=en:MAILTO:jon@example.org
 638 ATTENDEE;CUTYPE=INDIVIDUAL;ROLE=REQ-PARTICIPANT;RSVP=TRUE;CN=Andrew
 639  Moughtonbeigh;LANGUAGE=en;PARTSTAT=ACCEPTED:MAILTO:andrew@example.org
 640 ATTENDEE;CUTYPE=INDIVIDUAL;ROLE=REQ-PARTICIPANT;PARTSTAT=NEEDS-ACTION;
 641  RSVP=TRUE;CN=David Smith;LANGUAGE=en:MAILTO:dave2@example.org
 642 X-MICROSOFT-CDO-REPLYTIME:20061020T071144Z
 643 CREATED:20061020T071144
 644 LAST-MODIFIED:20061020T071144
 645 BEGIN:VALARM
 646 X-EVOLUTION-ALARM-UID:20061020T071108Z-7292-1000-1-0@ubu
 647 ACTION:DISPLAY
 648 TRIGGER;VALUE=DURATION;RELATED=START:-PT15M
 649 END:VALARM
 650 END:VEVENT
 651 BEGIN:VEVENT
 652 UID:20061009T214137Z-5718-1001-1-1@dolmein
 653 DTSTAMP:20061009T214524Z
 654 DTSTART;TZID=/softwarestudio.org/Olson_20011030_5/Pacific/Auckland:
 655  20061012T140000
 656 DTEND;TZID=/softwarestudio.org/Olson_20011030_5/Pacific/Auckland:
 657  20061012T150000
 658 TRANSP:OPAQUE
 659 SEQUENCE:2
 660 SUMMARY:Sysadmin Interview
 661 LOCATION:Copperstuff\, Level 2\, 150 Walthias St
 662 CLASS:PRIVATE
 663 ORGANIZER;CN=Ian Winsleigh:MAILTO:ian@example.org
 664 ATTENDEE;CUTYPE=INDIVIDUAL;ROLE=REQ-PARTICIPANT;PARTSTAT=ACCEPTED;
 665  RSVP=TRUE;CN=Ian Winsleigh;LANGUAGE=en:MAILTO:ian@example.org
 666 ATTENDEE;CUTYPE=INDIVIDUAL;ROLE=REQ-PARTICIPANT;RSVP=TRUE;CN=Andrew
 667  Moughtonbeigh;LANGUAGE=en;PARTSTAT=ACCEPTED:MAILTO:andrew@example.org
 668 ATTENDEE;CUTYPE=INDIVIDUAL;ROLE=REQ-PARTICIPANT;PARTSTAT=NEEDS-ACTION;
 669  RSVP=TRUE;CN=David Callenius;LANGUAGE=en:MAILTO:dcallenius@example.org
 670 ATTENDEE;CUTYPE=INDIVIDUAL;ROLE=REQ-PARTICIPANT;PARTSTAT=NEEDS-ACTION;
 671  RSVP=TRUE;LANGUAGE=en:MAILTO:jo@example.net
 672 X-MICROSOFT-CDO-REPLYTIME:20061010T014639Z
 673 CREATED:20061010T014639
 674 LAST-MODIFIED:20061010T014639
 675 BEGIN:VALARM
 676 X-EVOLUTION-ALARM-UID:20061010T014606Z-6897-1000-1-2@ubu
 677 ACTION:DISPLAY
 678 TRIGGER;VALUE=DURATION;RELATED=START:-PT15M
 679 END:VALARM
 680 END:VEVENT
 681 BEGIN:VTIMEZONE
 682 TZID:/softwarestudio.org/Olson_20011030_5/Pacific/Auckland
 683 X-LIC-LOCATION:Pacific/Auckland
 684 BEGIN:STANDARD
 685 TZOFFSETFROM:+1300
 686 TZOFFSETTO:+1200
 687 TZNAME:NZST
 688 DTSTART:19700315T030000
 689 RRULE:FREQ=YEARLY;INTERVAL=1;BYDAY=3SU;BYMONTH=3
 690 END:STANDARD
 691 BEGIN:DAYLIGHT
 692 TZOFFSETFROM:+1200
 693 TZOFFSETTO:+1300
 694 TZNAME:NZDT
 695 DTSTART:19701004T020000
 696 RRULE:FREQ=YEARLY;INTERVAL=1;BYDAY=1SU;BYMONTH=10
 697 END:DAYLIGHT
 698 END:VTIMEZONE
 699 BEGIN:VTIMEZONE
 700 TZID:Pacific/Auckland
 701 BEGIN:STANDARD
 702 TZOFFSETFROM:+1300
 703 TZOFFSETTO:+1200
 704 DTSTART:19900318T030000
 705 RRULE:FREQ=YEARLY;UNTIL=20070317T140000Z;BYMONTH=3;BYDAY=3SU
 706 TZNAME:NZST
 707 END:STANDARD
 708 BEGIN:DAYLIGHT
 709 TZOFFSETFROM:+1200
 710 TZOFFSETTO:+1300
 711 DTSTART:20070930T020000
 712 RRULE:FREQ=YEARLY;BYMONTH=9;BYDAY=-1SU
 713 TZNAME:NZDT
 714 END:DAYLIGHT
 715 BEGIN:STANDARD
 716 TZOFFSETFROM:+1300
 717 TZOFFSETTO:+1200
 718 DTSTART:20080406T030000
 719 RRULE:FREQ=YEARLY;BYMONTH=4;BYDAY=1SU
 720 TZNAME:NZST
 721 END:STANDARD
 722 END:VTIMEZONE
 723 END:VCALENDAR
 724 ENDDATA
 725
 726 QUERY
 727 SELECT count(*) AS caldav_data FROM caldav_data WHERE dav_name ~ '^/user1/anotherone/'
 728 ENDQUERY
 729
 730 QUERY
 731 SELECT count(*) AS calendar_item FROM calendar_item WHERE dav_name ~ '^/user1/anotherone/'
 732 ENDQUERY
 733
 734 QUERY
 735 SELECT count(*) AS alarms FROM calendar_alarm JOIN calendar_item USING(dav_id)
 736   WHERE dav_name ~ '^/user1/anotherone/'
 737 ENDQUERY
 738
 739 QUERY
 740 SELECT count(*) AS attendees FROM calendar_attendee JOIN calendar_item USING(dav_id)
 741   WHERE dav_name ~ '^/user1/anotherone/'
 742 ENDQUERY
 743
 744 QUERY
 745 SELECT
 746      collection_id,
 747    dav_displayname,
 748           dav_etag,
 749           dav_name,
 750 default_privileges,
 751        description,
 752     is_addressbook,
 753        is_calendar,
 754   parent_container,
 755 public_events_only,
 756      resourcetypes,
 757    schedule_transp,
 758           timezone,
 759            user_no,
 760  publicly_readable
 761  FROM collection WHERE dav_name = '/user1/anotherone/'
 762 ENDQUERY