sqlc

package

Go to main page

Versions in this module

v0

v0.15.7

Jan 11, 2026

v0.15.6

Dec 23, 2025

v0.15.5

Nov 23, 2025

v0.15.4

Oct 26, 2025

v0.15.3

Oct 26, 2025

v0.15.2

Oct 26, 2025

v0.15.1

Oct 2, 2025

v0.15.0

Sep 21, 2025

Changes in this version

+ type AssignGroupToUserParams struct

+ GroupID string

+ UserID string

+ type AssignParentGroupParams struct

+ ChildGroupID string

+ ParentGroupID string

+ type Comment struct

+ Author string

+ Created time.Time

+ ID string

+ Message string

+ Ticket string

+ Updated time.Time

+ type CreateCommentParams struct

+ Author string

+ Message string

+ Ticket string

+ type CreateFileParams struct

+ Blob string

+ Name string

+ Size float64

+ Ticket string

+ type CreateGroupParams struct

+ Name string

+ Permissions string

+ type CreateLinkParams struct

+ Name string

+ Ticket string

+ Url string

+ type CreateParamParams struct

+ Key string

+ Value []byte

+ type CreateReactionParams struct

+ Action string

+ Actiondata []byte

+ Name string

+ Trigger string

+ Triggerdata []byte

+ type CreateTaskParams struct

+ Name string

+ Open bool

+ Owner *string

+ Ticket string

+ type CreateTicketParams struct

+ Description string

+ Name string

+ Open bool

+ Owner *string

+ Resolution *string

+ Schema []byte

+ State []byte

+ Type string

+ type CreateTimelineParams struct

+ Message string

+ Ticket string

+ Time time.Time

+ type CreateTypeParams struct

+ Icon *string

+ Plural string

+ Schema []byte

+ Singular string

+ type CreateUserParams struct

+ Active bool

+ Avatar *string

+ Email *string

+ Name *string

+ PasswordHash string

+ TokenKey string

+ Username string

+ type CreateWebhookParams struct

+ Collection string

+ Destination string

+ Name string

+ type DBTX interface

+ ExecContext func(ctx context.Context, query string, args ...interface{}) (sql.Result, error)

+ PrepareContext func(ctx context.Context, query string) (*sql.Stmt, error)

+ QueryContext func(ctx context.Context, query string, args ...interface{}) (*sql.Rows, error)

+ QueryRowContext func(ctx context.Context, query string, args ...interface{}) *sql.Row

+ type DashboardCount struct

+ Count int64

+ ID string

+ type Feature struct

+ Key string

+ type File struct

+ Blob string

+ Created time.Time

+ ID string

+ Name string

+ Size float64

+ Ticket string

+ Updated time.Time

+ type GetCommentRow struct

+ Author string

+ AuthorName *string

+ Created time.Time

+ ID string

+ Message string

+ Ticket string

+ Updated time.Time

+ type GetTaskRow struct

+ Created time.Time

+ ID string

+ Name string

+ Open bool

+ Owner *string

+ OwnerName *string

+ Ticket string

+ TicketName *string

+ TicketType *string

+ Updated time.Time

+ type Group struct

+ Created time.Time

+ ID string

+ Name string

+ Permissions string

+ Updated time.Time

+ type GroupEffectiveGroup struct

+ ChildGroupID string

+ GroupType string

+ ParentGroupID string

+ type GroupEffectivePermission struct

+ ParentGroupID string

+ Permission string

+ type GroupInheritance struct

+ ChildGroupID string

+ ParentGroupID string

+ type InsertCommentParams struct

+ Author string

+ Created time.Time

+ ID string

+ Message string

+ Ticket string

+ Updated time.Time

+ type InsertFileParams struct

+ Blob string

+ Created time.Time

+ ID string

+ Name string

+ Size float64

+ Ticket string

+ Updated time.Time

+ type InsertGroupParams struct

+ Created time.Time

+ ID string

+ Name string

+ Permissions string

+ Updated time.Time

+ type InsertLinkParams struct

+ Created time.Time

+ ID string

+ Name string

+ Ticket string

+ Updated time.Time

+ Url string

+ type InsertReactionParams struct

+ Action string

+ Actiondata []byte

+ Created time.Time

+ ID string

+ Name string

