diff options
| -rwxr-xr-x | bin/bootstrap-mysql | 88 |
1 files changed, 87 insertions, 1 deletions
diff --git a/bin/bootstrap-mysql b/bin/bootstrap-mysql index 8545ab8..650f05d 100755 --- a/bin/bootstrap-mysql +++ b/bin/bootstrap-mysql @@ -2,7 +2,8 @@ # shellcheck source=conf/default.conf . "${0%/*}/../conf/default.conf" -. "${0%/*}/mysql-functions" +# shellcheck source=bin/mysql-functions +. "${base_dir}/bin/mysql-functions" tmp_dir=$(mktemp -d 'tmp.bootstrap-mysql.XXXXXXXXXX' --tmpdir) trap 'rm -rf --one-file-system "${tmp_dir}"' EXIT @@ -387,3 +388,88 @@ tr ' ' '.' < \ while read -r state_file; do mysql_generate_package_metadata "${state_file}" done + +grep '^\('"$( + # shellcheck disable=SC2086 + printf '%s\\|' ${standalone_package_repositories} ${stable_package_repositories} +)"'\) ' "${tmp_dir}/master-mirror-listing" | \ + sed ' + s/\.pkg\.tar\.xz$// + s/-\([^-:]\+\)\(\(-[^-]\+\)\{2\}\)$/-0:\1\2/ + s/\(-[0-9]\+\)\(-[^-]\+\)$/\1.0\2/ + s/-\([^-:]\+\):\([^-:]\+\)-\([^-.]\+\)\.\([^-.]\+\)-\([^-]\+\)$/ \1 \2 \3 \4 \5/ + ' | \ + while read -r repo pkgname epoch pkgver pkgrel sub_pkgrel arch; do + # we don't care too much about those - they won't be moved anyways + printf '(' + # shellcheck disable=SC2046 + printf 'from_base64("%s"),' \ + $( + printf '%s\n' \ + "${pkgname}" \ + "${epoch}" \ + "${pkgver}" \ + "${pkgrel}" \ + "${sub_pkgrel}" \ + "${arch}" \ + "${repo}" | \ + base64_encode_each + ) | \ + sed 's/,$/),/' + printf '\n' + done > \ + "${tmp_dir}/new-stable-packages" + +if [ -s "${tmp_dir}/new-stable-packages" ]; then + { + # shellcheck disable=SC2016 + printf 'CREATE TEMPORARY TABLE `stable_packages` (' + # shellcheck disable=SC2016 + printf '`%s` %s,' \ + 'pkgname' 'VARCHAR(64)' \ + 'epoch' 'MEDIUMINT' \ + 'pkgver' 'VARCHAR(64)' \ + 'pkgrel' 'MEDIUMINT' \ + 'sub_pkgrel' 'MEDIUMINT' \ + 'architecture' 'VARCHAR(16)' \ + 'repository' 'VARCHAR(64)' \ + 'build_assignment' 'BIGINT NOT NULL AUTO_INCREMENT' + # shellcheck disable=SC2016 + printf 'PRIMARY KEY (`build_assignment`));\n' + # shellcheck disable=SC2016 + sed ' + 1~10 ! b not_start + s/^/INSERT IGNORE INTO `stable_packages` (`pkgname`,`epoch`,`pkgver`,`pkgrel`,`sub_pkgrel`,`architecture`,`repository`) VALUES \n/ + :not_start + $ b end + 0~10 b end + b + :end + s/,$/;/ + ' "${tmp_dir}/new-stable-packages" + # shellcheck disable=SC2016 + printf 'INSERT IGNORE INTO `binary_packages` (`pkgname`,`epoch`,`pkgver`,`pkgrel`,`sub_pkgrel`,`architecture`,`repository`,`build_assignment`,`has_issues`,`is_tested`)' + printf ' SELECT ' + # shellcheck disable=SC2016 + printf '`stable_packages`.`%s`,' \ + 'pkgname' \ + 'epoch' \ + 'pkgver' \ + 'pkgrel' \ + 'sub_pkgrel' + # shellcheck disable=SC2016 + printf '`%s`.`id`,' \ + 'architectures' \ + 'repositories' + # shellcheck disable=SC2016 + printf -- '-`build_assignment`,0,1 FROM `stable_packages`' + # shellcheck disable=SC2016 + printf ' JOIN `%s` ON `stable_packages`.`%s`=`%s`.`name`' \ + 'repositories' 'repository' 'repositories' \ + 'architectures' 'architecture' 'architectures' + printf ';\n' + # shellcheck disable=SC2016 + printf 'DROP TABLE `stable_packages`;\n' + } | \ + ${mysql_command% -e} +fi |