9 lines
285 B
SQL
9 lines
285 B
SQL
-- name: CreateFeedback :one
|
|
INSERT INTO feedback (user_id, workspace_id, message, metadata)
|
|
VALUES ($1, sqlc.narg(workspace_id), $2, $3)
|
|
RETURNING *;
|
|
|
|
-- name: CountRecentFeedbackByUser :one
|
|
SELECT count(*) FROM feedback
|
|
WHERE user_id = $1 AND created_at > now() - interval '1 hour';
|