import { KeyRangeSpec } from '@firtoz/idb-collections';

/**
 * Index information returned by getStoreIndexes
 */
interface IndexInfo {
    name: string;
    keyPath: string | string[];
}
/**
 * Options for creating an object store
 */
interface CreateStoreOptions {
    keyPath?: string;
    autoIncrement?: boolean;
}
/**
 * Options for creating an index
 */
interface CreateIndexOptions {
    unique?: boolean;
}
/**
 * Minimal database interface with high-level async operations.
 * This is the interface that custom implementations (mocks, Chrome extension proxies, etc.) need to implement.
 *
 * All operations are simple async functions - no transactions, requests, or callbacks to deal with.
 */
interface IDBDatabaseLike {
    /** Database version number */
    readonly version: number;
    /** Check if a store exists */
    hasStore(storeName: string): boolean;
    /** Get list of all store names */
    getStoreNames(): string[];
    /** Create an object store (only valid during migrations) */
    createStore(storeName: string, options?: CreateStoreOptions): void;
    /** Delete an object store (only valid during migrations) */
    deleteStore(storeName: string): void;
    /** Create an index on a store (only valid during migrations) */
    createIndex(storeName: string, indexName: string, keyPath: string | string[], options?: CreateIndexOptions): void;
    /** Delete an index from a store (only valid during migrations) */
    deleteIndex(storeName: string, indexName: string): void;
    /** Get all indexes for a store (for index discovery) */
    getStoreIndexes(storeName: string): IndexInfo[];
    /** Get all items from a store */
    getAll<T = unknown>(storeName: string): Promise<T[]>;
    /** Get items from a store using an index with optional key range */
    getAllByIndex<T = unknown>(storeName: string, indexName: string, keyRange?: KeyRangeSpec): Promise<T[]>;
    /** Get a single item by key */
    get<T = unknown>(storeName: string, key: IDBValidKey): Promise<T | undefined>;
    /** Add items to a store (batch operation) */
    add(storeName: string, items: unknown[]): Promise<void>;
    /** Update items in a store (batch operation, uses put) */
    put(storeName: string, items: unknown[]): Promise<void>;
    /** Delete items from a store by keys (batch operation) */
    delete(storeName: string, keys: IDBValidKey[]): Promise<void>;
    /** Clear all items from a store */
    clear(storeName: string): Promise<void>;
    /** Close the database connection */
    close(): void;
}
/**
 * Options for opening a database with version upgrade support.
 */
interface IDBOpenOptions {
    /** Target version for the database. If higher than current, triggers upgrade. */
    version?: number;
    /** Called during version upgrade - this is where schema changes (createStore, createIndex) are allowed. */
    onUpgrade?: (db: IDBDatabaseLike) => void;
}
/**
 * Function type for creating/opening an IndexedDB-like database.
 * Custom implementations can use this to provide proxy/mock/alternative backends.
 */
type IDBCreator = (name: string, options?: IDBOpenOptions) => Promise<IDBDatabaseLike>;
/**
 * Function type for deleting an IndexedDB database.
 */
type IDBDeleter = (name: string) => Promise<void>;

export type { CreateIndexOptions, CreateStoreOptions, IDBCreator, IDBDatabaseLike, IDBDeleter, IDBOpenOptions, IndexInfo };