123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101 |
- // Copyright 2016 The Gitea Authors. All rights reserved.
- // SPDX-License-Identifier: MIT
-
- package repo
-
- import (
- "context"
-
- "code.gitea.io/gitea/models/db"
- user_model "code.gitea.io/gitea/models/user"
- "code.gitea.io/gitea/modules/timeutil"
- )
-
- // Star represents a starred repo by an user.
- type Star struct {
- ID int64 `xorm:"pk autoincr"`
- UID int64 `xorm:"UNIQUE(s)"`
- RepoID int64 `xorm:"UNIQUE(s)"`
- CreatedUnix timeutil.TimeStamp `xorm:"INDEX created"`
- }
-
- func init() {
- db.RegisterModel(new(Star))
- }
-
- // StarRepo or unstar repository.
- func StarRepo(ctx context.Context, userID, repoID int64, star bool) error {
- ctx, committer, err := db.TxContext(ctx)
- if err != nil {
- return err
- }
- defer committer.Close()
- staring := IsStaring(ctx, userID, repoID)
-
- if star {
- if staring {
- return nil
- }
-
- if err := db.Insert(ctx, &Star{UID: userID, RepoID: repoID}); err != nil {
- return err
- }
- if _, err := db.Exec(ctx, "UPDATE `repository` SET num_stars = num_stars + 1 WHERE id = ?", repoID); err != nil {
- return err
- }
- if _, err := db.Exec(ctx, "UPDATE `user` SET num_stars = num_stars + 1 WHERE id = ?", userID); err != nil {
- return err
- }
- } else {
- if !staring {
- return nil
- }
-
- if _, err := db.DeleteByBean(ctx, &Star{UID: userID, RepoID: repoID}); err != nil {
- return err
- }
- if _, err := db.Exec(ctx, "UPDATE `repository` SET num_stars = num_stars - 1 WHERE id = ?", repoID); err != nil {
- return err
- }
- if _, err := db.Exec(ctx, "UPDATE `user` SET num_stars = num_stars - 1 WHERE id = ?", userID); err != nil {
- return err
- }
- }
-
- return committer.Commit()
- }
-
- // IsStaring checks if user has starred given repository.
- func IsStaring(ctx context.Context, userID, repoID int64) bool {
- has, _ := db.GetEngine(ctx).Get(&Star{UID: userID, RepoID: repoID})
- return has
- }
-
- // GetStargazers returns the users that starred the repo.
- func GetStargazers(ctx context.Context, repo *Repository, opts db.ListOptions) ([]*user_model.User, error) {
- sess := db.GetEngine(ctx).Where("star.repo_id = ?", repo.ID).
- Join("LEFT", "star", "`user`.id = star.uid")
- if opts.Page > 0 {
- sess = db.SetSessionPagination(sess, &opts)
-
- users := make([]*user_model.User, 0, opts.PageSize)
- return users, sess.Find(&users)
- }
-
- users := make([]*user_model.User, 0, 8)
- return users, sess.Find(&users)
- }
-
- // ClearRepoStars clears all stars for a repository and from the user that starred it.
- // Used when a repository is set to private.
- func ClearRepoStars(ctx context.Context, repoID int64) error {
- if _, err := db.Exec(ctx, "UPDATE `user` SET num_stars=num_stars-1 WHERE id IN (SELECT `uid` FROM `star` WHERE repo_id = ?)", repoID); err != nil {
- return err
- }
-
- if _, err := db.Exec(ctx, "UPDATE `repository` SET num_stars = 0 WHERE id = ?", repoID); err != nil {
- return err
- }
-
- return db.DeleteBeans(ctx, Star{RepoID: repoID})
- }
|