diff options
| author | Kyren223 <Kyren223@proton.me> | 2024-11-28 18:00:50 +0200 |
|---|---|---|
| committer | Kyren223 <Kyren223@proton.me> | 2024-11-28 18:00:50 +0200 |
| commit | d0356edef4dc0a14304b8890e8152911740ff87a (patch) | |
| tree | 9f96b2e1b591d9d86970db9102abae04055a5ac7 /internal/data/users.sql.go | |
| parent | c3f8131caf597dc028c08c8dd9f2f65a213e580d (diff) | |
Added position to networks
Diffstat (limited to 'internal/data/users.sql.go')
| -rw-r--r-- | internal/data/users.sql.go | 37 |
1 files changed, 0 insertions, 37 deletions
diff --git a/internal/data/users.sql.go b/internal/data/users.sql.go index 562ab35..33eab3f 100644 --- a/internal/data/users.sql.go +++ b/internal/data/users.sql.go @@ -109,43 +109,6 @@ func (q *Queries) GetUserByPublicKey(ctx context.Context, publicKey ed25519.Publ return i, err } -const getUserNetworks = `-- name: GetUserNetworks :many -SELECT networks.id, networks.owner_id, networks.name, networks.icon, networks.bg_hex_color, networks.fg_hex_color, networks.is_public FROM networks -JOIN users_networks ON networks.id = users_networks.network_id -WHERE users_networks.user_id = ? -` - -func (q *Queries) GetUserNetworks(ctx context.Context, userID snowflake.ID) ([]Network, error) { - rows, err := q.db.QueryContext(ctx, getUserNetworks, userID) - if err != nil { - return nil, err - } - defer rows.Close() - var items []Network - for rows.Next() { - var i Network - if err := rows.Scan( - &i.ID, - &i.OwnerID, - &i.Name, - &i.Icon, - &i.BgHexColor, - &i.FgHexColor, - &i.IsPublic, - ); err != nil { - return nil, err - } - items = append(items, i) - } - if err := rows.Close(); err != nil { - return nil, err - } - if err := rows.Err(); err != nil { - return nil, err - } - return items, nil -} - const setUserDescription = `-- name: SetUserDescription :one UPDATE users SET description = ? |
