14 lines
248 B
SQL
14 lines
248 B
SQL
-- name: CreateMerchant :one
|
|
INSERT INTO merchants (name,owner_id)
|
|
VALUES ($1, $2)
|
|
RETURNING *;
|
|
|
|
-- name: GetMerchantById :one
|
|
SELECT * FROM merchants
|
|
WHERE id = $1;
|
|
|
|
-- name: GetMerchantByUserId :one
|
|
SELECT * FROM merchants
|
|
WHERE owner_id = $1;
|
|
|