sqliteDao

package
v0.0.0-...-4b2ec8c Latest Latest
Warning

This package is not in the latest version of its module.

 Go to latest Published: Jun 10, 2024 License: MIT Imports: 5 Imported by: 0

Documentation

Index

Constants

View Source 
const CountCategories = `-- name: CountCategories :one
SELECT count(*)
FROM Category
`
View Source 
const CountDetails = `-- name: CountDetails :one
SELECT count(*)
FROM Detail
`
View Source 
const CountGroups = `-- name: CountGroups :one
SELECT count(*)
FROM [Group]
`
View Source 
const CountPosts = `-- name: CountPosts :one
SELECT count(*)
FROM Post
`
View Source 
const CountTags = `-- name: CountTags :one
SELECT count(*)
FROM Tag
`
View Source 
const CountTagsByParentId = `-- name: CountTagsByParentId :one
SELECT count(*)
FROM Tag
WHERE parent_id = ?
`
View Source 
const CountTodos = `-- name: CountTodos :one
SELECT count(*)
FROM Todo
`
View Source 
const CountTodosOnGroups = `-- name: CountTodosOnGroups :one
SELECT count(*)
FROM TodosOnGroups
`
View Source 
const CountUsers = `-- name: CountUsers :one
SELECT count(*)
FROM User
`
View Source 
const CreateCategory = `-- name: CreateCategory :execresult
INSERT INTO Category (name, desc, created_at, updated_at)
VALUES (?, ?, ?, ?)
`
View Source 
const CreateDetail = `-- name: CreateDetail :execresult
INSERT INTO Detail (desc, img_url, todo_id)
VALUES (?, ?, ?)
`
View Source 
const CreateGroup = `-- name: CreateGroup :execresult
INSERT INTO [Group] (name, desc, created_at, updated_at)
VALUES (?, ?, ?, ?)
`
View Source 
const CreatePost = `-- name: CreatePost :execresult
INSERT INTO Post (name, created_at, updated_at, created_by_id)
VALUES (?, ?, ?, ?)
`
View Source 
const CreateTag = `-- name: CreateTag :execresult
INSERT INTO Tag (name, parent_id)
VALUES (?, ?)
`
View Source 
const CreateTodo = `` /* 261-byte string literal not displayed */
View Source 
const CreateTodosOnGroup = `-- name: CreateTodosOnGroup :execresult
INSERT INTO TodosOnGroups (todo_id, group_id)
VALUES (?, ?)
`
View Source 
const CreateUser = `` /* 128-byte string literal not displayed */
View Source 
const DeleteCategory = `-- name: DeleteCategory :exec
DELETE
FROM Category
WHERE id = ?
`
View Source 
const DeleteDetail = `-- name: DeleteDetail :exec
DELETE
FROM Detail
WHERE id = ?
`
View Source 
const DeleteGroup = `-- name: DeleteGroup :exec
DELETE
FROM [Group]
WHERE id = ?
`
View Source 
const DeletePost = `-- name: DeletePost :exec
DELETE
FROM Post
WHERE id = ?
`
View Source 
const DeleteTag = `-- name: DeleteTag :exec
DELETE
FROM Tag
WHERE id = ?
`
View Source 
const DeleteTodo = `-- name: DeleteTodo :exec
DELETE
FROM Todo
WHERE id = ?
`
View Source 
const DeleteTodosOnGroup = `-- name: DeleteTodosOnGroup :exec
DELETE
FROM TodosOnGroups
WHERE todo_id = ?
  and group_id = ?
`
View Source 
const DeleteUser = `-- name: DeleteUser :exec
DELETE
FROM User
WHERE id = ?
`
View Source 
const GetCategories = `-- name: GetCategories :many
SELECT id, name, "desc", created_at, updated_at
FROM Category
`
View Source 
const GetCategoriesByIds = `-- name: GetCategoriesByIds :many
SELECT id, name, "desc", created_at, updated_at
FROM Category
WHERE id IN (/*SLICE:ids*/?)
`
View Source 
const GetCategory = `-- name: GetCategory :one
SELECT id, name, "desc", created_at, updated_at
FROM Category
WHERE id = ?
LIMIT 1
`
View Source 
const GetDetailById = `-- name: GetDetailById :one
SELECT id, "desc", img_url, todo_id
FROM Detail
WHERE id = ?
LIMIT 1
`
View Source 
const GetDetailByTodoId = `-- name: GetDetailByTodoId :one
SELECT id, "desc", img_url, todo_id
FROM Detail
WHERE todo_id = ?
LIMIT 1
`
View Source 
const GetDetails = `-- name: GetDetails :many
SELECT id, "desc", img_url, todo_id
FROM Detail
`
View Source 
const GetDetailsByIds = `-- name: GetDetailsByIds :many
SELECT id, "desc", img_url, todo_id
FROM Detail
WHERE id IN (/*SLICE:ids*/?)
`
View Source 
const GetDetailsByTodoIds = `-- name: GetDetailsByTodoIds :many
SELECT id, "desc", img_url, todo_id
FROM Detail
WHERE todo_id IN (/*SLICE:ids*/?)
`
View Source 
const GetGroup = `-- name: GetGroup :one
SELECT id, name, "desc", created_at, updated_at
FROM [Group]
WHERE id = ?
LIMIT 1
`
View Source 
const GetGroups = `-- name: GetGroups :many
SELECT id, name, "desc", created_at, updated_at
FROM [Group]
`
View Source 
const GetGroupsByIds = `-- name: GetGroupsByIds :many
SELECT id, name, "desc", created_at, updated_at
FROM [Group]
WHERE id IN (/*SLICE:ids*/?)
`
View Source 
const GetPost = `-- name: GetPost :one
SELECT id, name, created_at, updated_at, created_by_id
FROM Post
WHERE id = ?
LIMIT 1
`
View Source 
const GetPosts = `-- name: GetPosts :many
SELECT id, name, created_at, updated_at, created_by_id
FROM Post
`
View Source 
const GetPostsByIds = `-- name: GetPostsByIds :many
SELECT id, name, created_at, updated_at, created_by_id
FROM Post
WHERE id IN (/*SLICE:ids*/?)
`
View Source 
const GetTag = `-- name: GetTag :one
SELECT id, name, parent_id
FROM Tag
WHERE id = ?
LIMIT 1
`
View Source 
const GetTags = `-- name: GetTags :many
SELECT id, name, parent_id
FROM Tag
`
View Source 
const GetTagsByIds = `-- name: GetTagsByIds :many
SELECT id, name, parent_id
FROM Tag
WHERE id IN (/*SLICE:ids*/?)
`
View Source 
const GetTagsByParentId = `-- name: GetTagsByParentId :many
SELECT id, name, parent_id
FROM Tag
WHERE parent_id = ?
`
View Source 
const GetTodo = `` /* 204-byte string literal not displayed */
View Source 
const GetTodos = `` /* 185-byte string literal not displayed */
View Source 
const GetTodosByIds = `` /* 219-byte string literal not displayed */
View Source 
const GetTodosOnGroupByGroupId = `-- name: GetTodosOnGroupByGroupId :one
SELECT todo_id, group_id, assigned_at
FROM TodosOnGroups
WHERE group_id = ?
LIMIT 1
`
View Source 
const GetTodosOnGroupByTodoId = `-- name: GetTodosOnGroupByTodoId :one
SELECT todo_id, group_id, assigned_at
FROM TodosOnGroups
WHERE todo_id = ?
LIMIT 1
`
View Source 
const GetTodosOnGroups = `-- name: GetTodosOnGroups :many
SELECT todo_id, group_id, assigned_at
FROM TodosOnGroups
`
View Source 
const GetTodosOnGroupsByGroupIds = `` /* 140-byte string literal not displayed */
View Source 
const GetTodosOnGroupsByTodoIds = `` /* 137-byte string literal not displayed */
View Source 
const GetUser = `-- name: GetUser :one
SELECT id, name, password, email, email_verified, image, role
FROM User
WHERE id = ?
LIMIT 1
`
View Source 
const GetUsers = `-- name: GetUsers :many
SELECT id, name, password, email, email_verified, image, role
FROM User
`
View Source 
const GetUsersByIds = `` /* 130-byte string literal not displayed */
View Source 
const UpdateCategory = `` /* 328-byte string literal not displayed */
View Source 
const UpdateDetail = `` /* 246-byte string literal not displayed */
View Source 
const UpdateGroup = `` /* 324-byte string literal not displayed */
View Source 
const UpdatePost = `` /* 341-byte string literal not displayed */
View Source 
const UpdateTag = `` /* 183-byte string literal not displayed */
View Source 
const UpdateTodo = `` /* 1051-byte string literal not displayed */
View Source 
const UpdateUser = `` /* 469-byte string literal not displayed */

