Changeset 976 for branches/cname-collision/t

Timestamp:

01/09/26 12:59:02 (13 days ago)

Author:

Kris Deugau

Message:

/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

Location:

branches/cname-collision/t

Files:

• DNSTest.pm (modified) (1 diff)
• dns-unitbase.sql (modified) (5 diffs)
• test-cname-timestamps.sql (added)

branches/cname-collision/t/DNSTest.pm

@@ -80 +80 @@
   diag( $reload ) if $debug;
   undef $ENV{PGPASSWORD};
+  # Set timestamps to a sliding window
+  my $stampwindow = qx( psql -h $dnsdb->{dbhost} -U $dnsdb->{dbuser} $dnsdb->{dbname} 2>&1 < t/test-cname-timestamps.sql );
+  diag( $stampwindow ) if $debug;
 } # new()
 

branches/cname-collision/t/dns-unitbase.sql

@@ -657 +657 @@
 2       example.org     1               1       2025121800      D       f       ac
 3       example.net     1               1       2025121800      D       f       ab
-4       expiry1.test    1               1       1765992407      D       f       
+4       expiry1.test    1               1       2026010702      D       t       
 \.
 
@@ -761 +761 @@
 53      0       1       1       admin   Initial User    Added record '192.168.2.17 TXT imma blocker!', TTL 2560 2025-12-23 13:06:20.492137-05   1       0
 55      0       1       1       admin   Initial User    Added record '192.168.2.18 CNAME 18-2.arpa.example.com', TTL 2560       2026-01-07 16:37:03.094557-05   1       0
+56      4       1       1       admin   Initial User    Added record 'expired1.expiry1.test A 192.168.2.23', TTL 5400, expires at 2025-12-24 18:30      2026-01-07 17:55:46.022401-05   0       0
+57      4       1       1       admin   Initial User    Added record 'expired2.expiry1.test TXT imma expire soon', TTL 5400, expires at 2026-01-10 07:00        2026-01-07 17:57:07.015962-05   0       0
+58      4       1       1       admin   Initial User    Added record 'active-after1.expiry1.test TXT not active yet', TTL 5400, valid after 2026-01-11 11:30    2026-01-07 18:12:57.491476-05   0       0
 \.
 
@@ -768 +771 @@
 --
 
-SELECT pg_catalog.setval('public.log_log_id_seq', 55, true);
+SELECT pg_catalog.setval('public.log_log_id_seq', 58, true);
 
 
@@ -855 +858 @@
 0       45      imma blocker!   16      192.168.2.17    0       0       0       2560    \N      1               1969-12-31 19:00:00-05  f       f       \N
 0       46      18-2.arpa.example.com   5       192.168.2.18    0       0       0       2560    \N      1               1969-12-31 19:00:00-05  f       f       \N
+4       47      expired1.expiry1.test   1       192.168.2.23    0       0       0       5400    \N      0               2025-12-24 18:30:00-05  t       t       \N
+4       48      expired2.expiry1.test   16      imma expire soon        0       0       0       5400    \N      0               2026-01-10 07:00:00-05  t       t       \N
+4       49      active-after1.expiry1.test      16      not active yet  0       0       0       5400    \N      0               2026-01-11 11:30:00-05  f       t       \N
 \.
 
@@ -862 +868 @@
 --
 
-SELECT pg_catalog.setval('public.records_record_id_seq', 46, true);
+SELECT pg_catalog.setval('public.records_record_id_seq', 49, true);