2 # PUT a calendar collection to user5 so we have some starting events
4 # There is no CalDAV defined behaviour for this.
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
18 PRODID:-//neutralspace inc.//dotcal.com//EN
20 TZID:America/Los_Angeles
21 X-LIC-LOCATION:America/Los_Angeles
26 DTSTART:19700308T020000
27 RRULE:FREQ=YEARLY;BYMONTH=3;BYDAY=2SU
33 DTSTART:19701101T020000
34 RRULE:FREQ=YEARLY;BYMONTH=11;BYDAY=1SU
38 LAST-MODIFIED:20100812T161339Z
40 UID:naltpirh2vfjfmplmsivuo30t8@google.com
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
49 X-VENUE:Tease Restaurant & Bar, corner of 2nd & Main
50 X-EMAIL-RSVP-UPDATES:true
51 RRULE:FREQ=MONTHLY;WKST=MO;BYDAY=3SU
55 DTSTART;TZID=America/Los_Angeles:20090707T170000
57 DTSTAMP:20090828T083735Z
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
67 CREATED:20091221T033228Z
71 DTSTART;TZID=America/Los_Angeles:20090907T170000
73 DTSTAMP:20090828T083735Z
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
82 CREATED:20091221T033228Z
83 RECURRENCE-ID;TZID=America/Los_Angeles:20090914T170000
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/'
101 FROM caldav_data JOIN calendar_item USING(dav_name)
102 WHERE caldav_data.dav_name ~ '^/user5/home/'