From 78a38f508e7b9d2389c9c422c2d164b9059b03f8 Mon Sep 17 00:00:00 2001 From: Kyren223 Date: Sun, 1 Dec 2024 10:09:21 +0200 Subject: Implemented frequency creation, BROKEN right now --- query/users_networks.sql | 4 ++++ 1 file changed, 4 insertions(+) (limited to 'query') diff --git a/query/users_networks.sql b/query/users_networks.sql index f467753..76cecf4 100644 --- a/query/users_networks.sql +++ b/query/users_networks.sql @@ -22,6 +22,10 @@ JOIN users_networks ON networks.id = users_networks.network_id WHERE users_networks.user_id = ? ORDER BY users_networks.position; +-- name: GetUserNetwork :one +SELECT * FROM users_networks +WHERE user_id = ? AND network_id = ?; + -- name: SetNetworkUser :one INSERT INTO users_networks ( user_id, network_id, -- cgit v1.3.1