Versions in this module Expand all Collapse all v0 v0.12.0 Jun 11, 2026 v0.11.0 Jun 11, 2026 Changes in this version + type AddTagToPostParams struct + PostId int64 + TagId int64 + type CreateAuthorParams struct + Bio sql.NullString + Email string + Name string + type CreatePostParams struct + AuthorId int64 + Content string + Published int64 + Title string + type CreateTagParams struct + Description sql.NullString + Name string type Querier + WithTx func(tx DBTX) *Queries type Queries + func (q *Queries) WithTx(tx DBTX) *Queries + type SearchPostsParams struct + Content any + Limit any + Offset any + Title any + type UpdateAuthorParams struct + Bio sql.NullString + Email string + Id int64 + Name string v0.5.0 Feb 9, 2026 v0.3.0 Feb 7, 2026 Changes in this version + type Authors struct + Bio sql.NullString + CreatedAt int32 + Email string + Id int32 + Name string + type CreateAuthorRow struct + Bio sql.NullString + CreatedAt int32 + Email string + Id int32 + Name string + type CreatePostRow struct + AuthorId int32 + Content string + CreatedAt int32 + Id int32 + Published int32 + Title string + UpdatedAt *int32 + ViewCount int32 + type CreateTagRow struct + Description sql.NullString + Id int32 + Name string + type DBTX interface + ExecContext func(ctx context.Context, query string, args ...any) (sql.Result, error) + QueryContext func(ctx context.Context, query string, args ...any) (*sql.Rows, error) + QueryRowContext func(ctx context.Context, query string, args ...any) *sql.Row + type GetAuthorRow struct + Bio sql.NullString + CreatedAt int32 + Email string + Id int32 + Name string + type GetAuthorStatsRow struct + Id int32 + Name string + TotalPosts *int32 + TotalViews *int32 + type GetAuthorWithPostCountRow struct + Bio sql.NullString + Email string + Id int32 + Name string + TotalPosts *int32 + type GetPopularTagsRow struct + Description sql.NullString + Id int32 + Name string + PostCount *int32 + type GetPostRow struct + AuthorId int32 + Content string + CreatedAt int32 + Id int32 + Published int32 + Title string + UpdatedAt *int32 + ViewCount int32 + type GetPostTagsRow struct + Description sql.NullString + Id int32 + Name string + type GetPostsByTagRow struct + AuthorId int32 + Content string + CreatedAt int32 + Id int32 + Published int32 + Title string + UpdatedAt *int32 + ViewCount int32 + type GetTagByNameRow struct + Description sql.NullString + Id int32 + Name string + type GetTagRow struct + Description sql.NullString + Id int32 + Name string + type ListAuthorsRow struct + Bio sql.NullString + CreatedAt int32 + Email string + Id int32 + Name string + type ListPostsRow struct + AuthorId int32 + Content string + CreatedAt int32 + Id int32 + Published int32 + Title string + UpdatedAt *int32 + ViewCount int32 + type ListTagsRow struct + Description sql.NullString + Id int32 + Name string + type ListUnpublishedPostsRow struct + AuthorId int32 + Content string + CreatedAt int32 + Id int32 + Published int32 + Title string + UpdatedAt *int32 + ViewCount int32 + type Posts struct + AuthorId int32 + Content string + CreatedAt int32 + Id int32 + Published int32 + Title string + UpdatedAt *int32 + ViewCount int32 + type Querier interface + AddTagToPost func(ctx context.Context, arg1 int32, arg2 int32) (sql.Result, error) + CreateAuthor func(ctx context.Context, arg1 string, arg2 string, arg3 sql.NullString) (CreateAuthorRow, error) + CreatePost func(ctx context.Context, arg1 int32, arg2 string, arg3 string, arg4 int32) (CreatePostRow, error) + CreateTag func(ctx context.Context, arg1 string, arg2 sql.NullString) (CreateTagRow, error) + DeleteAuthor func(ctx context.Context, id int32) (sql.Result, error) + DeleteTag func(ctx context.Context, id int32) (sql.Result, error) + GetAuthor func(ctx context.Context, id int32) (GetAuthorRow, error) + GetAuthorStats func(ctx context.Context, id int32) (GetAuthorStatsRow, error) + GetAuthorWithPostCount func(ctx context.Context, id int32) (GetAuthorWithPostCountRow, error) + GetPopularTags func(ctx context.Context, arg1 *int32) ([]GetPopularTagsRow, error) + GetPost func(ctx context.Context, id int32) (GetPostRow, error) + GetPostTags func(ctx context.Context, postId int32) ([]GetPostTagsRow, error) + GetPostsByTag func(ctx context.Context, name string) ([]GetPostsByTagRow, error) + GetTag func(ctx context.Context, id int32) (GetTagRow, error) + GetTagByName func(ctx context.Context, name string) (GetTagByNameRow, error) + IncrementViewCount func(ctx context.Context, id int32) (sql.Result, error) + ListAuthors func(ctx context.Context) ([]ListAuthorsRow, error) + ListPosts func(ctx context.Context) ([]ListPostsRow, error) + ListTags func(ctx context.Context) ([]ListTagsRow, error) + ListUnpublishedPosts func(ctx context.Context) ([]ListUnpublishedPostsRow, error) + SearchPosts func(ctx context.Context, title *int32, arg2 *int32, arg3 *int32, arg4 *int32) ([]SearchPostsRow, error) + UpdateAuthor func(ctx context.Context, name string, arg2 string, arg3 sql.NullString, arg4 int32) (UpdateAuthorRow, error) + type Queries struct + func New(db DBTX) *Queries + func (q *Queries) AddTagToPost(ctx context.Context, arg1 int32, arg2 int32) (sql.Result, error) + func (q *Queries) CreateAuthor(ctx context.Context, arg1 string, arg2 string, arg3 sql.NullString) (CreateAuthorRow, error) + func (q *Queries) CreatePost(ctx context.Context, arg1 int32, arg2 string, arg3 string, arg4 int32) (CreatePostRow, error) + func (q *Queries) CreateTag(ctx context.Context, arg1 string, arg2 sql.NullString) (CreateTagRow, error) + func (q *Queries) DeleteAuthor(ctx context.Context, id int32) (sql.Result, error) + func (q *Queries) DeleteTag(ctx context.Context, id int32) (sql.Result, error) + func (q *Queries) GetAuthor(ctx context.Context, id int32) (GetAuthorRow, error) + func (q *Queries) GetAuthorStats(ctx context.Context, id int32) (GetAuthorStatsRow, error) + func (q *Queries) GetAuthorWithPostCount(ctx context.Context, id int32) (GetAuthorWithPostCountRow, error) + func (q *Queries) GetPopularTags(ctx context.Context, arg1 *int32) ([]GetPopularTagsRow, error) + func (q *Queries) GetPost(ctx context.Context, id int32) (GetPostRow, error) + func (q *Queries) GetPostTags(ctx context.Context, postId int32) ([]GetPostTagsRow, error) + func (q *Queries) GetPostsByTag(ctx context.Context, name string) ([]GetPostsByTagRow, error) + func (q *Queries) GetTag(ctx context.Context, id int32) (GetTagRow, error) + func (q *Queries) GetTagByName(ctx context.Context, name string) (GetTagByNameRow, error) + func (q *Queries) IncrementViewCount(ctx context.Context, id int32) (sql.Result, error) + func (q *Queries) ListAuthors(ctx context.Context) ([]ListAuthorsRow, error) + func (q *Queries) ListPosts(ctx context.Context) ([]ListPostsRow, error) + func (q *Queries) ListTags(ctx context.Context) ([]ListTagsRow, error) + func (q *Queries) ListUnpublishedPosts(ctx context.Context) ([]ListUnpublishedPostsRow, error) + func (q *Queries) SearchPosts(ctx context.Context, title *int32, arg2 *int32, arg3 *int32, arg4 *int32) ([]SearchPostsRow, error) + func (q *Queries) UpdateAuthor(ctx context.Context, name string, arg2 string, arg3 sql.NullString, arg4 int32) (UpdateAuthorRow, error) + type QueryResult struct + LastInsertID int64 + RowsAffected int64 + type SearchPostsRow struct + AuthorId int32 + Content string + CreatedAt int32 + Id int32 + Published int32 + Title string + UpdatedAt *int32 + ViewCount int32 + type Tags struct + Description sql.NullString + Id int32 + Name string + type UpdateAuthorRow struct + Bio sql.NullString + CreatedAt int32 + Email string + Id int32 + Name string
Go to main page