Package Exports

@uql/mysql
@uql/mysql/index.js

This package does not declare an exports field, so the exports above have been automatically detected and optimized by JSPM instead. If any package subpath is missing, it is recommended to post an issue to the original package (@uql/mysql) to support the "exports" field. If that is not possible, create a JSPM override to customize the exports field for this package.

Readme

uql ·

Learn more of uql in the website https://uql.io 🔆

Quick Start

uql is a flexible and efficient ORM, with declarative JSON syntax and really smart type-safety.

The uql queries can be safely written in the frontend (browser/mobile) and sent to the backend; or only use uql in the backend, or even in a mobile app with an embedded database (like sqlite).

Features

JSON (serializable) syntax for all the queries.
uses the power of TypeScript to get (smart) type-safety everywhere.
the generated queries are performant, safe, and human-readable.
$project, $filter, $sort, $limit works at multiple levels (including deep relations and their fields).
declarative and imperative transactions.
soft-delete, virtual fields, repositories, connection pooling.
transparent support for inheritance patterns between entities.
supports Postgres, MySQL, MariaDB, SQLite, MongoDB (beta).

Installation

Install the core package:

npm install @uql/core --save

yarn add @uql/core

Install one of the specific packages according to your database:

Database Package

MySQL @uql/mysql

PostgreSQL @uql/postgres

MariaDB @uql/maria

MongoDB @uql/mongo

SQLite @uql/sqlite

E.g. for PostgreSQL
```
npm install @uql/postgres --save
```
or with yarn
```
yarn add @uql/postgres
```

Database	Package
`MySQL`	`@uql/mysql`
`PostgreSQL`	`@uql/postgres`
`MariaDB`	`@uql/maria`
`MongoDB`	`@uql/mongo`
`SQLite`	`@uql/sqlite`

Additionally, your tsconfig.json may need the following flags:

"target": "es6", // or a more recent ecmascript version.
"experimentalDecorators": true,
"emitDecoratorMetadata": true

Configuration

A default querier-pool can be set in any of the bootstrap files of your app (e.g. in the server.ts).

import { setDefaultQuerierPool } from '@uql/core';
import { PgQuerierPool } from '@uql/postgres';

const querierPool = new PgQuerierPool(
  {
    host: 'localhost',
    user: 'theUser',
    password: 'thePassword',
    database: 'theDatabase',
  },
  // a logger can optionally be passed so the SQL queries are logged
  console.log
);

setDefaultQuerierPool(querierPool);

Definition of Entities

Take any dump class (aka DTO) and annotate it with the decorators from '@uql/core/entity'.

import { v4 as uuidv4 } from 'uuid';
import { Field, ManyToOne, Id, OneToMany, Entity, OneToOne, ManyToMany } from '@uql/core/entity';

@Entity()
export class Profile {
  /**
   * primary key
   */
  @Id({ onInsert: uuidv4 })
  id?: string;
  @Field()
  picture?: string;
  /**
   * foreign-keys are really simple to specify.
   */
  @Field({ reference: () => User })
  creatorId?: string;
}

@Entity()
export class User {
  @Id({ onInsert: uuidv4 })
  id?: string;
  @Field()
  name?: string;
  @Field()
  email?: string;
  @Field()
  password?: string;
  /**
   * `mappedBy` can be a callback or a string (callback is useful for auto-refactoring).
   */
  @OneToOne({ entity: () => Profile, mappedBy: (profile) => profile.creatorId, cascade: true })
  profile?: Profile;
}

@Entity()
export class MeasureUnitCategory {
  @Id({ onInsert: uuidv4 })
  id?: string;
  @Field()
  name?: string;
  @OneToMany({ entity: () => MeasureUnit, mappedBy: (measureUnit) => measureUnit.category })
  measureUnits?: MeasureUnit[];
}

@Entity()
export class MeasureUnit {
  @Id({ onInsert: uuidv4 })
  id?: string;
  @Field()
  name?: string;
  @Field({ reference: () => MeasureUnitCategory })
  categoryId?: string;
  @ManyToOne({ cascade: 'persist' })
  category?: MeasureUnitCategory;
}

Creation of Queries

import { getQuerier, getRepository } from '@uql/core';
import { User } from './entity';

const querier = await getQuerier();

const users = await querier.findMany(User, {
  $project: { id: true, email: true, profile: ['id', 'picture'] },
  $filter: { email: { $iendsWith: '@google.com' } },
  $sort: { createdAt: -1 },
  $limit: 100,
});

await querier.release();

See more in https://uql.io 🔆