davical/testing/tests/scheduling/3106-DELETE-Recurring.test
2022-12-11 02:06:24 +13:00

22 lines
666 B
Plaintext

#
# We now DELETE the organisers copy of the actual event.
#
TYPE=DELETE
URL=http://regression.host/user1/home/recurring-event.ics
HEADER=User-Agent: 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)
HEAD
#
# Query to confirm we got rid of it.
# - An event in the manager's calendar, with a PARTSTART=DECLINED for user 1
# - An iTIP message in the manager's inbox.
QUERY
SELECT calendar_item.dav_name,
regexp_replace(caldav_data,'DTSTAMP:[0-9T]{15}Z','DTSTAMP:looks good') AS vcalendar
FROM calendar_item JOIN caldav_data USING(dav_id, dav_name)
WHERE uid = 'recurring-event'
ORDER BY dav_id
ENDQUERY