1
0
go-rss-aggregator/sql/queries/feed_follows.sql
2023-09-09 14:39:32 +03:00

11 lines
303 B
SQL

-- name: CreateFeedFollow :one
INSERT INTO feed_follows (created_at, updated_at, user_id, feed_id)
VALUES (?, ?, ?, ?)
RETURNING *;
-- name: GetFeedFollowsByUser :many
SELECT * FROM feed_follows WHERE user_id = ?;
-- name: DeleteFeedFollow :exec
DELETE FROM feed_follows WHERE id = ? AND user_id = ?;