Select and Where types

SelectShape

type SelectShape = {
  [field: string]: true | { as: string } | SelectShape;  // nested relation
};

WhereShape

type WhereShape = {
  [field: string]:
    | Value                         // implicit eq
    | Value[]                       // implicit in
    | { contains?: Value; gte?: Value; lte?: Value; ... };  // operators
};

OrderByShape

type OrderByShape = {
  [field: string]: "asc" | "desc";
};

CreateInput

type CreateInput = {
  [field: string]: Value;
  // Fields with .autoCreate() are excluded
  // Many-to-many relations passed as array of IDs or objects
  [relation: string]: ID[] | JunctionData[];
};

UpdateInput

type UpdateInput = {
  [field: string]: Value;
  // Many-to-many relations passed as array of IDs (replaces all)
};

CursorOptions

type CursorOptions = {
  select?: SelectShape;
  where?: WhereShape;
  orderBy: OrderByShape;  // required
  after?: string;
  limit: number;          // required
};

PaginationOptions

type PaginationOptions = {
  page: number;
  perPage: number;
};

.get() also accepts limit and offset as direct options for simple pagination without using pagination.

const { data } = await jsorm.users.get({ limit: 10, offset: 20 });