From ef3de9e86e58ef3c70da9cf673ee44fc6f1006f9 Mon Sep 17 00:00:00 2001
From: Taras Madan <tarasmadan@google.com>
Date: Tue, 27 Aug 2024 17:22:10 +0200
Subject: tools/syz-covermerger: drop all data on init_db.sh call

It looks save because the data can always be recalculated.
---
 tools/syz-covermerger/init_db.sh | 21 +++++++++++++++------
 1 file changed, 15 insertions(+), 6 deletions(-)

(limited to 'tools')

diff --git a/tools/syz-covermerger/init_db.sh b/tools/syz-covermerger/init_db.sh
index 929eaca32..c7f1c7afa 100755
--- a/tools/syz-covermerger/init_db.sh
+++ b/tools/syz-covermerger/init_db.sh
@@ -6,9 +6,12 @@ set -e # exit on any problem
 set -o pipefail
 
 db="coverage"
-echo "making sure spanner table 'files' exists"
+echo "drop table 'files' if exists"
+gcloud spanner databases ddl update $db --instance=syzbot --project=syzkaller \
+--ddl="DROP TABLE IF EXISTS files"
+echo "create table 'files'"
 create_table=$( echo -n '
-CREATE TABLE IF NOT EXISTS
+CREATE TABLE
   files (
     "session" text,
     "filepath" text,
@@ -19,9 +22,12 @@ CREATE TABLE IF NOT EXISTS
 gcloud spanner databases ddl update $db --instance=syzbot --project=syzkaller \
  --ddl="$create_table"
 
-echo "making sure spanner table 'merge_history' exists"
+echo "drop table 'merge_history' if exists"
+gcloud spanner databases ddl update $db --instance=syzbot --project=syzkaller \
+--ddl="DROP TABLE IF EXISTS merge_history"
+echo "create table 'merge_history'"
 create_table=$( echo -n '
-CREATE TABLE IF NOT EXISTS
+CREATE TABLE
   merge_history (
     "namespace" text,
     "repo" text,
@@ -36,9 +42,12 @@ CREATE TABLE IF NOT EXISTS
 gcloud spanner databases ddl update $db --instance=syzbot --project=syzkaller \
  --ddl="$create_table"
 
-echo "making sure spanner table 'file_subsystems' exists"
+echo "drop table 'file_subsystems' if exists"
+gcloud spanner databases ddl update $db --instance=syzbot --project=syzkaller \
+--ddl="DROP TABLE IF EXISTS file_subsystems"
+echo "create table 'file_subsystems'"
 create_table=$( echo -n '
-CREATE TABLE IF NOT EXISTS
+CREATE TABLE
   file_subsystems (
     "namespace" text,
     "filepath" text,
-- 
cgit mrf-deployment