postgres

func (*Store) Close ¶

func (s *Store) Close()

Close releases all pooled connections.

func (*Store) CompleteAuthorizationConfirmation ¶ added in v0.7.0

func (s *Store) CompleteAuthorizationConfirmation(ctx context.Context, tokenHash []byte, approve bool, code string) (*store.AuthorizationConfirmationResult, error)

CompleteAuthorizationConfirmation consumes a confirmation and, on approval, creates an auth code atomically.

func (*Store) ConsumeAuthCode ¶

func (s *Store) ConsumeAuthCode(ctx context.Context, code string) (*store.AuthCode, error)

ConsumeAuthCode atomically deletes and returns the auth code record. Returns ErrNotFound for unknown or expired codes.

func (*Store) ConsumePendingAuth ¶

func (s *Store) ConsumePendingAuth(ctx context.Context, state string) (*store.PendingAuth, error)

ConsumePendingAuth atomically deletes and returns the pending auth for the given state. Returns ErrNotFound for unknown or expired states.

func (*Store) CreateWebSession ¶ added in v0.6.0

func (s *Store) CreateWebSession(ctx context.Context, session store.WebSession) (*store.WebSession, error)

func (*Store) DeleteGrant ¶

func (s *Store) DeleteGrant(ctx context.Context, jti string, retired *store.RetiredRefreshToken) error

DeleteGrant removes a grant row by jti.

func (*Store) DeleteInsight ¶ added in v0.4.0

func (s *Store) DeleteInsight(ctx context.Context, p store.DeleteInsightParams) (int, error)

DeleteInsight soft-deletes an insight and returns its resulting revision.

func (*Store) EnsureProject ¶

func (s *Store) EnsureProject(ctx context.Context, orgID, createdBy uuid.UUID, slug, name string) (*store.Project, error)

EnsureProject creates the project if it does not exist and returns it. If it already exists the name is updated to match the provided value.

func (*Store) GetClient ¶

func (s *Store) GetClient(ctx context.Context, clientID string) (*store.OAuthClient, error)

SaveClient persists a new OAuth2 client registration.

func (*Store) GetGrant ¶

func (s *Store) GetGrant(ctx context.Context, jti string) (*store.Grant, error)

GetGrant fetches and decrypts a grant by JWT ID.

func (*Store) GetGrantByRefreshToken ¶

func (s *Store) GetGrantByRefreshToken(ctx context.Context, token string) (*store.Grant, error)

GetGrantByRefreshToken fetches and decrypts a grant by our_refresh_token.

func (*Store) GetInsight ¶ added in v0.6.0

func (s *Store) GetInsight(ctx context.Context, p store.GetInsightParams) (*store.InsightDetail, error)

GetInsight returns one live insight and its immediate project-local relationships.

func (*Store) GetPersonalOrgByUserID ¶

func (s *Store) GetPersonalOrgByUserID(ctx context.Context, userID uuid.UUID) (*store.Org, error)

GetPersonalOrgByUserID returns the personal org for the given user. Returns ErrNotFound if the user has no personal org.

func (*Store) GetProjectBySlug ¶

func (s *Store) GetProjectBySlug(ctx context.Context, orgID uuid.UUID, slug string) (*store.Project, error)

GetProjectBySlug fetches a project by org and slug. Returns ErrNotFound if no matching row exists.

func (*Store) GetProjectDashboard ¶ added in v0.6.0

func (s *Store) GetProjectDashboard(ctx context.Context, projectID uuid.UUID) (*store.ProjectDashboard, error)

GetProjectDashboard returns aggregate read models for the project dashboard.

func (*Store) GetRetiredRefreshToken ¶ added in v0.4.0

func (s *Store) GetRetiredRefreshToken(ctx context.Context, tokenHash []byte) (*store.RetiredRefreshToken, error)

GetRetiredRefreshToken returns retained metadata for a consumed or deleted refresh token.

func (*Store) GetUserByGitHubID ¶

func (s *Store) GetUserByGitHubID(ctx context.Context, githubID int64) (*store.User, error)

GetUserByGitHubID looks up a user by GitHub numeric ID. Returns ErrNotFound if no matching row exists.

func (*Store) GetUserByID ¶

func (s *Store) GetUserByID(ctx context.Context, id uuid.UUID) (*store.User, error)

GetUserByID looks up a user by internal UUID. Returns ErrNotFound if no matching row exists.

func (*Store) GetWebSessionByTokenHash ¶ added in v0.6.0

func (s *Store) GetWebSessionByTokenHash(ctx context.Context, tokenHash []byte) (*store.WebSession, error)

func (*Store) IsTokenRevoked ¶

func (s *Store) IsTokenRevoked(ctx context.Context, jti string) (bool, error)

IsTokenRevoked returns true if the jti is present and not yet expired.

func (*Store) ListAuditLog ¶ added in v0.3.0

func (s *Store) ListAuditLog(ctx context.Context, filter store.AuditLogFilter) ([]*store.AuditLogEntry, error)

ListAuditLog returns audit_log entries newest-first, with optional filtering by table, operation, and a minimum timestamp.

func (*Store) ListInsightHistory ¶ added in v0.6.0

