import type { ProjectMember } from '@owox/idp-protocol';
import type { DatabaseAccount, DatabaseOperationResult, DatabaseUser, OnboardingAnswer } from '../types/index.js';
import { type AuthFlowParams } from '../utils/request-utils.js';
import type { DatabaseStore } from './database-store.js';
import { StoreResult } from './store-result.js';
export interface MysqlConnectionConfig {
    host: string;
    user: string;
    password: string;
    database: string;
    port?: number;
    ssl?: unknown;
}
/**
 * MySQL-backed DatabaseStore implementation.
 */
export declare class MysqlDatabaseStore implements DatabaseStore {
    private readonly config;
    private pool?;
    private readonly logger;
    private authTableReady;
    private projectTablesReady;
    private onboardingTableReady;
    private userProjectOnboardingTableReady;
    constructor(config: MysqlConnectionConfig);
    private getPool;
    private toIso;
    private toBoolean;
    private mapUser;
    private mapAccount;
    initialize(): Promise<void>;
    isHealthy(): Promise<boolean>;
    cleanupExpiredSessions(): Promise<DatabaseOperationResult>;
    getUserById(userId: string): Promise<DatabaseUser | null>;
    getUserByBiUserId(biUserId: string): Promise<DatabaseUser | null>;
    getUserByEmail(email: string): Promise<DatabaseUser | null>;
    getAccountByUserId(userId: string): Promise<DatabaseAccount | null>;
    getAccountsByUserId(userId: string): Promise<DatabaseAccount[]>;
    getAccountByUserIdAndProvider(userId: string, providerId: string): Promise<DatabaseAccount | null>;
    updateUserLastLoginMethod(userId: string, loginMethod: string): Promise<void>;
    updateUserFirstLoginMethod(userId: string, loginMethod: string): Promise<void>;
    updateUserBiUserId(userId: string, biUserId: string): Promise<void>;
    saveAuthState(state: string, codeVerifier: string, expiresAt?: Date | null, authFlowParams?: AuthFlowParams): Promise<void>;
    getAuthState(state: string): Promise<StoreResult>;
    deleteAuthState(state: string): Promise<void>;
    purgeExpiredAuthStates(): Promise<number>;
    /**
     * Escapes special LIKE pattern characters (%, _, \) to prevent SQL injection.
     */
    private escapeLikePattern;
    shutdown(): Promise<void>;
    getAdapter(): Promise<unknown>;
    private ensureAuthStatesTable;
    findActiveMagicLink(email: string): Promise<{
        id: string;
        createdAt?: Date | null;
        expiresAt?: Date | null;
    } | null>;
    private ensureProjectTables;
    saveProjectMembers(projectId: string, members: ProjectMember[], ttlSeconds: number): Promise<void>;
    getProjectMembers(projectId: string): Promise<ProjectMember[] | null>;
    getProjectSyncInfo(projectId: string): Promise<{
        expiresAt: Date | null;
        updatedAt: Date | null;
    } | null>;
    private ensureOnboardingTable;
    saveOnboardingAnswers(answers: OnboardingAnswer[]): Promise<void>;
    hasOnboardingAnswers(userId: string, projectId: string): Promise<boolean>;
    getOnboardingAnswers(userId: string, projectId: string): Promise<OnboardingAnswer[]>;
    private ensureUserProjectOnboardingTable;
    getUserProjectOnboardingStatus(biUserId: string, projectId: string): Promise<string | null>;
    setUserProjectOnboardingStatus(biUserId: string, projectId: string, status: string): Promise<void>;
}
//# sourceMappingURL=mysql-database-store.d.ts.map