diff options
| author |  tobi <31960611+tsmethurst@users.noreply.github.com> | 2022-10-08 13:50:48 +0200 |
|---|---|---|
| committer |  GitHub <noreply@github.com> | 2022-10-08 13:50:48 +0200 |
| commit | aa07750bdb4dacdb1be39d765114915bba3fc29f (patch) | |
| tree | 30e9e5052f607f8c8e4f7d518559df8706275e0f /internal/db/bundb/migrations | |
| parent | [performance] cache domains after max retries in transport (#884) (diff) | |
| download | gotosocial-aa07750bdb4dacdb1be39d765114915bba3fc29f.tar.xz | |
[chore] Standardize database queries, use `bun.Ident()` properly (#886)
* use bun.Ident for user queries
* use bun.Ident for account queries
* use bun.Ident for media queries
* add DeleteAccount func
* remove CaseInsensitive in Where+use Ident ipv Safe
* update admin db
* update domain, use ident
* update emoji, use ident
* update instance queries, use bun.Ident
* fix media
* update mentions, use bun ident
* update relationship + tests
* use tableexpr
* add test follows to bun db test suite
* update notifications
* updatebyprimarykey => updatebyid
* fix session
* prefer explicit ID to pk
* fix little fucky wucky
* remove workaround
* use proper db func for attachment selection
* update status db
* add m2m entries in test rig
* fix up timeline
* go fmt
* fix status put issue
* update GetAccountStatuses
Diffstat (limited to 'internal/db/bundb/migrations')
| -rw-r--r-- | internal/db/bundb/migrations/20220612091800_duplicated_media_cleanup.go | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/internal/db/bundb/migrations/20220612091800_duplicated_media_cleanup.go b/internal/db/bundb/migrations/20220612091800_duplicated_media_cleanup.go index 4c4ada594..b0179ec4f 100644 --- a/internal/db/bundb/migrations/20220612091800_duplicated_media_cleanup.go +++ b/internal/db/bundb/migrations/20220612091800_duplicated_media_cleanup.go @@ -47,8 +47,8 @@ func init() { } if _, err := tx.NewDelete(). - Model(a). - WherePK(). + TableExpr("? AS ?", bun.Ident("media_attachments"), bun.Ident("media_attachment")). + Where("? = ?", bun.Ident("media_attachment.id"), a.ID). Exec(ctx); err != nil { l.Errorf("error deleting attachment with id %s: %s", a.ID, err) } else { |