From 650053446d18424500ae6330b5ad0da81fa86373 Mon Sep 17 00:00:00 2001 From: René 'Necoro' Neumann Date: Thu, 17 Oct 2024 17:40:49 +0200 Subject: SQL: Fetch * instead of specific columns for simplicity --- model/categories.sql.go | 22 +++++++++++----------- 1 file changed, 11 insertions(+), 11 deletions(-) (limited to 'model/categories.sql.go') diff --git a/model/categories.sql.go b/model/categories.sql.go index 7df0cb3..c67e20d 100644 --- a/model/categories.sql.go +++ b/model/categories.sql.go @@ -10,33 +10,33 @@ import ( ) const getCategoriesOrdered = `-- name: GetCategoriesOrdered :many -SELECT id, name +SELECT id, name, parent_id, user_id FROM categories WHERE user_id = $1 ORDER BY name ASC ` -type GetCategoriesOrderedRow struct { - ID int32 - Name string -} - // GetCategoriesOrdered // -// SELECT id, name +// SELECT id, name, parent_id, user_id // FROM categories // WHERE user_id = $1 // ORDER BY name ASC -func (q *Queries) GetCategoriesOrdered(ctx context.Context, userID int32) ([]GetCategoriesOrderedRow, error) { +func (q *Queries) GetCategoriesOrdered(ctx context.Context, userID int32) ([]Category, error) { rows, err := q.db.Query(ctx, getCategoriesOrdered, userID) if err != nil { return nil, err } defer rows.Close() - var items []GetCategoriesOrderedRow + var items []Category for rows.Next() { - var i GetCategoriesOrderedRow - if err := rows.Scan(&i.ID, &i.Name); err != nil { + var i Category + if err := rows.Scan( + &i.ID, + &i.Name, + &i.ParentID, + &i.UserID, + ); err != nil { return nil, err } items = append(items, i) -- cgit v1.2.3-70-g09d2