func (s *Store) ListInsightHistory(ctx context.Context, p store.ListInsightHistoryParams) (*store.InsightHistoryPage, error)

func (*Store) ListInsights ¶ added in v0.4.0

func (s *Store) ListInsights(ctx context.Context, p store.ListInsightsParams) (*store.InsightPage, error)

func (*Store) ListOrgs ¶ added in v0.6.0

func (s *Store) ListOrgs(ctx context.Context) ([]*store.Org, error)

ListOrgs returns every org, ordered by kind then name.

func (*Store) ListProjects ¶

func (s *Store) ListProjects(ctx context.Context, orgID uuid.UUID) ([]*store.Project, error)

ListProjects returns all projects in the org, ordered by name.

func (*Store) ListTags ¶

func (s *Store) ListTags(ctx context.Context, projectID uuid.UUID, limit int) ([]store.TagCount, error)

ListTags returns tags for a project ordered by usage frequency.

func (*Store) Migrate ¶

func (s *Store) Migrate(ctx context.Context, logger *slog.Logger) error

Migrate runs all pending SQL migrations under an advisory lock.

func (*Store) Ping ¶

func (s *Store) Ping(ctx context.Context) error

Ping verifies the database connection is alive.

func (*Store) RestoreInsight ¶ added in v0.6.0

func (s *Store) RestoreInsight(ctx context.Context, p store.RestoreInsightParams) (*store.Insight, error)

func (*Store) RevokeToken ¶

func (s *Store) RevokeToken(ctx context.Context, jti string, expiresAt time.Time) error

RevokeToken inserts a jti into the revoked_tokens table. Idempotent on duplicate jti. Lazily prunes expired rows.

func (*Store) RevokeWebSessionByTokenHash ¶ added in v0.6.0

func (s *Store) RevokeWebSessionByTokenHash(ctx context.Context, tokenHash []byte) error

func (*Store) RotateGrant ¶

func (s *Store) RotateGrant(ctx context.Context, oldToken, oldJTI string, oldJWTExpiry time.Time, g store.Grant, retired *store.RetiredRefreshToken) (*store.Grant, error)

RotateGrant atomically replaces a grant row identified by oldToken and records the old jti as revoked in the same transaction. Returns ErrNotFound if oldToken does not match any row (concurrent rotation race).

func (*Store) SaveClient ¶

func (s *Store) SaveClient(ctx context.Context, c store.OAuthClient) error

func (*Store) SearchInsights ¶ added in v0.4.0

func (s *Store) SearchInsights(ctx context.Context, p store.SearchInsightsParams) (*store.InsightSearchPage, error)

SearchInsights runs a full-text search over live insights in a project.

func (*Store) StoreAuthCode ¶

func (s *Store) StoreAuthCode(ctx context.Context, code string, c store.AuthCode) error

StoreAuthCode persists an authorization code with a 5-minute TTL. Lazily prunes all expired rows in the same transaction.

func (*Store) StoreAuthorizationConfirmation ¶ added in v0.7.0

func (s *Store) StoreAuthorizationConfirmation(ctx context.Context, tokenHash []byte, c store.AuthorizationConfirmation) error

StoreAuthorizationConfirmation persists a post-GitHub confirmation with a 10-minute TTL.

func (*Store) StorePendingAuth ¶

func (s *Store) StorePendingAuth(ctx context.Context, state string, p store.PendingAuth) error

StorePendingAuth persists an authorization state with a 10-minute TTL. Lazily prunes all expired rows in the same transaction.

func (*Store) TouchClient ¶ added in v0.6.0

func (s *Store) TouchClient(ctx context.Context, clientID string) error

TouchClient records recent use without writing more than once per day.

func (*Store) TouchWebSession ¶ added in v0.6.0

func (s *Store) TouchWebSession(ctx context.Context, id uuid.UUID, lastSeenAt, idleExpiresAt time.Time) error

func (*Store) UpdateInsight ¶ added in v0.4.0

func (s *Store) UpdateInsight(ctx context.Context, p store.UpdateInsightParams) (*store.Insight, error)

UpdateInsight patches content and/or tags on an existing live insight, scoped to orgID.

func (*Store) UpsertClient ¶ added in v0.6.0

func (s *Store) UpsertClient(ctx context.Context, c store.OAuthClient) error

UpsertClient refreshes first-party metadata without changing recorded activity.

func (*Store) UpsertGrant ¶

func (s *Store) UpsertGrant(ctx context.Context, g store.Grant) error

UpsertGrant inserts or replaces a grant row and lazily prunes expired grants for the same GitHub user within the same transaction.

func (*Store) UpsertUser ¶

func (s *Store) UpsertUser(ctx context.Context, profile store.GitHubProfile) (*store.User, error)

UpsertUser creates or updates a user from GitHub identity. On first login a personal org is created and the user is added as owner. Returns the user row.

func (*Store) WriteInsight ¶ added in v0.4.0

func (s *Store) WriteInsight(ctx context.Context, p store.WriteInsightParams) (*store.Insight, error)

WriteInsight creates or updates an insight. If Key is set and a live insight with that key exists in the project it is updated in place; otherwise a new row is inserted.