+ Trigger string

+ Triggerdata []byte

+ Updated time.Time

+ type InsertTaskParams struct

+ Created time.Time

+ ID string

+ Name string

+ Open bool

+ Owner *string

+ Ticket string

+ Updated time.Time

+ type InsertTicketParams struct

+ Created time.Time

+ Description string

+ ID string

+ Name string

+ Open bool

+ Owner *string

+ Resolution *string

+ Schema []byte

+ State []byte

+ Type string

+ Updated time.Time

+ type InsertTimelineParams struct

+ Created time.Time

+ ID string

+ Message string

+ Ticket string

+ Time time.Time

+ Updated time.Time

+ type InsertTypeParams struct

+ Created time.Time

+ ID string

+ Icon *string

+ Plural string

+ Schema []byte

+ Singular string

+ Updated time.Time

+ type InsertUserParams struct

+ Active bool

+ Avatar *string

+ Created time.Time

+ Email *string

+ ID string

+ Name *string

+ PasswordHash string

+ TokenKey string

+ Updated time.Time

+ Username string

+ type InsertWebhookParams struct

+ Collection string

+ Created time.Time

+ Destination string

+ ID string

+ Name string

+ Updated time.Time

+ type Link struct

+ Created time.Time

+ ID string

+ Name string

+ Ticket string

+ Updated time.Time

+ Url string

+ type ListChildGroupsRow struct

+ Created time.Time

+ GroupType string

+ ID string

+ Name string

+ Permissions string

+ Updated time.Time

+ type ListCommentsParams struct

+ Limit int64

+ Offset int64

+ Ticket string

+ type ListCommentsRow struct

+ Author string

+ AuthorName *string

+ Created time.Time

+ ID string

+ Message string

+ Ticket string

+ TotalCount int64

+ Updated time.Time

+ type ListFeaturesParams struct

+ Limit int64

+ Offset int64

+ type ListFeaturesRow struct

+ Key string

+ TotalCount int64

+ type ListFilesParams struct

+ Limit int64

+ Offset int64

+ Ticket string

+ type ListFilesRow struct

+ Blob string

+ Created time.Time

+ ID string

+ Name string

+ Size float64

+ Ticket string

+ TotalCount int64

+ Updated time.Time

+ type ListGroupUsersRow struct

+ Active bool

+ Avatar *string

+ Created time.Time

+ Email *string

+ GroupType string

+ ID string

+ Lastresetsentat *time.Time

+ Lastverificationsentat *time.Time

+ Name *string

+ Passwordhash string

+ Tokenkey string

+ Updated time.Time

+ Username string

+ type ListGroupsParams struct

+ Limit int64

+ Offset int64

+ type ListGroupsRow struct

+ Created time.Time

+ ID string

+ Name string

+ Permissions string

+ TotalCount int64

+ Updated time.Time

+ type ListLinksParams struct

+ Limit int64

+ Offset int64

+ Ticket string

+ type ListLinksRow struct

+ Created time.Time

+ ID string

+ Name string

+ Ticket string

+ TotalCount int64

+ Updated time.Time

+ Url string

+ type ListParentGroupsRow struct

+ Created time.Time

+ GroupType string

+ ID string

+ Name string

+ Permissions string

+ Updated time.Time

+ type ListReactionsByTriggerParams struct

+ Limit int64

+ Offset int64

+ Trigger string

+ type ListReactionsByTriggerRow struct

+ Action string

+ Actiondata []byte

+ Created time.Time

+ ID string

+ Name string

+ TotalCount int64

+ Trigger string

+ Triggerdata []byte

+ Updated time.Time

+ type ListReactionsParams struct

+ Limit int64

+ Offset int64

+ type ListReactionsRow struct

+ Action string

+ Actiondata []byte

+ Created time.Time

+ ID string

+ Name string

+ TotalCount int64

+ Trigger string

+ Triggerdata []byte

+ Updated time.Time

+ type ListTasksParams struct

+ Limit int64

+ Offset int64

+ Ticket string

+ type ListTasksRow struct

+ Created time.Time

+ ID string

+ Name string

+ Open bool

+ Owner *string

+ OwnerName *string

+ Ticket string

+ TicketName *string

+ TicketType *string

+ TotalCount int64

+ Updated time.Time

