sqlcpostgres

package
v1.5.0 Latest Latest
Warning

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

Go to latest
Published: Mar 30, 2026 License: MIT Imports: 2 Imported by: 0

Documentation

Index

Constants

This section is empty.

Variables

This section is empty.

Functions

This section is empty.

Types

type CreateMemberParams

type CreateMemberParams struct {
	ID             string `json:"id"`
	UserID         string `json:"user_id"`
	OrganizationID string `json:"organization_id"`
	Role           string `json:"role"`
	CreatedAt      string `json:"created_at"`
	UpdatedAt      string `json:"updated_at"`
}

type CreateOrganizationParams

type CreateOrganizationParams struct {
	ID        string `json:"id"`
	Name      string `json:"name"`
	Slug      string `json:"slug"`
	CreatedAt string `json:"created_at"`
	UpdatedAt string `json:"updated_at"`
}

type CreateTeamMemberParams

type CreateTeamMemberParams struct {
	ID        string `json:"id"`
	TeamID    string `json:"team_id"`
	UserID    string `json:"user_id"`
	Role      string `json:"role"`
	CreatedAt string `json:"created_at"`
	UpdatedAt string `json:"updated_at"`
}

type CreateTeamParams

type CreateTeamParams struct {
	ID             string         `json:"id"`
	OrganizationID string         `json:"organization_id"`
	Name           string         `json:"name"`
	Description    sql.NullString `json:"description"`
	CreatedAt      string         `json:"created_at"`
	UpdatedAt      string         `json:"updated_at"`
}

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 DeleteOrganizationParams

type DeleteOrganizationParams struct {
	ID        string `json:"id"`
	UpdatedAt string `json:"updated_at"`
}

type GetMemberParams

type GetMemberParams struct {
	UserID         string `json:"user_id"`
	OrganizationID string `json:"organization_id"`
}

type GetOrganizationBySlugRow

type GetOrganizationBySlugRow struct {
	ID        string `json:"id"`
	Name      string `json:"name"`
	Slug      string `json:"slug"`
	CreatedAt string `json:"created_at"`
	UpdatedAt string `json:"updated_at"`
}

type GetOrganizationRow

type GetOrganizationRow struct {
	ID        string `json:"id"`
	Name      string `json:"name"`
	Slug      string `json:"slug"`
	CreatedAt string `json:"created_at"`
	UpdatedAt string `json:"updated_at"`
}

type GetTeamMemberParams

type GetTeamMemberParams struct {
	TeamID string `json:"team_id"`
	UserID string `json:"user_id"`
}

type IsOrganizationMemberParams

type IsOrganizationMemberParams struct {
	UserID         string `json:"user_id"`
	OrganizationID string `json:"organization_id"`
}

type IsOwnerOrAdminParams

type IsOwnerOrAdminParams struct {
	UserID         string `json:"user_id"`
	OrganizationID string `json:"organization_id"`
}

type IsOwnerParams

type IsOwnerParams struct {
	UserID         string `json:"user_id"`
	OrganizationID string `json:"organization_id"`
}

type ListOrganizationMembersParams

type ListOrganizationMembersParams struct {
	OrganizationID string `json:"organization_id"`
	Limit          int32  `json:"limit"`
	Offset         int32  `json:"offset"`
}

type ListTeamMembersParams

type ListTeamMembersParams struct {
	TeamID string `json:"team_id"`
	Limit  int32  `json:"limit"`
	Offset int32  `json:"offset"`
}

type ListTeamsParams

type ListTeamsParams struct {
	OrganizationID string `json:"organization_id"`
	Limit          int32  `json:"limit"`
	Offset         int32  `json:"offset"`
}

type ListUserOrganizationsParams

type ListUserOrganizationsParams struct {
	UserID string `json:"user_id"`
	Limit  int32  `json:"limit"`
	Offset int32  `json:"offset"`
}

type ListUserOrganizationsRow

type ListUserOrganizationsRow struct {
	ID        string `json:"id"`
	Name      string `json:"name"`
	Slug      string `json:"slug"`
	CreatedAt string `json:"created_at"`
	UpdatedAt string `json:"updated_at"`
}

type Member

type Member struct {
	ID             string `json:"id"`
	UserID         string `json:"user_id"`
	OrganizationID string `json:"organization_id"`
	Role           string `json:"role"`
	CreatedAt      string `json:"created_at"`
	UpdatedAt      string `json:"updated_at"`
}

type Organization

type Organization struct {
	ID        string `json:"id"`
	Name      string `json:"name"`
	Slug      string `json:"slug"`
	Disabled  int32  `json:"disabled"`
	CreatedAt string `json:"created_at"`
	UpdatedAt string `json:"updated_at"`
}

type Queries

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

func New

func New(db DBTX) *Queries

func (*Queries) CountOrganizationMembers

func (q *Queries) CountOrganizationMembers(ctx context.Context, organizationID string) (int64, error)

func (*Queries) CountTeamMembers

func (q *Queries) CountTeamMembers(ctx context.Context, teamID string) (int64, error)

func (*Queries) CountTeams

func (q *Queries) CountTeams(ctx context.Context, organizationID string) (int64, error)

func (*Queries) CountUserOrganizations

func (q *Queries) CountUserOrganizations(ctx context.Context, userID string) (int64, error)

func (*Queries) CreateMember

func (q *Queries) CreateMember(ctx context.Context, arg CreateMemberParams) error

User Organizations queries

func (*Queries) CreateOrganization

