testing/tests/regression-suite/0997-PUT-many-overrides.test

   1 #
   2 # Attempt to put an event containing many overrides
   3 #
   4 TYPE=PUT
   5 URL=http://regression.host/caldav.php/User%20Six/home/c0f7c860-1345-012d-125f-002421a2359e.ics
   6
   7 HEADER=Content-Type: text/calendar; charset=utf-8
   8 AUTH=User Six:user6
   9
  10 BEGINDATA
  11 BEGIN:VCALENDAR
  12 PRODID:-//Mozilla.org/NONSGML Mozilla Calendar V1.1//EN
  13 VERSION:2.0
  14 BEGIN:VTIMEZONE
  15 TZID:Europe/Zagreb
  16 X-LIC-LOCATION:Europe/Zagreb
  17 BEGIN:DAYLIGHT
  18 TZOFFSETFROM:+0100
  19 TZOFFSETTO:+0200
  20 TZNAME:CEST
  21 DTSTART:19700329T020000
  22 RRULE:FREQ=YEARLY;BYDAY=-1SU;BYMONTH=3
  23 END:DAYLIGHT
  24 BEGIN:STANDARD
  25 TZOFFSETFROM:+0200
  26 TZOFFSETTO:+0100
  27 TZNAME:CET
  28 DTSTART:19701025T030000
  29 RRULE:FREQ=YEARLY;BYDAY=-1SU;BYMONTH=10
  30 END:STANDARD
  31 END:VTIMEZONE
  32 BEGIN:VEVENT
  33 CREATED:20101126T133639Z
  34 LAST-MODIFIED:20101126T133639Z
  35 DTSTAMP:20101126T133640Z
  36 UID:KOrganizer-1348288421.174
  37 SUMMARY:Kosarkaska utakmica
  38 DTSTART;TZID=Europe/Zagreb:20101128T110000
  39 DTEND;TZID=Europe/Zagreb:20101128T130000
  40 LOCATION:Zagrebacki velesajam
  41 TRANSP:OPAQUE
  42 END:VEVENT
  43 BEGIN:VEVENT
  44 CREATED:20110402T095510Z
  45 LAST-MODIFIED:20110402T095533Z
  46 DTSTAMP:20110402T095533Z
  47 UID:9fc3d340-fd02-4198-9b7f-bd9b339fdf01
  48 SUMMARY:SOKAZ
  49 DTSTART;TZID=Europe/Zagreb:20110329T193000
  50 DTEND;TZID=Europe/Zagreb:20110329T220000
  51 TRANSP:OPAQUE
  52 END:VEVENT
  53 BEGIN:VEVENT
  54 CREATED:20110406T222101Z
  55 LAST-MODIFIED:20110406T222129Z
  56 DTSTAMP:20110406T222129Z
  57 UID:b5185f5f-c60d-43e2-8727-d73b05f0b403
  58 SUMMARY:SOKAZ
  59 DTSTART;TZID=Europe/Zagreb:20110408T180000
  60 DTEND;TZID=Europe/Zagreb:20110408T210000
  61 TRANSP:OPAQUE
  62 END:VEVENT
  63 BEGIN:VEVENT
  64 CREATED:20110405T141057Z
  65 LAST-MODIFIED:20110410T105121Z
  66 DTSTAMP:20110410T105121Z
  67 UID:ad2e3d46-338c-4123-bfed-edf0d06a3f5d
  68 SUMMARY:Vaterpolo PMF
  69 DTSTART;TZID=Europe/Zagreb:20110411T120000
  70 DTEND;TZID=Europe/Zagreb:20110411T130000
  71 TRANSP:OPAQUE
  72 END:VEVENT
  73 BEGIN:VEVENT
  74 CREATED:20110406T222101Z
  75 LAST-MODIFIED:20110412T145952Z
  76 DTSTAMP:20110412T145952Z
  77 UID:97f37cf2-a89a-4eb9-aff7-024e21d4ac63
  78 SUMMARY:SOKAZ
  79 DTSTART;TZID=Europe/Zagreb:20110413T200000
  80 DTEND;TZID=Europe/Zagreb:20110413T230000
  81 TRANSP:OPAQUE
  82 END:VEVENT
  83 BEGIN:VEVENT
  84 CREATED:20110417T133012Z
  85 LAST-MODIFIED:20110417T133033Z
  86 DTSTAMP:20110417T133033Z
  87 UID:d98993b2-3fc1-4f40-a3b7-1744f2eff118
  88 SUMMARY:SOKAZ
  89 DTSTART;TZID=Europe/Zagreb:20110419T193000
  90 DTEND;TZID=Europe/Zagreb:20110419T223000
  91 TRANSP:OPAQUE
  92 END:VEVENT
  93 BEGIN:VEVENT
  94 CREATED:20110320T103444Z
  95 LAST-MODIFIED:20110509T075204Z
  96 DTSTAMP:20110509T075204Z
  97 UID:d9600248-ff59-45aa-a08b-d16d09f7443c
  98 SUMMARY:Stolni tenis
  99 DTSTART;TZID=Europe/Zagreb:20110509T150000
 100 DTEND;TZID=Europe/Zagreb:20110509T160000
 101 LOCATION:PBF
 102 TRANSP:OPAQUE
 103 END:VEVENT
 104 BEGIN:VEVENT
 105 CREATED:20110320T103420Z
 106 LAST-MODIFIED:20110320T103436Z
 107 DTSTAMP:20110320T103436Z
 108 UID:bf913c7d-8e42-4d30-989b-3f86c3e7f130
 109 SUMMARY:SOKAZ
 110 DTSTART;TZID=Europe/Zagreb:20110322T200000
 111 DTEND;TZID=Europe/Zagreb:20110322T230000
 112 TRANSP:OPAQUE
 113 END:VEVENT
 114 BEGIN:VEVENT
 115 CREATED:20110414T134428Z
 116 LAST-MODIFIED:20110414T134446Z
 117 DTSTAMP:20110414T134446Z
 118 UID:6d870107-9251-4eb1-baff-9cc9c9d995a0
 119 SUMMARY:Vaterpolo
 120 DTSTART;TZID=Europe/Zagreb:20110415T120000
 121 DTEND;TZID=Europe/Zagreb:20110415T130000
 122 TRANSP:OPAQUE
 123 END:VEVENT
 124 BEGIN:VEVENT
 125 CREATED:20110320T103444Z
 126 LAST-MODIFIED:20110320T103513Z
 127 DTSTAMP:20110320T103513Z
 128 UID:b79f6edf-3b11-439f-85af-7eca5d5e7d6e
 129 SUMMARY:Stolni tenis
 130 DTSTART;TZID=Europe/Zagreb:20110321T150000
 131 DTEND;TZID=Europe/Zagreb:20110321T160000
 132 LOCATION:PBF
 133 TRANSP:OPAQUE
 134 END:VEVENT
 135 BEGIN:VEVENT
 136 CREATED:20110405T141057Z
 137 LAST-MODIFIED:20110405T141143Z
 138 DTSTAMP:20110405T141143Z
 139 UID:3bc03dfc-c7e1-4500-ae67-a17c309025e8
 140 SUMMARY:Vaterpolo PMF
 141 DTSTART;TZID=Europe/Zagreb:20110406T133000
 142 DTEND;TZID=Europe/Zagreb:20110406T143000
 143 TRANSP:OPAQUE
 144 END:VEVENT
 145 BEGIN:VEVENT
 146 CREATED:20110430T093717Z
 147 LAST-MODIFIED:20110430T093741Z
 148 DTSTAMP:20110430T093741Z
 149 UID:d0fe1e24-25c9-4f1a-a1a5-7e4c38b2a4bd
 150 SUMMARY:SOKAZ
 151 DTSTART;TZID=Europe/Zagreb:20110427T193000
 152 DTEND;TZID=Europe/Zagreb:20110427T223000
 153 TRANSP:OPAQUE
 154 END:VEVENT
 155 BEGIN:VEVENT
 156 CREATED:20110430T093903Z
 157 LAST-MODIFIED:20110503T141014Z
 158 DTSTAMP:20110503T141014Z
 159 UID:e8835dcb-9c58-446c-8020-1d14e299994b
 160 SUMMARY:SOKAZ
 161 DTSTART;TZID=Europe/Zagreb:20110506T190000
 162 DTEND;TZID=Europe/Zagreb:20110506T220000
 163 DESCRIPTION:protiv VIDRE\; dvorana u podsusedu
 164 TRANSP:OPAQUE
 165 SEQUENCE:2
 166 X-MOZ-GENERATION:2
 167 END:VEVENT
 168 BEGIN:VEVENT
 169 CREATED:20110320T103444Z
 170 LAST-MODIFIED:20110503T141104Z
 171 DTSTAMP:20110503T141104Z
 172 UID:631e6b38-c41c-49c6-8902-357650d1332c
 173 SUMMARY:Stolni tenis
 174 DTSTART;TZID=Europe/Zagreb:20110502T150000
 175 DTEND;TZID=Europe/Zagreb:20110502T160000
 176 LOCATION:PBF
 177 TRANSP:OPAQUE
 178 END:VEVENT
 179 BEGIN:VEVENT
 180 CREATED:20110320T103444Z
 181 LAST-MODIFIED:20110412T145824Z
 182 DTSTAMP:20110412T145824Z
 183 UID:2f32a2e1-f739-4c1a-920b-a605cc969e25
 184 SUMMARY:Stolni tenis
 185 DTSTART;TZID=Europe/Zagreb:20110411T150000
 186 DTEND;TZID=Europe/Zagreb:20110411T160000
 187 LOCATION:PBF
 188 TRANSP:OPAQUE
 189 END:VEVENT
 190 BEGIN:VEVENT
 191 CREATED:20110414T134428Z
 192 LAST-MODIFIED:20110416T203013Z
 193 DTSTAMP:20110416T203013Z
 194 UID:63d93f32-aa1d-4aaf-b0c6-f332689c395b
 195 SUMMARY:Vaterpolo
 196 DTSTART;TZID=Europe/Zagreb:20110415T140000
 197 DTEND;TZID=Europe/Zagreb:20110415T150000
 198 TRANSP:OPAQUE
 199 SEQUENCE:1
 200 X-MOZ-GENERATION:1
 201 END:VEVENT
 202 BEGIN:VEVENT
 203 CREATED:20110320T103444Z
 204 LAST-MODIFIED:20110417T195943Z
 205 DTSTAMP:20110417T195943Z
 206 UID:96d9a904-21da-44cf-a818-ace2e24117f3
 207 SUMMARY:Stolni tenis
 208 DTSTART;TZID=Europe/Zagreb:20110418T150000
 209 DTEND;TZID=Europe/Zagreb:20110418T160000
 210 LOCATION:PBF
 211 TRANSP:OPAQUE
 212 END:VEVENT
 213 BEGIN:VEVENT
 214 CREATED:20110513T180125Z
 215 LAST-MODIFIED:20110513T180150Z
 216 DTSTAMP:20110513T180150Z
 217 UID:6541bbc5-5054-4482-9656-781fccb1c9c0
 218 SUMMARY:Stolni tenis
 219 DTSTART;TZID=Europe/Zagreb:20110513T160000
 220 DTEND;TZID=Europe/Zagreb:20110513T170000
 221 DESCRIPTION:s filom u dvorani Precko
 222 TRANSP:OPAQUE
 223 END:VEVENT
 224 BEGIN:VEVENT
 225 CREATED:20110520T201034Z
 226 LAST-MODIFIED:20110520T201057Z
 227 DTSTAMP:20110520T201057Z
 228 UID:585e23cf-ef43-459a-9ad7-f05ceadc369e
 229 SUMMARY:SOKAZ
 230 DTSTART;TZID=Europe/Zagreb:20110524T190000
 231 DTEND;TZID=Europe/Zagreb:20110524T220000
 232 TRANSP:OPAQUE
 233 END:VEVENT
 234 BEGIN:VEVENT
 235 CREATED:20110311T213444Z
 236 LAST-MODIFIED:20110311T213526Z
 237 DTSTAMP:20110311T213526Z
 238 UID:abe35ff2-22ca-4abc-84ed-75cd594f152a
 239 SUMMARY:SOKAZ
 240 DTSTART;TZID=Europe/Zagreb:20110311T190000
 241 DTEND;TZID=Europe/Zagreb:20110311T220000
 242 LOCATION:Rugvica
 243 DESCRIPTION:igramo protiv STK Rugvice
 244 TRANSP:OPAQUE
 245 END:VEVENT
 246 BEGIN:VEVENT
 247 CREATED:20110314T195438Z
 248 LAST-MODIFIED:20110314T195500Z
 249 DTSTAMP:20110314T195500Z
 250 UID:f1a6d3ca-6070-453f-ae7d-10e204569461
 251 SUMMARY:SOKAZ
 252 DTSTART;TZID=Europe/Zagreb:20110317T200000
 253 DTEND;TZID=Europe/Zagreb:20110317T210000
 254 DESCRIPTION:protiv Mladih purgera
 255 TRANSP:OPAQUE
 256 END:VEVENT
 257 BEGIN:VEVENT
 258 CREATED:20110320T103444Z
 259 LAST-MODIFIED:20110328T181956Z
 260 DTSTAMP:20110328T181956Z
 261 UID:db31907b-1b8a-4f70-aa8e-e2c86ffc125a
 262 SUMMARY:Stolni tenis
 263 DTSTART;TZID=Europe/Zagreb:20110328T150000
 264 DTEND;TZID=Europe/Zagreb:20110328T160000
 265 LOCATION:PBF
 266 TRANSP:OPAQUE
 267 END:VEVENT
 268 BEGIN:VEVENT
 269 CREATED:20110602T091841Z
 270 LAST-MODIFIED:20110602T091933Z
 271 DTSTAMP:20110602T091933Z
 272 UID:158bce95-0f67-4cfc-9cc0-df42603a7497
 273 SUMMARY:SOKAZ
 274 DTSTART;TZID=Europe/Zagreb:20110606T193000
 275 DTEND;TZID=Europe/Zagreb:20110606T230000
 276 TRANSP:OPAQUE
 277 END:VEVENT
 278 BEGIN:VEVENT
 279 CREATED:20110603T144349Z
 280 LAST-MODIFIED:20110603T144405Z
 281 DTSTAMP:20110603T144405Z
 282 UID:e0b1fbe6-885e-447b-8811-0d0dafc7cc9a
 283 SUMMARY:Stolni tenis
 284 DTSTART;TZID=Europe/Zagreb:20110603T100000
 285 DTEND;TZID=Europe/Zagreb:20110603T130000
 286 TRANSP:OPAQUE
 287 END:VEVENT
 288 BEGIN:VEVENT
 289 CREATED:20110605T191628Z
 290 LAST-MODIFIED:20110605T191643Z
 291 DTSTAMP:20110605T191643Z
 292 UID:d59ca055-4396-442c-af99-5c45cfd8e75d
 293 SUMMARY:Stolni tenis
 294 DTSTART;TZID=Europe/Zagreb:20110604T180000
 295 DTEND;TZID=Europe/Zagreb:20110604T210000
 296 TRANSP:OPAQUE
 297 END:VEVENT
 298 BEGIN:VEVENT
 299 CREATED:20110607T222032Z
 300 LAST-MODIFIED:20110607T222045Z
 301 DTSTAMP:20110607T222045Z
 302 UID:6ec29b6e-c8f3-40b3-87d3-d7ebe742a8cc
 303 SUMMARY:Stolni tenis
 304 DTSTART;TZID=Europe/Zagreb:20110606T150000
 305 DTEND;TZID=Europe/Zagreb:20110606T160000
 306 TRANSP:OPAQUE
 307 END:VEVENT
 308 BEGIN:VEVENT
 309 CREATED:20111007T155910Z
 310 LAST-MODIFIED:20111007T155930Z
 311 DTSTAMP:20111007T155930Z
 312 UID:807b2e3b-6bc1-4fd4-8002-6a4a3d6ab210
 313 SUMMARY:SOKAZ
 314 DTSTART;TZID=Europe/Zagreb:20111010T200000
 315 DTEND;TZID=Europe/Zagreb:20111010T230000
 316 TRANSP:OPAQUE
 317 END:VEVENT
 318 BEGIN:VEVENT
 319 CREATED:20111009T102456Z
 320 LAST-MODIFIED:20111009T102524Z
 321 DTSTAMP:20111009T102524Z
 322 UID:17848910-224e-4b2e-82a1-880e7579fc09
 323 SUMMARY:Stolni tenis
 324 DTSTART;TZID=Europe/Zagreb:20111009T190000
 325 DTEND;TZID=Europe/Zagreb:20111009T210000
 326 LOCATION:faks
 327 DESCRIPTION:trening s najmanom na faksu
 328 TRANSP:OPAQUE
 329 END:VEVENT
 330 BEGIN:VEVENT
 331 CREATED:20111010T141132Z
 332 LAST-MODIFIED:20111010T141158Z
 333 DTSTAMP:20111010T141158Z
 334 UID:1dc66abb-d265-4115-bed1-8647076b6a6e
 335 SUMMARY:SOKAZ
 336 DTSTART;TZID=Europe/Zagreb:20111014T203000
 337 DTEND;TZID=Europe/Zagreb:20111014T230000
 338 DESCRIPTION:Odra Vex dizajn
 339 TRANSP:OPAQUE
 340 END:VEVENT
 341 BEGIN:VEVENT
 342 CREATED:20111014T073351Z
 343 LAST-MODIFIED:20111014T073406Z
 344 DTSTAMP:20111014T073406Z
 345 UID:40881d4c-03b1-4bd6-9486-47c88e42d4a9
 346 SUMMARY:Girje
 347 DTSTART;TZID=Europe/Zagreb:20111011T190000
 348 DTEND;TZID=Europe/Zagreb:20111011T200000
 349 TRANSP:OPAQUE
 350 END:VEVENT
 351 BEGIN:VEVENT
 352 CREATED:20111015T174624Z
 353 LAST-MODIFIED:20111015T174705Z
 354 DTSTAMP:20111015T174705Z
 355 UID:9d8b6e90-6ba9-4bec-8000-e1f9609b84a7
 356 SUMMARY:Stolni
 357 DTSTART;TZID=Europe/Zagreb:20111015T170000
 358 DTEND;TZID=Europe/Zagreb:20111015T190000
 359 TRANSP:OPAQUE
 360 END:VEVENT
 361 BEGIN:VEVENT
 362 CREATED:20111016T111311Z
 363 LAST-MODIFIED:20111016T111339Z
 364 DTSTAMP:20111016T111339Z
 365 UID:8f2601db-6537-40aa-91b5-3bff62c6aaeb
 366 SUMMARY:SOKAZ
 367 DTSTART;TZID=Europe/Zagreb:20111018T193000
 368 DTEND;TZID=Europe/Zagreb:20111018T220000
 369 TRANSP:OPAQUE
 370 END:VEVENT
 371 BEGIN:VEVENT
 372 CREATED:20111022T125946Z
 373 LAST-MODIFIED:20111022T130003Z
 374 DTSTAMP:20111022T130003Z
 375 UID:c606f5b2-4519-4b4c-9010-96ca6d301e70
 376 SUMMARY:Stolni tenis
 377 DTSTART;TZID=Europe/Zagreb:20111022T100000
 378 DTEND;TZID=Europe/Zagreb:20111022T120000
 379 TRANSP:OPAQUE
 380 END:VEVENT
 381 BEGIN:VEVENT
 382 CREATED:20111022T125946Z
 383 LAST-MODIFIED:20111022T130030Z
 384 DTSTAMP:20111022T130030Z
 385 UID:178d87de-d399-422f-955c-3d8867a7f384
 386 SUMMARY:Stolni tenis
 387 DTSTART;TZID=Europe/Zagreb:20111023T100000
 388 DTEND;TZID=Europe/Zagreb:20111023T120000
 389 TRANSP:OPAQUE
 390 END:VEVENT
 391 BEGIN:VEVENT
 392 CREATED:20111007T155910Z
 393 LAST-MODIFIED:20111026T212929Z
 394 DTSTAMP:20111026T212929Z
 395 UID:104e403e-9639-4316-813f-e843520901a5
 396 SUMMARY:SOKAZ
 397 DTSTART;TZID=Europe/Zagreb:20111028T203000
 398 DTEND;TZID=Europe/Zagreb:20111028T233000
 399 TRANSP:OPAQUE
 400 END:VEVENT
 401 BEGIN:VEVENT
 402 CREATED:20111111T094915Z
 403 LAST-MODIFIED:20111111T094932Z
 404 DTSTAMP:20111111T094932Z
 405 UID:64804e8e-fef5-46e3-b2a2-b494d9120dc1
 406 SUMMARY:SOKAZ
 407 DTSTART;TZID=Europe/Zagreb:20111111T190000
 408 DTEND;TZID=Europe/Zagreb:20111111T213000
 409 TRANSP:OPAQUE
 410 END:VEVENT
 411 BEGIN:VEVENT
 412 CREATED:20111113T175921Z
 413 LAST-MODIFIED:20111113T175937Z
 414 DTSTAMP:20111113T175937Z
 415 UID:72181664-03b7-4789-90a0-8bbec9300b5c
 416 SUMMARY:SOKAZ
 417 DTSTART;TZID=Europe/Zagreb:20111116T193000
 418 DTEND;TZID=Europe/Zagreb:20111116T220000
 419 TRANSP:OPAQUE
 420 END:VEVENT
 421 BEGIN:VEVENT
 422 CREATED:20111126T133916Z
 423 LAST-MODIFIED:20111126T133937Z
 424 DTSTAMP:20111126T133937Z
 425 UID:f3f56428-d648-4d8a-9174-57927d74e346
 426 SUMMARY:SOKAZ
 427 DTSTART;TZID=Europe/Zagreb:20111124T193000
 428 DTEND;TZID=Europe/Zagreb:20111124T223000
 429 TRANSP:OPAQUE
 430 END:VEVENT
 431 BEGIN:VEVENT
 432 CREATED:20111126T133916Z
 433 LAST-MODIFIED:20111126T134122Z
 434 DTSTAMP:20111126T134122Z
 435 UID:548df49b-2451-4224-bd7b-5780dd93a19e
 436 SUMMARY:SOKAZ
 437 DTSTART;TZID=Europe/Zagreb:20111201T193000
 438 DTEND;TZID=Europe/Zagreb:20111201T223000
 439 TRANSP:OPAQUE
 440 END:VEVENT
 441 BEGIN:VEVENT
 442 CREATED:20111014T073351Z
 443 LAST-MODIFIED:20111127T154401Z
 444 DTSTAMP:20111127T154401Z
 445 UID:154529bd-dcd2-43ad-900e-050a4d22f3a1
 446 SUMMARY:Girje
 447 RRULE:FREQ=WEEKLY;UNTIL=20111220T180000Z;BYDAY=MO,TH
 448 DTSTART;TZID=Europe/Zagreb:20111013T190000
 449 DTEND;TZID=Europe/Zagreb:20111013T200000
 450 TRANSP:OPAQUE
 451 SEQUENCE:1
 452 X-MOZ-GENERATION:3
 453 END:VEVENT
 454 BEGIN:VEVENT
 455 CREATED:20111126T134122Z
 456 LAST-MODIFIED:20111126T134129Z
 457 DTSTAMP:20111126T134129Z
 458 UID:154529bd-dcd2-43ad-900e-050a4d22f3a1
 459 SUMMARY:Girje
 460 RECURRENCE-ID;TZID=Europe/Zagreb:20111201T190000
 461 DTSTART;TZID=Europe/Zagreb:20111130T190000
 462 DTEND;TZID=Europe/Zagreb:20111130T200000
 463 SEQUENCE:2
 464 TRANSP:OPAQUE
 465 X-MOZ-GENERATION:2
 466 END:VEVENT
 467 BEGIN:VEVENT
 468 CREATED:20111127T154352Z
 469 LAST-MODIFIED:20111127T154401Z
 470 DTSTAMP:20111127T154401Z
 471 UID:154529bd-dcd2-43ad-900e-050a4d22f3a1
 472 SUMMARY:Girje
 473 RECURRENCE-ID;TZID=Europe/Zagreb:20111205T190000
 474 DTSTART;TZID=Europe/Zagreb:20111206T190000
 475 DTEND;TZID=Europe/Zagreb:20111206T200000
 476 SEQUENCE:2
 477 TRANSP:OPAQUE
 478 X-MOZ-GENERATION:3
 479 END:VEVENT
 480 END:VCALENDAR
 481 ENDDATA
 482
 483 QUERY
 484 SELECT caldav_data.caldav_data AS "Event Data", caldav_data.dav_name, caldav_data.dav_etag, dtstart, summary, description
 485   FROM caldav_data JOIN calendar_item USING(dav_name)
 486   WHERE caldav_data.dav_name ~ 'c0f7c860-1345-012d-125f-002421a2359e.ics'
 487 ENDQUERY
 488
 489