mirror of https://github.com/rocboss/paopao-ce
You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
44 lines
1.3 KiB
44 lines
1.3 KiB
--------------------------------------------------------------------------------
|
|
-- following_manager sql dml
|
|
--------------------------------------------------------------------------------
|
|
|
|
-- name: CreateFollowing :exec
|
|
INSERT INTO p_following (user_id, follow_id, created_on)
|
|
VALUES ($1, $2, $3);
|
|
|
|
-- name: ExistFollowing :one
|
|
SELECT true FROM p_following WHERE user_id=$1 AND follow_id=$2 AND is_del=0;
|
|
|
|
-- name: DeleteFollowing :exec
|
|
UPDATE p_following
|
|
SET is_del=1, deleted_on=$1
|
|
WHERE user_id=$2 AND follow_id=$3 AND is_del=0;
|
|
|
|
-- name: ListFollows :many
|
|
SELECT u.id user_id,
|
|
u.username username,
|
|
u.nickname nickname,
|
|
u.avatar avatar,
|
|
u.created_on created_on
|
|
FROM p_following f JOIN p_user u ON f.follow_id=u.id
|
|
WHERE f.user_id=$1 AND f.is_del=0
|
|
ORDER BY u.nickname ASC
|
|
LIMIT $2 OFFSET $3;
|
|
|
|
-- name: CountFollows :one
|
|
SELECT count(*) FROM p_following WHERE user_id=$1 AND is_del=0;
|
|
|
|
-- name: ListFollowings :many
|
|
SELECT u.id user_id,
|
|
u.username username,
|
|
u.nickname nickname,
|
|
u.avatar avatar,
|
|
u.created_on created_on
|
|
FROM p_following f JOIN p_user u ON f.user_id=u.id
|
|
WHERE f.follow_id=$1 AND f.is_del=0
|
|
ORDER BY u.nickname ASC
|
|
LIMIT $2 OFFSET $3;
|
|
|
|
-- name: CountFollowings :one
|
|
SELECT count(*) FROM p_following WHERE follow_id=$1 AND is_del=0;
|