query/networks.sql


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15

-- name: ListNetworks :many
SELECT * FROM networks
ORDER BY id;

-- name: GetNetwork :one
SELECT * FROM networks
WHERE id = ?;

-- name: CreateNetwork :one
INSERT INTO networks (
  id, name, owner_id
) VALUES (
  ?, ?, ?
)
RETURNING *;