← Back to branch summary

~ubuntu-branches/ubuntu/vivid/davical/vivid

« back to all changes in this revision

Viewing changes to testing/tests/scheduling/3024-PUT-iCal-with-attendees.test

  • Committer: Bazaar Package Importer
  • Author(s): Andrew McMillan
  • Date: 2011-10-24 20:09:10 UTC
  • Revision ID: james.westby@ubuntu.com-20111024200910-2mz5wmc9ukh22vge
Tags: 0.9.9.7-1
New upstream release.

Show diffs side-by-side

added added

removed removed

Lines of Context:
testing/tests/scheduling/3024-PUT-iCal-with-attendees.test
 
1
#
 
2
# PUT an event with attendees
 
3
#
 
4
TYPE=PUT
 
5
URL=http://regression.host/caldav.php/manager1/home/E1A13F04-iCal-schedule.ics
 
6
HEADER=Content-Type: text/calendar
 
7
HEADER=DAVKit/4.0.3 (732.2); CalendarStore/4.0.4 (997.7); iCal/4.0.4 (1395.7); Mac OS X/10.6.8 (10K549)
 
8
HEAD
 
9
 
 
10
AUTH=manager1:manager1
 
11
 
 
12
# Before we run, this time we'll set schedule-deliver privileges
 
13
# on the invitee...
 
14
DOSQL
 
15
UPDATE dav_principal
 
16
   SET default_privileges = privilege_to_bits(ARRAY['schedule-deliver'])
 
17
 WHERE dav_name = '/user1/'
 
18
ENDDOSQL
 
19
 
 
20
BEGINDATA
 
21
BEGIN:VCALENDAR
 
22
VERSION:2.0
 
23
PRODID:-//Apple Inc.//iCal 4.0.4//EN
 
24
CALSCALE:GREGORIAN
 
25
BEGIN:VTIMEZONE
 
26
TZID:Pacific/Auckland
 
27
BEGIN:DAYLIGHT
 
28
TZOFFSETFROM:+1200
 
29
RRULE:FREQ=YEARLY;BYMONTH=9;BYDAY=-1SU
 
30
DTSTART:20070930T020000
 
31
TZNAME:GMT+13:00
 
32
TZOFFSETTO:+1300
 
33
END:DAYLIGHT
 
34
BEGIN:STANDARD
 
35
TZOFFSETFROM:+1300
 
36
RRULE:FREQ=YEARLY;BYMONTH=4;BYDAY=1SU
 
37
DTSTART:20080406T030000
 
38
TZNAME:GMT+12:00
 
39
TZOFFSETTO:+1200
 
40
END:STANDARD
 
41
END:VTIMEZONE
 
42
BEGIN:VEVENT
 
43
CREATED:20111018T195845Z
 
44
UID:E1A13F04-iCal-schedule
 
45
DTEND;TZID=Pacific/Auckland:20111019T110000
 
46
ATTENDEE;CN="Manager 1";CUTYPE=INDIVIDUAL;PARTSTAT=ACCEPTED:mailto:manag
 
47
 er1@example.net
 
48
ATTENDEE;CN="user1@example.net";CUTYPE=INDIVIDUAL;EMAIL="user1@example.n
 
49
 et";PARTSTAT=NEEDS-ACTION;ROLE=REQ-PARTICIPANT;RSVP=TRUE:mailto:user1@ex
 
50
 ample.net
 
51
TRANSP:OPAQUE
 
52
SUMMARY:Meeting with User1
 
53
DTSTART;TZID=Pacific/Auckland:20111019T100000
 
54
DTSTAMP:20111018T200107Z
 
55
ORGANIZER;CN="Manager 1":mailto:manager1@example.net
 
56
SEQUENCE:5
 
57
END:VEVENT
 
58
END:VCALENDAR
 
59
ENDDATA
 
60
 
 
61
 
 
62
QUERY
 
63
SELECT caldav_data.user_no, caldav_data.dav_name,
 
64
       caldav_type, logged_user, caldav_data.caldav_data AS "vcalendar",
 
65
       summary
 
66
FROM caldav_data JOIN calendar_item USING(dav_name) LEFT JOIN timezones ON (tz_id=tzid)
 
67
WHERE calendar_item.uid = 'E1A13F04-iCal-schedule'
 
68
ORDER BY caldav_data.dav_id
 
69
ENDQUERY
 
70