/
githubmirror
/
sqlc
Обзор
Документация
Войти
/
githubmirror
/
sqlc
Код
Запросы
0
Пакеты
0
Релизы
0
Аналитика
Безопасность
main
examples/ondeck/mysql/query/venue.sql
48 строк
643 B
Kyle Conroy
examples: Port ondeck to MySQL (#680)
26 авг 2020, 18:29
Не верифицирован
26 авг 2020, 18:29
ea268b2
Код
Авторство
О чём код?
/* name: ListVenues :many */ SELECT * FROM venue WHERE city = ? ORDER BY name; /* name: DeleteVenue :exec */ DELETE FROM venue WHERE slug = ? AND slug = ?; /* name: GetVenue :one */ SELECT * FROM venue WHERE slug = ? AND city = ?; /* name: CreateVenue :execresult */ INSERT INTO venue ( slug, name, city, created_at, spotify_playlist, status, statuses, tags ) VALUES ( ?, ?, ?, NOW(), ?, ?, ?, ? ); /* name: UpdateVenueName :exec */ UPDATE venue SET name = ? WHERE slug = ?; /* name: VenueCountByCity :many */ SELECT city, count(*) FROM venue GROUP BY 1 ORDER BY 1;