db: refactor "action" table to use GORM (#7054)

Co-authored-by: deepsource-autofix[bot] <62050782+deepsource-autofix[bot]@users.noreply.github.com>

1 files changed, 38 insertions, 0 deletions

diff --git a/internal/db/watches.go b/internal/db/watches.go
new file mode 100644
index 00000000..e93a4ab6
--- /dev/null
+++ b/internal/db/watches.go
@@ -0,0 +1,38 @@
+// Copyright 2020 The Gogs Authors. All rights reserved.
+// Use of this source code is governed by a MIT-style
+// license that can be found in the LICENSE file.
+
+package db
+
+import (
+	"context"
+
+	"gorm.io/gorm"
+)
+
+// WatchesStore is the persistent interface for watches.
+//
+// NOTE: All methods are sorted in alphabetical order.
+type WatchesStore interface {
+	// ListByRepo returns all watches of the given repository.
+	ListByRepo(ctx context.Context, repoID int64) ([]*Watch, error)
+}
+
+var Watches WatchesStore
+
+var _ WatchesStore = (*watches)(nil)
+
+type watches struct {
+	*gorm.DB
+}
+
+// NewWatchesStore returns a persistent interface for watches with given
+// database connection.
+func NewWatchesStore(db *gorm.DB) WatchesStore {
+	return &watches{DB: db}
+}
+
+func (db *watches) ListByRepo(ctx context.Context, repoID int64) ([]*Watch, error) {
+	var watches []*Watch
+	return watches, db.WithContext(ctx).Where("repo_id = ?", repoID).Find(&watches).Error
+}