Using hapi-sequelize about hapi-sequelize

[iwasrobbed]

Here's an example of setting things up in server.js

// Inside server.js

const HapiSequelize = require('hapi-sequelize');

const options = {
    sequelize: {
        name: 'yourDatabaseName',
        models: ['./lib/modules/people/person.js'],
        sequelize: new Sequelize(process.env.DATABASE_URL),
        sync: true, // sync models - default false
        forceSync: false, // force sync (drops tables) - default false
        // onConnect: function (database) { // Optional
        //     console.log("Connected to db");
        //     // migrations, seeders, etc.
        // }
    },
};

server.register([
    { register: HapiSequelize, options: options.sequelize },
], (err) => {
    if (err) {
        server.log('error', 'Failed to load a plugin: ', err);
        throw err;
    }

    // Start server
    server.start((err) => {
        if (err) {
            server.log('error', 'Failed to start server: ', err);
            throw err;
        }
        server.log('info', 'Server running at: ' + server.info.uri);
    });
});

and your model would look like

module.exports = function(sequelize, DataTypes) {

    const Person = sequelize.define("Person", {
        uid: {
            type: DataTypes.BIGINT,
            primaryKey: true
        },
        firstName: {
            type: DataTypes.STRING,
            allowNull: false
        },
        lastName: {
            type: DataTypes.STRING,
            allowNull: false
        },
        email: {
            type: DataTypes.STRING,
            allowNull: false
        }
    }, {
        classMethods: {
        },
        instanceMethods: {
        }
    });

    return Person;

};

then you'd query in your controller / server layer like:

const list = function*(request, reply) {
    try {
        return reply(yield Person(request).all());
    } catch (err) {
        return reply(err);
    }
};

[IAIAE]

any api for how to use a model? @iwasrobbed

[iwasrobbed]

@IAIAE The example above shows how to use the model. Sequelize itself gives you all the APIs http://docs.sequelizejs.com/manual/tutorial/models-usage.html ; this lib is just a wrapper around Sequelize that gives you access to it via hapi

If you're accessing a model from a controller, you can do something like this to get any arbitrary model:

const Collection = function(request) {
    return request.getDb().getModel('Collection');
};

and then something like this in your controller or service layer function

Collection(request).create(request.payload));