+ type ListTicketsParams struct

+ Limit int64

+ Offset int64

+ type ListTicketsRow struct

+ Created time.Time

+ Description string

+ ID string

+ Name string

+ Open bool

+ Owner *string

+ OwnerName *string

+ Resolution *string

+ Schema []byte

+ State []byte

+ TotalCount int64

+ Type string

+ TypePlural *string

+ TypeSingular *string

+ Updated time.Time

+ type ListTimelineParams struct

+ Limit int64

+ Offset int64

+ Ticket string

+ type ListTimelineRow struct

+ Created time.Time

+ ID string

+ Message string

+ Ticket string

+ Time time.Time

+ TotalCount int64

+ Updated time.Time

+ type ListTypesParams struct

+ Limit int64

+ Offset int64

+ type ListTypesRow struct

+ Created time.Time

+ ID string

+ Icon *string

+ Plural string

+ Schema []byte

+ Singular string

+ TotalCount int64

+ Updated time.Time

+ type ListUserGroupsRow struct

+ Created time.Time

+ GroupType string

+ ID string

+ Name string

+ Permissions string

+ TotalCount int64

+ Updated time.Time

+ type ListUsersParams struct

+ Limit int64

+ Offset int64

+ type ListUsersRow struct

+ Active bool

+ Avatar *string

+ Created time.Time

+ Email *string

+ ID string

+ Lastresetsentat *time.Time

+ Lastverificationsentat *time.Time

+ Name *string

+ Passwordhash string

+ Tokenkey string

+ TotalCount int64

+ Updated time.Time

+ Username string

+ type ListWebhooksParams struct

+ Limit int64

+ Offset int64

+ type ListWebhooksRow struct

+ Collection string

+ Created time.Time

+ Destination string

+ ID string

+ Name string

+ TotalCount int64

+ Updated time.Time

+ type Param struct

+ Key string

+ Value []byte

+ type Queries struct

+ ReadDB *sql.DB

+ WriteDB *sql.DB

+ func New(readDB, writeDB *sql.DB) *Queries

+ type Reaction struct

+ Action string

+ Actiondata []byte

+ Created time.Time

+ ID string

+ Name string

+ Trigger string

+ Triggerdata []byte

+ Updated time.Time

+ type ReadQueries struct

+ func (q *ReadQueries) GetComment(ctx context.Context, id string) (GetCommentRow, error)

+ func (q *ReadQueries) GetDashboardCounts(ctx context.Context) ([]DashboardCount, error)

+ func (q *ReadQueries) GetFeature(ctx context.Context, key string) (string, error)

+ func (q *ReadQueries) GetFile(ctx context.Context, id string) (File, error)

+ func (q *ReadQueries) GetGroup(ctx context.Context, id string) (Group, error)

+ func (q *ReadQueries) GetLink(ctx context.Context, id string) (Link, error)

+ func (q *ReadQueries) GetReaction(ctx context.Context, id string) (Reaction, error)

+ func (q *ReadQueries) GetSidebar(ctx context.Context) ([]Sidebar, error)

+ func (q *ReadQueries) GetTask(ctx context.Context, id string) (GetTaskRow, error)

+ func (q *ReadQueries) GetTimeline(ctx context.Context, id string) (Timeline, error)

+ func (q *ReadQueries) GetType(ctx context.Context, id string) (Type, error)

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

+ func (q *ReadQueries) GetWebhook(ctx context.Context, id string) (Webhook, error)

+ func (q *ReadQueries) ListChildGroups(ctx context.Context, groupID string) ([]ListChildGroupsRow, error)

+ func (q *ReadQueries) ListComments(ctx context.Context, arg ListCommentsParams) ([]ListCommentsRow, error)

+ func (q *ReadQueries) ListFeatures(ctx context.Context, arg ListFeaturesParams) ([]ListFeaturesRow, error)

+ func (q *ReadQueries) ListFiles(ctx context.Context, arg ListFilesParams) ([]ListFilesRow, error)

+ func (q *ReadQueries) ListGroupUsers(ctx context.Context, groupID string) ([]ListGroupUsersRow, error)

+ func (q *ReadQueries) ListGroups(ctx context.Context, arg ListGroupsParams) ([]ListGroupsRow, error)

