import type { D1Database } from '@cloudflare/workers-types';
import { Storage } from '.';
import { CrowdinCredentials } from '../types';
import { IntegrationConfig, IntegrationCredentials, IntegrationFilesSnapshot, IntegrationSyncSettings, IntegrationWebhooks } from '../modules/integration/types';
import { CreateJobParams, GetActiveJobsParams, GetJobParams, GetFileTranslationCacheByLanguageParams, Job, TranslationCache, UpdateJobParams, UpdateTranslationCacheParams, GetFileTranslationCache, UnsyncedFiles, GetUnsyncedFiles, IntegrationSyncedData, GetAllJobsParams } from '../modules/integration/util/types';
import { UserErrors } from './types';
export interface D1StorageConfig {
    /**
     * Cloudflare D1 database binding
     * This should be passed from env.DB in Workers/Pages Functions
     */
    database: D1Database;
}
export declare class D1Storage implements Storage {
    private db;
    private migrated;
    tables: {
        crowdin_credentials: string;
        integration_credentials: string;
        sync_settings: string;
        app_metadata: string;
        files_snapshot: string;
        webhooks: string;
        user_errors: string;
        integration_settings: string;
        job: string;
        translation_file_cache: string;
        unsynced_files: string;
        synced_data: string;
    };
    constructor(config: D1StorageConfig);
    ensureMigrated(): Promise<void>;
    private addColumn;
    private updateTables;
    migrate(skipOnboarding?: boolean): Promise<void>;
    saveCrowdinCredentials(credentials: CrowdinCredentials): Promise<void>;
    updateCrowdinCredentials(credentials: CrowdinCredentials): Promise<void>;
    getCrowdinCredentials(id: string): Promise<CrowdinCredentials | undefined>;
    getAllCrowdinCredentials(): Promise<CrowdinCredentials[]>;
    deleteCrowdinCredentials(id: string): Promise<void>;
    saveIntegrationCredentials(id: string, credentials: any, crowdinId: string): Promise<void>;
    updateIntegrationCredentials(id: string, credentials: any): Promise<void>;
    updateIntegrationManagers(id: string, managers: any): Promise<void>;
    getIntegrationCredentials(id: string): Promise<IntegrationCredentials | undefined>;
    getAllIntegrationCredentials(crowdinId: string): Promise<IntegrationCredentials[]>;
    deleteIntegrationCredentials(id: string): Promise<void>;
    deleteAllIntegrationCredentials(crowdinId: string): Promise<void>;
    saveMetadata(id: string, metadata: any, crowdinId: string): Promise<void>;
    updateMetadata(id: string, metadata: any, crowdinId: string): Promise<void>;
    getMetadata(id: string): Promise<any>;
    getAllMetadata(): Promise<any[]>;
    deleteMetadata(id: string): Promise<void>;
    getSyncSettingsByProvider(integrationId: string, provider: string): Promise<IntegrationSyncSettings | undefined>;
    getSyncSettingsBySchedule(type: string, schedule: string): Promise<IntegrationSyncSettings[]>;
    saveSyncSettings(files: any, integrationId: string, crowdinId: string, type: string, provider: string): Promise<void>;
    updateSyncSettings(files: any, integrationId: string, crowdinId: string, type: string, provider: string): Promise<void>;
    getSyncSettings(integrationId: string, crowdinId: string, type: string, provider: string): Promise<IntegrationSyncSettings | undefined>;
    saveFilesSnapshot(files: any, integrationId: string, crowdinId: string, provider: string): Promise<void>;
    updateFilesSnapshot(files: any, integrationId: string, crowdinId: string, provider: string): Promise<void>;
    getFilesSnapshot(integrationId: string, crowdinId: string, provider: string): Promise<IntegrationFilesSnapshot | undefined>;
    getAllWebhooks(integrationId: string, crowdinId: string, provider: string): Promise<IntegrationWebhooks[] | undefined>;
    getWebhooks(fileId: string, integrationId: string, crowdinId: string, provider: string): Promise<IntegrationWebhooks | undefined>;
    saveWebhooks(fileId: string, integrationId: string, crowdinId: string, provider: string): Promise<void>;
    deleteWebhooks(fileIds: any[], integrationId: string, crowdinId: string, provider: string): Promise<void>;
    getAllUserErrors(crowdinId: string, integrationId?: string): Promise<UserErrors[] | undefined>;
    saveUserError(action: string, message: string, data: any, createdAt: string, crowdinId: string, integrationId?: string): Promise<void>;
    deleteUserErrors(date: string, crowdinId: string, integrationId?: string): Promise<void>;
    deleteAllUsersErrorsOlderThan(date: string): Promise<void>;
    saveIntegrationConfig(integrationId: string, crowdinId: string, config: any): Promise<void>;
    getAllIntegrationConfigs(crowdinId: string): Promise<IntegrationConfig[]>;
    getIntegrationConfig(integrationId: string): Promise<IntegrationConfig | undefined>;
    updateIntegrationConfig(integrationId: string, config: any): Promise<void>;
    createJob(params: CreateJobParams): Promise<string>;
    updateJob(params: UpdateJobParams): Promise<void>;
    getJob(params: GetJobParams): Promise<Job | undefined>;
    getActiveJobs(params: GetActiveJobsParams): Promise<Job[] | undefined>;
    deleteFinishedJobs(): Promise<void>;
    getAllInProgressJobs(): Promise<Job[] | undefined>;
    getAllJobs(params: GetAllJobsParams): Promise<Job[] | undefined>;
    saveTranslationCache(params: TranslationCache): Promise<void>;
    getFileTranslationCache(params: GetFileTranslationCache): Promise<TranslationCache[] | undefined>;
    getFileTranslationCacheByLanguage(params: GetFileTranslationCacheByLanguageParams): Promise<TranslationCache | undefined>;
    updateTranslationCache(params: UpdateTranslationCacheParams): Promise<void>;
    saveUnsyncedFiles(params: UnsyncedFiles): Promise<void>;
    updateUnsyncedFiles(params: UnsyncedFiles): Promise<void>;
    getUnsyncedFiles(params: GetUnsyncedFiles): Promise<UnsyncedFiles | undefined>;
    registerCustomTable(tableName: string, schema: Record<string, string>): Promise<void>;
    insertRecord(tableName: string, data: Record<string, any>): Promise<void>;
    selectRecords(tableName: string, options?: {
        columns?: string[];
        whereClause?: string;
        orderBy?: string;
        limit?: number;
        offset?: number;
        distinct?: boolean;
    }, params?: any[]): Promise<any[]>;
    updateRecord(tableName: string, data: Record<string, any>, whereClause: string, params?: any[]): Promise<void>;
    deleteRecord(tableName: string, whereClause: string, params?: any[]): Promise<void>;
    saveSyncedData(files: any, integrationId: string, crowdinId: string, type: string): Promise<void>;
    updateSyncedData(files: any, integrationId: string, crowdinId: string, type: string): Promise<void>;
    getSyncedData(integrationId: string, crowdinId: string, type: string): Promise<IntegrationSyncedData | undefined>;
    /**
     * Converts undefined values to null for D1 compatibility
     * D1 does not support undefined values, so we convert them to null
     */
    private sanitizeBindValues;
}