Send patches - preferably formatted by git format-patch - to patches at archlinux32 dot org.
summaryrefslogtreecommitdiff
path: root/bin
diff options
context:
space:
mode:
authorErich Eckner <git@eckner.net>2018-02-02 11:38:35 +0100
committerErich Eckner <git@eckner.net>2018-02-02 11:38:35 +0100
commitc2f8dbb0fa210ea32c59b5b87b3f2e900eb32d70 (patch)
tree89517be31c72a772d1d1a04e47caba18e320df12 /bin
parent879c73de4704e8531e0434316de09b184f5a43dc (diff)
bin/seed-build-list: start mysql query
Diffstat (limited to 'bin')
-rwxr-xr-xbin/seed-build-list17
1 files changed, 17 insertions, 0 deletions
diff --git a/bin/seed-build-list b/bin/seed-build-list
index 08f6a42..9a0123e 100755
--- a/bin/seed-build-list
+++ b/bin/seed-build-list
@@ -133,6 +133,23 @@ mod_repo_rev=$(cat "${work_dir}/archlinux32.revision")
generate_package_metadata "${pkg}" "${repo_rev}" "${mod_repo_rev}" "${prepo}"
done
+# shellcheck disable=SC2016
+{
+ printf 'SELECT '
+ printf '`package_sources`.`%s`,' \
+ 'pkgbase' 'git_revision' 'mod_git_revision'
+ printf '`upstream_repositories`.`name`,`binary_packages`.`pkgname`'
+ printf ' FROM `binary_packages`'
+ printf ' JOIN `%s` ON `%s`.`id`=`%s`.`%s`' \
+ 'build_assignments' 'build_assignments' 'binary_packages' 'build_assignment' \
+ 'package_sources' 'package_sources' 'build_assignments' 'package_source' \
+ 'upstream_repositories' 'upstream_repositories' 'package_sources' 'upstream_package_repository'
+} | \
+ ${mysql_command} --raw --batch | \
+ sed '
+ 1d
+ y/\t/ /
+ ' > /dev/null # not yet working (the query works, but the entries are missing)
find "${work_dir}/package-infos" -maxdepth 1 -name '*.packages' -exec grep -HF '' "{}" \; | \
sed '
s|^.*/||