Variables

This section is empty.

Functions

This section is empty.

Types

type Category 

type Category struct {
	ID        int64      `db:"id" json:"id"`
	Name      string     `db:"name" json:"name"`
	Desc      string     `db:"desc" json:"desc"`
	CreatedAt *time.Time `db:"created_at" json:"created_at"`
	UpdatedAt *time.Time `db:"updated_at" json:"updated_at"`
}

type CreateCategoryParams 

type CreateCategoryParams struct {
	Name      string     `db:"name" json:"name"`
	Desc      string     `db:"desc" json:"desc"`
	CreatedAt *time.Time `db:"created_at" json:"created_at"`
	UpdatedAt *time.Time `db:"updated_at" json:"updated_at"`
}

type CreateDetailParams 

type CreateDetailParams struct {
	Desc   string `db:"desc" json:"desc"`
	ImgUrl string `db:"img_url" json:"img_url"`
	TodoID int64  `db:"todo_id" json:"todo_id"`
}

type CreateGroupParams 

type CreateGroupParams struct {
	Name      string     `db:"name" json:"name"`
	Desc      string     `db:"desc" json:"desc"`
	CreatedAt *time.Time `db:"created_at" json:"created_at"`
	UpdatedAt *time.Time `db:"updated_at" json:"updated_at"`
}

