aboutsummaryrefslogtreecommitdiff
path: root/weed/filer2/postgres/postgres_store.go
diff options
context:
space:
mode:
authorChris Lu <chris.lu@gmail.com>2019-12-13 00:23:05 -0800
committerChris Lu <chris.lu@gmail.com>2019-12-13 00:23:05 -0800
commitbbb6ebc3c024e8f2992ba8ad4eb3426364e70566 (patch)
tree8ef528f73c31d44103a652ccb850c34677dd9aa8 /weed/filer2/postgres/postgres_store.go
parent0fa1269bc77abe30f4d108a88a97e29e1bca3124 (diff)
downloadseaweedfs-bbb6ebc3c024e8f2992ba8ad4eb3426364e70566.tar.xz
seaweedfs-bbb6ebc3c024e8f2992ba8ad4eb3426364e70566.zip
filer: DeleteFolderChildren for deleting large folders
Diffstat (limited to 'weed/filer2/postgres/postgres_store.go')
-rw-r--r--weed/filer2/postgres/postgres_store.go1
1 files changed, 1 insertions, 0 deletions
diff --git a/weed/filer2/postgres/postgres_store.go b/weed/filer2/postgres/postgres_store.go
index ffd3d1e01..3ec000fe0 100644
--- a/weed/filer2/postgres/postgres_store.go
+++ b/weed/filer2/postgres/postgres_store.go
@@ -45,6 +45,7 @@ func (store *PostgresStore) initialize(user, password, hostname string, port int
store.SqlUpdate = "UPDATE filemeta SET meta=$1 WHERE dirhash=$2 AND name=$3 AND directory=$4"
store.SqlFind = "SELECT meta FROM filemeta WHERE dirhash=$1 AND name=$2 AND directory=$3"
store.SqlDelete = "DELETE FROM filemeta WHERE dirhash=$1 AND name=$2 AND directory=$3"
+ store.SqlDeleteFolderChildren = "DELETE FROM filemeta WHERE dirhash=$1 AND directory=$2"
store.SqlListExclusive = "SELECT NAME, meta FROM filemeta WHERE dirhash=$1 AND name>$2 AND directory=$3 ORDER BY NAME ASC LIMIT $4"
store.SqlListInclusive = "SELECT NAME, meta FROM filemeta WHERE dirhash=$1 AND name>=$2 AND directory=$3 ORDER BY NAME ASC LIMIT $4"