lyquocnam / fastify-sequelize

Fastity plugin work with Sequelize (adapter for NodeJS -> Sqlite, Mysql, Mssql, Posgres)

fastify-sequelize

Fastity plugin work with Sequelize (adapter for NodeJS -> Sqlite, Mysql, Mssql, Posgres)

install

npm install fastify-sequelize

Usage

const fastify = require('fastify')()
const fsequelize = require('fastify-sequelize')

const sequelizeConfig = {
    instance: 'sequelize', // the name of fastify plugin instance.
    autoConnect: true, // auto authentication and test connection on first run

    // other sequelize config goes here
    dialect: 'sqlite',

    // SQLite only
    storage: 'path/to/db.sqlite'
}

fastify
    .register(fsequelize, sequelizeConfig)
    .ready()

fastify.listen(3000, () => {
  console.log('> listening on port 3000')
})

• instance: (optional) the name of instance will be mapped to fastify, default is sequelize
• autoConnect: default: true auto authentication and test connection on first run.
• sequelizeConfig: all sequelize configurations, you can see here.

fastify-sequelize's Issues

add unit tests

unit tests are missing

Problems with fastify.close with fastify-sequelize

Hello,
I have strange problem with fastify-sequelize in tests - fastify.close throw an exception on app.close. And I have that problem only with fastify-sequelize. I made small test and put it on github - [email protected]:mitry1974/testFSP.git
Can you help me - what is going wrong in that case?

const fastify = require('fastify');
const fastifySequelize = require('fastify-sequelize');
const config = require('../dbconfig');

let app;

beforeEach(async () => {
try {
app = fastify ();
app.register(fastifySequelize, config);
await app.ready();
} catch(e) {
console.log('application start throw an error');
console.log(e);
}
});

afterEach(async () => {
try{
await app.close();
} catch (e) {
console.log('app.close throw an error');
console.log(e);
}
app = null;
});

test('1', () => {
expect(5).toBe(5);
});

test('2', () => {
expect(6).toBe(6);
});

Update sequelize dependency

You should update sequelize dependency because it uses deprecated string based operators
When you run your code example you'll get that error:

sequelize deprecated String based operators are now deprecated. Please use Symbol based operators for better security, read more at http://docs.sequelizejs.com/manual/tutorial/querying.html#operators

Please update the sequelize version

During installation, npm issues a warning:

npm WARN deprecated [email protected]: This version will no longer receive security fixes per our security policy. Please update to sequelize@5 or above.

Please consider updating the Sequelize version to 5.

plugins can return a promise

as sequelize is promise-based, you can return a promise instead of calling next.

Currently you are not handling the error correctly, as catch() is just console.logging.

Is it customazible for DB user and pass?

Hi, I checked out your package. Thanks for connector! But I am still wondering is it possible to set user, DB, and password manually?

use onClose hook

you can use the onClose hook in fastify to have it take care of shutting down sequelize for you.

Ref https://github.com/fastify/fastify/blob/master/docs/Hooks.md

Add some basic example for usage

Hi I am totally fresh to NodeJS environment. I have been using fastify-seuqlize for some REST API development. If possible please add some example of usage basically how to define models in different folders and export them as module to be used in other models for relations.

integrate authentication

I think the plugin needs to do authentication before starting up.

Update package on NPM

My lates pull request has been integrated and I could change back to using the NPM version if it gets pushed. I see it has not been updated in 4 years on NPM. Could you push an update?

https://www.npmjs.com/package/fastify-sequelize