diff options
| author | Chris Lu <chrislusf@users.noreply.github.com> | 2021-03-30 00:25:01 -0700 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2021-03-30 00:25:01 -0700 |
| commit | bec74c3e6a4279288c790fb052eb2844e3b9bc36 (patch) | |
| tree | 555d0e3edf71e66f404185c3148b7553b7c9c50c /weed/command/scaffold.go | |
| parent | a95929e53ca609181dddda04ece0e6d482234161 (diff) | |
| parent | 9f1cab179c1c41deb1db627e8bfbc632a2dffba7 (diff) | |
| download | seaweedfs-bec74c3e6a4279288c790fb052eb2844e3b9bc36.tar.xz seaweedfs-bec74c3e6a4279288c790fb052eb2844e3b9bc36.zip | |
Merge pull request #1948 from LazyDBA247-Anyvision/master
add enableUpsert=true
Diffstat (limited to 'weed/command/scaffold.go')
| -rw-r--r-- | weed/command/scaffold.go | 28 |
1 files changed, 12 insertions, 16 deletions
diff --git a/weed/command/scaffold.go b/weed/command/scaffold.go index 337adaa22..7df69e211 100644 --- a/weed/command/scaffold.go +++ b/weed/command/scaffold.go @@ -120,10 +120,9 @@ connection_max_idle = 2 connection_max_open = 100 connection_max_lifetime_seconds = 0 interpolateParams = false -# Empty insertQuery will use the default insert query -# example insertQuery can be for UPSERT syntax: -# insertQuery = """INSERT INTO ` + "`%s`" + ` (dirhash,name,directory,meta) VALUES(?,?,?,?) ON DUPLICATE KEY UPDATE meta = VALUES(meta)""" -insertQuery = "" +# if insert/upsert failing, you can disable upsert or update query syntax to match your RDBMS syntax: +upsertQuery = """INSERT INTO ` + "`%s`" + ` (dirhash,name,directory,meta) VALUES(?,?,?,?) ON DUPLICATE KEY UPDATE meta = VALUES(meta)""" +enableUpsert = true [mysql2] # or memsql, tidb enabled = false @@ -145,10 +144,9 @@ connection_max_idle = 2 connection_max_open = 100 connection_max_lifetime_seconds = 0 interpolateParams = false -# Empty insertQuery will use the default insert query -# example insertQuery can be for UPSERT syntax: -# insertQuery = """INSERT INTO ` + "`%s`" + ` (dirhash,name,directory,meta) VALUES(?,?,?,?) ON DUPLICATE KEY UPDATE meta = VALUES(meta)""" -insertQuery = "" +# if insert/upsert failing, you can disable upsert or update query syntax to match your RDBMS syntax: +upsertQuery = """INSERT INTO ` + "`%s`" + ` (dirhash,name,directory,meta) VALUES(?,?,?,?) ON DUPLICATE KEY UPDATE meta = VALUES(meta)""" +enableUpsert = true [postgres] # or cockroachdb, YugabyteDB # CREATE TABLE IF NOT EXISTS filemeta ( @@ -169,10 +167,9 @@ sslmode = "disable" connection_max_idle = 100 connection_max_open = 100 connection_max_lifetime_seconds = 0 -# Empty insertQuery will use the default insert query -# example insertQuery can be for UPSERT syntax: -# insertQuery = """INSERT INTO "%[1]s" (dirhash,name,directory,meta) VALUES($1,$2,$3,$4) ON CONFLICT ON CONSTRAINT "%[1]s_pkey" DO UPDATE SET meta = EXCLUDED.meta WHERE "%[1]s".meta != EXCLUDED.meta""" -insertQuery = "" +# if insert/upsert failing, you can disable upsert or update query syntax to match your RDBMS syntax: +upsertQuery = """INSERT INTO "%[1]s" (dirhash,name,directory,meta) VALUES($1,$2,$3,$4) ON CONFLICT (dirhash,name) DO UPDATE SET meta = EXCLUDED.meta WHERE "%[1]s".meta != EXCLUDED.meta""" +enableUpsert = true [postgres2] enabled = false @@ -195,10 +192,9 @@ sslmode = "disable" connection_max_idle = 100 connection_max_open = 100 connection_max_lifetime_seconds = 0 -# Empty insertQuery will use the default insert query -# example insertQuery can be for UPSERT syntax: -# insertQuery = """INSERT INTO "%[1]s" (dirhash,name,directory,meta) VALUES($1,$2,$3,$4) ON CONFLICT ON CONSTRAINT "%[1]s_pkey" DO UPDATE SET meta = EXCLUDED.meta WHERE "%[1]s".meta != EXCLUDED.meta""" -insertQuery = "" +# if insert/upsert failing, you can disable upsert or update query syntax to match your RDBMS syntax: +upsertQuery = """INSERT INTO "%[1]s" (dirhash,name,directory,meta) VALUES($1,$2,$3,$4) ON CONFLICT ON CONSTRAINT "%[1]s_pkey" DO UPDATE SET meta = EXCLUDED.meta WHERE "%[1]s".meta != EXCLUDED.meta""" +enableUpsert = true [cassandra] # CREATE TABLE filemeta ( |