/
githubmirror
/
sqlc
Обзор
Документация
Войти
/
githubmirror
/
sqlc
Код
Запросы
0
Пакеты
0
Релизы
0
Аналитика
Безопасность
main
internal/endtoend/testdata/join_left/postgresql/query.sql
59 строк
1 KB
Kyle Gray
test(endtoend): Split shema and queries (#2803)
04 окт 2023, 19:13
Не верифицирован
04 окт 2023, 19:13
5664224
Код
Авторство
О чём код?
-- name: GetMayors :many SELECT user_id, mayors.full_name FROM users LEFT JOIN cities USING (city_id) INNER JOIN mayors USING (mayor_id); -- name: GetMayorsOptional :many SELECT user_id, mayors.full_name FROM users LEFT JOIN cities USING (city_id) LEFT JOIN mayors USING (mayor_id); -- name: AllAuthors :many SELECT * FROM authors a LEFT JOIN authors p ON a.parent_id = p.id; -- name: AllAuthorsAliases :many SELECT * FROM authors a LEFT JOIN authors p ON a.parent_id = p.id; -- name: AllAuthorsAliases2 :many SELECT a.*, p.* FROM authors a LEFT JOIN authors p ON a.parent_id = p.id; -- name: AllSuperAuthors :many SELECT * FROM authors LEFT JOIN super_authors ON authors.parent_id = super_authors.super_id; -- name: AllSuperAuthorsAliases :many SELECT * FROM authors a LEFT JOIN super_authors sa ON a.parent_id = sa.super_id; -- name: AllSuperAuthorsAliases2 :many SELECT a.*, sa.* FROM authors a LEFT JOIN super_authors sa ON a.parent_id = sa.super_id; -- name: GetSuggestedUsersByID :many SELECT DISTINCT u.*, m.* FROM users_2 u LEFT JOIN media m ON u.user_avatar_id = m.media_id WHERE u.user_id != @user_id LIMIT @user_imit;