/
githubmirror
/
sqlc
Обзор
Документация
Войти
/
githubmirror
/
sqlc
Код
Запросы
0
Пакеты
0
Релизы
0
Аналитика
Безопасность
main
examples/ondeck/sqlite/query/venue.sql
48 строк
655 B
Kazuyuki Honda
feat: More SQL Syntax Support for SQLite (#1687)
18 июн 2022, 23:36
Не верифицирован
18 июн 2022, 23:36
0dc2c81
Код
Авторство
О чём код?
/* 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 ( ?, ?, ?, CURRENT_TIMESTAMP, ?, ?, ?, ? ); /* name: UpdateVenueName :exec */ UPDATE venue SET name = ? WHERE slug = ?; /* name: VenueCountByCity :many */ SELECT city, count(*) FROM venue GROUP BY 1 ORDER BY 1;