import { ZodObject, ZodTypeAny, z } from 'zod';
import { PApi, PTable } from './papi';
import type { ApiOptions, ExtractResultFromQuery, PActionBody, PHooks, ZodSchemaToKysely } from '../types';
import type { CompiledQuery, InsertQueryBuilder, Kysely, RawBuilder, SelectQueryBuilder } from 'kysely';
export declare class SqliteApi<Schema extends ZodObject<any, any, any>> extends PApi<Schema> {
    table<K extends keyof z.output<Schema> & string>(tableName: K, opts?: {
        ky?: Kysely<ZodSchemaToKysely<Schema>>;
        hooks?: PHooks[];
    }): PTable<z.output<Schema>[K], z.input<Schema>[K], K>;
    /**
     * only working cloudflare D1 and sqlite
     * use this api to execute one sql query with multiple parameters
     * https://developers.cloudflare.com/d1/platform/client-api/#dbbatch
     * @param batchParams  order of params is not automatic like what kysely does
     */
    batchOneSmt<V extends SelectQueryBuilder<z.output<Schema>, any, any> | InsertQueryBuilder<z.output<Schema>, any, any>>(sqlQuery: {
        compile: () => CompiledQuery<z.output<Schema>>;
    } | RawBuilder<z.output<Schema>>, batchParams: Array<any[]>, opts?: ApiOptions): Promise<{
        rows: ExtractResultFromQuery<V>[];
        error: any;
    }>;
    $batchOneSmt(sqlQuery: {
        compile: () => CompiledQuery<z.output<Schema>>;
    } | RawBuilder<z.output<Schema>>, batchParams: Array<any[]>): PActionBody;
    batchAllSmt(sqlQuerys: Array<{
        compile: () => CompiledQuery<z.output<Schema>>;
    }>, opts?: ApiOptions): Promise<{
        error: any;
        rows: any[];
        getOne: <X = any>(index: number) => X | undefined;
        getMany: <X = any>(index: number) => X[];
    }>;
    bulk<V extends string>(operations: {
        [key in V]: PActionBody | {
            compile: () => CompiledQuery<z.output<Schema>>;
        } | RawBuilder<z.output<Schema>> | undefined;
    }, opts?: ApiOptions & {
        isTransaction: boolean;
    }): Promise<{
        data: {
            key: string;
            results: any[];
            table: string;
        }[];
        error: any;
        getOne: <X = any>(key: V, table?: keyof z.output<Schema>, extend?: ZodObject<any, any>) => X | undefined;
        getMany: <X = any>(key: V, table?: string, extend?: ZodObject<any, any>) => X[];
    }>;
    /**
     * extend the origin zod schema
     * it similar to withTables on kysely
     *
     * ```typescript
     * const extendApi = api.withTables(
     *   {
     *     NewTable: z.object({
     *       id: z.number().optional(),
     *       name: z.string(),
     *     }),
     *   },
     *   { // option
     *     newTable: o => o.table('NewTable'),
     *   })
     * ```
     **/
    withTables<T extends {
        [k: string]: ZodTypeAny;
    }, ExtendApi extends {
        [key: string]: (api: PApi<ExtendSchema>) => PTable<any, any, any>;
    }, ExtendSchema extends ZodObject<z.input<Schema> & T, any, any, z.input<Schema> & {
        [k in keyof T]: z.input<T[k]>;
    }, z.output<Schema> & {
        [k in keyof T]: z.output<T[k]>;
    }>>(schema: T, extendApi?: ExtendApi): PApi<ExtendSchema> & { [key in keyof ExtendApi]: ReturnType<ExtendApi[key]>; };
}