Method execute

packages/oracledb/src/OracleConnection.ts:142–197

(
    query: string | NativeQueryBuilder | RawQueryFragment,
    params: readonly unknown[] = [],
    method: 'all' | 'get' | 'run' = 'all',
    ctx?: Transaction,
    loggerContext?: LoggingOptions,
  )

  }

  override async execute<
    T extends QueryResult | EntityData<AnyEntity> | EntityData<AnyEntity>[] = EntityData<AnyEntity>[],
  >(
    query: string | NativeQueryBuilder | RawQueryFragment,
    params: readonly unknown[] = [],
    method: 'all' | 'get' | 'run' = 'all',
    ctx?: Transaction,
    loggerContext?: LoggingOptions,
  ): Promise<T> {
    await this.ensureConnection();

    if (query instanceof NativeQueryBuilder) {
      query = query.toRaw();
    }

    if (isRaw(query)) {
      params = query.params;
      query = query.sql;
    }

    query = this.stripTrailingSemicolon(query);

    let last: Dictionary | undefined;
    let rawQuery: string | undefined;
    const lastParam = params[params.length - 1];

    if (Utils.isObject(lastParam) && '__outBindings' in lastParam && lastParam.__outBindings) {
      rawQuery = lastParam.__rawQuery;
      const { __outBindings, ...rest } = lastParam as Dictionary & { __outBindings: boolean };
      last = rest;
      params = [...params.slice(0, -1), last];
    }

    query = this.config.get('onQuery')(query, params);
    const formatted = this.platform.formatQuery(query, params);
    const sql = this.getSql(rawQuery ?? query, formatted, loggerContext);

    return this.executeQuery<T>(
      sql,
      async () => {
        const compiled = CompiledQuery.raw(formatted, last as unknown[]);

        if (ctx) {
          const res = await ctx.executeQuery(compiled);
          return this.transformRawResult<T>(res, method);
        }

        const res = await this.getClient().executeQuery({
          ...compiled,
          autoCommit: true,
        } as CompiledQuery);
        return this.transformRawResult<T>(res, method);
      },
      { query, params, ...loggerContext },
    );
  }

  /** @inheritDoc */