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

   1 #
   2 # PUT a calendar collection to user3 to test UTF-8 processing
   3 #
   4 TYPE=PUT
   5 URL=http://regression.host/caldav.php/user3/utf8/
   6 HEADER=User-Agent: RSCDS Testing/0.9.x
   7 HEADER=Content-Type: text/calendar; charset=utf-8
   8 AUTH=user3:user3
   9
  10 HEAD
  11
  12 QUERY
  13 SELECT caldav_data.user_no, caldav_type, logged_user,
  14        uid, dtstamp, dtstart at time zone olson_name as dtstart, dtend at time zone olson_name as dtend, due, summary, location,
  15        description, priority, class, transp, rrule, url,
  16        percent_complete, tz_id, status,
  17        caldav_data AS "A1 CalDAV DATA"
  18 FROM caldav_data JOIN calendar_item USING(dav_name) JOIN timezones ON (tz_id=tzid)
  19 WHERE caldav_data.dav_name ~ '^/user3/utf8/'
  20 ENDQUERY
  21
  22 QUERY
  23 SELECT count(*)
  24   FROM caldav_data JOIN calendar_item USING(dav_name)
  25   WHERE caldav_data.dav_name ~ '^/user3/utf8/'
  26 ENDQUERY
  27
  28 DATA=utf8-test