0f4df23290
Some checks failed
kotlin / test (push) Has been skipped
python / test (push) Has been skipped
typescript / test (push) Has been skipped
go / build darwin/amd64 (push) Has been cancelled
go / build linux/amd64 (push) Has been cancelled
go / build windows/amd64 (push) Has been cancelled
go / build darwin/arm64 (push) Has been cancelled
go / build linux/arm64 (push) Has been cancelled
go / build windows/arm64 (push) Has been cancelled
go / test (push) Has been cancelled
go / vuln_check (push) Has been cancelled
34 lines
930 B
SQL
34 lines
930 B
SQL
/* name: ListUsersByID :many */
|
|
SELECT first_name, id, last_name FROM users WHERE id < ?;
|
|
|
|
/* name: ListUserOrders :many */
|
|
SELECT
|
|
users.id,
|
|
users.first_name,
|
|
orders.price
|
|
FROM
|
|
orders
|
|
LEFT JOIN users ON orders.user_id = users.id
|
|
WHERE orders.price > sqlc.arg('min_price');
|
|
|
|
/* name: GetUserByID :one */
|
|
SELECT first_name, id, last_name FROM users WHERE id = sqlc.arg('target_id');
|
|
|
|
/* name: ListUsersByFamily :many */
|
|
SELECT first_name, last_name FROM users WHERE age < sqlc.arg('max_age') AND last_name = sqlc.arg('in_family');
|
|
|
|
/* name: ListUsersWithLimit :many */
|
|
SELECT first_name, last_name FROM users LIMIT ?;
|
|
|
|
/* name: LimitSQLCArg :many */
|
|
select first_name, id FROM users LIMIT ?;
|
|
|
|
/* name: InsertNewUser :exec */
|
|
INSERT INTO users (first_name, last_name) VALUES (?, ?);
|
|
|
|
/* name: ListUserParenExpr :many */
|
|
SELECT * FROM users WHERE (job_status = 'APPLIED' OR job_status = 'PENDING')
|
|
AND id > ?
|
|
ORDER BY id
|
|
LIMIT ?;
|