type CreatePostParams 

type CreatePostParams struct {
	Name        string     `db:"name" json:"name"`
	CreatedAt   *time.Time `db:"created_at" json:"created_at"`
	UpdatedAt   *time.Time `db:"updated_at" json:"updated_at"`
	CreatedByID string     `db:"created_by_id" json:"created_by_id"`
}

type CreateTagParams 

type CreateTagParams struct {
	Name     string `db:"name" json:"name"`
	ParentID *int64 `db:"parent_id" json:"parent_id"`
}

type CreateTodoParams 

type CreateTodoParams struct {
	Title         string     `db:"title" json:"title"`
	Score         int64      `db:"score" json:"score"`
	Amount        float64    `db:"amount" json:"amount"`
	Status        string     `db:"status" json:"status"`
	CreatedAt     *time.Time `db:"created_at" json:"created_at"`
	UpdatedAt     *time.Time `db:"updated_at" json:"updated_at"`
	Deadline      *time.Time `db:"deadline" json:"deadline"`
	Priority      string     `db:"priority" json:"priority"`
	Tags          string     `db:"tags" json:"tags"`
	Content       string     `db:"content" json:"content"`
	CreatedBy     string     `db:"created_by" json:"created_by"`
	AssigneeEmail string     `db:"assignee_email" json:"assignee_email"`
	DetailID      *int64     `db:"detail_id" json:"detail_id"`
	CategoryID    *int64     `db:"category_id" json:"category_id"`
}

type CreateTodosOnGroupParams 

type CreateTodosOnGroupParams struct {
	TodoID  int64 `db:"todo_id" json:"todo_id"`
	GroupID int64 `db:"group_id" json:"group_id"`
}

type CreateUserParams 

type CreateUserParams struct {
	Name          *string    `db:"name" json:"name"`
	Password      *string    `db:"password" json:"password"`
	Email         *string    `db:"email" json:"email"`
	EmailVerified *time.Time `db:"email_verified" json:"email_verified"`
	Image         *string    `db:"image" json:"image"`
	Role          string     `db:"role" json:"role"`
}

