0.2.1 • Published 7 years ago

@postgres-queries/builder v0.2.1

Weekly downloads
1
License
MIT
Repository
-
Last release
7 years ago

Queries Builder

All query factories function takes an object as a parameter, containing the following keys:

  • table: table name on which operate the query,
  • permanentFilters: query filters provided to each underlying queries, as a plain object

Count

Build a COUNT(*) query.

import { countAll } from "postgres-queries-builder";

const countQuery = countAll({
  table: "user",
  permanentFilters: {
    active: 1
  }
});

countQuery({
  filter: {
    department: "HR"
  }
});

// SELECT COUNT(*) FROM user WHERE active = 1 AND departement = "HR"

The countQuery takes an extra object parameter whose keys are:

  • filter: extra filter to apply to the query, as a plain object