diff options
| author | Erich Eckner <git@eckner.net> | 2018-02-02 11:38:35 +0100 |
|---|---|---|
| committer | Erich Eckner <git@eckner.net> | 2018-02-02 11:38:35 +0100 |
| commit | c2f8dbb0fa210ea32c59b5b87b3f2e900eb32d70 (patch) | |
| tree | 89517be31c72a772d1d1a04e47caba18e320df12 /bin | |
| parent | 879c73de4704e8531e0434316de09b184f5a43dc (diff) | |
| download | builder-c2f8dbb0fa210ea32c59b5b87b3f2e900eb32d70.tar.xz | |
bin/seed-build-list: start mysql query
Diffstat (limited to 'bin')
| -rwxr-xr-x | bin/seed-build-list | 17 |
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|^.*/|| |