test/t2100-mkpkglists.sh

   1 #!/bin/sh
   2
   3 test_description='mkpkglists tests'
   4
   5 . ./setup.sh
   6
   7 test_expect_success 'Test package list generation with no packages.' '
   8         echo "DELETE FROM Packages;" | sqlite3 aur.db &&
   9         echo "DELETE FROM PackageBases;" | sqlite3 aur.db &&
  10         "$MKPKGLISTS" &&
  11         test $(zcat packages.gz | wc -l) -eq 1 &&
  12         test $(zcat pkgbase.gz | wc -l) -eq 1
  13 '
  14
  15 test_expect_success 'Test package list generation.' '
  16         cat <<-EOD | sqlite3 aur.db &&
  17         INSERT INTO PackageBases (ID, Name, PackagerUID, SubmittedTS, ModifiedTS, FlaggerComment) VALUES (1, "foobar", 1, 0, 0, "");
  18         INSERT INTO PackageBases (ID, Name, PackagerUID, SubmittedTS, ModifiedTS, FlaggerComment) VALUES (2, "foobar2", 2, 0, 0, "");
  19         INSERT INTO PackageBases (ID, Name, PackagerUID, SubmittedTS, ModifiedTS, FlaggerComment) VALUES (3, "foobar3", NULL, 0, 0, "");
  20         INSERT INTO PackageBases (ID, Name, PackagerUID, SubmittedTS, ModifiedTS, FlaggerComment) VALUES (4, "foobar4", 1, 0, 0, "");
  21         INSERT INTO Packages (ID, PackageBaseID, Name) VALUES (1, 1, "pkg1");
  22         INSERT INTO Packages (ID, PackageBaseID, Name) VALUES (2, 1, "pkg2");
  23         INSERT INTO Packages (ID, PackageBaseID, Name) VALUES (3, 1, "pkg3");
  24         INSERT INTO Packages (ID, PackageBaseID, Name) VALUES (4, 2, "pkg4");
  25         INSERT INTO Packages (ID, PackageBaseID, Name) VALUES (5, 3, "pkg5");
  26         EOD
  27         "$MKPKGLISTS" &&
  28         cat <<-EOD >expected &&
  29         foobar
  30         foobar2
  31         foobar4
  32         EOD
  33         gunzip pkgbase.gz &&
  34         sed "/^#/d" pkgbase >actual &&
  35         test_cmp actual expected &&
  36         cat <<-EOD >expected &&
  37         pkg1
  38         pkg2
  39         pkg3
  40         pkg4
  41         EOD
  42         gunzip packages.gz &&
  43         sed "/^#/d" packages >actual &&
  44         test_cmp actual expected
  45 '
  46
  47 test_expect_success 'Test user list generation.' '
  48         "$MKPKGLISTS" &&
  49         cat <<-EOD >expected &&
  50         dev
  51         tu
  52         tu2
  53         tu3
  54         tu4
  55         user
  56         user2
  57         user3
  58         user4
  59         EOD
  60         gunzip users.gz &&
  61         sed "/^#/d" users >actual &&
  62         test_cmp actual expected
  63 '
  64
  65 test_done