type DBTX 

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
}

type DeleteTodosOnGroupParams 

type DeleteTodosOnGroupParams struct {
	TodoID  int64 `db:"todo_id" json:"todo_id"`
	GroupID int64 `db:"group_id" json:"group_id"`
}

type Detail 

type Detail struct {
	ID     int64  `db:"id" json:"id"`
	Desc   string `db:"desc" json:"desc"`
	ImgUrl string `db:"img_url" json:"img_url"`
	TodoID int64  `db:"todo_id" json:"todo_id"`
}

type Group 

type Group struct {
	ID        int64      `db:"id" json:"id"`
	Name      string     `db:"name" json:"name"`
	Desc      string     `db:"desc" json:"desc"`
	CreatedAt *time.Time `db:"created_at" json:"created_at"`
	UpdatedAt *time.Time `db:"updated_at" json:"updated_at"`
}

type Post 

type Post struct {
	ID          int64      `db:"id" json:"id"`
	Name        string     `db:"name" json:"name"`
	CreatedAt   *time.Time `db:"created_at" json:"created_at"`
	UpdatedAt   *time.Time `db:"updated_at" json:"updated_at"`
	CreatedByID string     `db:"created_by_id" json:"created_by_id"`
}

type Querier 

type Querier interface {
	CountCategories(ctx context.Context) (int64, error)
	CountDetails(ctx context.Context) (int64, error)
	CountGroups(ctx context.Context) (int64, error)
	CountPosts(ctx context.Context) (int64, error)
	CountTags(ctx context.Context) (int64, error)
	CountTagsByParentId(ctx context.Context, parentID *int64) (int64, error)
	CountTodos(ctx context.Context) (int64, error)
	CountTodosOnGroups(ctx context.Context) (int64, error)
	CountUsers(ctx context.Context) (int64, error)
	CreateCategory(ctx context.Context, arg CreateCategoryParams) (sql.Result, error)
	CreateDetail(ctx context.Context, arg CreateDetailParams) (sql.Result, error)
	CreateGroup(ctx context.Context, arg CreateGroupParams) (sql.Result, error)
	CreatePost(ctx context.Context, arg CreatePostParams) (sql.Result, error)
	CreateTag(ctx context.Context, arg CreateTagParams) (sql.Result, error)
	CreateTodo(ctx context.Context, arg CreateTodoParams) (sql.Result, error)
	CreateTodosOnGroup(ctx context.Context, arg CreateTodosOnGroupParams) (sql.Result, error)
	CreateUser(ctx context.Context, arg CreateUserParams) (sql.Result, error)
	DeleteCategory(ctx context.Context, id int64) error
	DeleteDetail(ctx context.Context, id int64) error
	DeleteGroup(ctx context.Context, id int64) error
	DeletePost(ctx context.Context, id int64) error
	DeleteTag(ctx context.Context, id int64) error
	DeleteTodo(ctx context.Context, id int64) error
	DeleteTodosOnGroup(ctx context.Context, arg DeleteTodosOnGroupParams) error
	DeleteUser(ctx context.Context, id string) error
	GetCategories(ctx context.Context) ([]Category, error)
	GetCategoriesByIds(ctx context.Context, ids []int64) ([]Category, error)
	GetCategory(ctx context.Context, id int64) (Category, error)
	GetDetailById(ctx context.Context, id int64) (Detail, error)
	GetDetailByTodoId(ctx context.Context, todoID int64) (Detail, error)
	GetDetails(ctx context.Context) ([]Detail, error)
	GetDetailsByIds(ctx context.Context, ids []int64) ([]Detail, error)
	GetDetailsByTodoIds(ctx context.Context, ids []int64) ([]Detail, error)
	GetGroup(ctx context.Context, id int64) (Group, error)
	GetGroups(ctx context.Context) ([]Group, error)
	GetGroupsByIds(ctx context.Context, ids []int64) ([]Group, error)
	GetPost(ctx context.Context, id int64) (Post, error)
	GetPosts(ctx context.Context) ([]Post, error)
	GetPostsByIds(ctx context.Context, ids []int64) ([]Post, error)
	GetTag(ctx context.Context, id int64) (Tag, error)
	GetTags(ctx context.Context) ([]Tag, error)
	GetTagsByIds(ctx context.Context, ids []int64) ([]Tag, error)
	GetTagsByParentId(ctx context.Context, parentID *int64) ([]Tag, error)
	GetTodo(ctx context.Context, id int64) (Todo, error)
	GetTodos(ctx context.Context) ([]Todo, error)
	GetTodosByIds(ctx context.Context, ids []int64) ([]Todo, error)
	GetTodosOnGroupByGroupId(ctx context.Context, groupID int64) (TodosOnGroup, error)
	GetTodosOnGroupByTodoId(ctx context.Context, todoID int64) (TodosOnGroup, error)
	GetTodosOnGroups(ctx context.Context) ([]TodosOnGroup, error)
	GetTodosOnGroupsByGroupIds(ctx context.Context, groupIds []int64) ([]TodosOnGroup, error)
	GetTodosOnGroupsByTodoIds(ctx context.Context, todoIds []int64) ([]TodosOnGroup, error)
	GetUser(ctx context.Context, id string) (User, error)
	GetUsers(ctx context.Context) ([]User, error)
	GetUsersByIds(ctx context.Context, ids []string) ([]User, error)
	UpdateCategory(ctx context.Context, arg UpdateCategoryParams) (sql.Result, error)
	UpdateDetail(ctx context.Context, arg UpdateDetailParams) (sql.Result, error)
	UpdateGroup(ctx context.Context, arg UpdateGroupParams) (sql.Result, error)
	UpdatePost(ctx context.Context, arg UpdatePostParams) (sql.Result, error)
	UpdateTag(ctx context.Context, arg UpdateTagParams) (sql.Result, error)
	UpdateTodo(ctx context.Context, arg UpdateTodoParams) (sql.Result, error)
	UpdateUser(ctx context.Context, arg UpdateUserParams) (sql.Result, error)
}

