Skip to content
This repository has been archived by the owner on Oct 13, 2022. It is now read-only.

beliven-it/knex-crud

Repository files navigation

knex-crud

Helper CRUD functions for Knex.js

Node.js CI

Install

$ npm i --save knex-crud

Usage

const knexCrud = require('knex-crud')

const petsCrud = new knexCrud('pets', {
  formatter: pet => ({
    isCat: pet.family === 'cats'
  })
})

petsCrud.bind(knex)

const felix = await petsCrud.insertOne({
  name: 'Felix',
  family: 'cats'
})

console.log(felix)

// {
//    id: 1,
//    name: 'Felix',
//    family: 'cats',
//    isCat: true
// }

Methods

Name Description
constructor (table, options) Initialize a new istance for table. Additional options can be passed.
bind (knex) Bind a knex instance. If not bound, all other methods will throw an error.
checkKnexBinding () Used to check for existing binding. If not bound , an error will be thrown.
getBaseQuery () Used to create the base for all queries. By default is knex(tableName).
list (filters) Return a list of records, optionally filtered by an array of filters functions (e.g. async query => query.where(...)).
paginatedList (filters, limit, offset) Return a paginated list of records, optionally filtered and limited. See list(...).
getOneBy (value, column) Get the first record matching the given value in column (${pk} by default).
insertOne (data) Insert a new record with given data and return it.
updateOneBy (data, value, column) Update data of the first matching record by value in column (${pk} by default).
deleteOneBy (data, value, column) Delete the first matching record by value in column (${pk} by default).

Options

Name Description
pk Define the primary key column for the table. Default: id
defaultOrder Define the default order query for the table: Default ${pk}:asc
formatter Define a function to format each entry in a query response.

Test

$ npm test

Acknowledgements

This project is kindly sponsored by:

Beliven

License

Licensed under MIT