Iskra API Reference
    Preparing search index...

    Interface OracleDatabase

    The driver as a repository needs it: statements, transactions and a ping. OracleDriver and fakeOracle() (@iskra-bun/db-oracle/testing) are both one.

    interface OracleDatabase {
        execute<
            T = Record<string, unknown>,
            const B extends OracleBinds = OracleBinds,
        >(
            sql: string,
            binds?: B,
            options?: StatementOptions,
        ): Promise<ExecuteResult<T, OutBinds<B>>>;
        executeMany(
            sql: string,
            rows: readonly OracleBinds[],
            options?: ExecuteManyOptions,
        ): Promise<ExecuteManyResult>;
        list<T = Record<string, unknown>, F = unknown, O = unknown>(
            options: ListOptions<T, F, O>,
            statement?: StatementOptions,
        ): Promise<ListResult<T>>;
        one<T = Record<string, unknown>>(
            sql: string,
            binds?: OracleBinds,
            options?: QueryOptions<T>,
        ): Promise<T>;
        ping(): Promise<boolean>;
        query<T = Record<string, unknown>>(
            sql: string,
            binds?: OracleBinds,
            options?: QueryOptions<T>,
        ): Promise<T[]>;
        queryOne<T = Record<string, unknown>>(
            sql: string,
            binds?: OracleBinds,
            options?: QueryOptions<T>,
        ): Promise<T | undefined>;
        transaction<R>(fn: (tx: OracleSession) => Promise<R>): Promise<R>;
    }

    Hierarchy (View Summary)

    Implemented by

    Index
    • The first row of a query, or a NoRowsError (NOT_FOUND, a 404 in web-kit).

      Type Parameters

      • T = Record<string, unknown>

      Parameters

      Returns Promise<T>

    • True when the database answers in time; never throws.

      Returns Promise<boolean>

    • The rows of a query.

      Type Parameters

      • T = Record<string, unknown>

      Parameters

      Returns Promise<T[]>

    • The first row of a query (fetching only that one), or undefined.

      Type Parameters

      • T = Record<string, unknown>

      Parameters

      Returns Promise<T | undefined>

    • Type Parameters

      • R

      Parameters

      Returns Promise<R>