import type { Database } from "bun:sqlite";
import type { ApiPrincipal } from "./types.js";
import type { SkillProfile, SkillSelection, StationSkillState, StationSkillStateInput } from "../types/skill-selection.js";
export interface SkillSelectionStore {
    profilesReferencingSkill(principal: ApiPrincipal, slug: string): Promise<string[]>;
    getProfile(principal: ApiPrincipal, id: string): Promise<SkillProfile | null>;
    /** null expected revision means create-only; null result means CAS conflict. */
    saveProfile(principal: ApiPrincipal, id: string, selections: SkillSelection[], expected: string | null): Promise<SkillProfile | null>;
    getStationState(principal: ApiPrincipal, id: string): Promise<StationSkillState | null>;
    /** Refuses an obsolete profile revision atomically with storing the receipt. */
    saveStationState(principal: ApiPrincipal, id: string, input: StationSkillStateInput): Promise<StationSkillState | null>;
}
type Row = Record<string, unknown>;
export declare class MemorySkillSelectionStore implements SkillSelectionStore {
    private profiles;
    private states;
    private key;
    getProfile(p: ApiPrincipal, id: string): Promise<SkillProfile | null>;
    profilesReferencingSkill(p: ApiPrincipal, slug: string): Promise<string[]>;
    saveProfile(p: ApiPrincipal, id: string, selected: SkillSelection[], expected: string | null): Promise<SkillProfile | null>;
    getStationState(p: ApiPrincipal, id: string): Promise<StationSkillState | null>;
    saveStationState(p: ApiPrincipal, id: string, input: StationSkillStateInput): Promise<StationSkillState | null>;
}
export declare class SqliteSkillSelectionStore implements SkillSelectionStore {
    private db;
    constructor(db: Database);
    profilesReferencingSkill(p: ApiPrincipal, slug: string): Promise<string[]>;
    getProfile(p: ApiPrincipal, id: string): Promise<SkillProfile | null>;
    saveProfile(p: ApiPrincipal, id: string, selected: SkillSelection[], expected: string | null): Promise<SkillProfile | null>;
    getStationState(p: ApiPrincipal, id: string): Promise<StationSkillState | null>;
    saveStationState(p: ApiPrincipal, id: string, input: StationSkillStateInput): Promise<StationSkillState | null>;
}
type Sql = (strings: TemplateStringsArray, ...values: unknown[]) => Promise<Row[]>;
type SqlTransaction = Sql;
interface SqlWithTransaction extends Sql {
    begin<T>(fn: (tx: SqlTransaction) => Promise<T>): Promise<T>;
}
export declare class PostgresSkillSelectionStore implements SkillSelectionStore {
    private sql;
    constructor(sql: SqlWithTransaction);
    profilesReferencingSkill(p: ApiPrincipal, slug: string): Promise<string[]>;
    getProfile(p: ApiPrincipal, id: string): Promise<SkillProfile | null>;
    saveProfile(p: ApiPrincipal, id: string, selected: SkillSelection[], expected: string | null): Promise<SkillProfile | null>;
    getStationState(p: ApiPrincipal, id: string): Promise<StationSkillState | null>;
    saveStationState(p: ApiPrincipal, id: string, input: StationSkillStateInput): Promise<StationSkillState | null>;
}
export {};