-- called by /home/master/builder/work/intentions/intention.10
-- : #!/bin/sh
-- : # called by /home/master/builder/bin/db-update
-- : [ -n "${base_dir}" ] || . /home/master/builder/lib/load-configuration
-- : {
-- :   mysql_run_query | sort -u >> "/home/master/builder/work/tmp.db-update.permanent.rRjWCZtQQU/rm"
-- : } <<END_OF_MYSQL_QUERY
-- : CREATE TEMPORARY TABLE \`replaced_bpir\` (\`id\` BIGINT, UNIQUE KEY (\`id\`));
-- : CREATE TEMPORARY TABLE \`moved_bpir\` (\`id\` BIGINT, \`new_repository\` MEDIUMINT, UNIQUE KEY (\`id\`));
-- : LOAD DATA LOCAL INFILE "/home/master/builder/work/tmp.mysql-functions.query.2023-07-15T01:34:51.sfQ2JR.infile.1" INTO TABLE \`moved_bpir\` COLUMNS TERMINATED BY " ";
-- : LOAD DATA LOCAL INFILE "/home/master/builder/work/tmp.mysql-functions.query.2023-07-15T01:34:51.sfQ2JR.infile.2" INTO TABLE \`replaced_bpir\` COLUMNS TERMINATED BY " ";
-- : DELETE \`binary_packages_in_repositories\` FROM \`binary_packages_in_repositories\` JOIN \`replaced_bpir\` ON \`binary_packages_in_repositories\`.\`id\`=\`replaced_bpir\`.\`id\`;
-- : SELECT CONCAT("pool/",CONCAT(\`binary_packages\`.\`pkgname\`,"-",IF(\`binary_packages\`.\`epoch\`=0,"",CONCAT(\`binary_packages\`.\`epoch\`,":")),\`binary_packages\`.\`pkgver\`,"-",\`binary_packages\`.\`pkgrel\`,IF(\`binary_packages\`.\`sub_pkgrel_omitted\`,"",CONCAT(".",\`binary_packages\`.\`sub_pkgrel\`)),"-",\`architectures\`.\`name\`,".pkg.",IF(\`compressions\`.\`suffix\` IS NULL,"tar.zst",\`compressions\`.\`suffix\`))) FROM \`binary_packages\` JOIN \`architectures\` ON \`binary_packages\`.\`architecture\`=\`architectures\`.\`id\` LEFT JOIN \`compressions\` ON \`binary_packages\`.\`compression\`=\`compressions\`.\`id\` WHERE NOT EXISTS (SELECT 1 FROM \`binary_packages_in_repositories\` WHERE \`binary_packages_in_repositories\`.\`package\`=\`binary_packages\`.\`id\`);
-- : DELETE \`binary_packages\` FROM \`binary_packages\` WHERE NOT EXISTS (SELECT 1 FROM \`binary_packages_in_repositories\` WHERE \`binary_packages_in_repositories\`.\`package\`=\`binary_packages\`.\`id\`);
-- : UPDATE \`binary_packages_in_repositories\` JOIN \`moved_bpir\` ON \`binary_packages_in_repositories\`.\`id\`=\`moved_bpir\`.\`id\` SET \`binary_packages_in_repositories\`.\`repository\`=\`moved_bpir\`.\`new_repository\`,\`binary_packages_in_repositories\`.\`last_moved\`=NOW() WHERE \`binary_packages_in_repositories\`.\`repository\`!=\`moved_bpir\`.\`new_repository\`;
-- : END_OF_MYSQL_QUERY
-- : rm "/home/master/builder/work/intentions/intention.10"
CREATE TEMPORARY TABLE `replaced_bpir` (`id` BIGINT, UNIQUE KEY (`id`));
CREATE TEMPORARY TABLE `moved_bpir` (`id` BIGINT, `new_repository` MEDIUMINT, UNIQUE KEY (`id`));
LOAD DATA LOCAL INFILE "/home/master/builder/work/tmp.mysql-functions.query.2023-07-15T01:34:51.sfQ2JR.infile.1" INTO TABLE `moved_bpir` COLUMNS TERMINATED BY " ";
LOAD DATA LOCAL INFILE "/home/master/builder/work/tmp.mysql-functions.query.2023-07-15T01:34:51.sfQ2JR.infile.2" INTO TABLE `replaced_bpir` COLUMNS TERMINATED BY " ";
DELETE `binary_packages_in_repositories` FROM `binary_packages_in_repositories` JOIN `replaced_bpir` ON `binary_packages_in_repositories`.`id`=`replaced_bpir`.`id`;
SELECT CONCAT("pool/",CONCAT(`binary_packages`.`pkgname`,"-",IF(`binary_packages`.`epoch`=0,"",CONCAT(`binary_packages`.`epoch`,":")),`binary_packages`.`pkgver`,"-",`binary_packages`.`pkgrel`,IF(`binary_packages`.`sub_pkgrel_omitted`,"",CONCAT(".",`binary_packages`.`sub_pkgrel`)),"-",`architectures`.`name`,".pkg.",IF(`compressions`.`suffix` IS NULL,"tar.zst",`compressions`.`suffix`))) FROM `binary_packages` JOIN `architectures` ON `binary_packages`.`architecture`=`architectures`.`id` LEFT JOIN `compressions` ON `binary_packages`.`compression`=`compressions`.`id` WHERE NOT EXISTS (SELECT 1 FROM `binary_packages_in_repositories` WHERE `binary_packages_in_repositories`.`package`=`binary_packages`.`id`);
DELETE `binary_packages` FROM `binary_packages` WHERE NOT EXISTS (SELECT 1 FROM `binary_packages_in_repositories` WHERE `binary_packages_in_repositories`.`package`=`binary_packages`.`id`);
UPDATE `binary_packages_in_repositories` JOIN `moved_bpir` ON `binary_packages_in_repositories`.`id`=`moved_bpir`.`id` SET `binary_packages_in_repositories`.`repository`=`moved_bpir`.`new_repository`,`binary_packages_in_repositories`.`last_moved`=NOW() WHERE `binary_packages_in_repositories`.`repository`!=`moved_bpir`.`new_repository`;