2 # Attempt to put this event into a location that is locked.
3 # - but this time supply the token so it succeeds
6 URL=http://regression.host/caldav.php/user1/home/i1278618276.ics
8 # Get the lock token from the earlier lock
10 SELECT opaquelocktoken FROM locks WHERE dav_name = '/user1/home/i1278618276.ics'
14 HEADER=Content-Type: text/calendar; charset=utf-8
15 HEADER=Lock-Token: <opaquelocktoken:##locktoken##>
20 PRODID:-//Facebook//NONSGML Facebook Events V0.9//EN
21 X-ORIGINAL-URL:http://www.facebook.com/event.php?eid=33142748183
26 DTSTAMP:20081030T194443
27 LAST-MODIFIED:20081030T194443
28 CREATED:20081030T194401
30 ORGANIZER:MAILTO:sigurd@sliverstripe.com
31 DTSTART:20081117T180000
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
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'