Merge branch 'master' of github.com:DAViCal/davical into github
[davical.git] / testing / tests / regression-suite / 0955-DELTICKET.test
blob3072be84d4aacc6a8ddebee43ff5a0d5091a109a
2 # DELTICKET the resource ticket we created back in 950...
4 TYPE=DELTICKET
5 URL=http://regression.host/caldav.php/user1/home/4aaf8f37-f232-4c8e-a72e-e171d4c4fe54.ics
6 HEADER=User-Agent: Ticket Spec Tests
7 HEAD
9 # Get the ticket we created earlier in 950...
10 GETSQL=ticket
11 SELECT ticket_id FROM access_ticket
12                 WHERE target_collection_id = 160 AND target_resource_id IS NOT NULL;
13 ENDSQL
15 HEADER=User-Agent: Ticket Spec Tests
16 HEADER=Ticket: ##ticket##
17 HEADER=Depth: 0
19 BEGINDATA
20 ENDDATA
22 QUERY
23 SELECT dav_owner_id,
24        date_trunc( 'minute', ('55 seconds' + expires - current_timestamp)::interval(0)) AS timeout,
25        privileges,
26        target_collection_id,
27        target_resource_id
28   FROM access_ticket
29 ENDQUERY
31 # REPLACE=!<T:id>\S{8}</T:id>!<T:id>Good Ticket ID</T:id>!
32 # REPLACE=!Ticket: \S{8}!Ticket:Good Ticket ID!