| 12345678910111213141516171819 |
- -- name: ListZones :many
- SELECT * FROM zones ORDER BY name;
- -- name: GetZone :one
- SELECT * FROM zones WHERE id = ?;
- -- name: CreateZone :one
- INSERT INTO zones (zone_id, name, api_key)
- VALUES (?, ?, ?)
- RETURNING *;
- -- name: UpdateZone :one
- UPDATE zones
- SET zone_id = ?, name = ?, api_key = ?, updated_at = CURRENT_TIMESTAMP
- WHERE id = ?
- RETURNING *;
- -- name: DeleteZone :exec
- DELETE FROM zones WHERE id = ?;
|
