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

Last change on this file since 978 was 976, checked in by Kris Deugau, 6 days ago

/branches/cname-collision

Add a set of test records with various expiry/valid-after settings for
testing CNAME collisions
Add a file of SQL UPDATEs and a call in the test setup module to normalize
the actual tested timestamps to a sliding window so that the base SQL
reference doesn't need to be updated on an ongoing basis for the tests to
work correctly
See #72, #88
File size: 484 bytes
Line 
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;
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;
Note: See TracBrowser for help on using the repository browser.