typeorm-front-query-builder

Easily build requests on url for your server which uses typeorm-server-query-builder.

TypeORM Frontend Query Builder

This library allows you to build url string query for typeorm-server-query-builder.

Installation

npm install typeorm-front-query-builder

Usage

import { Query } from 'typeorm-front-query-builder';
 
const query = new Query();
query.fieldBetween('age', 18, 45).join(['posts', 'photos']);
 
const urlQuery = query.toString();
// age__between=18,45&relations=posts,photos

Available Lookups

Lookup	Method
(none)	fieldEqual(field: string, value: Primitive, not = false): Query
contains	fieldContains(field: string, value: Primitive, not = false): Query
startswith	fieldStartsWith(field: string, value: Primitive, not = false): Query
endswith	fieldEndsWith(field: string, value: Primitive, not = false): Query
isnull	fieldIsNull(field: string, not = false): Query
lt	fieldLessThan(field: string, value: Primitive, not = false): Query
lte	fieldLessThanOrEqual(field: string, value: Primitive, not = false): Query
gt	fieldGreaterThan(field: string, value: Primitive, not = false): Query
gte	fieldGreaterThanOrEqual(field: string, value: Primitive, not = false): Query
in	fieldIn(field: string, elements: Array<Primitive>, not = false): Query
between	fieldBetween(field: string, firstValue: string | number, lastValue: string | number, not = false): Query

Options

Option	Default
pagination	[enable|disable]Pagnination(): Query
page	setPage(page: number): Query
limit	setLimit(limit: number): Query
order	orderBy(field: string, by: 'ASC' | 'DESC'): Query
join	join(relations: string[]): Query
select	select(fields: string[]): Query

Others methods

Get a raw request object to pass it to an http POST request body for example

public getRawObject(): object

Get the query string to form a query on url (?)

public toString(): string