From 650053446d18424500ae6330b5ad0da81fa86373 Mon Sep 17 00:00:00 2001
From: René 'Necoro' Neumann <necoro@necoro.eu>
Date: Thu, 17 Oct 2024 17:40:49 +0200
Subject: SQL: Fetch * instead of specific columns for simplicity

---
 model/sexps.sql.go | 27 ++++++++++++++-------------
 1 file changed, 14 insertions(+), 13 deletions(-)

(limited to 'model/sexps.sql.go')

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)
-- 
cgit v1.2.3-70-g09d2