Merge branch 'master' of github.com:DAViCal/davical into github
[davical.git] / testing / tests / regression-suite / 0804-Mulberry-PUT-1.test
blob3cc9af4e8bf01b988412a907718d6db77417d74b
2 # Attempt to put this event into a location that is locked.
3 #  - but this time supply the token so it succeeds
5 TYPE=PUT
6 URL=http://regression.host/caldav.php/user1/home/i1278618276.ics
8 # Get the lock token from the earlier lock
9 GETSQL=locktoken
10 SELECT opaquelocktoken FROM locks WHERE dav_name = '/user1/home/i1278618276.ics'
11 ENDSQL
14 HEADER=Content-Type: text/calendar; charset=utf-8
15 HEADER=Lock-Token: <opaquelocktoken:##locktoken##>
16 HEAD
18 BEGINDATA
19 BEGIN:VCALENDAR
20 PRODID:-//Facebook//NONSGML Facebook Events V0.9//EN
21 X-ORIGINAL-URL:http://www.facebook.com/event.php?eid=33142748183
22 VERSION:2.0
23 CALSCALE:GREGORIAN
24 METHOD:PUBLISH
25 BEGIN:VEVENT
26 DTSTAMP:20081030T194443
27 LAST-MODIFIED:20081030T194443
28 CREATED:20081030T194401
29 SEQUENCE:42
30 ORGANIZER:MAILTO:sigurd@sliverstripe.com
31 DTSTART:20081117T180000
32 DTEND:20081117T210000
33 UID:e33142748183@facebook.com
34 SUMMARY:Wellington Meetup and v2.3 pre-release party
35 LOCATION:Southern Cross Bar/Restaurant\, Cub
36  a St/Able Smith St intersection
37 URL:http://www.facebook.com/event.php?eid=33142748183
38 DESCRIPTION:Food\, alcohol\, code\, and websites.
39   What more do you want in life?\n\nW
40  e're interesting in meeting up wit
41  h the local web community and thos
42  e who use SilverStripe\, so that we
43   can listen to your ideas and answ
44  er your questions\, technical or ot
45  herwise.\n\nWe'll also be demonstrat
46  ing what's coming in SilverStripe 
47  v2.3\, and you get to meet the peop
48  le behind the code!\n\n\nhttp://www.f
49  acebook.com/event.php?eid=33142748
50  183
51 CLASS:PUBLIC
52 CATEGORIES:
53 STATUS:CONFIRMED
54 PARTSTAT:ACCEPTED
55 END:VEVENT
56 END:VCALENDAR
57 ENDDATA
59 QUERY
60 SELECT caldav_data.user_no, caldav_type, logged_user, 
61        uid, dtstamp, dtstart, dtend, due, summary, location,
62        description, priority, class, transp, rrule, url,
63        percent_complete, tz_id, status,
64        ((current_timestamp AT TIME ZONE 'GMT' - calendar_item.last_modified) < '2 seconds'::interval) AS "~ Modified Now",
65        caldav_data AS "A1 CalDAV DATA"
66 FROM caldav_data JOIN calendar_item USING(dav_name) LEFT JOIN timezones ON (tz_id=tzid)
67 WHERE caldav_data.dav_name ~ '^/user1/home/i1278618276.ics'
68 ENDQUERY