diff options
author | Přemysl Eric Janouch <p@janouch.name> | 2023-12-12 06:37:20 +0100 |
---|---|---|
committer | Přemysl Eric Janouch <p@janouch.name> | 2023-12-12 06:37:20 +0100 |
commit | 80c5f1cd32c06977da69c8a815ffa35ce9a909f1 (patch) | |
tree | b2e2e16ed2240afeeb8b582bcb6c88069e113737 /main.go | |
parent | 4ed83bdb017d7d078d7d56863f35b95940988e5b (diff) | |
download | gallery-80c5f1cd32c06977da69c8a815ffa35ce9a909f1.tar.gz gallery-80c5f1cd32c06977da69c8a815ffa35ce9a909f1.tar.xz gallery-80c5f1cd32c06977da69c8a815ffa35ce9a909f1.zip |
Think about garbage collection
Diffstat (limited to 'main.go')
-rw-r--r-- | main.go | 3 |
1 files changed, 2 insertions, 1 deletions
@@ -583,7 +583,8 @@ func cmdTag(args []string) error { // or even just clear the tag space completely: // // DELETE FROM tag_assignment - // WHERE tag IN (SELECT id FROM tag WHERE space = ?) + // WHERE tag IN (SELECT id FROM tag WHERE space = ?); + // DELETE FROM tag WHERE space = ?; stmt, err := tx.Prepare(`INSERT INTO tag_assignment(sha1, tag, weight) VALUES (?, (SELECT id FROM tag WHERE space = ? AND name = ?), ?) ON CONFLICT DO UPDATE SET weight = ?`) |