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/users.sql.sqlite.go | 95 ----------------------------------------------- 1 file changed, 95 deletions(-) delete mode 100644 model/users.sql.sqlite.go (limited to 'model/users.sql.sqlite.go') diff --git a/model/users.sql.sqlite.go b/model/users.sql.sqlite.go deleted file mode 100644 index 4662ca4..0000000 --- a/model/users.sql.sqlite.go +++ /dev/null @@ -1,95 +0,0 @@ -//go:build sqlite - -// Code generated by sqlc. DO NOT EDIT. -// versions: -// sqlc v1.25.0 -// source: users.sql - -package model - -import ( - "context" -) - -const getUserById = `-- name: GetUserById :one -SELECT id, name, pwd, description - FROM users - WHERE id = ? -` - -// GetUserById -// -// SELECT id, name, pwd, description -// FROM users -// WHERE id = ? -func (q *Queries) GetUserById(ctx context.Context, id int64) (User, error) { - row := q.db.QueryRowContext(ctx, getUserById, id) - var i User - err := row.Scan( - &i.ID, - &i.Name, - &i.Pwd, - &i.Description, - ) - return i, err -} - -const getUserByName = `-- name: GetUserByName :one -SELECT id, name, pwd, description - FROM users - WHERE LOWER(name) = LOWER(?) -` - -// GetUserByName -// -// SELECT id, name, pwd, description -// FROM users -// WHERE LOWER(name) = LOWER(?) -func (q *Queries) GetUserByName(ctx context.Context, lower string) (User, error) { - row := q.db.QueryRowContext(ctx, getUserByName, lower) - var i User - err := row.Scan( - &i.ID, - &i.Name, - &i.Pwd, - &i.Description, - ) - return i, err -} - -const getUsers = `-- name: GetUsers :many -SELECT id, name, pwd, description - FROM users -` - -// GetUsers -// -// SELECT id, name, pwd, description -// FROM users -func (q *Queries) GetUsers(ctx context.Context) ([]User, error) { - rows, err := q.db.QueryContext(ctx, getUsers) - if err != nil { - return nil, err - } - defer rows.Close() - var items []User - for rows.Next() { - var i User - if err := rows.Scan( - &i.ID, - &i.Name, - &i.Pwd, - &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-54-g00ecf