source: branches/cname-collision/t/test-cname-timestamps.sql@ 1014

Last change on this file since 1014 was 1014, checked in by Kris Deugau, 4 days ago

/branches/cname-collision

Add another test zone and records for update-to-CNAME test cases
Add relevant timestamp updates for the new test suite records
See #72, #88
File size: 1.8 KB
RevLine 
[976]1-- Set timestamps on selected test records to a sliding window so that
2-- various tests expecting to find various expired, expiring, or valid-after
3-- records work correctly
4
5UPDATE records SET stamp = date_trunc('day', now() - interval '5 day') + '18:30' WHERE record_id = 47;
[979]6UPDATE records SET stamp = date_trunc('day', now() + interval '3 day') + '07:00' WHERE record_id = 48;
7UPDATE records SET stamp = date_trunc('day', now() + interval '5 day') + '11:30' WHERE record_id = 49;
[984]8UPDATE records SET stamp = date_trunc('day', now() - interval '3 day') + '14:00' WHERE record_id = 50;
[988]9
10UPDATE records SET stamp = date_trunc('day', now() + interval '4 day') + '11:30' WHERE record_id = 59;
11UPDATE records SET stamp = date_trunc('day', now() + interval '4 day') + '11:30' WHERE record_id = 60;
[992]12UPDATE records SET stamp = date_trunc('day', now() + interval '2 day') + '11:30' WHERE record_id = 61;
[994]13UPDATE records SET stamp = date_trunc('day', now() - interval '2 day') + '11:30' WHERE record_id = 62;
[998]14
15UPDATE records SET stamp = date_trunc('day', now() + interval '4 day') + '11:30' WHERE record_id = 64;
16UPDATE records SET stamp = date_trunc('day', now() - interval '2 day') + '11:30' WHERE record_id = 65;
17UPDATE records SET stamp = date_trunc('day', now() + interval '2 day') + '11:30' WHERE record_id = 66;
18UPDATE records SET stamp = date_trunc('day', now() + interval '1 day') + '11:30' WHERE record_id = 67;
19
[1014]20UPDATE records SET stamp = date_trunc('day', now() - interval '2 day') + '11:30' WHERE record_id = 75;
21UPDATE records SET stamp = date_trunc('day', now() + interval '2 day') + '11:30' WHERE record_id = 76;
22UPDATE records SET stamp = date_trunc('day', now() - interval '2 day') + '11:30' WHERE record_id = 77;
23UPDATE records SET stamp = date_trunc('day', now() + interval '2 day') + '11:30' WHERE record_id = 78;
Note: See TracBrowser for help on using the repository browser.