mirror of
https://github.com/abhinavxd/libredesk.git
synced 2025-11-05 06:23:27 +00:00
26 lines
400 B
SQL
26 lines
400 B
SQL
-- name: insert
|
|
INSERT INTO csat_responses (
|
|
conversation_id
|
|
)
|
|
VALUES ($1)
|
|
RETURNING uuid;
|
|
|
|
-- name: get
|
|
SELECT id,
|
|
uuid,
|
|
created_at,
|
|
updated_at,
|
|
conversation_id,
|
|
rating,
|
|
feedback,
|
|
response_timestamp
|
|
FROM csat_responses
|
|
WHERE uuid = $1;
|
|
|
|
-- name: update
|
|
UPDATE csat_responses
|
|
SET rating = $2,
|
|
feedback = $3,
|
|
response_timestamp = NOW()
|
|
WHERE uuid = $1;
|