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

   1 #
   2 # PUT a calendar collection to user5 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/user5/home/
   8 HEADER=User-Agent: RSCDS Testing/0.9.x
   9 HEADER=Content-Type: text/calendar; charset=utf-8
  10 AUTH=user5:user5
  11
  12 HEAD
  13
  14 BEGINDATA
  15 BEGIN:VCALENDAR
  16 VERSION:2.0
  17 CALSCALE:GREGORIAN
  18 PRODID:-//neutralspace inc.//dotcal.com//EN
  19 BEGIN:VTIMEZONE
  20 TZID:America/Los_Angeles
  21 X-LIC-LOCATION:America/Los_Angeles
  22 BEGIN:DAYLIGHT
  23 TZOFFSETFROM:-0800
  24 TZOFFSETTO:-0700
  25 TZNAME:PDT
  26 DTSTART:19700308T020000
  27 RRULE:FREQ=YEARLY;BYMONTH=3;BYDAY=2SU
  28 END:DAYLIGHT
  29 BEGIN:STANDARD
  30 TZOFFSETFROM:-0700
  31 TZOFFSETTO:-0800
  32 TZNAME:PST
  33 DTSTART:19701101T020000
  34 RRULE:FREQ=YEARLY;BYMONTH=11;BYDAY=1SU
  35 END:STANDARD
  36 END:VTIMEZONE
  37 BEGIN:VEVENT
  38 LAST-MODIFIED:20100812T161339Z
  39 SEQUENCE:5
  40 UID:naltpirh2vfjfmplmsivuo30t8@google.com
  41 SUMMARY:Tango Night
  42 DESCRIPTION:Never will you see a space glow like a night of Tango at Tease.
  43  \nAll dancers welcome!\n$5 suggested donation
  44 DTSTART;TZID=America/Los_Angeles:20100815T200000
  45 CREATED:20091221T033228Z
  46 DTSTAMP:20100812T161339Z
  47 DURATION:PT3H
  48 LOCATION:
  49 X-VENUE:Tease Restaurant & Bar, corner of 2nd & Main
  50 X-EMAIL-RSVP-UPDATES:true
  51 RRULE:FREQ=MONTHLY;WKST=MO;BYDAY=3SU
  52 END:VEVENT
  53 BEGIN:VEVENT
  54 SEQUENCE:4
  55 DTSTART;TZID=America/Los_Angeles:20090707T170000
  56 STATUS:CONFIRMED
  57 DTSTAMP:20090828T083735Z
  58 SUMMARY:Sketch Salone
  59 DTEND;TZID=America/Los_Angeles:20090707T200000
  60 LOCATION:Tease Restaurant & Bar\, corner of 2nd & Main
  61 RRULE:FREQ=WEEKLY;WKST=SU;INTERVAL=2;UNTIL=20090921T065959Z;BYDAY=MO
  62 DESCRIPTION:Sketch Salone\, where the artist in you can come to the
  63  surface.  Live model Hosted by Kevin Christman\n per bench seat by
  64  RSVP or welcome to use a table
  65 UID:v3f2otajsto18em4rom3jd4238@google.com
  66 TRANSP:TRANSPARENT
  67 CREATED:20091221T033228Z
  68 END:VEVENT
  69 BEGIN:VEVENT
  70 SEQUENCE:4
  71 DTSTART;TZID=America/Los_Angeles:20090907T170000
  72 STATUS:CONFIRMED
  73 DTSTAMP:20090828T083735Z
  74 SUMMARY:Sketch Salone
  75 DTEND;TZID=America/Los_Angeles:20090907T200000
  76 LOCATION:Tease Restaurant & Bar\, corner of 2nd & Main
  77 DESCRIPTION:Sketch Salone\, where the artist in you can come to the
  78  surface.  Live model Hosted by Kevin Christman\n per bench seat by
  79  RSVP or welcome to use a table
  80 UID:v3f2otajsto18em4rom3jd4238@google.com
  81 TRANSP:TRANSPARENT
  82 CREATED:20091221T033228Z
  83 RECURRENCE-ID;TZID=America/Los_Angeles:20090914T170000
  84 END:VEVENT
  85 END:VCALENDAR
  86 ENDDATA
  87
  88
  89 QUERY
  90 SELECT caldav_data.user_no, caldav_type, logged_user,
  91        uid, dtstamp, dtstart at time zone olson_name as dtstart, dtend at time zone olson_name as dtend, due, summary, location,
  92        description, priority, class, transp, rrule, url,
  93        percent_complete, tz_id, status,
  94        caldav_data AS "A1 CalDAV DATA"
  95 FROM caldav_data JOIN calendar_item USING(dav_name) JOIN timezones ON (tz_id=tzid)
  96 WHERE caldav_data.dav_name ~ '^/user5/home/'
  97 ENDQUERY
  98
  99 QUERY
 100 SELECT count(*)
 101   FROM caldav_data JOIN calendar_item USING(dav_name)
 102   WHERE caldav_data.dav_name ~ '^/user5/home/'
 103 ENDQUERY
 104