SQL: Fetch * instead of specific columns for simplicity

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)