spatie/laravel-query-builder

driverspatie4/8 capabilities

Setup

Import the driver directly so every other driver tree-shakes away.

spatie.ts

import { SPATIE_DRIVER, QubeeStore, QueryBuilder, Paginator } from '@qubeejs/core';

const store = new QubeeStore();
const qb = new QueryBuilder(store, SPATIE_DRIVER.createRequestStrategy('query'));
const paginator = new Paginator(
  store,
  SPATIE_DRIVER.createResponseStrategy(),
  SPATIE_DRIVER.createResponseOptions({}),
);

Example query

qb.setResource('articles')
  .addFilter('status', 'published')
  .addSort('createdAt', SortEnum.DESC)
  .setLimit(25)
  .generateUri();

Produces:

/articles?filter[status]=published&limit=25&page=1&sort=-createdAt

Capabilities

Capability	Supported
Filters	✅
Operators	—
Sort	✅
Select	—
Fields	✅
Includes	✅
Search	—
Embedded	—

Bee aware

This driver does not support operators, select, search, embedded. Calling addFilterOperator(), addSelect(), setSearch(), addEmbedded() throws UnsupportedCapabilityError.

Reading a response

const body = await fetch(`https://example.com/api${uri}`).then((r) => r.json());
const page = paginator.paginate(body);

page.data; // rows
page.total; // total rows the backend reported
page.lastPage; // final page number