+ func (q *ReadQueries) ListLinks(ctx context.Context, arg ListLinksParams) ([]ListLinksRow, error)

+ func (q *ReadQueries) ListParentGroups(ctx context.Context, groupID string) ([]ListParentGroupsRow, error)

+ func (q *ReadQueries) ListParentPermissions(ctx context.Context, groupID string) ([]string, error)

+ func (q *ReadQueries) ListReactions(ctx context.Context, arg ListReactionsParams) ([]ListReactionsRow, error)

+ func (q *ReadQueries) ListReactionsByTrigger(ctx context.Context, arg ListReactionsByTriggerParams) ([]ListReactionsByTriggerRow, error)

+ func (q *ReadQueries) ListTasks(ctx context.Context, arg ListTasksParams) ([]ListTasksRow, error)

+ func (q *ReadQueries) ListTickets(ctx context.Context, arg ListTicketsParams) ([]ListTicketsRow, error)

+ func (q *ReadQueries) ListTimeline(ctx context.Context, arg ListTimelineParams) ([]ListTimelineRow, error)

+ func (q *ReadQueries) ListTypes(ctx context.Context, arg ListTypesParams) ([]ListTypesRow, error)

+ func (q *ReadQueries) ListUserGroups(ctx context.Context, userID string) ([]ListUserGroupsRow, error)

+ func (q *ReadQueries) ListUserPermissions(ctx context.Context, userID string) ([]string, error)

+ func (q *ReadQueries) ListUsers(ctx context.Context, arg ListUsersParams) ([]ListUsersRow, error)

+ func (q *ReadQueries) ListWebhooks(ctx context.Context, arg ListWebhooksParams) ([]ListWebhooksRow, error)

+ func (q *ReadQueries) Param(ctx context.Context, key string) (Param, error)

+ func (q *ReadQueries) SearchTickets(ctx context.Context, arg SearchTicketsParams) ([]SearchTicketsRow, error)

+ func (q *ReadQueries) SystemUser(ctx context.Context) (User, error)

+ func (q *ReadQueries) Ticket(ctx context.Context, id string) (TicketRow, error)

+ func (q *ReadQueries) UserByEmail(ctx context.Context, email *string) (User, error)

+ func (q *ReadQueries) UserByUserName(ctx context.Context, username string) (User, error)

+ type RemoveGroupFromUserParams struct

+ GroupID string

+ UserID string

+ type RemoveParentGroupParams struct

+ ChildGroupID string

+ ParentGroupID string

+ type SearchTicketsParams struct

+ Limit int64

+ Offset int64

+ Open interface{}

+ Query interface{}

+ Type interface{}

+ type SearchTicketsRow struct

+ Created time.Time

+ Description string

+ ID string

+ Name string

+ Open bool

+ OwnerName *string

+ State []byte

+ TotalCount int64

+ Type string

+ type Sidebar struct

+ Count int64

+ ID string

+ Icon *string

+ Plural string

+ Singular string

+ type Task struct

+ Created time.Time

+ ID string

+ Name string

+ Open bool

+ Owner *string

+ Ticket string

+ Updated time.Time

+ type Ticket struct

+ Created time.Time

+ Description string

+ ID string

+ Name string

+ Open bool

+ Owner *string

+ Resolution *string

+ Schema []byte

+ State []byte

+ Type string

+ Updated time.Time

+ type TicketRow struct

+ Created time.Time

+ Description string

+ ID string

+ Name string

+ Open bool

+ Owner *string

+ OwnerName *string

+ Resolution *string

+ Schema []byte

+ State []byte

+ Type string

+ TypePlural *string

+ TypeSingular *string

+ Updated time.Time

+ type TicketSearch struct

+ CommentMessages string

+ Created time.Time

+ Description string

+ FileNames string

+ ID string

+ LinkNames string

+ LinkUrls string

+ Name string

+ Open bool

+ OwnerName *string

+ State []byte

+ TaskNames string

+ TimelineMessages string

+ Type string

+ type Timeline struct

+ Created time.Time

+ ID string

+ Message string

+ Ticket string

+ Time time.Time

+ Updated time.Time

+ type Type struct

+ Created time.Time

+ ID string

+ Icon *string

+ Plural string

+ Schema []byte

+ Singular string

+ Updated time.Time

