test/t2300-pkgmaint.sh

   1 #!/bin/sh
   2
   3 test_description='pkgmaint tests'
   4
   5 . ./setup.sh
   6
   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);
  15         EOD
  16         "$PKGMAINT" &&
  17         cat <<-EOD >expected &&
  18         foobar
  19         foobar2
  20         foobar3
  21         EOD
  22         echo "SELECT Name FROM PackageBases;" | sqlite3 aur.db >actual &&
  23         test_cmp actual expected
  24 '
  25
  26 test_done