Open platform to collect and prioritize feedback
package postgres
import (
"context"
"strconv"
"time"
"github.com/getfider/fider/app/models/cmd"
"github.com/getfider/fider/app/models/entity"
"github.com/getfider/fider/app/models/query"
"github.com/getfider/fider/app/pkg/dbx"
"github.com/getfider/fider/app/pkg/errors"
"github.com/getfider/fider/app/services/sqlstore/dbEntities"
)
func addVote(ctx context.Context, c *cmd.AddVote) error {
return using(ctx, func(trx *dbx.Trx, tenant *entity.Tenant, user *entity.User) error {
if !c.Post.CanBeVoted() {
return nil
}
_, err := trx.Execute(
`INSERT INTO post_votes (tenant_id, user_id, post_id, created_at) VALUES ($1, $2, $3, $4) ON CONFLICT DO NOTHING`,
tenant.ID, c.User.ID, c.Post.ID, time.Now(),
)
if err != nil {
return errors.Wrap(err, "failed add vote to post")
}
return nil
})
}
func removeVote(ctx context.Context, c *cmd.RemoveVote) error {
return using(ctx, func(trx *dbx.Trx, tenant *entity.Tenant, user *entity.User) error {
if !c.Post.CanBeVoted() {
return nil
}
_, err := trx.Execute(`DELETE FROM post_votes WHERE user_id = $1 AND post_id = $2 AND tenant_id = $3`, c.User.ID, c.Post.ID, tenant.ID)
if err != nil {
return errors.Wrap(err, "failed to remove vote from post")
}
return nil
})
}
func listPostVotes(ctx context.Context, q *query.ListPostVotes) error {
return using(ctx, func(trx *dbx.Trx, tenant *entity.Tenant, user *entity.User) error {
q.Result = make([]*entity.Vote, 0)
sqlLimit := "ALL"
if q.Limit > 0 {
sqlLimit = strconv.Itoa(q.Limit)
}
emailColumn := "''"
if q.IncludeEmail {
emailColumn = "u.email"
}
votes := []*dbEntities.Vote{}
err := trx.Select(&votes, `
SELECT
pv.created_at,
u.id AS user_id,
u.name AS user_name,
`+emailColumn+` AS user_email,
u.avatar_type AS user_avatar_type,
u.avatar_bkey AS user_avatar_bkey
FROM post_votes pv
INNER JOIN users u
ON u.id = pv.user_id
AND u.tenant_id = pv.tenant_id
WHERE pv.post_id = $1
AND pv.tenant_id = $2
ORDER BY pv.created_at
LIMIT `+sqlLimit, q.PostID, tenant.ID)
if err != nil {
return errors.Wrap(err, "failed to get votes of post")
}
q.Result = make([]*entity.Vote, len(votes))
for i, vote := range votes {
q.Result[i] = vote.ToModel(ctx)
}
return nil
})
}