type Queries 

type Queries struct {
	// contains filtered or unexported fields
}

func New 

func New(db DBTX) *Queries

func Prepare 

func Prepare(ctx context.Context, db DBTX) (*Queries, error)

func (*Queries) Close 

func (q *Queries) Close() error

func (*Queries) CountCategories 

func (q *Queries) CountCategories(ctx context.Context) (int64, error)

func (*Queries) CountDetails 

func (q *Queries) CountDetails(ctx context.Context) (int64, error)

func (*Queries) CountGroups 

func (q *Queries) CountGroups(ctx context.Context) (int64, error)

func (*Queries) CountPosts 

func (q *Queries) CountPosts(ctx context.Context) (int64, error)

func (*Queries) CountTags 

func (q *Queries) CountTags(ctx context.Context) (int64, error)

func (*Queries) CountTagsByParentId 

func (q *Queries) CountTagsByParentId(ctx context.Context, parentID *int64) (int64, error)

func (*Queries) CountTodos 

func (q *Queries) CountTodos(ctx context.Context) (int64, error)

func (*Queries) CountTodosOnGroups 

func (q *Queries) CountTodosOnGroups(ctx context.Context) (int64, error)

func (*Queries) CountUsers 

func (q *Queries) CountUsers(ctx context.Context) (int64, error)

func (*Queries) CreateCategory 

func (q *Queries) CreateCategory(ctx context.Context, arg CreateCategoryParams) (sql.Result, error)

func (*Queries) CreateDetail 

func (q *Queries) CreateDetail(ctx context.Context, arg CreateDetailParams) (sql.Result, error)

func (*Queries) CreateGroup 

func (q *Queries) CreateGroup(ctx context.Context, arg CreateGroupParams) (sql.Result, error)

func (*Queries) CreatePost 

func (q *Queries) CreatePost(ctx context.Context, arg CreatePostParams) (sql.Result, error)

func (*Queries) CreateTag 

