import { Database } from "sqlite";
import { Connection } from "../../sqlite/connection.js";
export type JobStatus = "queued" | "running" | "paused" | "completed" | "failed" | "cancelled" | "partial";
export type CommandStatus = "running" | "succeeded" | "failed" | "cancelled";
export type TaskRunStatus = "queued" | "running" | "succeeded" | "failed" | "cancelled";
export interface ProjectRow {
    id: string;
    key: string;
    name?: string;
    description?: string;
    metadata?: Record<string, unknown>;
    createdAt: string;
    updatedAt: string;
}
export interface EpicInsert {
    projectId: string;
    key: string;
    title: string;
    description: string;
    storyPointsTotal?: number | null;
    priority?: number | null;
    metadata?: Record<string, unknown>;
}
export interface EpicRow extends EpicInsert {
    id: string;
    createdAt: string;
    updatedAt: string;
}
export interface StoryInsert {
    projectId: string;
    epicId: string;
    key: string;
    title: string;
    description: string;
    acceptanceCriteria?: string | null;
    storyPointsTotal?: number | null;
    priority?: number | null;
    metadata?: Record<string, unknown>;
}
export interface StoryRow extends StoryInsert {
    id: string;
    createdAt: string;
    updatedAt: string;
}
export interface TaskInsert {
    projectId: string;
    epicId: string;
    userStoryId: string;
    key: string;
    title: string;
    description: string;
    type?: string | null;
    status: string;
    storyPoints?: number | null;
    priority?: number | null;
    assignedAgentId?: string | null;
    assigneeHuman?: string | null;
    vcsBranch?: string | null;
    vcsBaseBranch?: string | null;
    vcsLastCommitSha?: string | null;
    metadata?: Record<string, unknown>;
    openapiVersionAtCreation?: string | null;
}
export interface TaskRow extends TaskInsert {
    id: string;
    createdAt: string;
    updatedAt: string;
}
export interface ProjectBacklogSummary {
    taskCount: number;
    nonNotStartedTaskCount: number;
    taskRunCount: number;
    taskQaRunCount: number;
    taskCommentCount: number;
    taskReviewCount: number;
    taskRevisionCount: number;
    taskLogCount: number;
}
export interface TaskDependencyInsert {
    taskId: string;
    dependsOnTaskId: string;
    relationType: string;
}
export interface TaskDependencyRow extends TaskDependencyInsert {
    id: string;
    createdAt: string;
    updatedAt: string;
}
export interface JobInsert {
    workspaceId: string;
    type: string;
    state: JobStatus;
    commandName?: string;
    payload?: Record<string, unknown>;
    totalItems?: number | null;
    processedItems?: number | null;
    lastCheckpoint?: string | null;
    agentId?: string | null;
    agentIds?: string[] | null;
}
export interface JobRow extends JobInsert {
    id: string;
    createdAt: string;
    updatedAt: string;
    completedAt?: string | null;
    errorSummary?: string | null;
}
export interface CommandRunInsert {
    workspaceId: string;
    commandName: string;
    jobId?: string | null;
    agentId?: string | null;
    taskIds?: string[];
    gitBranch?: string | null;
    gitBaseBranch?: string | null;
    startedAt: string;
    status: CommandStatus;
    spProcessed?: number | null;
}
export interface CommandRunRow extends CommandRunInsert {
    id: string;
    completedAt?: string | null;
    errorSummary?: string | null;
    durationSeconds?: number | null;
}
export interface TaskRunInsert {
    taskId: string;
    command: string;
    status: TaskRunStatus;
    jobId?: string | null;
    commandRunId?: string | null;
    agentId?: string | null;
    startedAt: string;
    finishedAt?: string | null;
    storyPointsAtRun?: number | null;
    spPerHourEffective?: number | null;
    gitBranch?: string | null;
    gitBaseBranch?: string | null;
    gitCommitSha?: string | null;
    runContext?: Record<string, unknown>;
}
export interface TaskRunRow extends TaskRunInsert {
    id: string;
}
export interface TaskStatusEventInsert {
    taskId: string;
    fromStatus?: string | null;
    toStatus: string;
    timestamp: string;
    commandName?: string | null;
    jobId?: string | null;
    taskRunId?: string | null;
    agentId?: string | null;
    metadata?: Record<string, unknown> | null;
}
export interface TaskLockRow {
    taskId: string;
    taskRunId: string;
    jobId?: string;
    acquiredAt: string;
    expiresAt: string;
}
export interface TaskQaRunInsert {
    taskId: string;
    taskRunId?: string | null;
    jobId?: string | null;
    commandRunId?: string | null;
    agentId?: string | null;
    modelName?: string | null;
    source: string;
    mode?: string | null;
    profileName?: string | null;
    runner?: string | null;
    rawOutcome?: string | null;
    recommendation?: string | null;
    evidenceUrl?: string | null;
    artifacts?: string[] | null;
    rawResult?: Record<string, unknown> | null;
    startedAt?: string | null;
    finishedAt?: string | null;
    metadata?: Record<string, unknown> | null;
    createdAt?: string;
}
export interface TaskQaRunRow extends TaskQaRunInsert {
    id: string;
}
export interface TokenUsageInsert {
    workspaceId: string;
    agentId?: string | null;
    modelName?: string | null;
    jobId?: string | null;
    commandRunId?: string | null;
    taskRunId?: string | null;
    taskId?: string | null;
    projectId?: string | null;
    epicId?: string | null;
    userStoryId?: string | null;
    commandName?: string | null;
    action?: string | null;
    invocationKind?: string | null;
    provider?: string | null;
    currency?: string | null;
    tokensPrompt?: number | null;
    tokensCompletion?: number | null;
    tokensTotal?: number | null;
    tokensCached?: number | null;
    tokensCacheRead?: number | null;
    tokensCacheWrite?: number | null;
    costEstimate?: number | null;
    durationSeconds?: number | null;
    durationMs?: number | null;
    startedAt?: string | null;
    finishedAt?: string | null;
    timestamp: string;
    metadata?: Record<string, unknown>;
}
export interface TaskRevisionInsert {
    taskId: string;
    jobId?: string | null;
    commandRunId?: string | null;
    snapshotBefore?: Record<string, unknown> | null;
    snapshotAfter?: Record<string, unknown> | null;
    createdAt: string;
}
export interface TaskCommentInsert {
    taskId: string;
    taskRunId?: string | null;
    jobId?: string | null;
    sourceCommand: string;
    authorType: "agent" | "human";
    authorAgentId?: string | null;
    category?: string | null;
    slug?: string | null;
    status?: string | null;
    file?: string | null;
    line?: number | null;
    pathHint?: string | null;
    body: string;
    metadata?: Record<string, unknown> | null;
    createdAt: string;
    resolvedAt?: string | null;
    resolvedBy?: string | null;
}
export interface TaskCommentRow extends TaskCommentInsert {
    id: string;
}
export interface TaskReviewInsert {
    taskId: string;
    jobId?: string | null;
    agentId?: string | null;
    modelName?: string | null;
    decision: string;
    summary?: string | null;
    findingsJson?: Record<string, unknown> | unknown[] | null;
    testRecommendationsJson?: string[] | null;
    metadata?: Record<string, unknown> | null;
    createdAt: string;
    createdBy?: string | null;
}
export interface TaskReviewRow extends TaskReviewInsert {
    id: string;
}
export declare class WorkspaceRepository {
    private db;
    private connection?;
    private static txLocks;
    private workspaceKey;
    constructor(db: Database, connection?: Connection | undefined);
    static create(cwd?: string): Promise<WorkspaceRepository>;
    close(): Promise<void>;
    getDb(): Database;
    private serialize;
    withTransaction<T>(fn: () => Promise<T>): Promise<T>;
    getProjectByKey(key: string): Promise<ProjectRow | undefined>;
    getProjectById(id: string): Promise<ProjectRow | undefined>;
    createProjectIfMissing(input: {
        key: string;
        name?: string;
        description?: string;
    }): Promise<ProjectRow>;
    insertEpics(epics: EpicInsert[], useTransaction?: boolean): Promise<EpicRow[]>;
    insertStories(stories: StoryInsert[], useTransaction?: boolean): Promise<StoryRow[]>;
    insertTasks(tasks: TaskInsert[], useTransaction?: boolean): Promise<TaskRow[]>;
    updateStoryPointsTotal(storyId: string, total: number | null): Promise<void>;
    updateEpicStoryPointsTotal(epicId: string, total: number | null): Promise<void>;
    insertTaskDependencies(deps: TaskDependencyInsert[], useTransaction?: boolean): Promise<TaskDependencyRow[]>;
    deleteTaskDependenciesForTask(taskId: string): Promise<void>;
    deleteProjectBacklog(projectId: string, useTransaction?: boolean): Promise<void>;
    updateTask(taskId: string, updates: {
        title?: string;
        description?: string | null;
        type?: string | null;
        status?: string;
        storyPoints?: number | null;
        priority?: number | null;
        metadata?: Record<string, unknown> | null;
        assignedAgentId?: string | null;
        assigneeHuman?: string | null;
        vcsBranch?: string | null;
        vcsBaseBranch?: string | null;
        vcsLastCommitSha?: string | null;
    }): Promise<void>;
    recordTaskStatusEvent(entry: TaskStatusEventInsert): Promise<void>;
    getTaskById(taskId: string): Promise<TaskRow | undefined>;
    getTaskByKey(taskKey: string): Promise<TaskRow | undefined>;
    listTasksByMetadataValue(projectId: string, metadataKey: string, metadataValue: string): Promise<TaskRow[]>;
    getTasksByIds(taskIds: string[]): Promise<TaskRow[]>;
    listEpicKeys(projectId: string): Promise<string[]>;
    listStoryKeys(epicId: string): Promise<string[]>;
    listTaskKeys(userStoryId: string): Promise<string[]>;
    getProjectBacklogSummary(projectId: string): Promise<ProjectBacklogSummary>;
    createJob(record: JobInsert): Promise<JobRow>;
    listJobs(): Promise<JobRow[]>;
    getJob(id: string): Promise<JobRow | undefined>;
    updateJobState(id: string, update: Partial<JobInsert> & {
        state?: JobStatus;
        errorSummary?: string | null;
        completedAt?: string | null;
    }): Promise<void>;
    createCommandRun(record: CommandRunInsert): Promise<CommandRunRow>;
    setCommandRunJobId(id: string, jobId: string): Promise<void>;
    setCommandRunAgentId(id: string, agentId: string): Promise<void>;
    setJobAgentIds(id: string, agentId: string): Promise<void>;
    completeCommandRun(id: string, update: {
        status: CommandStatus;
        completedAt: string;
        errorSummary?: string | null;
        durationSeconds?: number | null;
        spProcessed?: number | null;
    }): Promise<void>;
    getTasksWithRelations(taskIds: string[]): Promise<Array<TaskRow & {
        epicKey: string;
        storyKey: string;
        epicTitle?: string;
        epicDescription?: string;
        storyTitle?: string;
        storyDescription?: string;
        acceptanceCriteria?: string[];
    }>>;
    createTaskRun(record: TaskRunInsert): Promise<TaskRunRow>;
    getTaskLock(taskId: string): Promise<TaskLockRow | undefined>;
    cleanupExpiredTaskLocks(nowIso?: string): Promise<string[]>;
    releaseTaskLocksByJob(jobId: string): Promise<string[]>;
    tryAcquireTaskLock(taskId: string, taskRunId: string, jobId?: string | null, ttlSeconds?: number): Promise<{
        acquired: boolean;
        lock?: TaskLockRow;
    }>;
    releaseTaskLock(taskId: string, taskRunId: string): Promise<void>;
    refreshTaskLock(taskId: string, taskRunId: string, ttlSeconds?: number): Promise<boolean>;
    createTaskQaRun(record: TaskQaRunInsert): Promise<TaskQaRunRow>;
    listTaskQaRuns(taskId: string): Promise<TaskQaRunRow[]>;
    listTaskQaRunsForJob(taskIds: string[], jobId: string): Promise<TaskQaRunRow[]>;
    insertTaskLog(entry: {
        taskRunId: string;
        sequence: number;
        timestamp: string;
        level?: string | null;
        source?: string | null;
        message?: string | null;
        details?: Record<string, unknown> | null;
    }): Promise<void>;
    updateTaskRun(id: string, update: {
        status?: TaskRunStatus;
        finishedAt?: string | null;
        gitBranch?: string | null;
        gitBaseBranch?: string | null;
        gitCommitSha?: string | null;
        storyPointsAtRun?: number | null;
        spPerHourEffective?: number | null;
        runContext?: Record<string, unknown> | null;
    }): Promise<void>;
    getTaskDependencies(taskIds: string[]): Promise<TaskDependencyRow[]>;
    createTaskComment(record: TaskCommentInsert): Promise<TaskCommentRow>;
    listTaskComments(taskId: string, options?: {
        sourceCommands?: string[];
        limit?: number;
        slug?: string | string[];
        resolved?: boolean;
    }): Promise<TaskCommentRow[]>;
    resolveTaskComment(params: {
        taskId: string;
        slug: string;
        resolvedAt: string;
        resolvedBy?: string | null;
    }): Promise<void>;
    reopenTaskComment(params: {
        taskId: string;
        slug: string;
    }): Promise<void>;
    createTaskReview(record: TaskReviewInsert): Promise<TaskReviewRow>;
    getLatestTaskReview(taskId: string): Promise<TaskReviewRow | undefined>;
    recordTokenUsage(entry: TokenUsageInsert): Promise<void>;
    insertTaskRevision(record: TaskRevisionInsert): Promise<void>;
    getEpicByKey(projectId: string, key: string): Promise<EpicRow | undefined>;
    getStoryByKey(epicId: string, key: string): Promise<StoryRow | undefined>;
    getStoryByProjectAndKey(projectId: string, key: string): Promise<StoryRow | undefined>;
}
//# sourceMappingURL=WorkspaceRepository.d.ts.map