+ type UpdateCommentParams struct

+ ID string

+ Message *string

+ type UpdateFileParams struct

+ Blob *string

+ ID string

+ Name *string

+ Size *float64

+ type UpdateGroupParams struct

+ ID string

+ Name *string

+ Permissions *string

+ type UpdateLinkParams struct

+ ID string

+ Name *string

+ Url *string

+ type UpdateParamParams struct

+ Key string

+ Value []byte

+ type UpdateReactionParams struct

+ Action *string

+ Actiondata []byte

+ ID string

+ Name *string

+ Trigger *string

+ Triggerdata []byte

+ type UpdateTaskParams struct

+ ID string

+ Name *string

+ Open *bool

+ Owner *string

+ type UpdateTicketParams struct

+ Description *string

+ ID string

+ Name *string

+ Open *bool

+ Owner *string

+ Resolution *string

+ Schema []byte

+ State []byte

+ Type *string

+ type UpdateTimelineParams struct

+ ID string

+ Message *string

+ Time *time.Time

+ type UpdateTypeParams struct

+ ID string

+ Icon *string

+ Plural *string

+ Schema []byte

+ Singular *string

+ type UpdateUserParams struct

+ Active *bool

+ Avatar *string

+ Email *string

+ ID string

+ LastResetSentAt *time.Time

+ LastVerificationSentAt *time.Time

+ Name *string

+ PasswordHash *string

+ TokenKey *string

+ Username *string

+ type UpdateWebhookParams struct

+ Collection *string

+ Destination *string

+ ID string

+ Name *string

+ type User struct

+ Active bool

+ Avatar *string

+ Created time.Time

+ Email *string

+ ID string

+ Lastresetsentat *time.Time

+ Lastverificationsentat *time.Time

+ Name *string

+ Passwordhash string

+ Tokenkey string

+ Updated time.Time

+ Username string

+ type UserEffectiveGroup struct

+ GroupID string

+ GroupType string

+ UserID string

+ type UserEffectivePermission struct

+ Permission string

+ UserID string

+ type UserGroup struct

+ GroupID string

+ UserID string

+ type Webhook struct

+ Collection string

+ Created time.Time

+ Destination string

+ ID string

+ Name string

+ Updated time.Time

+ type WriteQueries struct

+ func (q *WriteQueries) AssignGroupToUser(ctx context.Context, arg AssignGroupToUserParams) error

+ func (q *WriteQueries) AssignParentGroup(ctx context.Context, arg AssignParentGroupParams) error

+ func (q *WriteQueries) CreateComment(ctx context.Context, arg CreateCommentParams) (Comment, error)

+ func (q *WriteQueries) CreateFeature(ctx context.Context, key string) (string, error)

+ func (q *WriteQueries) CreateFile(ctx context.Context, arg CreateFileParams) (File, error)

+ func (q *WriteQueries) CreateGroup(ctx context.Context, arg CreateGroupParams) (Group, error)

+ func (q *WriteQueries) CreateLink(ctx context.Context, arg CreateLinkParams) (Link, error)

+ func (q *WriteQueries) CreateParam(ctx context.Context, arg CreateParamParams) error

+ func (q *WriteQueries) CreateReaction(ctx context.Context, arg CreateReactionParams) (Reaction, error)

+ func (q *WriteQueries) CreateTask(ctx context.Context, arg CreateTaskParams) (Task, error)

+ func (q *WriteQueries) CreateTicket(ctx context.Context, arg CreateTicketParams) (Ticket, error)

+ func (q *WriteQueries) CreateTimeline(ctx context.Context, arg CreateTimelineParams) (Timeline, error)

+ func (q *WriteQueries) CreateType(ctx context.Context, arg CreateTypeParams) (Type, error)

+ func (q *WriteQueries) CreateUser(ctx context.Context, arg CreateUserParams) (User, error)

+ func (q *WriteQueries) CreateWebhook(ctx context.Context, arg CreateWebhookParams) (Webhook, error)

+ func (q *WriteQueries) DeleteComment(ctx context.Context, id string) error

+ func (q *WriteQueries) DeleteFeature(ctx context.Context, key string) error

+ func (q *WriteQueries) DeleteFile(ctx context.Context, id string) error

