complexdb

type Authors struct {
	Id        int32          `json:"id"`
	Name      string         `json:"name"`
	Email     string         `json:"email"`
	Bio       sql.NullString `json:"bio"`
	CreatedAt int32          `json:"created_at"`
}

type CreateAuthorRow struct {
	Id        int32
	Name      string
	Email     string
	Bio       sql.NullString
	CreatedAt int32
}

type CreatePostRow struct {
	Id        int32
	AuthorId  int32
	Title     string
	Content   string
	Published int32
	ViewCount int32
	CreatedAt int32
	UpdatedAt *int32
}

type CreateTagRow struct {
	Id          int32
	Name        string
	Description sql.NullString
}

type DBTX interface {
	ExecContext(ctx context.Context, query string, args ...any) (sql.Result, error)
	QueryContext(ctx context.Context, query string, args ...any) (*sql.Rows, error)
	QueryRowContext(ctx context.Context, query string, args ...any) *sql.Row
}

type GetAuthorRow struct {
	Id        int32
	Name      string
	Email     string
	Bio       sql.NullString
	CreatedAt int32
}

type GetAuthorStatsRow struct {
	Id         int32
	Name       string
	TotalPosts *int32
	TotalViews *int32
}

type GetAuthorWithPostCountRow struct {
	Id         int32
	Name       string
	Email      string
	Bio        sql.NullString
	TotalPosts *int32
}

type GetPopularTagsRow struct {
	Id          int32
	Name        string
	Description sql.NullString
	PostCount   *int32
}

type GetPostRow struct {
	Id        int32
	AuthorId  int32
	Title     string
	Content   string
	Published int32
	ViewCount int32
	CreatedAt int32
	UpdatedAt *int32
}

type GetPostTagsRow struct {
	Id          int32
	Name        string
	Description sql.NullString
}

type GetPostsByTagRow struct {
	Id        int32
	AuthorId  int32
	Title     string
	Content   string
	Published int32
	ViewCount int32
	CreatedAt int32
	UpdatedAt *int32
}

type GetTagByNameRow struct {
	Id          int32
	Name        string
	Description sql.NullString
}

type GetTagRow struct {
	Id          int32
	Name        string
	Description sql.NullString
}

type ListAuthorsRow struct {
	Id        int32
	Name      string
	Email     string
	Bio       sql.NullString
	CreatedAt int32
}

type ListPostsRow struct {
	Id        int32
	AuthorId  int32
	Title     string
	Content   string
	Published int32
	ViewCount int32
	CreatedAt int32
	UpdatedAt *int32
}

type ListTagsRow struct {
	Id          int32
	Name        string
	Description sql.NullString
}

type ListUnpublishedPostsRow struct {
	Id        int32
	AuthorId  int32
	Title     string
	Content   string
	Published int32
	ViewCount int32
	CreatedAt int32
	UpdatedAt *int32
}

type Posts struct {
	Id        int32  `json:"id"`
	AuthorId  int32  `json:"author_id"`
	Title     string `json:"title"`
	Content   string `json:"content"`
	Published int32  `json:"published"`
	ViewCount int32  `json:"view_count"`
	CreatedAt int32  `json:"created_at"`
	UpdatedAt *int32 `json:"updated_at"`
}

type Querier interface {
	AddTagToPost(ctx context.Context, arg1 int32, arg2 int32) (sql.Result, error)
	CreateAuthor(ctx context.Context, arg1 string, arg2 string, arg3 sql.NullString) (CreateAuthorRow, error)
	CreatePost(ctx context.Context, arg1 int32, arg2 string, arg3 string, arg4 int32) (CreatePostRow, error)
	CreateTag(ctx context.Context, arg1 string, arg2 sql.NullString) (CreateTagRow, error)
	DeleteAuthor(ctx context.Context, id int32) (sql.Result, error)
	DeleteTag(ctx context.Context, id int32) (sql.Result, error)
	GetAuthor(ctx context.Context, id int32) (GetAuthorRow, error)
	GetAuthorStats(ctx context.Context, id int32) (GetAuthorStatsRow, error)
	GetAuthorWithPostCount(ctx context.Context, id int32) (GetAuthorWithPostCountRow, error)
	GetPopularTags(ctx context.Context, arg1 *int32) ([]GetPopularTagsRow, error)
	GetPost(ctx context.Context, id int32) (GetPostRow, error)
	GetPostTags(ctx context.Context, postId int32) ([]GetPostTagsRow, error)
	GetPostsByTag(ctx context.Context, name string) ([]GetPostsByTagRow, error)
	GetTag(ctx context.Context, id int32) (GetTagRow, error)
	GetTagByName(ctx context.Context, name string) (GetTagByNameRow, error)
	IncrementViewCount(ctx context.Context, id int32) (sql.Result, error)
	ListAuthors(ctx context.Context) ([]ListAuthorsRow, error)
	ListPosts(ctx context.Context) ([]ListPostsRow, error)
	ListTags(ctx context.Context) ([]ListTagsRow, error)
	ListUnpublishedPosts(ctx context.Context) ([]ListUnpublishedPostsRow, error)
	SearchPosts(ctx context.Context, title *int32, arg2 *int32, arg3 *int32, arg4 *int32) ([]SearchPostsRow, error)
	UpdateAuthor(ctx context.Context, name string, arg2 string, arg3 sql.NullString, arg4 int32) (UpdateAuthorRow, error)
}

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

type QueryResult struct {
	LastInsertID int64
	RowsAffected int64
}

type SearchPostsRow struct {
	Id        int32
	AuthorId  int32
	Title     string
	Content   string
	Published int32
	ViewCount int32
	CreatedAt int32
	UpdatedAt *int32
}

type Tags struct {
	Id          int32          `json:"id"`
	Name        string         `json:"name"`
	Description sql.NullString `json:"description"`
}

type UpdateAuthorRow struct {
	Id        int32
	Name      string
	Email     string
	Bio       sql.NullString
	CreatedAt int32
}