/
githubmirror
/
sqlc
Обзор
Документация
Войти
/
githubmirror
/
sqlc
Код
Запросы
0
Пакеты
0
Релизы
0
Аналитика
Безопасность
main
internal/endtoend/testdata/params_location/postgresql/stdlib/query.sql
33 строки
937 B
Kyle Gray
test(endtoend): Split shema and queries (#2803)
04 окт 2023, 19:13
Не верифицирован
04 окт 2023, 19:13
5664224
Код
Авторство
О чём код?
/* name: ListUsersByID :many */ SELECT first_name, id, last_name FROM users WHERE id < $1; /* 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 $1; /* name: LimitSQLCArg :many */ select first_name, id FROM users LIMIT $1; /* name: InsertNewUser :exec */ INSERT INTO users (first_name, last_name) VALUES ($1, $2); /* name: ListUserParenExpr :many */ SELECT * FROM users WHERE (job_status = 'APPLIED' OR job_status = 'PENDING') AND id > $1 ORDER BY id LIMIT $2;