aboutsummaryrefslogtreecommitdiff
path: root/weed/filer/ydb/ydb_queries.go
diff options
context:
space:
mode:
authorChris Lu <chrislusf@users.noreply.github.com>2022-05-11 10:11:16 -0700
committerGitHub <noreply@github.com>2022-05-11 10:11:16 -0700
commite41b11b0045376700d4ab047a54a2758a69552ea (patch)
treee7413a024d877d5c4918dc090c70617823c2f06b /weed/filer/ydb/ydb_queries.go
parentbff1ccc1debf256912d747ab8ca127799d5a28dd (diff)
parentf523aed3c9b52529d63172a4572ac2e4db8ebc3a (diff)
downloadseaweedfs-e41b11b0045376700d4ab047a54a2758a69552ea.tar.xz
seaweedfs-e41b11b0045376700d4ab047a54a2758a69552ea.zip
Merge pull request #3040 from kmlebedev/ydb_fix
fixes from comments
Diffstat (limited to 'weed/filer/ydb/ydb_queries.go')
-rw-r--r--weed/filer/ydb/ydb_queries.go15
1 files changed, 1 insertions, 14 deletions
diff --git a/weed/filer/ydb/ydb_queries.go b/weed/filer/ydb/ydb_queries.go
index c8876e004..f1db9a143 100644
--- a/weed/filer/ydb/ydb_queries.go
+++ b/weed/filer/ydb/ydb_queries.go
@@ -6,7 +6,7 @@ package ydb
import asql "github.com/chrislusf/seaweedfs/weed/filer/abstract_sql"
const (
- insertQuery = `
+ upsertQuery = `
PRAGMA TablePathPrefix("%v");
DECLARE $dir_hash AS int64;
DECLARE $directory AS Utf8;
@@ -19,19 +19,6 @@ const (
VALUES
($dir_hash, $name, $directory, $meta, $expire_at);`
- updateQuery = `
- PRAGMA TablePathPrefix("%v");
- DECLARE $dir_hash AS int64;
- DECLARE $directory AS Utf8;
- DECLARE $name AS Utf8;
- DECLARE $meta AS String;
- DECLARE $expire_at AS Optional<uint32>;
-
- REPLACE INTO ` + asql.DEFAULT_TABLE + `
- (dir_hash, name, directory, meta, expire_at)
- VALUES
- ($dir_hash, $name, $directory, $meta, $expire_at);`
-
deleteQuery = `
PRAGMA TablePathPrefix("%v");
DECLARE $dir_hash AS int64;