func (q *Queries) CreateOrganization(ctx context.Context, arg CreateOrganizationParams) error

Organizations queries

func (*Queries) CreateTeam

func (q *Queries) CreateTeam(ctx context.Context, arg CreateTeamParams) error

Teams queries

func (*Queries) CreateTeamMember

func (q *Queries) CreateTeamMember(ctx context.Context, arg CreateTeamMemberParams) error

Team Members queries

func (*Queries) DeleteOrganization

func (q *Queries) DeleteOrganization(ctx context.Context, arg DeleteOrganizationParams) error

func (*Queries) DeleteTeam

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

func (*Queries) GetMember

func (q *Queries) GetMember(ctx context.Context, arg GetMemberParams) (Member, error)

func (*Queries) GetOrganization

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

func (*Queries) GetOrganizationBySlug

func (q *Queries) GetOrganizationBySlug(ctx context.Context, slug string) (GetOrganizationBySlugRow, error)

func (*Queries) GetTeam

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

func (*Queries) GetTeamMember

func (q *Queries) GetTeamMember(ctx context.Context, arg GetTeamMemberParams) (TeamMember, error)

func (*Queries) IsOrganizationMember

func (q *Queries) IsOrganizationMember(ctx context.Context, arg IsOrganizationMemberParams) (bool, error)

func (*Queries) IsOwner

func (q *Queries) IsOwner(ctx context.Context, arg IsOwnerParams) (bool, error)

func (*Queries) IsOwnerOrAdmin

func (q *Queries) IsOwnerOrAdmin(ctx context.Context, arg IsOwnerOrAdminParams) (bool, error)

func (*Queries) ListOrganizationMembers

func (q *Queries) ListOrganizationMembers(ctx context.Context, arg ListOrganizationMembersParams) ([]Member, error)

func (*Queries) ListTeamMembers

func (q *Queries) ListTeamMembers(ctx context.Context, arg ListTeamMembersParams) ([]TeamMember, error)

func (*Queries) ListTeams

func (q *Queries) ListTeams(ctx context.Context, arg ListTeamsParams) ([]Team, error)

func (*Queries) ListUserOrganizations

func (q *Queries) ListUserOrganizations(ctx context.Context, arg ListUserOrganizationsParams) ([]ListUserOrganizationsRow, error)

func (*Queries) RemoveMember

func (q *Queries) RemoveMember(ctx context.Context, arg RemoveMemberParams) error

func (*Queries) RemoveTeamMember

func (q *Queries) RemoveTeamMember(ctx context.Context, arg RemoveTeamMemberParams) error

func (*Queries) UpdateMemberRole

func (q *Queries) UpdateMemberRole(ctx context.Context, arg UpdateMemberRoleParams) error

func (*Queries) UpdateOrganization

func (q *Queries) UpdateOrganization(ctx context.Context, arg UpdateOrganizationParams) error

func (*Queries) UpdateTeam

func (q *Queries) UpdateTeam(ctx context.Context, arg UpdateTeamParams) error

func (*Queries) UpdateTeamMemberRole

func (q *Queries) UpdateTeamMemberRole(ctx context.Context, arg UpdateTeamMemberRoleParams) error

func (*Queries) WithTx

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

type RemoveMemberParams

type RemoveMemberParams struct {
	UserID         string `json:"user_id"`
	OrganizationID string `json:"organization_id"`
}

type RemoveTeamMemberParams

type RemoveTeamMemberParams struct {
	TeamID string `json:"team_id"`
	UserID string `json:"user_id"`
}

type Team

type Team struct {
	ID             string         `json:"id"`
	OrganizationID string         `json:"organization_id"`
	Name           string         `json:"name"`
	Description    sql.NullString `json:"description"`
	CreatedAt      string         `json:"created_at"`
	UpdatedAt      string         `json:"updated_at"`
}

type TeamMember

type TeamMember struct {
	ID        string `json:"id"`
	TeamID    string `json:"team_id"`
	UserID    string `json:"user_id"`
	Role      string `json:"role"`
	CreatedAt string `json:"created_at"`
	UpdatedAt string `json:"updated_at"`
}

type UpdateMemberRoleParams

type UpdateMemberRoleParams struct {
	UserID         string `json:"user_id"`
	OrganizationID string `json:"organization_id"`
	Role           string `json:"role"`
	UpdatedAt      string `json:"updated_at"`
}

type UpdateOrganizationParams

type UpdateOrganizationParams struct {
	ID        string `json:"id"`
	Name      string `json:"name"`
	Slug      string `json:"slug"`
	UpdatedAt string `json:"updated_at"`
}

type UpdateTeamMemberRoleParams

type UpdateTeamMemberRoleParams struct {
	TeamID    string `json:"team_id"`
	UserID    string `json:"user_id"`
	Role      string `json:"role"`
	UpdatedAt string `json:"updated_at"`
}

type UpdateTeamParams

type UpdateTeamParams struct {
	ID          string         `json:"id"`
	Name        string         `json:"name"`
	Description sql.NullString `json:"description"`
	UpdatedAt   string         `json:"updated_at"`
}

type User

type User struct {
	ID        string         `json:"id"`
	Avatar    sql.NullString `json:"avatar"`
	Name      string         `json:"name"`
	Email     sql.NullString `json:"email"`
	CreatedAt string         `json:"created_at"`
	UpdatedAt string         `json:"updated_at"`
	Disabled  int32          `json:"disabled"`
}

Jump to

Keyboard shortcuts

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