TypeORM JSON Query

$3

!npm
!GitHub
!GitHub package.json dependency version (dev dep on branch)


Install

``bash
npm i --save @lomray/typeorm-json-query
`

Usage

Pass request JSON query to TypeormJsonQuery.

__Request:__
`http request
POST http://127.0.0.1:3000
Content-Type: application/json

{
"attributes": ["id", "param"], // or empty for select all
"orderBy": { "id": "DESC", { "param": { "order": "ASC", "nulls": "last" } } },
"relations": ["demo"],
"where": { "id": 1, "or": [{ "param": "hello" }, { "param": "world" }] },
}
`

__Server implementation:__
`typescript
import TypeormJsonQuery from '@lomray/typeorm-json-query';
import express from 'express';
import { getRepository } from 'typeorm';
import TestEntity from './entities/test-entity';

express()
.get('/demo-endpoint', (req, res) => {
const jsonQuery = req.body;
const typeormQuery = TypeormJsonQuery.init({
queryBuilder: getRepository(TestEntity).createQueryBuilder(),
query: jsonQuery,
});

console.log(typeormQuery.toQuery().getSql());

res.send('Ok.');
});
`

__Also, you can use IJsonQuery interface for support build JSON query on client side:__
`typescript
import { IJsonQuery } from '@lomray/typeorm-json-query';
import ITestEntity from './interfaces/i-test-entity';
import axios from 'axios';

const body: IJsonQuery = {
relations: [{ name: 'test', where: { id: 1 } }],
where: { and: [{ id: { '<': 5 } }, { param: { like: '%hello%' } }] },
};

axios.request({
method: 'POST',
body,
});
``

Check out __tests__/index-test.ts or src/index.ts for more info.