func (q *Queries) CreateTag(ctx context.Context, arg CreateTagParams) (sql.Result, error)

func (*Queries) CreateTodo 

func (q *Queries) CreateTodo(ctx context.Context, arg CreateTodoParams) (sql.Result, error)

func (*Queries) CreateTodosOnGroup 

func (q *Queries) CreateTodosOnGroup(ctx context.Context, arg CreateTodosOnGroupParams) (sql.Result, error)

func (*Queries) CreateUser 

func (q *Queries) CreateUser(ctx context.Context, arg CreateUserParams) (sql.Result, error)

func (*Queries) DeleteCategory 

func (q *Queries) DeleteCategory(ctx context.Context, id int64) error

func (*Queries) DeleteDetail 

func (q *Queries) DeleteDetail(ctx context.Context, id int64) error

func (*Queries) DeleteGroup 

func (q *Queries) DeleteGroup(ctx context.Context, id int64) error

func (*Queries) DeletePost 

func (q *Queries) DeletePost(ctx context.Context, id int64) error

func (*Queries) DeleteTag 

func (q *Queries) DeleteTag(ctx context.Context, id int64) error

func (*Queries) DeleteTodo 

func (q *Queries) DeleteTodo(ctx context.Context, id int64) error

func (*Queries) DeleteTodosOnGroup 

func (q *Queries) DeleteTodosOnGroup(ctx context.Context, arg DeleteTodosOnGroupParams) error

func (*Queries) DeleteUser 

func (q *Queries) DeleteUser(ctx context.Context, id string) error

func (*Queries) GetCategories 

func (q *Queries) GetCategories(ctx context.Context) ([]Category, error)

func (*Queries) GetCategoriesByIds 

func (q *Queries) GetCategoriesByIds(ctx context.Context, ids []int64) ([]Category, error)

func (*Queries) GetCategory 

func (q *Queries) GetCategory(ctx context.Context, id int64) (Category, error)

func (*Queries) GetDetailById 

func (q *Queries) GetDetailById(ctx context.Context, id int64) (Detail, error)

func (*Queries) GetDetailByTodoId 

func (q *Queries) GetDetailByTodoId(ctx context.Context, todoID int64) (Detail, error)

func (*Queries) GetDetails 

func (q *Queries) GetDetails(ctx context.Context) ([]Detail, error)

func (*Queries) GetDetailsByIds 

func (q *Queries) GetDetailsByIds(ctx context.Context, ids []int64) ([]Detail, error)

func (*Queries) GetDetailsByTodoIds 

func (q *Queries) GetDetailsByTodoIds(ctx context.Context, ids []int64) ([]Detail, error)

func (*Queries) GetGroup 

func (q *Queries) GetGroup(ctx context.Context, id int64) (Group, error)

func (*Queries) GetGroups 

func (q *Queries) GetGroups(ctx context.Context) ([]Group, error)

func (*Queries) GetGroupsByIds 

func (q *Queries) GetGroupsByIds(ctx context.Context, ids []int64) ([]Group, error)

func (*Queries) GetPost 

func (q *Queries) GetPost(ctx context.Context, id int64) (Post, error)

func (*Queries) GetPosts 

func (q *Queries) GetPosts(ctx context.Context) ([]Post, error)

func (*Queries) GetPostsByIds 

func (q *Queries) GetPostsByIds(ctx context.Context, ids []int64) ([]Post, error)

func (*Queries) GetTag 

func (q *Queries) GetTag(ctx context.Context, id int64) (Tag, error)

func (*Queries) GetTags 

func (q *Queries) GetTags(ctx context.Context) ([]Tag, error)

func (*Queries) GetTagsByIds 

func (q *Queries) GetTagsByIds(ctx context.Context, ids []int64) ([]Tag, error)

func (*Queries) GetTagsByParentId 

func (q *Queries) GetTagsByParentId(ctx context.Context, parentID *int64) ([]Tag, error)

func (*Queries) GetTodo 

func (q *Queries) GetTodo(ctx context.Context, id int64) (Todo, error)

