From cd1a6cbd06d3b75adf708fcd2a7974bf94452248 Mon Sep 17 00:00:00 2001 From: René 'Necoro' Neumann Date: Thu, 22 Feb 2024 22:59:53 +0100 Subject: Switch from mysql to postgres --- model/sexps.sql.go | 16 +++++++--------- 1 file changed, 7 insertions(+), 9 deletions(-) (limited to 'model/sexps.sql.go') diff --git a/model/sexps.sql.go b/model/sexps.sql.go index 1108e55..8a54443 100644 --- a/model/sexps.sql.go +++ b/model/sexps.sql.go @@ -7,27 +7,28 @@ package model import ( "context" - "database/sql" + + "github.com/jackc/pgx/v5/pgtype" ) const getSingleExpenses = `-- name: GetSingleExpenses :many SELECT id, description FROM single_expenses - WHERE user_id = ? + WHERE user_id = $1 ` type GetSingleExpensesRow struct { - ID int32 - Description sql.NullString + ID int64 + Description pgtype.Text } // GetSingleExpenses // // SELECT id, description // FROM single_expenses -// WHERE user_id = ? +// WHERE user_id = $1 func (q *Queries) GetSingleExpenses(ctx context.Context, userID int32) ([]GetSingleExpensesRow, error) { - rows, err := q.db.QueryContext(ctx, getSingleExpenses, userID) + rows, err := q.db.Query(ctx, getSingleExpenses, userID) if err != nil { return nil, err } @@ -40,9 +41,6 @@ func (q *Queries) GetSingleExpenses(ctx context.Context, userID int32) ([]GetSin } items = append(items, i) } - if err := rows.Close(); err != nil { - return nil, err - } if err := rows.Err(); err != nil { return nil, err } -- cgit v1.2.3-70-g09d2