From b3485c78114e505b7bc9c6969afa108ea3f4755c Mon Sep 17 00:00:00 2001 From: René 'Necoro' Neumann Date: Wed, 14 Feb 2024 23:38:53 +0100 Subject: Remove sqlite support: the differences with sqlc just get too cumbersome --- model/sexps.sql.go | 50 ++++++++++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 50 insertions(+) create mode 100644 model/sexps.sql.go (limited to 'model/sexps.sql.go') diff --git a/model/sexps.sql.go b/model/sexps.sql.go new file mode 100644 index 0000000..1108e55 --- /dev/null +++ b/model/sexps.sql.go @@ -0,0 +1,50 @@ +// Code generated by sqlc. DO NOT EDIT. +// versions: +// sqlc v1.25.0 +// source: sexps.sql + +package model + +import ( + "context" + "database/sql" +) + +const getSingleExpenses = `-- name: GetSingleExpenses :many +SELECT id, description + FROM single_expenses + WHERE user_id = ? +` + +type GetSingleExpensesRow struct { + ID int32 + Description sql.NullString +} + +// GetSingleExpenses +// +// SELECT id, description +// FROM single_expenses +// WHERE user_id = ? +func (q *Queries) GetSingleExpenses(ctx context.Context, userID int32) ([]GetSingleExpensesRow, error) { + rows, err := q.db.QueryContext(ctx, getSingleExpenses, userID) + if err != nil { + return nil, err + } + defer rows.Close() + var items []GetSingleExpensesRow + for rows.Next() { + var i GetSingleExpensesRow + if err := rows.Scan(&i.ID, &i.Description); err != nil { + return nil, err + } + items = append(items, i) + } + if err := rows.Close(); err != nil { + return nil, err + } + if err := rows.Err(); err != nil { + return nil, err + } + return items, nil +} -- cgit v1.2.3-70-g09d2