diff options
Diffstat (limited to 'tsp/jobs')
-rwxr-xr-x | tsp/jobs/update_db.sh | 37 |
1 files changed, 37 insertions, 0 deletions
diff --git a/tsp/jobs/update_db.sh b/tsp/jobs/update_db.sh new file mode 100755 index 0000000..1c322ee --- /dev/null +++ b/tsp/jobs/update_db.sh @@ -0,0 +1,37 @@ +#!/bin/sh + +# Copyright (c) 2016 Samsung Electronics Co., Ltd All Rights Reserved +# +# Licensed under the Apache License, Version 2.0 (the "License"); +# you may not use this file except in compliance with the License. +# You may obtain a copy of the License at +# +# http://www.apache.org/licenses/LICENSE-2.0 +# +# 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. + +# Author: Aleksander Mistewicz <a.mistewicz@samsung.com> + +export TSP_DIR="$(CDPATH='' cd -- "$(dirname -- "$0")" && pwd -P)/.." + +. "${TSP_DIR}/common.sh" + +SR="$1" +TAG="$2" +BUILD_NR="$3" +TARGET="$4" + +test -n "$SR" || die "Missing argument: sr" +test -n "$TAG" || die "Missing argument: tag" +test -n "$BUILD_NR" || die "Missing argument: build_nr" +test -n "$TARGET" || die "Missing argument: target" + +lockfile-create --use-pid "${DBPATH}" +sqlite3 "${DBPATH}" "insert into test values (NULL,'$SR', CURRENT_TIMESTAMP, $BUILD_NR,\ + (select r.rid from result r where r.rname='$TAG'),\ + (select d.did from device d where d.dname='$TARGET'));" +lockfile-remove "${DBPATH}" |