Send patches - preferably formatted by git format-patch - to patches at archlinux32 dot org.
summaryrefslogtreecommitdiff
path: root/buildmaster/deletion-links.php
diff options
context:
space:
mode:
authorErich Eckner <git@eckner.net>2019-03-07 13:58:16 +0100
committerErich Eckner <git@eckner.net>2019-03-07 13:58:16 +0100
commit229df61eba717104bbaa34b6112e0b4fd5503598 (patch)
tree237f1c4b0f8e650e17f232bbb103d4d901ab194c /buildmaster/deletion-links.php
parent96d39b398eb9b57fe808e34b40e7123204eef1db (diff)
table `upstream_packages` makes available_upstream_packages() obsolete
Diffstat (limited to 'buildmaster/deletion-links.php')
-rw-r--r--buildmaster/deletion-links.php28
1 files changed, 3 insertions, 25 deletions
diff --git a/buildmaster/deletion-links.php b/buildmaster/deletion-links.php
index 54329bb..3a82c4e 100644
--- a/buildmaster/deletion-links.php
+++ b/buildmaster/deletion-links.php
@@ -16,29 +16,6 @@ if (array_key_exists("pkgname", $_GET))
else
$filter = "";
-$available_upstream_packages = available_upstream_packages('pkgname');
-
-mysql_run_query(
- "CREATE TEMPORARY TABLE `available` (" .
- "`pkgname` VARCHAR(88), " .
- "UNIQUE KEY `name` (`pkgname`)" .
- ")"
-);
-
-mysql_run_query(
- "INSERT INTO `available` (`pkgname`) VALUES (\"" .
- implode(array_map("base64_encode", $available_upstream_packages), "\"),(\"") .
- "\")"
-);
-
-mysql_run_query(
- "DELETE FROM `available` WHERE `available`.`pkgname`=\"\""
-);
-
-mysql_run_query(
- "UPDATE `available` SET `available`.`pkgname`=from_base64(`available`.`pkgname`)"
-);
-
mysql_run_query(
"CREATE TEMPORARY TABLE `d_bpir` (" .
"`id` BIGINT, " .
@@ -53,7 +30,7 @@ mysql_run_query(
" SELECT" .
" `binary_packages_in_repositories`.`id`," .
"IF(" .
- "`available`.`pkgname` IS NULL," .
+ "`upstream_packages`.`id` IS NULL," .
"\"#00ff00\"," .
"IF(" .
"`build_assignments`.`is_black_listed` IS NULL," .
@@ -65,7 +42,8 @@ mysql_run_query(
mysql_join_binary_packages_in_repositories_binary_packages() .
mysql_join_binary_packages_build_assignments() .
$available_filter .
- " JOIN `available` ON `available`.`pkgname`=`binary_packages`.`pkgname`" .
+ " JOIN `upstream_packages`" .
+ " ON `upstream_packages`.`pkgname`=`binary_packages`.`pkgname`" .
" WHERE `binary_packages_in_repositories`.`is_to_be_deleted`" .
" AND `binary_packages`.`pkgname` NOT LIKE \"lib32-%\"" .
$filter