diff options
Diffstat (limited to '')
-rw-r--r-- | model/categories.sql.go | 22 |
1 files changed, 11 insertions, 11 deletions
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) |