@cuillere/postgres NPM

cuillere is an asynchronous execution framework based on generator functions and middlewares.

🚧 cuillere is still in early development stage, the API may change at any time.

Why ?

The goal of cuillere is to abstract some inevitable technical complexity (such as managing database transactions) in middlewares, and keep business code as simple and focused as possible.

Usage

In this example we use cuillere to manage the connection to a PostgreSQL database.

const cuillere = require('@cuillere/core')
const { poolMiddleware, transactionMiddleware, queryMiddleware } = require('@cuillere/postgres')

const cllr = cuillere(
  poolMiddleware({ /* postgres config */ }), // Manages connection pool
  transactionMiddleware(), // Manages transactions
  queryMiddleware() // Executes queries
)

const addUserAddress = (userId, address, setDefault) => cllr.execute(function*() {
  const res = yield query({
    text: `INSERT INTO addresses (userId, street, postalcode, city)
           VALUES ($1, $2, $3, $4)
           RETURNING *`,
    values: [userId, address.street, address.postalCode, address.city]
  })
  if (setDefault) {
    const addressId = res.rows[0].id
    yield query({
      text: `UPDATE users
             SET defaultaddressid = $1
             WHERE userid = $2`,
      values: [addressId, userId]
    })
  }
})