diff options
| author | Kyren223 <ulmliad223@gmail.com> | 2024-10-27 17:04:08 +0200 |
|---|---|---|
| committer | Kyren223 <ulmliad223@gmail.com> | 2024-10-27 17:04:08 +0200 |
| commit | 31e3778061a20e0787c076d9353e82b2e223841e (patch) | |
| tree | ad95dad6c9d1d7df57314dd01787be4f23dc7549 /query/frequencies.sql | |
| parent | 9a1030a5799b4b5e4456152993732c3bff375888 (diff) | |
feat: add setup for SQL
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 *; |