3 test_description
='pkgmaint tests'
7 test_expect_success
'Test package base cleanup script.' '
8 now=$(date -d now +%s) &&
9 threedaysago=$(date -d "3 days ago" +%s) &&
10 cat <<-EOD | sqlite3 aur.db &&
11 INSERT INTO PackageBases (ID, Name, PackagerUID, SubmittedTS, ModifiedTS) VALUES (1, "foobar", 1, $now, 0);
12 INSERT INTO PackageBases (ID, Name, PackagerUID, SubmittedTS, ModifiedTS) VALUES (2, "foobar2", 2, $threedaysago, 0);
13 INSERT INTO PackageBases (ID, Name, PackagerUID, SubmittedTS, ModifiedTS) VALUES (3, "foobar3", NULL, $now, 0);
14 INSERT INTO PackageBases (ID, Name, PackagerUID, SubmittedTS, ModifiedTS) VALUES (4, "foobar4", NULL, $threedaysago, 0);
17 cat <<-EOD >expected &&
22 echo "SELECT Name FROM PackageBases;" | sqlite3 aur.db >actual &&
23 test_cmp actual expected