Function runValues

repos/effect/packages/sql/d1/src/D1Client.ts:151–168

(
        sql: string,
        params: ReadonlyArray<unknown>
      )

        const transforms: Array<TransformRows | undefined> = []
        const queryTexts: Array<string> = []

        for (const original of statements) {
          const statement = transformer === undefined
            ? original
            : yield* transformer(original, options.getClient(), fiber, span)
          const [sql, params] = statement.compile()
          queryTexts.push(sql)
          transforms.push((statement as StatementWithTransformRows).transformRows)
          prepared.push((yield* Cache.get(options.prepareCache, sql)).bind(...params))
        }

        for (const [key, value] of options.spanAttributes) {
          span.attribute(key, value)
        }
        span.attribute(ATTR_DB_OPERATION_NAME, "batch")
        span.attribute(ATTR_DB_QUERY_TEXT, queryTexts.join("; "))

        // D1 batches execute on the binding directly and intentionally cannot participate in SqlClient transactions.
        const responses = yield* Effect.tryPromise({
          try: () =>
            options.db.batch<Record<string, unknown>>(prepared).then((responses) => {