+ func (q *WriteQueries) DeleteGroup(ctx context.Context, id string) error

+ func (q *WriteQueries) DeleteLink(ctx context.Context, id string) error

+ func (q *WriteQueries) DeleteReaction(ctx context.Context, id string) error

+ func (q *WriteQueries) DeleteTask(ctx context.Context, id string) error

+ func (q *WriteQueries) DeleteTicket(ctx context.Context, id string) error

+ func (q *WriteQueries) DeleteTimeline(ctx context.Context, id string) error

+ func (q *WriteQueries) DeleteType(ctx context.Context, id string) error

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

+ func (q *WriteQueries) DeleteWebhook(ctx context.Context, id string) error

+ func (q *WriteQueries) InsertComment(ctx context.Context, arg InsertCommentParams) (Comment, error)

+ func (q *WriteQueries) InsertFile(ctx context.Context, arg InsertFileParams) (File, error)

+ func (q *WriteQueries) InsertGroup(ctx context.Context, arg InsertGroupParams) (Group, error)

+ func (q *WriteQueries) InsertLink(ctx context.Context, arg InsertLinkParams) (Link, error)

+ func (q *WriteQueries) InsertReaction(ctx context.Context, arg InsertReactionParams) (Reaction, error)

+ func (q *WriteQueries) InsertTask(ctx context.Context, arg InsertTaskParams) (Task, error)

+ func (q *WriteQueries) InsertTicket(ctx context.Context, arg InsertTicketParams) (Ticket, error)

+ func (q *WriteQueries) InsertTimeline(ctx context.Context, arg InsertTimelineParams) (Timeline, error)

+ func (q *WriteQueries) InsertType(ctx context.Context, arg InsertTypeParams) (Type, error)

+ func (q *WriteQueries) InsertUser(ctx context.Context, arg InsertUserParams) (User, error)

+ func (q *WriteQueries) InsertWebhook(ctx context.Context, arg InsertWebhookParams) (Webhook, error)

+ func (q *WriteQueries) RemoveGroupFromUser(ctx context.Context, arg RemoveGroupFromUserParams) error

+ func (q *WriteQueries) RemoveParentGroup(ctx context.Context, arg RemoveParentGroupParams) error

+ func (q *WriteQueries) UpdateComment(ctx context.Context, arg UpdateCommentParams) (Comment, error)

+ func (q *WriteQueries) UpdateFile(ctx context.Context, arg UpdateFileParams) (File, error)

+ func (q *WriteQueries) UpdateGroup(ctx context.Context, arg UpdateGroupParams) (Group, error)

+ func (q *WriteQueries) UpdateLink(ctx context.Context, arg UpdateLinkParams) (Link, error)

+ func (q *WriteQueries) UpdateParam(ctx context.Context, arg UpdateParamParams) error

+ func (q *WriteQueries) UpdateReaction(ctx context.Context, arg UpdateReactionParams) (Reaction, error)

+ func (q *WriteQueries) UpdateTask(ctx context.Context, arg UpdateTaskParams) (Task, error)

+ func (q *WriteQueries) UpdateTicket(ctx context.Context, arg UpdateTicketParams) (Ticket, error)

+ func (q *WriteQueries) UpdateTimeline(ctx context.Context, arg UpdateTimelineParams) (Timeline, error)

+ func (q *WriteQueries) UpdateType(ctx context.Context, arg UpdateTypeParams) (Type, error)

+ func (q *WriteQueries) UpdateUser(ctx context.Context, arg UpdateUserParams) (User, error)

+ func (q *WriteQueries) UpdateWebhook(ctx context.Context, arg UpdateWebhookParams) (Webhook, error)

v0.15.0-rc.10

Sep 21, 2025

v0.15.0-rc.9

Sep 21, 2025

v0.15.0-rc.8

Sep 4, 2025

v0.15.0-rc.7

Sep 2, 2025

v0.15.0-rc.6

Sep 2, 2025

v0.15.0-rc.5

Sep 2, 2025

v0.15.0-rc.4

Sep 2, 2025

v0.15.0-rc.3

Sep 2, 2025

v0.15.0-rc.2

Sep 2, 2025

v0.15.0-rc.1

Sep 2, 2025

?	: This menu
/	: Search site
f or F	: Jump to
y or Y	: Canonical URL