Fastify-waterline NPM

fastify-waterline

Build Status npm-version

fastify-waterline add a Waterline ORM instance to your Fastify project.

What is Waterline?

Waterline is a datastore-agnostic tool that dramatically simplifies interaction with one or more databases. It provides an abstraction layer on top of the underlying database, allowing you to easily query and manipulate your data without writing vendor-specific integration code.

Install

npm i fastify-waterline --save

Usage

First of all you need to define a model. A model represents a set of structured data, called records. Models usually correspond to a table/collection in a database, attributes correspond to columns/fields, and records correspond to rows/documents. Here is an example:

// file models/user.js
'use strict'

module.exports = {
  attributes: {
    id: {
      type: 'number',
      autoMigrations: { autoIncrement: true }
    },
    firstName: {
      type: 'string',
      required: true
    },
    lastName: {
      type: 'string',
      required: true
    },
    username: {
      type: 'string',
      required: true
    }
  },
  primaryKey: 'id',
  tableName: 'users'
}

Now let's imagine that this model represent a table in a MySQL database called test. Now we can add the fastify-waterline plugin at our fastify instance in this way:

const fastify = Fastify()
fastify.register(require('fastify-waterline'), [{
  name: 'mysql',
  adapter: 'mysql',
  host: 'localhost',
  port: 3306,
  user: 'root',
  database: 'test',
  entitiesFolder: './models'
}])

fastify.ready(async err => {
  if (err) {
    fastify.log.error(err)
  }

  const UserModel = await fastify.fw.getModel('user')
  let newUser = await UserModel.create({
    firstName: 'Davide',
    lastName: 'D\'Antonio',
    username: 'ddantonio'
  }).meta({ fetch: true })
})

The Fastify instance expose two methods getModel and getInstance

Options

Option	Description
`name`	The name of the connection
`adapter`	The adapter that must be used. One of `mysql`, `mongo`, `postgresql`, `disk`
`host`	The database host
`port`	The database port
`user`	The database user
`password`	The database password
`entitiesFolder`	The folder path of our `.js` entities files
`entities`	An array of entities for example `[ require('./models/user'), require('./models/post') ]`