[Qa-jenkins-scm] [Git][qa/jenkins.debian.net][master] reproducible Archlinux: use correct variable for UPDATE query

[Holger Levsen]

Holger Levsen pushed to branch master at Debian QA / jenkins.debian.net


Commits:
d51f023d by Holger Levsen at 2018-09-25T11:50:08Z
reproducible Archlinux: use correct variable for UPDATE query

Signed-off-by: Holger Levsen <holger at layer-acht.org>

- - - - -


2 changed files:

- TODO
- bin/reproducible_build_archlinux_pkg.sh


Changes:

=====================================
TODO
=====================================
@@ -325,7 +325,6 @@ See link:https://jenkins.debian.net/userContent/about.html["about jenkins.debian
 *** check/make sure that packages which are newer in trunk than repo are only scheduled once
 *** fix irc notification
 ** make _archlinux_build.sh
-*** write db
 *** refactor and reuse unregister_build from _build.sh
 *** we share /var/log/jenkins/reproducible-race-conditions.log with debian, is that ok? (else fix maintenance job and handle_race_condition())
 *** make build respect pacman exit code, see FIXME in _html_.sh


=====================================
bin/reproducible_build_archlinux_pkg.sh
=====================================
@@ -55,7 +55,7 @@ update_pkg_in_db() {
 	QUERY="INSERT into results (package_id, version, status, build_date, build_duration, node1, node2, job)
 		VALUES ('${SRCPKGID}', '$BUILD_VERSION', '$BUILD_STATE', '$DATE', '$BUILD_DURATION', '$NODE1', '$NODE2', '$BUILD_URL')
 		ON CONFLICT (package_id)
-		DO UPDATE SET version='$BUILD_VERSION', status='$BUILD_STATE', build_date='$DATE_DATE', build_duration='$BUILD_DURATION', node1='$NODE1', node2='$NODE2', job='$BUILD_URL' WHERE results.package_id='$SRCPKGID'";
+		DO UPDATE SET version='$BUILD_VERSION', status='$BUILD_STATE', build_date='$DATE', build_duration='$BUILD_DURATION', node1='$NODE1', node2='$NODE2', job='$BUILD_URL' WHERE results.package_id='$SRCPKGID'";
         echo "$QUERY"
 	query_db "$QUERY"
         QUERY="INSERT INTO stats_build (name, version, suite, architecture, status, build_date, build_duration, node1, node2, job) 



View it on GitLab: https://salsa.debian.org/qa/jenkins.debian.net/commit/d51f023d988fab31729ebd8717cea1059bf7fa4b

-- 
View it on GitLab: https://salsa.debian.org/qa/jenkins.debian.net/commit/d51f023d988fab31729ebd8717cea1059bf7fa4b
You're receiving this email because of your account on salsa.debian.org.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://alioth-lists.debian.net/pipermail/qa-jenkins-scm/attachments/20180925/16861d88/attachment-0001.html>