func (*Queries) GetTodos 

func (q *Queries) GetTodos(ctx context.Context) ([]Todo, error)

func (*Queries) GetTodosByIds 

func (q *Queries) GetTodosByIds(ctx context.Context, ids []int64) ([]Todo, error)

func (*Queries) GetTodosOnGroupByGroupId 

func (q *Queries) GetTodosOnGroupByGroupId(ctx context.Context, groupID int64) (TodosOnGroup, error)

func (*Queries) GetTodosOnGroupByTodoId 

func (q *Queries) GetTodosOnGroupByTodoId(ctx context.Context, todoID int64) (TodosOnGroup, error)

func (*Queries) GetTodosOnGroups 

func (q *Queries) GetTodosOnGroups(ctx context.Context) ([]TodosOnGroup, error)

func (*Queries) GetTodosOnGroupsByGroupIds 

func (q *Queries) GetTodosOnGroupsByGroupIds(ctx context.Context, groupIds []int64) ([]TodosOnGroup, error)

func (*Queries) GetTodosOnGroupsByTodoIds 

func (q *Queries) GetTodosOnGroupsByTodoIds(ctx context.Context, todoIds []int64) ([]TodosOnGroup, error)

func (*Queries) GetUser 

func (q *Queries) GetUser(ctx context.Context, id string) (User, error)

func (*Queries) GetUsers 

func (q *Queries) GetUsers(ctx context.Context) ([]User, error)

func (*Queries) GetUsersByIds 

func (q *Queries) GetUsersByIds(ctx context.Context, ids []string) ([]User, error)

func (*Queries) UpdateCategory 

func (q *Queries) UpdateCategory(ctx context.Context, arg UpdateCategoryParams) (sql.Result, error)

func (*Queries) UpdateDetail 

func (q *Queries) UpdateDetail(ctx context.Context, arg UpdateDetailParams) (sql.Result, error)

func (*Queries) UpdateGroup 

func (q *Queries) UpdateGroup(ctx context.Context, arg UpdateGroupParams) (sql.Result, error)

func (*Queries) UpdatePost 

func (q *Queries) UpdatePost(ctx context.Context, arg UpdatePostParams) (sql.Result, error)

func (*Queries) UpdateTag 

func (q *Queries) UpdateTag(ctx context.Context, arg UpdateTagParams) (sql.Result, error)

func (*Queries) UpdateTodo 

func (q *Queries) UpdateTodo(ctx context.Context, arg UpdateTodoParams) (sql.Result, error)

func (*Queries) UpdateUser 

func (q *Queries) UpdateUser(ctx context.Context, arg UpdateUserParams) (sql.Result, error)

func (*Queries) WithTx 

func (q *Queries) WithTx(tx *sql.Tx) *Queries

type Tag 

type Tag struct {
	ID       int64  `db:"id" json:"id"`
	Name     string `db:"name" json:"name"`
	ParentID *int64 `db:"parent_id" json:"parent_id"`
}

type Todo 

type Todo struct {
	ID            int64      `db:"id" json:"id"`
	Title         string     `db:"title" json:"title"`
	Score         int64      `db:"score" json:"score"`
	Amount        float64    `db:"amount" json:"amount"`
	Status        string     `db:"status" json:"status"`
	CreatedAt     *time.Time `db:"created_at" json:"created_at"`
	UpdatedAt     *time.Time `db:"updated_at" json:"updated_at"`
	Deadline      *time.Time `db:"deadline" json:"deadline"`
	Priority      string     `db:"priority" json:"priority"`
	Tags          string     `db:"tags" json:"tags"`
	Content       string     `db:"content" json:"content"`
	CreatedBy     string     `db:"created_by" json:"created_by"`
	AssigneeEmail string     `db:"assignee_email" json:"assignee_email"`
	DetailID      *int64     `db:"detail_id" json:"detail_id"`
	CategoryID    *int64     `db:"category_id" json:"category_id"`
}

type TodosOnGroup 

