sqlstore

package

Go to main page

Versions in this module

v0

v0.4.1

Sep 11, 2026

v0.4.0

Sep 11, 2026

Changes in this version

type Dialect

+ StringAgg func(expr, separator string) string

type Store

+ func (s *Store) ActiveOrganizationOf(ctx context.Context, sessionID string) (string, error)

+ func (s *Store) AddTeamMember(ctx context.Context, teamID, userID string) error

+ func (s *Store) ClearActiveOrganization(ctx context.Context, orgID, userID string) error

+ func (s *Store) ConsumeInvitation(ctx context.Context, tokenHash string, now time.Time) (*store.Invitation, error)

+ func (s *Store) CountMembers(ctx context.Context, orgID string) (int, error)

+ func (s *Store) CountPendingInvitations(ctx context.Context, orgID string, now time.Time) (int, error)

+ func (s *Store) CreateCustomRole(ctx context.Context, r *store.CustomRole) error

+ func (s *Store) CreateInvitation(ctx context.Context, i *store.Invitation) error

+ func (s *Store) CreateMembership(ctx context.Context, m *store.Membership) error

+ func (s *Store) CreateOrganization(ctx context.Context, o *store.Organization) error

+ func (s *Store) CreateTeam(ctx context.Context, t *store.Team) error

+ func (s *Store) CustomRoleByName(ctx context.Context, orgID, name string) (*store.CustomRole, error)

+ func (s *Store) DeleteCustomRole(ctx context.Context, orgID, name string) error

+ func (s *Store) DeleteMembership(ctx context.Context, orgID, userID string) error

+ func (s *Store) DeleteOrganization(ctx context.Context, id string) error

+ func (s *Store) DeleteRows(ctx context.Context, table, column string, value any) (int, error)

+ func (s *Store) DeleteTeam(ctx context.Context, id string) error

+ func (s *Store) InvitationByID(ctx context.Context, id string) (*store.Invitation, error)

+ func (s *Store) InvitationByTokenHash(ctx context.Context, tokenHash string) (*store.Invitation, error)

+ func (s *Store) ListCustomRoles(ctx context.Context, orgID string) ([]store.CustomRole, error)

+ func (s *Store) ListInvitations(ctx context.Context, f store.InvitationFilter) ([]store.Invitation, string, error)

+ func (s *Store) ListMembers(ctx context.Context, f store.MemberFilter) ([]store.Membership, string, error)

+ func (s *Store) ListOrganizations(ctx context.Context, f store.OrganizationFilter) ([]store.Organization, string, error)

+ func (s *Store) ListTeamMembers(ctx context.Context, teamID string) ([]string, error)

+ func (s *Store) ListTeams(ctx context.Context, orgID string) ([]store.Team, error)

+ func (s *Store) LockActiveMembersWithRole(ctx context.Context, orgID, role string) ([]string, error)

+ func (s *Store) MembershipOf(ctx context.Context, orgID, userID string) (*store.Membership, error)

+ func (s *Store) MembershipsOfUser(ctx context.Context, userID string) ([]store.Membership, error)

+ func (s *Store) OrganizationByID(ctx context.Context, id string) (*store.Organization, error)

+ func (s *Store) OrganizationBySlug(ctx context.Context, slug string) (*store.Organization, error)

+ func (s *Store) RemoveTeamMember(ctx context.Context, teamID, userID string) error

+ func (s *Store) SessionWithUserAndMembership(ctx context.Context, tokenHash string) (*store.Session, *store.User, *store.Organization, *store.Membership, error)

+ func (s *Store) SetActiveOrganization(ctx context.Context, sessionID, orgID string) error

+ func (s *Store) SetInvitationStatus(ctx context.Context, id, from, to string) error

+ func (s *Store) TeamByID(ctx context.Context, id string) (*store.Team, error)

+ func (s *Store) TeamsOfUser(ctx context.Context, orgID, userID string) ([]store.Team, error)

+ func (s *Store) UpdateMembership(ctx context.Context, m *store.Membership) error

+ func (s *Store) UpdateOrganization(ctx context.Context, o *store.Organization) error

v0.3.0

Sep 10, 2026

Changes in this version

type Store

+ func (s *Store) APIKeyByHash(ctx context.Context, keyHash string) (*store.APIKey, *store.User, error)

+ func (s *Store) APIKeyByID(ctx context.Context, id string) (*store.APIKey, error)

+ func (s *Store) CleanupRateLimits(ctx context.Context, before time.Time) (int, error)

+ func (s *Store) CountAttempt(ctx context.Context, key string, window time.Duration, now time.Time) (int, time.Time, error)

+ func (s *Store) CreateAPIKey(ctx context.Context, k *store.APIKey) error

+ func (s *Store) DeleteSessionsExcept(ctx context.Context, sessionID string) (int, error)

+ func (s *Store) InsertRow(ctx context.Context, table string, columns []string, values []any) error

+ func (s *Store) ListAPIKeys(ctx context.Context, userID string) ([]store.APIKey, error)

+ func (s *Store) ListUsers(ctx context.Context, f store.UserListFilter) ([]store.User, string, error)

+ func (s *Store) LockEnabledUsersWithRole(ctx context.Context, role string) ([]string, error)

+ func (s *Store) RevokeAPIKey(ctx context.Context, id, byUserID string, at time.Time) error

+ func (s *Store) SessionWithUser(ctx context.Context, tokenHash string) (*store.Session, *store.User, error)

+ func (s *Store) TableColumns(ctx context.Context, table string) ([]string, bool, error)

+ func (s *Store) TouchAPIKey(ctx context.Context, id string, at time.Time) error

+ func (s *Store) UseSchema(o schema.Options) error

v0.2.0

Sep 2, 2026

Changes in this version

type Store

+ func (s *Store) RecoveryCodes() store.RecoveryCodeStore

+ func (s *Store) TOTP() store.TOTPStore

v0.1.0

Aug 24, 2026

Changes in this version

+ const SQLiteTimeLayout

+ type Dialect struct

+ IsUniqueViolation func(err error) bool

+ Name schema.Dialect

+ NumberedPlaceholders bool

+ TextTime bool

+ type Store struct

+ func New(db *sql.DB, d Dialect) *Store

+ func (s *Store) Accounts() store.AccountStore

+ func (s *Store) Close() error

+ func (s *Store) DB() *sql.DB

+ func (s *Store) Migrator() store.Migrator

+ func (s *Store) OAuthStates() store.OAuthStateStore

+ func (s *Store) Sessions() store.SessionStore

+ func (s *Store) Tokens() store.TokenStore

+ func (s *Store) Transaction(ctx context.Context, fn func(store.Store) error) error

+ func (s *Store) Users() store.UserStore

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