mirror of
https://gitlab.com/davical-project/davical.git
synced 2026-04-27 15:31:32 +00:00
71 lines
2.1 KiB
Plaintext
71 lines
2.1 KiB
Plaintext
#
|
|
# Attempt to put this event into a location that is locked.
|
|
# - but this time supply the token so it succeeds
|
|
#
|
|
TYPE=PUT
|
|
URL=http://regression.host/caldav.php/user1/home/i1278618276.ics
|
|
|
|
# Get the lock token from the earlier lock
|
|
GETSQL=locktoken
|
|
SELECT opaquelocktoken FROM locks WHERE dav_name = '/user1/home/i1278618276.ics'
|
|
ENDSQL
|
|
|
|
|
|
HEADER=Content-Type: text/calendar; charset=utf-8
|
|
HEADER=Lock-Token: <opaquelocktoken:##locktoken##>
|
|
HEAD
|
|
|
|
BEGINDATA
|
|
BEGIN:VCALENDAR
|
|
PRODID:-//Facebook//NONSGML Facebook Events V0.9//EN
|
|
X-ORIGINAL-URL:http://www.facebook.com/event.php?eid=33142748183
|
|
VERSION:2.0
|
|
CALSCALE:GREGORIAN
|
|
METHOD:PUBLISH
|
|
BEGIN:VEVENT
|
|
DTSTAMP:20081030T194443
|
|
LAST-MODIFIED:20081030T194443
|
|
CREATED:20081030T194401
|
|
SEQUENCE:42
|
|
ORGANIZER:MAILTO:sigurd@sliverstripe.com
|
|
DTSTART:20081117T180000
|
|
DTEND:20081117T210000
|
|
UID:e33142748183@facebook.com
|
|
SUMMARY:Wellington Meetup and v2.3 pre-release party
|
|
LOCATION:Southern Cross Bar/Restaurant\, Cub
|
|
a St/Able Smith St intersection
|
|
URL:http://www.facebook.com/event.php?eid=33142748183
|
|
DESCRIPTION:Food\, alcohol\, code\, and websites.
|
|
What more do you want in life?\n\nW
|
|
e're interesting in meeting up wit
|
|
h the local web community and thos
|
|
e who use SilverStripe\, so that we
|
|
can listen to your ideas and answ
|
|
er your questions\, technical or ot
|
|
herwise.\n\nWe'll also be demonstrat
|
|
ing what's coming in SilverStripe
|
|
v2.3\, and you get to meet the peop
|
|
le behind the code!\n\n\nhttp://www.f
|
|
acebook.com/event.php?eid=33142748
|
|
183
|
|
CLASS:PUBLIC
|
|
CATEGORIES:
|
|
STATUS:CONFIRMED
|
|
PARTSTAT:ACCEPTED
|
|
END:VEVENT
|
|
END:VCALENDAR
|
|
ENDDATA
|
|
|
|
QUERY
|
|
SELECT caldav_data.user_no, caldav_type, logged_user,
|
|
uid, dtstamp, dtstart, dtend, due, summary, location,
|
|
description, priority, class, transp, rrule, url,
|
|
percent_complete, tz_id, status,
|
|
((current_timestamp AT TIME ZONE 'GMT' - calendar_item.last_modified) < '2 seconds'::interval) AS "~ Modified Now",
|
|
caldav_data AS "A1 CalDAV DATA"
|
|
FROM caldav_data JOIN calendar_item USING(dav_name) LEFT JOIN timezones ON (tz_id=tzid)
|
|
WHERE caldav_data.dav_name ~ '^/user1/home/i1278618276.ics'
|
|
ENDQUERY
|
|
|
|
|