/**
 * Type declaration for @dotdo/pglite
 * This allows TypeScript to recognize the module without requiring type definitions
 */
declare module '@dotdo/pglite' {
  export type DebugLevel = 0 | 1 | 2 | 3 | 4 | 5

  export interface PGliteOptions {
    wasmModule?: WebAssembly.Module
    fsBundle?: Blob
    dataDir?: string
    debug?: DebugLevel
    relaxedDurability?: boolean
    extensions?: Record<string, unknown>
    username?: string
    database?: string
  }

  export interface QueryOptions {
    rowMode?: 'array' | 'object'
  }

  export interface Results<T = Record<string, unknown>> {
    rows: T[]
    fields: { name: string; dataTypeID: number }[]
    affectedRows?: number
  }

  export interface Transaction {
    query<T = Record<string, unknown>>(sql: string, params?: unknown[], options?: QueryOptions): Promise<Results<T>>
    exec(sql: string): Promise<Results[]>
    rollback(): Promise<void>
  }

  export class PGlite {
    constructor(options?: PGliteOptions | string)
    static create(options?: PGliteOptions | string): Promise<PGlite>
    query<T = Record<string, unknown>>(sql: string, params?: unknown[], options?: QueryOptions): Promise<Results<T>>
    exec(sql: string): Promise<Results[]>
    transaction<T>(callback: (tx: Transaction) => Promise<T>): Promise<T>
    close(): Promise<void>
    listen(channel: string, callback: (payload: string) => void): Promise<() => Promise<void>>
    notify(channel: string, payload?: string): Promise<void>
    waitReady: Promise<void>
    ready: boolean
    closed: boolean
  }
}