A Seneca.js Data Storage Plugin

seneca-mysql-store

A storage engine that uses mySql to persist data. It may also be used as an example on how to implement a storage plugin for Seneca using an underlying relational store.

If you're using this module, and need help, you can:

• Post a github issue,
• Tweet to @senecajs,
• Ask on the Gitter.

If you are new to Seneca in general, please take a look at senecajs.org. We have everything from tutorials to sample apps to help get you up and running quickly.

Install

To install, simply use npm. Remember you will need to install Seneca.js separately.

npm install seneca
npm install seneca-mysql-store

Test

To run tests, simply use npm:

npm run test

To run tests with Docker

Build the MySQL Docker image:

npm run build

Start the MySQL container:

npm run start

Stop the MySQL container:

npm run stop

While the container is running you can run the tests into another terminal:

npm run test

Quick Example

var seneca = require('seneca')()
seneca.use('mysql-store', {
  name:'senecatest',
  host:'localhost',
  user:'senecatest',
  password:'senecatest',
  port:3306
})

seneca.ready(function () {
  var apple = seneca.make$('fruit')
  apple.name  = 'Pink Lady'
  apple.price = 0.99
  apple.save$(function (err, apple) {
    console.log("apple.id = " + apple.id)
  })
})

Usage

You don't use this module directly. It provides an underlying data storage engine for the Seneca entity API:

var entity = seneca.make$('typename')
entity.someproperty = "something"
entity.anotherproperty = 100

entity.save$(function (err, entity) { ... })
entity.load$({id: ...}, function (err, entity) { ... })
entity.list$({property: ...}, function (err, entity) { ... })
entity.remove$({id: ...}, function (err, entity) { ... })

Query Support

The standard Seneca query format is supported:

• .list$({f1:v1, f2:v2, ...}) implies pseudo-query f1==v1 AND f2==v2, ....

• .list$({f1:v1, ...}, {sort$:{field1:1}}) means sort by f1, ascending.

• .list$({f1:v1, ...}, {sort$:{field1:-1}}) means sort by f1, descending.

• .list$({f1:v1, ...}, {limit$:10}) means only return 10 results.

• .list$({f1:v1, ...}, {skip$:5}) means skip the first 5.

• .list$({f1:v1,...}, {fields$:['fd1','f2']}) means only return the listed fields.

Note: you can use sort$, limit$, skip$ and fields$ together.

Native Driver

As with all seneca stores, you can access the native driver, in this case, the mysql connectionPool object using entity.native$(function (err, connectionPool) {...}).

Contributing

We encourage participation. If you feel you can help in any way, be it with examples, extra testing, or new features please get in touch.

License

Copyright Mircea Alexandru and other contributors 2016, Licensed under MIT.