type TodosOnGroup struct {
	TodoID     int64      `db:"todo_id" json:"todo_id"`
	GroupID    int64      `db:"group_id" json:"group_id"`
	AssignedAt *time.Time `db:"assigned_at" json:"assigned_at"`
}

type UpdateCategoryParams 

type UpdateCategoryParams struct {
	Name      interface{} `db:"name" json:"name"`
	Desc      interface{} `db:"desc" json:"desc"`
	CreatedAt interface{} `db:"created_at" json:"created_at"`
	UpdatedAt interface{} `db:"updated_at" json:"updated_at"`
	ID        int64       `db:"id" json:"id"`
}

type UpdateDetailParams 

type UpdateDetailParams struct {
	Desc   interface{} `db:"desc" json:"desc"`
	ImgUrl interface{} `db:"img_url" json:"img_url"`
	TodoID interface{} `db:"todo_id" json:"todo_id"`
	ID     int64       `db:"id" json:"id"`
}

type UpdateGroupParams 

type UpdateGroupParams struct {
	Name      interface{} `db:"name" json:"name"`
	Desc      interface{} `db:"desc" json:"desc"`
	CreatedAt interface{} `db:"created_at" json:"created_at"`
	UpdatedAt interface{} `db:"updated_at" json:"updated_at"`
	ID        int64       `db:"id" json:"id"`
}

type UpdatePostParams 

type UpdatePostParams struct {
	Name        interface{} `db:"name" json:"name"`
	CreatedAt   interface{} `db:"created_at" json:"created_at"`
	UpdatedAt   interface{} `db:"updated_at" json:"updated_at"`
	CreatedByID interface{} `db:"created_by_id" json:"created_by_id"`
	ID          int64       `db:"id" json:"id"`
}

type UpdateTagParams 

type UpdateTagParams struct {
	Name     interface{} `db:"name" json:"name"`
	ParentID interface{} `db:"parent_id" json:"parent_id"`
	ID       int64       `db:"id" json:"id"`
}

type UpdateTodoParams 

type UpdateTodoParams struct {
	Title         interface{} `db:"title" json:"title"`
	Score         interface{} `db:"score" json:"score"`
	Amount        interface{} `db:"amount" json:"amount"`
	Status        interface{} `db:"status" json:"status"`
	CreatedAt     interface{} `db:"created_at" json:"created_at"`
	UpdatedAt     interface{} `db:"updated_at" json:"updated_at"`
	Deadline      interface{} `db:"deadline" json:"deadline"`
	Priority      interface{} `db:"priority" json:"priority"`
	Tags          interface{} `db:"tags" json:"tags"`
	Content       interface{} `db:"content" json:"content"`
	CreatedBy     interface{} `db:"created_by" json:"created_by"`
	AssigneeEmail interface{} `db:"assignee_email" json:"assignee_email"`
	DetailID      interface{} `db:"detail_id" json:"detail_id"`
	CategoryID    interface{} `db:"category_id" json:"category_id"`
	ID            int64       `db:"id" json:"id"`
}

type UpdateUserParams 

type UpdateUserParams struct {
	Name          interface{} `db:"name" json:"name"`
	Password      interface{} `db:"password" json:"password"`
	Email         interface{} `db:"email" json:"email"`
	EmailVerified interface{} `db:"email_verified" json:"email_verified"`
	Image         interface{} `db:"image" json:"image"`
	Role          interface{} `db:"role" json:"role"`
	ID            string      `db:"id" json:"id"`
}

type User 

type User struct {
	ID            string     `db:"id" json:"id"`
	Name          *string    `db:"name" json:"name"`
	Password      *string    `db:"password" json:"password"`
	Email         *string    `db:"email" json:"email"`
	EmailVerified *time.Time `db:"email_verified" json:"email_verified"`
	Image         *string    `db:"image" json:"image"`
	Role          string     `db:"role" json:"role"`
}

Source Files

View all Source files

Jump to

Keyboard shortcuts

? : This menu
/ : Search site
f or F : Jump to
y or Y : Canonical URL
go.dev uses cookies from Google to deliver and enhance the quality of its services and to analyze traffic. Learn more.