diff options
| author | Kyren223 <Kyren223@proton.me> | 2024-11-23 22:32:02 +0200 |
|---|---|---|
| committer | Kyren223 <Kyren223@proton.me> | 2024-11-23 22:32:02 +0200 |
| commit | 7894503e7a5de54b2b6788822d248172ed1ca141 (patch) | |
| tree | fb752f67af438165eed26cce867c1257d2f4cebb /query/frequencies.sql | |
| parent | 25c79bfbf37a541f7115b5c9fea3656984b71d54 (diff) | |
Added network setters
Diffstat (limited to 'query/frequencies.sql')
| -rw-r--r-- | query/frequencies.sql | 9 |
1 files changed, 6 insertions, 3 deletions
diff --git a/query/frequencies.sql b/query/frequencies.sql index 6e18fe6..6e67c24 100644 --- a/query/frequencies.sql +++ b/query/frequencies.sql @@ -28,17 +28,20 @@ WHERE network_id = ? AND position IN (@pos1, @pos2); -- name: SetFrequencyName :one UPDATE frequencies SET name = ? -WHERE id = ?; +WHERE id = ? +RETURNING *; -- name: SetFrequencyColor :one UPDATE frequencies SET hex_color = ? -WHERE id = ?; +WHERE id = ? +RETURNING *; -- name: SetFrequencyPerms :one UPDATE frequencies SET perms = ? -WHERE id = ?; +WHERE id = ? +RETURNING *; -- name: DeleteFrequency :exec DELETE FROM frequencies WHERE id = ?; |
