14 lines
349 B
SQL
14 lines
349 B
SQL
-- name: CreateLock :one
|
|
INSERT INTO locks (zwave_device_id, name) VALUES (?, "") RETURNING *;
|
|
|
|
-- name: GetLocks :many
|
|
SELECT * FROM locks;
|
|
|
|
-- name: GetLock :one
|
|
SELECT * FROM locks WHERE id = ?;
|
|
|
|
-- name: GetLockByDeviceID :one
|
|
SELECT * FROM locks WHERE zwave_device_id = ?;
|
|
|
|
-- name: UpdateLockName :exec
|
|
UPDATE locks SET name = ? WHERE id = ?;
|