Function firstAllShards

firstAllShards<T = Record<string, unknown>>(
    sql: string,
    bindings?: any[],
    batchSize?: number,
    options?: ReadOptions,
): Promise<(T | null)[]>
Executes a query on all shards and returns the first matching record from each shard.

This function is useful for scenarios where you need to retrieve a single record from each shard, such as fetching the latest entry or a specific item that may exist on multiple shards.
Type Parameters
- T = Record<string, unknown>
Parameters
- sql: string
  The SQL statement to execute
- bindings: any[] = []
  Parameter values to bind to the SQL statement
- batchSize: number = 50
  Number of concurrent queries to run at once (default: 50)
- Optionaloptions: ReadOptions
  Read guarantee for this call
Returns Promise<(T | null)[]>
Promise resolving to an array of first matching records from each shard

Since
1.0.4
- Defined in src/router.ts:4313