diff options
Diffstat (limited to 'query/frequencies.sql')
| -rw-r--r-- | query/frequencies.sql | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/query/frequencies.sql b/query/frequencies.sql new file mode 100644 index 0000000..ed68c78 --- /dev/null +++ b/query/frequencies.sql @@ -0,0 +1,12 @@ +-- name: GetNetworkFrequencies :many +SELECT * FROM frequencies +WHERE network_id = ? +ORDER BY id; + +-- name: CreateFrequency :one +INSERT INTO frequencies ( + id, network_id, name +) VALUES ( + ?, ?, ? +) +RETURNING *; |