testing/tests/regression-suite/0000-Setup-PUT-collection.test

   1 #
   2 # PUT a calendar collection to user2 so we have some starting events
   3 #
   4 # There is no CalDAV defined behaviour for this.
   5 #
   6 TYPE=PUT
   7 URL=http://regression.host/caldav.php/user2/home/
   8 HEADER=User-Agent: RSCDS Testing/0.7.x
   9 HEADER=Content-Type: text/calendar; charset=utf-8
  10 HEADER=X-DAViCal-Flush-Cache: now
  11 AUTH=admin:nimda
  12
  13 HEAD
  14
  15 BEGINDATA
  16 BEGIN:VCALENDAR
  17 PRODID:-//Mozilla.org/NONSGML Mozilla Calendar V1.1//EN
  18 X-WR-CALNAME:User 2's Calendar, as uploaded by Admin
  19 VERSION:2.0
  20
  21 BEGIN:VTIMEZONE
  22 TZID:Pacific/Auckland
  23 X-LIC-LOCATION:Pacific/Auckland
  24 BEGIN:DAYLIGHT
  25 TZOFFSETFROM:+1200
  26 TZOFFSETTO:+1300
  27 TZNAME:NZDT
  28 DTSTART:19700927T020000
  29 RRULE:FREQ=YEARLY;INTERVAL=1;BYDAY=-1SU;BYMONTH=9
  30 END:DAYLIGHT
  31 BEGIN:STANDARD
  32 TZOFFSETFROM:+1300
  33 TZOFFSETTO:+1200
  34 TZNAME:NZST
  35 DTSTART:19700405T030000
  36 RRULE:FREQ=YEARLY;INTERVAL=1;BYDAY=1SU;BYMONTH=4
  37 END:STANDARD
  38 END:VTIMEZONE
  39
  40 BEGIN:VEVENT
  41 CREATED:20081023T054958Z
  42 LAST-MODIFIED:20081023T055044Z
  43 DTSTAMP:20081023T054958Z
  44 UID:33169d69-2969-4a96-a3e1-2e312b7614e6
  45 SUMMARY:Near Daily Action Meeting
  46 RRULE:FREQ=DAILY;INTERVAL=1;BYDAY=MO,WE,FR
  47 DTSTART;TZID=Pacific/Auckland:20081020T110000
  48 DTEND;TZID=Pacific/Auckland:20081020T113000
  49 X-MOZ-GENERATION:2
  50 END:VEVENT
  51
  52 BEGIN:VEVENT
  53 CREATED:20081023T054934Z
  54 LAST-MODIFIED:20081023T055059Z
  55 DTSTAMP:20081023T054934Z
  56 UID:047871e3-6b70-4178-9af8-0ceb50f7b092
  57 SUMMARY:Weekly Project Meeting
  58 RRULE:FREQ=WEEKLY;INTERVAL=1
  59 DTSTART;TZID=Pacific/Auckland:20081020T090000
  60 DTEND;TZID=Pacific/Auckland:20081020T100000
  61 X-MOZ-GENERATION:2
  62 END:VEVENT
  63
  64 BEGIN:VEVENT
  65 CREATED:20081023T055115Z
  66 LAST-MODIFIED:20081023T055139Z
  67 DTSTAMP:20081023T055115Z
  68 UID:9429a973-2b13-4b1a-be09-948d75425c45
  69 SUMMARY:Weekly catch-up
  70 RRULE:FREQ=WEEKLY;INTERVAL=1
  71 DTSTART;TZID=Pacific/Auckland:20081024T140000
  72 DTEND;TZID=Pacific/Auckland:20081024T150000
  73 X-MOZ-GENERATION:2
  74 END:VEVENT
  75
  76 BEGIN:VTIMEZONE
  77 TZID:America/Los_Angeles
  78 X-TZINFO:America/Los_Angeles[2007g/Partial@883612800000]
  79 BEGIN:DAYLIGHT
  80 TZOFFSETTO:-0700
  81 TZOFFSETFROM:-0800
  82 TZNAME:America/Los_Angeles(DST)
  83 DTSTART:19980405T020000
  84 RRULE:FREQ=YEARLY;UNTIL=20060403T100000Z;BYMONTH=4;BYDAY=1SU
  85 END:DAYLIGHT
  86 BEGIN:STANDARD
  87 TZOFFSETTO:-0800
  88 TZOFFSETFROM:-0700
  89 TZNAME:America/Los_Angeles(STD)
  90 DTSTART:19981025T020000
  91 RRULE:FREQ=YEARLY;UNTIL=20061030T100000Z;BYMONTH=10;BYDAY=-1SU
  92 END:STANDARD
  93 BEGIN:DAYLIGHT
  94 TZOFFSETTO:-0700
  95 TZOFFSETFROM:-0800
  96 TZNAME:America/Los_Angeles(DST)
  97 DTSTART:20070311T020000
  98 RRULE:FREQ=YEARLY;BYMONTH=3;BYDAY=2SU
  99 END:DAYLIGHT
 100 BEGIN:STANDARD
 101 TZOFFSETTO:-0800
 102 TZOFFSETFROM:-0700
 103 TZNAME:America/Los_Angeles(STD)
 104 DTSTART:20071104T020000
 105 RRULE:FREQ=YEARLY;BYMONTH=11;BYDAY=1SU
 106 END:STANDARD
 107 END:VTIMEZONE
 108
 109 BEGIN:VEVENT
 110 LAST-MODIFIED:20080303T015422Z
 111 SEQUENCE:5
 112 UID:7d729xc0-0895-012d-124e-002421a2359e
 113 SUMMARY:1st Monday, 2nd Tuesday, 3rd Thursday & Last Friday
 114 RRULE:FREQ=MONTHLY;BYDAY=1MO,2TU,3TH,-1FR;INTERVAL=1
 115 DESCRIPTION:An all day event on various days.
 116 DTSTART;TZID=America/Los_Angeles:20081006T000000
 117 CREATED:20080303T015329Z
 118 DTSTAMP:20080303T015422Z
 119 DURATION:P1D
 120 END:VEVENT
 121
 122 BEGIN:VEVENT
 123 LAST-MODIFIED:20081123T210725Z
 124 SEQUENCE:6
 125 UID:bd262d20-1cdb-012d-1264-002421a2359e
 126 SUMMARY:Afternoon run
 127 DESCRIPTION:
 128 DTSTART;TZID=America/Los_Angeles:20081123T150000
 129 CREATED:20081123T210644Z
 130 DTSTAMP:20081123T210725Z
 131 DURATION:PT1H
 132 LOCATION:
 133 RRULE:FREQ=WEEKLY;INTERVAL=1;BYDAY=SU
 134 END:VEVENT
 135
 136 BEGIN:VEVENT
 137 LAST-MODIFIED:20110101T005414Z
 138 SEQUENCE:12
 139 URL;VALUE=URI:http://www.oregontrufflefestival.com
 140 UID:56f0e0e0-f742-012d-680c-002421a2359e
 141 SUMMARY:Willamette Valley Vineyards at the Oregon Truffle Festival
 142 DESCRIPTION:The 6th Annual Oregon Truffle Festival will be held in and arou
 143  nd Eugene Oregon over three brisk winter days from January 28-30\, 2011. Cr
 144  eated to celebrate the magnificent Oregon truffles as they reach the peak o
 145  f ripeness in their native soil\, it is the first festival of its kind in N
 146  orth America\, dedicated to sharing the experience of the chefs\, foragers
 147  and fans of Oregon\\'s wild truffles\, from their hidden source in the fore
 148  st to their glory on the table.\n\nThe theme for 2011 is "Slow Food"\, and
 149  Willamette Valley Vineyards will be hosting a gourmet wine luncheon during
 150  the festival. Please visit www.oregontrufflefestival.com for more info and
 151  to purchase tickets.\n\n<img src="http://4.bp.blogspot.com/_nunnaUzLU1w/S7F
 152  WYsdewdI/AAAAAAAACj4/92TfhNIHKQI/s1600/wvv.jpg">
 153 DTSTART;TZID=America/Los_Angeles:20110128
 154 CREATED:20101231T193025Z
 155 DTSTAMP:20110101T005414Z
 156 DURATION:P1D
 157 LOCATION:Eugene Oregon
 158 X-VENUE:
 159 X-EMAIL-RSVP-UPDATES:true
 160 RRULE:FREQ=DAILY;COUNT=3;INTERVAL=1
 161 END:VEVENT
 162
 163 END:VCALENDAR
 164 ENDDATA
 165
 166 QUERY
 167 SELECT caldav_data.user_no, caldav_type, logged_user,
 168        uid, dtstamp, dtstart at time zone olson_name as dtstart, dtend at time zone olson_name as dtend, due, summary, location,
 169        description, priority, class, transp, rrule, url,
 170        percent_complete, tz_id, status,
 171        caldav_data AS "A1 CalDAV DATA"
 172 FROM caldav_data JOIN calendar_item USING(dav_name) LEFT JOIN timezones ON (tz_id=tzid)
 173 WHERE caldav_data.dav_name ~ '^/user2/home/'
 174 ENDQUERY
 175
 176 QUERY
 177 SELECT count(*)
 178   FROM caldav_data JOIN calendar_item USING(dav_name)
 179   WHERE caldav_data.dav_name ~ '^/user2/home/'
 180 ENDQUERY
 181