Send patches - preferably formatted by git format-patch - to patches at archlinux32 dot org.
summaryrefslogtreecommitdiff
path: root/lib/mysql-functions
diff options
context:
space:
mode:
authorErich Eckner <git@eckner.net>2018-05-04 16:12:19 +0200
committerErich Eckner <git@eckner.net>2018-05-04 16:12:19 +0200
commitf784b4cb189dcbc36c3d32a3e1f55026e519dc4b (patch)
tree809ebd1844f02ae930a5c7b5f100e8de582d73f1 /lib/mysql-functions
parent23c5752921470dc41d1d5a036a3336b19aef8a6f (diff)
lib/mysql-functions: bugfixes
Diffstat (limited to 'lib/mysql-functions')
-rwxr-xr-xlib/mysql-functions19
1 files changed, 13 insertions, 6 deletions
diff --git a/lib/mysql-functions b/lib/mysql-functions
index d259729..71097cb 100755
--- a/lib/mysql-functions
+++ b/lib/mysql-functions
@@ -171,7 +171,7 @@ mysql_add_package_source() {
fi
{
- printf 'INSERT INTO package_sources'
+ printf 'INSERT INTO `package_sources`'
printf ' (`pkgbase`,`git_revision`,`mod_git_revision`,`upstream_package_repository`,`uses_upstream`,`uses_modification`,`commit_time`)'
printf ' VALUES ('
printf 'from_base64("%s"),' \
@@ -193,7 +193,7 @@ mysql_add_package_source() {
"${uses_modification}"
printf 'from_unixtime(%s))' \
"${commit_time}"
- printf ' ON DUPLICATE KEY UPDATE `id`=LAST_INSERT_ID(`id`);\n'
+ printf ' ON DUPLICATE KEY UPDATE `id`=LAST_INSERT_ID(`package_sources`.`id`);\n'
printf 'SELECT LAST_INSERT_ID();\n'
} | \
mysql_run_query
@@ -291,7 +291,7 @@ mysql_generate_package_metadata() {
printf ' FROM `architectures`'
printf ' WHERE `architectures`.`name` = from_base64("%s")' \
"${arch}"
- printf ' ON DUPLICATE KEY UPDATE `id`=LAST_INSERT_ID(`id`);\n'
+ printf ' ON DUPLICATE KEY UPDATE `id`=LAST_INSERT_ID(`build_assignments`.`id`);\n'
printf 'SELECT "%s",LAST_INSERT_ID();\n' \
"${arch}"
done | \
@@ -338,8 +338,8 @@ mysql_generate_package_metadata() {
# this binary package is either built by the build_assignment
# with the identical arch (if existent) or by the one
# with arch=$any_arch
- grep "^${arch64} " "${temp_dir}/build-assignments.id" || \
- grep "^${any_arch} " "${temp_dir}/build-assignments.id"
+ grep "^${arch64}"'\s' "${temp_dir}/build-assignments.id" || \
+ grep "^${any_arch}"'\s' "${temp_dir}/build-assignments.id"
} | \
sed '
s/^.*\s/build-assignment-id = /
@@ -352,6 +352,13 @@ mysql_generate_package_metadata() {
done
done
+ # TODO: This should become multiple mysql queries:
+ # 1st inserting install_targets
+ # 2nd inserting binary_packages (and binary_packages_in_repositories)
+ # 3rd,4th inserting dependencies and install_target_providers
+ # The links between the above should _solely_ be made by the ids of
+ # the respective rows.
+
# now each "ARCHINFO $pkgname $arch" file represents one binary package
find "${temp_dir}" -mindepth 1 -maxdepth 1 -name 'ARCHINFO * *' -printf '%f\n' | \
while read -r _ pkgname arch; do
@@ -485,7 +492,7 @@ mysql_generate_package_metadata() {
} | \
sed '
s|,)|)|g
- s| JOIN JOIN | JOIN |
+ s| JOIN WHERE | WHERE |
s| AND;$|;|
' >> \
"${temp_dir}/add-binary-packages-command"