* [PATCH v3 2/3] recheck: Add a recheck parser for patchwork comments
2023-11-28 21:01 [PATCH v3 0/3] Add a recheck framework to pw-ci Aaron Conole
2023-11-28 21:01 ` [PATCH v3 1/3] pw_mon: improve command line options Aaron Conole
@ 2023-11-28 21:01 ` Aaron Conole
2023-11-28 21:01 ` [PATCH v3 3/3] github: add a tool for restarting checks Aaron Conole
2023-11-30 16:04 ` [PATCH v3 0/3] Add a recheck framework to pw-ci Aaron Conole
3 siblings, 0 replies; 5+ messages in thread
From: Aaron Conole @ 2023-11-28 21:01 UTC (permalink / raw)
To: ci
Cc: Michael Santana, David Marchand, Thomas Monjalon, Patrick Robb,
Dumitru Ceara
Add a recheck parsing tool that will allow for labs to build a
recheck workflow based on specific recheck labels and projects,
with an associated state machine and querying interface.
The output of the recheck parsing tool is json and can be fed to
jq or other json parsing utilities for better field support.
Acked-by: Michael Santana <msantana@redhat.com>
Signed-off-by: Aaron Conole <aconole@redhat.com>
---
RECHECK.rst | 81 ++++++++++++++++++++++++++++++++++++++
pw_mon | 59 +++++++++++++++++++++++++++-
recheck_tool | 100 +++++++++++++++++++++++++++++++++++++++++++++++
series_db_lib.sh | 72 +++++++++++++++++++++++++++++++++-
4 files changed, 310 insertions(+), 2 deletions(-)
create mode 100644 RECHECK.rst
create mode 100755 recheck_tool
diff --git a/RECHECK.rst b/RECHECK.rst
new file mode 100644
index 0000000..080f397
--- /dev/null
+++ b/RECHECK.rst
@@ -0,0 +1,81 @@
+..
+ Licensed under the terms of the GNU General Public License as published
+ by the Free Software Foundation; either version 2 of the License, or
+ (at your option) any later version. You may obtain a copy of the
+ license at
+
+ https://www.gnu.org/licenses/old-licenses/gpl-2.0.html
+
+ Unless required by applicable law or agreed to in writing, software
+ distributed under the License is distributed on an "AS IS" BASIS, WITHOUT
+ WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the
+ License for the specific language governing permissions and limitations
+ under the License.
+
+
+============================
+Recheck Requests
+============================
+
+Various testing labs performing CI testing on new patch series send
+their results to the appropriate mailing lists for a pw-ci monitor
+to collect the reports and publish them to patchwork. On each
+patch in the series, the results will appear with test category
+contexts corresponding to the various test types which are run.
+Examples include github-<worfklow>, travis-ci, etc.
+
+If a reported failure on a series seems suspicious to the patch submitter
+or maintainer, then there may be an interest in requesting a retest on the
+series for the failing label(s) in order to verify the failure is not
+spurious or a false positive. This retest demonstrates to the submitter or
+maintainer that the failure can be reliably reproduced. Unfortunately, at
+present, the best way to accomplish this is to reach out to lab maintainers
+via email or Slack. This is not ideal for developers in need of quick test
+results.
+
+Going forward, CI testing labs have the option to implement a request for
+retest of their respective test labels on patchwork via emails sent to the
+developer mailing list. This is accomplished using the the `recheck_tool`
+to advance the retest check state through various points.
+
+An example might look like::
+
+ $ export PROJ=foo
+ $ export INST=patches.foo.com
+ $ export FILTER=foo-ci
+ $ export FOO_TOKEN=abcd1234!@$%
+ $ ./pw_mon --pw-project=$PROJ --pw-instance=$INST \
+ --add-filter-recheck=$FILTER
+
+ $ for recheck in $(./recheck_tool --pw-project=$PROJ --pw-instance=$INST \
+ --filter=$FILTER --state=0); do
+ echo "Asking for retest $recheck"
+ SERIES=$(echo $recheck | jq -rc '.series_id')
+ SHA=$(echo $recheck | jq -rc '.sha')
+ MSG=$(echo $recheck | jq -rc '.message_id')
+ ./foo_ci_restart --pw-project=$PROJ --pw-instance=$INST \
+ --series-id=$SERIES --sha=$SHA --token=$FOO_TOKEN
+ ./recheck_tool --pw-project=$PROJ --pw-instance=$INST --msgid=$MSG \
+ --series-id=$SERIES --filter=$FILTER \
+ --update --state=0 --new-state=1
+ done
+
+From the users' perspective, in order to request a retest on your patch
+series, send an email reply to one of your series’s patch or cover letter
+emails with email content of the format used below::
+
+ Recheck-request: <test names>
+
+The valid delimiter is a comma optionally followed by a space: “,” “, “
+
+Valid examples::
+
+ Recheck-request: foo, bar, baz
+
+ Recheck-request: foo,bar,baz
+
+ Recheck-request: foo,bar,baz,
+
+Individual projects will have their own policies around who may request a
+recheck, how many recheck requests may be sent, etc. This should be
+documented by the individual projects.
diff --git a/pw_mon b/pw_mon
index e1c1eab..bbe9837 100755
--- a/pw_mon
+++ b/pw_mon
@@ -1,6 +1,6 @@
#!/bin/sh
# SPDX-Identifier: gpl-2.0-or-later
-# Copyright (C) 2018, Red Hat, Inc.
+# Copyright (C) 2018-2023 Red Hat, Inc.
#
# Monitors a project on a patchwork instance for new series submissions
# Records the submissions in the series database (and emits them on the
@@ -44,6 +44,7 @@ if [ "$1" != "" ]; then
fi
fi
+recheck_filter=""
while [ "$1" != "" ]; do
if echo "$1" | grep -q -s -E ^--pw-project= ; then
@@ -64,8 +65,13 @@ while [ "$1" != "" ]; do
echo ""
echo "Options:"
echo " --pw-credentials=u:p Sets user / password for web client"
+ echo " --add-filter-recheck=filter Adds a filter to flag that a recheck needs to be done"
echo ""
exit 0
+ elif echo "$1" | grep -q -s -E ^--add-filter-recheck=; then
+ filter_str=$(echo "$1" | sed s/--add-filter-recheck=//)
+ recheck_filter="$filter_str $recheck_filter"
+ shift
else
echo "Unknown option: '$1'"
echo "Rerun with --help for details"
@@ -190,7 +196,58 @@ function check_superseded_series() {
done
}
+function run_recheck() {
+ local recheck_list=$(echo "$7" | sed -e 's/^Recheck-request: // ' -e 's/,/ /g')
+
+ for filter in $recheck_filter; do
+ for check in $recheck_list; do
+ if [ "$filter" == "$check" ]; then
+ insert_recheck_request_if_needed "$1" "$3" "$8" "$check" "$2" "$9"
+ fi
+ done
+ done
+}
+
+function check_patch_for_retest_request() {
+ local patch_url="$1"
+
+ local patch_json=$(curl -s "$userpw" "$patch_url")
+ local patch_comments_url=$(echo "$patch_json" | jq -rc '.comments')
+ local patch_id=$(echo "$patch_json" | jq -rc '.id')
+ if [ "Xnull" != "X$patch_comments_url" ]; then
+ local comments_json=$(curl -s "$userpw" "$patch_comments_url")
+
+ local seq_end=$(echo "$comments_json" | jq -rc 'length')
+ if [ "$seq_end" -a $seq_end -gt 0 ]; then
+ seq_end=$((seq_end-1))
+ for comment_id in $(seq 0 $seq_end); do
+ local recheck_requested=$(echo "$comments_json" | jq -rc ".[$comment_id].content" | grep "^Recheck-request: ")
+ if [ "X$recheck_requested" != "X" ]; then
+ local msgid=$(echo "$comments_json" | jq -rc ".[$comment_id].msgid")
+ run_recheck "$pw_instance" "$series_id" "$project" "$url" "$repo" "$branchname" "$recheck_requested" "$msgid" "$patch_id"
+ fi
+ done
+ fi
+ fi
+}
+
+function check_series_needs_retest() {
+ local pw_instance="$1"
+
+ series_get_active_branches "$pw_instance" | while IFS=\| read -r series_id project url repo branchname; do
+ local patch_comments_url=$(curl -s "$userpw" "$url" | jq -rc '.patches[] | .url')
+
+ for patch in $patch_comments_url; do
+ check_patch_for_retest_request $patch
+ done
+ done
+}
+
check_undownloaded_series "$pw_instance" "$pw_project"
check_completed_series "$pw_instance" "$pw_project"
check_new_series "$pw_instance" "$pw_project"
check_superseded_series "$pw_instance"
+
+# check for retest requests after a series is still passing all the
+# checks above
+check_series_needs_retest "$pw_instance"
diff --git a/recheck_tool b/recheck_tool
new file mode 100755
index 0000000..98031a9
--- /dev/null
+++ b/recheck_tool
@@ -0,0 +1,99 @@
+#!/bin/sh
+# SPDX-Identifier: gpl-2.0-or-later
+# Copyright (C) 2023 Red Hat, Inc.
+#
+# Licensed under the terms of the GNU General Public License as published
+# by the Free Software Foundation; either version 2 of the License, or
+# (at your option) any later version. You may obtain a copy of the
+# license at
+#
+# https://www.gnu.org/licenses/old-licenses/gpl-2.0.html
+#
+# Unless required by applicable law or agreed to in writing, software
+# distributed under the License is distributed on an "AS IS" BASIS, WITHOUT
+# WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the
+# License for the specific language governing permissions and limitations
+# under the License.
+
+mode="select"
+
+while [ "$1" != "" ]; do
+ if echo "$1" | grep -q -s -E ^--help ; then
+ echo "recheck / retest state machine script"
+ echo ""
+ echo "$0:"
+ echo " --pw-project=<proj>: Patchwork project."
+ echo " --pw-instance=<inst>: Patchwork instance."
+ echo " --filter=<str>: Job / request for recheck."
+ echo " --state=<0..>: Resync state ID."
+ echo " --msgid=<msgid>: Message ID to select."
+ echo " --update: Set tool in update mode"
+ echo " --new-state=<0..>: New state ID to set"
+ echo " --series-id=<..>: Series ID"
+ echo ""
+ echo "Will spit out a parsable json for each db line when selecting"
+ exit 0
+ elif echo "$1" | grep -q -s -E ^--pw-project= ; then
+ pw_project=$(echo "$1" | sed s/^--pw-project=//)
+ elif echo "$1" | grep -q -s -E ^--pw-instance= ; then
+ pw_instance=$(echo "$1" | sed s/^--pw-instance=//)
+ elif echo "$1" | grep -q -s -E ^--filter= ; then
+ filter=$(echo "$1" | sed s/^--filter=//)
+ elif echo "$1" | grep -q -s -E ^--state= ; then
+ recheck_state=$(echo "$1" | sed s/^--state=//)
+ elif echo "$1" | grep -q -s -E ^--msgid= ; then
+ message_id=$(echo "$1" | sed s/^--msgid=//)
+ elif echo "$1" | grep -q -s -E ^--update ; then
+ mode="update"
+ elif echo "$1" | grep -q -s -E ^--new-state= ; then
+ new_recheck_state=$(echo "$1" | sed s/^--new-state=//)
+ elif echo "$1" | grep -q -s -E ^--series-id= ; then
+ series_id=$(echo "$1" | sed s/^--series-id=//)
+ else
+ echo "Unknown option: '$1'"
+ echo "Rerun with --help for details"
+ exit 1
+ fi
+ shift
+done
+
+source $(dirname $0)/series_db_lib.sh
+
+if [ "$mode" == "select" ]; then
+ echo -n "{\"rechecks\":["
+ printed=""
+ for request in $(get_recheck_requests_by_project "$pw_instance" \
+ "$pw_project" \
+ "$recheck_state" \
+ "$filter"); do
+ message_id=$(echo $request | cut -d\| -f1)
+ series_id=$(echo $request | cut -d\| -f2)
+ patch_id=$(echo $request | cut -d\| -f3)
+
+ sha=$(get_sha_for_series_id_and_patch "$series_id" "$patch_id" \
+ "$pw_instance")
+ echo -n "$printed{\"pw_instance\":\"$pw_instance\",\"series_id\":$series_id,\"patch_id\":$patch_id,\"sha\":\"$sha\",\"msg_id\":\"$message_id\",\"state\":\"$recheck_state\",\"requested\":\"$filter\"}"
+ printed=","
+ done
+ echo "]}"
+elif [ "$mode" == "update" ]; then
+ if [ "X$new_recheck_state" == "X" -o "X$series_id" == "X" ]; then
+ echo "Need to set a series-id and a new recheck state when updating."
+ exit 1
+ fi
+
+ request=$(get_recheck_request "$pw_instance" "$pw_project" "$message_id" \
+ "$filter" "$series_id" "$recheck_state")
+ if [ "X$request" == "X" ]; then
+ echo "{\"result\":\"notfound\"}"
+ exit 0
+ fi
+
+ set_recheck_request_state "$pw_instance" "$pw_project" "$message_id" \
+ "$filter" "$series_id" "$new_recheck_state"
+
+ echo "{\"result\":\"executed\",\"recheck\":{\"pw_instance\": \"$pw_instance\", \"series_id\":$series_id, \"msg_id\":\"$message_id\", \"state\":\"$new_recheck_state\", \"requested\": \"$filter\"}}"
+else
+ echo "Uknown state: $mode"
+ exit 1
+fi
diff --git a/series_db_lib.sh b/series_db_lib.sh
index 6c2d98e..e03a02e 100644
--- a/series_db_lib.sh
+++ b/series_db_lib.sh
@@ -1,6 +1,6 @@
#!/bin/sh
# SPDX-Identifier: gpl-2.0-or-later
-# Copyright (C) 2018,2019 Red Hat, Inc.
+# Copyright (C) 2018-2023 Red Hat, Inc.
#
# Licensed under the terms of the GNU General Public License as published
# by the Free Software Foundation; either version 2 of the License, or
@@ -114,6 +114,22 @@ EOF
run_db_command "INSERT INTO series_schema_version(id) values (7);"
fi
+ run_db_command "select * from series_schema_version;" | egrep '^8$' > /dev/null 2>&1
+ if [ $? -eq 1 ]; then
+ sqlite3 ${HOME}/.series-db <<EOF
+CREATE TABLE recheck_requests (
+recheck_id INTEGER,
+recheck_message_id STRING,
+recheck_requested_by STRING,
+recheck_series STRING,
+recheck_patch INTEGER,
+patchwork_instance STRING,
+patchwork_project STRING,
+recheck_sync INTEGER
+);
+EOF
+ run_db_command "INSERT INTO series_schema_version(id) values (8);"
+ fi
}
function series_db_exists() {
@@ -390,3 +406,57 @@ function get_patch_id_by_series_id_and_sha() {
echo "select patch_id from git_builds where patchwork_instance=\"$instance\" and series_id=$series_id and sha=\"$sha\";" | series_db_execute
}
+
+function get_sha_for_series_id_and_patch() {
+ local series_id="$1"
+ local patch_id="$2"
+ local instance="$3"
+
+ echo "select sha from git_builds where patchwork_instance=\"$instance\" and series_id=\"$series_id\" and patch_id=\"$patch_id\"" | series_db_execute
+}
+
+function get_recheck_requests_by_project() {
+ local recheck_instance="$1"
+ local recheck_project="$2"
+ local recheck_state="$3"
+ local recheck_requested_by="$4"
+
+ series_db_exists
+
+ echo "select recheck_message_id,recheck_series,recheck_patch from recheck_requests where patchwork_instance=\"$recheck_instance\" and patchwork_project=\"$recheck_project\" and recheck_sync=$recheck_state and recheck_requested_by=\"$recheck_requested_by\";" | series_db_execute
+}
+
+function insert_recheck_request_if_needed() {
+ local recheck_instance="$1"
+ local recheck_project="$2"
+ local recheck_msgid="$3"
+ local recheck_requested_by="$4"
+ local recheck_series="$5"
+ local recheck_patch="$6"
+
+ if ! echo "select * from recheck_requests where recheck_message_id=\"$recheck_msgid\";" | series_db_execute | grep $recheck_msgid >/dev/null 2>&1; then
+ echo "INSERT INTO recheck_requests (recheck_message_id, recheck_requested_by, recheck_series, recheck_patch, patchwork_instance, patchwork_project, recheck_sync) values (\"$recheck_msgid\", \"$recheck_requested_by\", \"$recheck_series\", $recheck_patch, \"$recheck_instance\", \"$recheck_project\", 0);" | series_db_execute
+ fi
+}
+
+function get_recheck_request() {
+ local recheck_instance="$1"
+ local recheck_project="$2"
+ local recheck_msgid="$3"
+ local recheck_requested_by="$4"
+ local recheck_series="$5"
+ local recheck_state="$6"
+
+ echo "select * from recheck_requests where patchwork_instance=\"$recheck_instance\" and patchwork_project=\"$recheck_project\" and recheck_requested_by=\"$recheck_requested_by\" and recheck_series=\"$recheck_series\" and recheck_message_id=\"$recheck_msgid\" and recheck_sync=$recheck_state;" | series_db_execute
+}
+
+function set_recheck_request_state() {
+ local recheck_instance="$1"
+ local recheck_project="$2"
+ local recheck_msgid="$3"
+ local recheck_requested_by="$4"
+ local recheck_series="$5"
+ local recheck_state="$6"
+
+ echo "UPDATE recheck_requests set recheck_sync=$recheck_state where patchwork_instance=\"$recheck_instance\" and patchwork_project=\"$recheck_project\" and recheck_requested_by=\"$recheck_requested_by\" and recheck_series=\"$recheck_series\";" | series_db_execute
+}
--
2.41.0
^ permalink raw reply [flat|nested] 5+ messages in thread* [PATCH v3 3/3] github: add a tool for restarting checks
2023-11-28 21:01 [PATCH v3 0/3] Add a recheck framework to pw-ci Aaron Conole
2023-11-28 21:01 ` [PATCH v3 1/3] pw_mon: improve command line options Aaron Conole
2023-11-28 21:01 ` [PATCH v3 2/3] recheck: Add a recheck parser for patchwork comments Aaron Conole
@ 2023-11-28 21:01 ` Aaron Conole
2023-11-30 16:04 ` [PATCH v3 0/3] Add a recheck framework to pw-ci Aaron Conole
3 siblings, 0 replies; 5+ messages in thread
From: Aaron Conole @ 2023-11-28 21:01 UTC (permalink / raw)
To: ci
Cc: Michael Santana, David Marchand, Thomas Monjalon, Patrick Robb,
Dumitru Ceara
The recheck framework can track specific recheck labels and track a
state for them. Add a tool that will restart github workflow runs
and mark the git build table to check for a repoll. This will allow
existing monitor tools to re-poll the workflow and report rerun
results.
Acked-by: Michael Santana <msantana@redhat.com>
Signed-off-by: Aaron Conole <aconole@redhat.com>
---
github_restart | 145 +++++++++++++++++++++++++++++++++++++++++++++++
series_db_lib.sh | 8 +++
2 files changed, 153 insertions(+)
create mode 100755 github_restart
diff --git a/github_restart b/github_restart
new file mode 100755
index 0000000..d5d63b9
--- /dev/null
+++ b/github_restart
@@ -0,0 +1,145 @@
+#!/bin/bash
+# SPDX-Identifier: gpl-2.0-or-later
+# Copyright (C) 2023, Red Hat, Inc.
+#
+# Restarts a github job run. This can be used in conjunction with
+# the recheck requests to provide the ability for a user to restart
+# a test - in case the workflow is suspected of having a spurious run.
+#
+# Licensed under the terms of the GNU General Public License as published
+# by the Free Software Foundation; either version 2 of the License, or
+# (at your option) any later version. You may obtain a copy of the
+# license at
+#
+# https://www.gnu.org/licenses/old-licenses/gpl-2.0.html
+#
+# Unless required by applicable law or agreed to in writing, software
+# distributed under the License is distributed on an "AS IS" BASIS, WITHOUT
+# WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the
+# License for the specific language governing permissions and limitations
+# under the License.
+
+wait_start="no"
+
+while [ "$1" != "" ]; do
+ if echo "$1" | grep -q -s -E ^--pw-project= ; then
+ pw_project=$(echo "$1" | sed s/^--pw-project=//)
+ shift
+ elif echo "$1" | grep -q -s -E ^--pw-instance= ; then
+ pw_instance=$(echo "$1" | sed s/^--pw-instance=//)
+ shift
+ elif echo "$1" | grep -q -s -E ^--pw-credentials= ; then
+ pw_credential=$(echo "$1" | sed s/^--pw-credentials=//)
+ shift
+ elif echo "$1" | grep -q -s -E ^--series-id= ; then
+ series_id=$(echo "$1" | sed s/^--series-id=//)
+ shift
+ elif echo "$1" | grep -q -s -E ^--wait-start ; then
+ wait_start="yes"
+ if echo "$1" | grep -q -s -E ^--wait-start= ; then
+ wait_start=$(echo "$1" | sed s/^--wait-start=//)
+ fi
+ shift
+ elif echo "$1" | grep -q -s -E ^--github-token= ; then
+ github_token=$(echo "$1" | sed s/^--github-token=//)
+ shift
+ elif echo "$1" | grep -q -s -E ^--repository= ; then
+ reponame=$(echo "$1" | sed s/^--repository=//)
+ shift
+ elif echo "$1" | grep -q -s -E ^--run-id= ; then
+ runid=$(echo "$1" | sed s/^--repository=//)
+ shift
+ elif echo "$1" | grep -q -s -E ^--sha= ; then
+ sha=$(echo "$1" | sed s/^--sha=//)
+ shift
+ elif echo "$1" | grep -q -s -E ^--workflow= ; then
+ workflow=$(echo "$1" | sed s/^--workflow=//)
+ shift
+ elif echo "$1" | grep -q -s -E ^--help ; then
+ echo "github restarting script"
+ echo "$0: args"
+ echo " --pw-project=<proj> Project name"
+ echo " --pw-instance=<inst url> URL for pw"
+ echo " --series-id=id Series ID for reference"
+ echo " --github-token=token Token for github"
+ echo " --wait-start[=yes|no] Wait for the remote to start"
+ echo " --repository=repo Repository name (ex foo/bar)"
+ echo " --run-id=id run ID"
+ echo " --workflow=workflow Workflow name"
+ echo " --sha=commit Commit sha"
+ echo ""
+ exit 0
+ else
+ echo "Unknown option: '$1'" >&2
+ echo "Rerun with --help for details" >&2
+ exit 1
+ fi
+done
+
+source $(dirname $0)/series_db_lib.sh
+
+if [ "X$wait_start" != "Xno" -a "X$wait_start" != "Xyes" ]; then
+ echo "Unrecognized '$wait_start' argument to --wait-start=" >&2
+ echo "valid values are 'yes' or 'no'." >&2
+ exit 1
+fi
+
+if [ "X$github_token" == "X" ]; then
+ echo "Please set a github API token." >&2
+ echo "Use --help for more info." >&2
+ exit 1
+fi
+
+if [ "X$reponame" == "X" ]; then
+ echo "Please set a repository (ie: '--repository=owner/repo')." >&2
+ echo "Use --help for more info." >&2
+ exit 1
+fi
+
+AUTH="Authorization: token ${github_token}"
+APP="Accept: application/vnd.github.v3+json"
+
+if [ "X$runid" == "X" ]; then
+
+ # lookup the runs based on the shasum
+
+ if [ "X$sha" == "X" ]; then
+ echo "Need a runid or shasum to key off." >&2
+ echo "See --help for more details." >&2
+ exit 1
+ fi
+
+ if [ "X$workflow" != "X" ]; then
+ workflow_select=" | select(.name == \"${workflow}\")"
+ fi
+
+ comma=""
+ for job in $(curl -s -S -H "${AUTH}" -H "${APP}" \
+ "https://api.github.com/repos/${reponame}/actions/runs?head_sha=${sha}" | \
+ jq -rc ".workflow_runs[] ${workflow_select} .id")
+ do
+ runid="${comma}${job}"
+ comma=","
+ done
+fi
+
+echo -n "{\"results\":["
+comma=""
+for job in $(echo "$runid" | sed 's/,/ /'); do
+ result=$(curl -s -X POST -L -S -H "${AUTH}" -H "${APP}" \
+ "https://api.github.com/repos/${reponame}/actions/runs/$job/rerun")
+ msg=$(echo "$result" | jq -rc '.message')
+
+ echo -n "$comma{\"run\":$job,\"result\":"
+ if [ "X$msg" == "Xnull" ]; then
+ echo -n "\"sent\""
+ if [ "X$series_id" != "X" ]; then
+ echo -n ",\"gap_sync\":\"reset\""
+ set_unsynced_for_series "$series_id" "$pw_instance" "gap_sync"
+ fi
+ else
+ echo -n "\"err\",\"error\":\"$msg\""
+ fi
+ echo -n "}"
+done
+echo "]}"
diff --git a/series_db_lib.sh b/series_db_lib.sh
index e03a02e..3f052ad 100644
--- a/series_db_lib.sh
+++ b/series_db_lib.sh
@@ -382,6 +382,14 @@ function set_synced_for_series() {
echo "update git_builds set gap_sync=1, obs_sync=1 where patchwork_instance=\"$instance\" and series_id=$series_id;" | series_db_execute
}
+function set_unsynced_for_series() {
+ local series_id="$1"
+ local instance="$2"
+ local ci_instance="$3"
+
+ echo "update git_builds set $ci_instance=0 where patchwork_instance=\"$instance\" and series_id=$series_id;" | series_db_execute
+}
+
function insert_commit() {
local series_id="$1"
local patch_id="$2"
--
2.41.0
^ permalink raw reply [flat|nested] 5+ messages in thread