SQL: Fetch * instead of specific columns for simplicity

1 files changed, 14 insertions, 13 deletions

diff --git a/model/sexps.sql.go b/model/sexps.sql.go
index 8a54443..33b9f57 100644
--- a/model/sexps.sql.go
+++ b/model/sexps.sql.go
@@ -7,36 +7,37 @@ package model
 
 import (
 	"context"
-
-	"github.com/jackc/pgx/v5/pgtype"
 )
 
 const getSingleExpenses = `-- name: GetSingleExpenses :many
-SELECT id, description
+SELECT id, description, expense, date, corr_month, category_id, user_id
   FROM single_expenses
  WHERE user_id = $1
 `
 
-type GetSingleExpensesRow struct {
-	ID          int64
-	Description pgtype.Text
-}
-
 // GetSingleExpenses
 //
-//	SELECT id, description
+//	SELECT id, description, expense, date, corr_month, category_id, user_id
 //	  FROM single_expenses
 //	 WHERE user_id = $1
-func (q *Queries) GetSingleExpenses(ctx context.Context, userID int32) ([]GetSingleExpensesRow, error) {
+func (q *Queries) GetSingleExpenses(ctx context.Context, userID int32) ([]SingleExpense, error) {
 	rows, err := q.db.Query(ctx, getSingleExpenses, userID)
 	if err != nil {
 		return nil, err
 	}
 	defer rows.Close()
-	var items []GetSingleExpensesRow
+	var items []SingleExpense
 	for rows.Next() {
-		var i GetSingleExpensesRow
-		if err := rows.Scan(&i.ID, &i.Description); err != nil {
+		var i SingleExpense
+		if err := rows.Scan(
+			&i.ID,
+			&i.Description,
+			&i.Expense,
+			&i.Date,
+			&i.CorrMonth,
+			&i.CategoryID,
+			&i.UserID,
+		); err != nil {
 			return nil, err
 		}
 		items = append(items, i)