diff options
Diffstat (limited to 'query/networks.sql')
| -rw-r--r-- | query/networks.sql | 15 |
1 files changed, 15 insertions, 0 deletions
diff --git a/query/networks.sql b/query/networks.sql new file mode 100644 index 0000000..d709975 --- /dev/null +++ b/query/networks.sql @@ -0,0 +1,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 *; |
