From c6f5e375dbd6fd17a5c162ecc3ad6b633452afef Mon Sep 17 00:00:00 2001 From: René 'Necoro' Neumann Date: Sun, 11 Feb 2024 23:46:54 +0100 Subject: Include generated sql files --- model/db_mysql.go | 33 ++++++++++++++++ model/db_sqlite.go | 33 ++++++++++++++++ model/models_mysql.go | 49 ++++++++++++++++++++++++ model/models_sqlite.go | 49 ++++++++++++++++++++++++ model/sexps.sql.mysql.go | 52 ++++++++++++++++++++++++++ model/sexps.sql.sqlite.go | 52 ++++++++++++++++++++++++++ model/users.sql.mysql.go | 95 +++++++++++++++++++++++++++++++++++++++++++++++ model/users.sql.sqlite.go | 95 +++++++++++++++++++++++++++++++++++++++++++++++ sql/users.sql | 9 ++++- 9 files changed, 465 insertions(+), 2 deletions(-) create mode 100644 model/db_mysql.go create mode 100644 model/db_sqlite.go create mode 100644 model/models_mysql.go create mode 100644 model/models_sqlite.go create mode 100644 model/sexps.sql.mysql.go create mode 100644 model/sexps.sql.sqlite.go create mode 100644 model/users.sql.mysql.go create mode 100644 model/users.sql.sqlite.go diff --git a/model/db_mysql.go b/model/db_mysql.go new file mode 100644 index 0000000..b236214 --- /dev/null +++ b/model/db_mysql.go @@ -0,0 +1,33 @@ +//go:build !sqlite + +// Code generated by sqlc. DO NOT EDIT. +// versions: +// sqlc v1.25.0 + +package model + +import ( + "context" + "database/sql" +) + +type DBTX interface { + ExecContext(context.Context, string, ...interface{}) (sql.Result, error) + PrepareContext(context.Context, string) (*sql.Stmt, error) + QueryContext(context.Context, string, ...interface{}) (*sql.Rows, error) + QueryRowContext(context.Context, string, ...interface{}) *sql.Row +} + +func New(db DBTX) *Queries { + return &Queries{db: db} +} + +type Queries struct { + db DBTX +} + +func (q *Queries) WithTx(tx *sql.Tx) *Queries { + return &Queries{ + db: tx, + } +} diff --git a/model/db_sqlite.go b/model/db_sqlite.go new file mode 100644 index 0000000..97e8f76 --- /dev/null +++ b/model/db_sqlite.go @@ -0,0 +1,33 @@ +//go:build sqlite + +// Code generated by sqlc. DO NOT EDIT. +// versions: +// sqlc v1.25.0 + +package model + +import ( + "context" + "database/sql" +) + +type DBTX interface { + ExecContext(context.Context, string, ...interface{}) (sql.Result, error) + PrepareContext(context.Context, string) (*sql.Stmt, error) + QueryContext(context.Context, string, ...interface{}) (*sql.Rows, error) + QueryRowContext(context.Context, string, ...interface{}) *sql.Row +} + +func New(db DBTX) *Queries { + return &Queries{db: db} +} + +type Queries struct { + db DBTX +} + +func (q *Queries) WithTx(tx *sql.Tx) *Queries { + return &Queries{ + db: tx, + } +} diff --git a/model/models_mysql.go b/model/models_mysql.go new file mode 100644 index 0000000..359e583 --- /dev/null +++ b/model/models_mysql.go @@ -0,0 +1,49 @@ +//go:build !sqlite + +// Code generated by sqlc. DO NOT EDIT. +// versions: +// sqlc v1.25.0 + +package model + +import ( + "database/sql" + "time" +) + +type Category struct { + ID int32 + Name string + ParentID sql.NullInt32 + UserID int32 +} + +type ConstExpense struct { + ID int32 + Description sql.NullString + Expense string + Months int32 + Start time.Time + End time.Time + PrevID sql.NullInt32 + UserID int32 + CategoryID int32 +} + +type SingleExpense struct { + ID int32 + Description sql.NullString + Expense string + Year int32 + Month int32 + Day int32 + UserID int32 + CategoryID int32 +} + +type User struct { + ID int32 + Name string + Pwd string + Description sql.NullString +} diff --git a/model/models_sqlite.go b/model/models_sqlite.go new file mode 100644 index 0000000..892cdd7 --- /dev/null +++ b/model/models_sqlite.go @@ -0,0 +1,49 @@ +//go:build sqlite + +// Code generated by sqlc. DO NOT EDIT. +// versions: +// sqlc v1.25.0 + +package model + +import ( + "database/sql" + "time" +) + +type Category struct { + ID int64 + Name string + ParentID sql.NullInt64 + UserID int64 +} + +type ConstExpense struct { + ID int64 + Description sql.NullString + Expense interface{} + Months int64 + Start time.Time + End time.Time + PrevID sql.NullInt64 + UserID int64 + CategoryID int64 +} + +type SingleExpense struct { + ID int64 + Description sql.NullString + Expense interface{} + Year int64 + Month int64 + Day int64 + UserID int64 + CategoryID int64 +} + +type User struct { + ID int64 + Name string + Pwd string + Description sql.NullString +} diff --git a/model/sexps.sql.mysql.go b/model/sexps.sql.mysql.go new file mode 100644 index 0000000..70bc93e --- /dev/null +++ b/model/sexps.sql.mysql.go @@ -0,0 +1,52 @@ +//go:build !sqlite + +// 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 +} diff --git a/model/sexps.sql.sqlite.go b/model/sexps.sql.sqlite.go new file mode 100644 index 0000000..6853390 --- /dev/null +++ b/model/sexps.sql.sqlite.go @@ -0,0 +1,52 @@ +//go:build sqlite + +// 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 int64 + Description sql.NullString +} + +// GetSingleExpenses +// +// SELECT id, description +// FROM single_expenses +// WHERE user_id = ? +func (q *Queries) GetSingleExpenses(ctx context.Context, userID int64) ([]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 +} diff --git a/model/users.sql.mysql.go b/model/users.sql.mysql.go new file mode 100644 index 0000000..b16d388 --- /dev/null +++ b/model/users.sql.mysql.go @@ -0,0 +1,95 @@ +//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 int32) (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 name = ? +` + +// GetUserByName +// +// SELECT id, name, pwd, description +// FROM users +// WHERE name = ? +func (q *Queries) GetUserByName(ctx context.Context, name string) (User, error) { + row := q.db.QueryRowContext(ctx, getUserByName, name) + 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 +} diff --git a/model/users.sql.sqlite.go b/model/users.sql.sqlite.go new file mode 100644 index 0000000..75fdf33 --- /dev/null +++ b/model/users.sql.sqlite.go @@ -0,0 +1,95 @@ +//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 name = ? +` + +// GetUserByName +// +// SELECT id, name, pwd, description +// FROM users +// WHERE name = ? +func (q *Queries) GetUserByName(ctx context.Context, name string) (User, error) { + row := q.db.QueryRowContext(ctx, getUserByName, name) + 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 +} diff --git a/sql/users.sql b/sql/users.sql index d16492a..3e0e992 100644 --- a/sql/users.sql +++ b/sql/users.sql @@ -2,7 +2,12 @@ SELECT * FROM users; --- name: GetUser :one +-- name: GetUserByName :one SELECT * FROM users - WHERE name = ?; \ No newline at end of file + WHERE name = ?; + +-- name: GetUserById :one +SELECT * + FROM users + WHERE id = ?; \ No newline at end of file -- cgit v1.2.3-70-g09d2