complexdb

type AddTagToPostParams struct {
	PostId int64
	TagId  int64
}

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

type CreateAuthorParams struct {
	Name  string
	Email string
	Bio   sql.NullString
}

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

type CreatePostParams struct {
	AuthorId  int64
	Title     string
	Content   string
	Published int64
}

type CreatePostRow struct {
	Id        int64
	AuthorId  int64
	Title     string
	Content   string
	Published int64
	ViewCount int64
	CreatedAt int64
	UpdatedAt sql.NullInt64
}

type CreateTagParams struct {
	Name        string
	Description sql.NullString
}

type CreateTagRow struct {
	Id          int64
	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        int64
	Name      string
	Email     string
	Bio       sql.NullString
	CreatedAt int64
}

type GetAuthorStatsRow struct {
	Id         int64
	Name       string
	TotalPosts any
	TotalViews any
}

type GetAuthorWithPostCountRow struct {
	Id         int64
	Name       string
	Email      string
	Bio        sql.NullString
	TotalPosts any
}

type GetPopularTagsRow struct {
	Id          int64
	Name        string
	Description sql.NullString
	PostCount   any
}

type GetPostRow struct {
	Id        int64
	AuthorId  int64
	Title     string
	Content   string
	Published int64
	ViewCount int64
	CreatedAt int64
	UpdatedAt sql.NullInt64
}

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

type GetPostsByTagRow struct {
	Id        int64
	AuthorId  int64
	Title     string
	Content   string
	Published int64
	ViewCount int64
	CreatedAt int64
	UpdatedAt sql.NullInt64
}

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

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

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

type ListPostsRow struct {
	Id        int64
	AuthorId  int64
	Title     string
	Content   string
	Published int64
	ViewCount int64
	CreatedAt int64
	UpdatedAt sql.NullInt64
}

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

type ListUnpublishedPostsRow struct {
	Id        int64
	AuthorId  int64
	Title     string
	Content   string
	Published int64
	ViewCount int64
	CreatedAt int64
	UpdatedAt sql.NullInt64
}

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

type Querier interface {
	AddTagToPost(ctx context.Context, arg AddTagToPostParams) error
	CreateAuthor(ctx context.Context, arg CreateAuthorParams) (CreateAuthorRow, error)
	CreatePost(ctx context.Context, arg CreatePostParams) (CreatePostRow, error)
	CreateTag(ctx context.Context, arg CreateTagParams) (CreateTagRow, error)
	DeleteAuthor(ctx context.Context, id int64) error
	DeleteTag(ctx context.Context, id int64) error
	GetAuthor(ctx context.Context, id int64) (GetAuthorRow, error)
	GetAuthorStats(ctx context.Context, id int64) (GetAuthorStatsRow, error)
	GetAuthorWithPostCount(ctx context.Context, id int64) (GetAuthorWithPostCountRow, error)
	GetPopularTags(ctx context.Context, limit any) ([]GetPopularTagsRow, error)
	GetPost(ctx context.Context, id int64) (GetPostRow, error)
	GetPostTags(ctx context.Context, postId int64) ([]GetPostTagsRow, error)
	GetPostsByTag(ctx context.Context, name string) ([]GetPostsByTagRow, error)
	GetTag(ctx context.Context, id int64) (GetTagRow, error)
	GetTagByName(ctx context.Context, name string) (GetTagByNameRow, error)
	IncrementViewCount(ctx context.Context, id int64) 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, arg SearchPostsParams) ([]SearchPostsRow, error)
	UpdateAuthor(ctx context.Context, arg UpdateAuthorParams) (UpdateAuthorRow, error)
	WithTx(tx DBTX) *Queries
}

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

type QueryResult struct {
	LastInsertID int64
	RowsAffected int64
}

type SearchPostsParams struct {
	Title   any
	Content any
	Limit   any
	Offset  any
}

type SearchPostsRow struct {
	Id        int64
	AuthorId  int64
	Title     string
	Content   string
	Published int64
	ViewCount int64
	CreatedAt int64
	UpdatedAt sql.NullInt64
}

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

type UpdateAuthorParams struct {
	Name  string
	Email string
	Bio   sql.NullString
	Id    int64
}

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