diff options
| author |  Romain de Laage <romain@delaage.fr>
| 2024-03-24 07:31:54 +0100 |
|---|---|---|
| committer |  Frédéric Guillot <f@miniflux.net>
| 2024-03-24 14:50:18 -0700 |
| commit | b54fe66809d820233da00b582b645e4b513f6dda (patch) | |
| tree | ed9db64d95fa6d6fb861802dc5ddc153755bfef8 /internal/database/migrations.go | |
| parent | 93c9d43497fed161c428933602f8112fce43733b (diff) | |
| download | v2-b54fe66809d820233da00b582b645e4b513f6dda.tar.gz v2-b54fe66809d820233da00b582b645e4b513f6dda.tar.zst v2-b54fe66809d820233da00b582b645e4b513f6dda.zip | |
fix: do not store empty tags
Diffstat (limited to 'internal/database/migrations.go')
| -rw-r--r-- | internal/database/migrations.go | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/internal/database/migrations.go b/internal/database/migrations.go index cfc1159d..d40e5d2f 100644 --- a/internal/database/migrations.go +++ b/internal/database/migrations.go @@ -876,4 +876,10 @@ var migrations = []func(tx *sql.Tx) error{ _, err = tx.Exec(sql) return err }, + func(tx *sql.Tx) (err error) { + // the WHERE part speed-up the request a lot + sql := `UPDATE entries SET tags = array_remove(tags, '') WHERE '' = ANY(tags);` + _, err = tx.Exec(sql) + return err + }, } |