27 lines
472 B
SQL
27 lines
472 B
SQL
-- name: CreateChirp :one
|
|
INSERT INTO chirps (id, created_at, updated_at, body, user_id)
|
|
VALUES (
|
|
gen_random_uuid(),
|
|
NOW(),
|
|
NOW(),
|
|
$1,
|
|
$2
|
|
)
|
|
RETURNING *;
|
|
|
|
-- name: GetChirps :many
|
|
SELECT * FROM chirps
|
|
ORDER BY created_at ASC;
|
|
|
|
-- name: GetChirpsByUserid :many
|
|
SELECT * FROM chirps
|
|
WHERE chirps.user_id = $1;
|
|
|
|
-- name: GetChirp :one
|
|
SELECT * FROM chirps
|
|
WHERE chirps.id = $1;
|
|
|
|
-- name: DeleteChirp :exec
|
|
DELETE FROM chirps
|
|
WHERE id = $1
|
|
AND user_id = $2; |