diff options
| author | Taras Madan <tarasmadan@google.com> | 2024-08-27 17:22:10 +0200 |
|---|---|---|
| committer | Taras Madan <tarasmadan@google.com> | 2024-08-28 11:19:13 +0000 |
| commit | ef3de9e86e58ef3c70da9cf673ee44fc6f1006f9 (patch) | |
| tree | ebaae66b6247f683d808656b568bfac2d3838ce8 /tools | |
| parent | 940f38c1d236deec56b628d5586fdd6a5c33f5b6 (diff) | |
tools/syz-covermerger: drop all data on init_db.sh call
It looks save because the data can always be recalculated.
Diffstat (limited to 'tools')
| -rwxr-xr-x | tools/syz-covermerger/init_db.sh | 21 |
1 files changed, 15 insertions, 6 deletions
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, |