db.js

import Sequelize from 'sequelize';
import _ from 'lodash';
import Faker from 'faker';

const Conn = new Sequelize(
  'tutorial',
  'tutorial',
  'tutorial',
  {
    dialect: 'postgres',
    host: '127.0.0.1'
  }
);

const Person = Conn.define('person',{
  firstName:{
    type: Sequelize.STRING,
    allowNull:false
  },
  lastName: {
    type: Sequelize.STRING,
    allowNul:false
  },
  email: {
    type: Sequelize.STRING,
    allowNull: false,
    validate: {
      isEmail: true
    }
  }
});

const Post = Conn.define('post',{
  title:{
    type: Sequelize.STRING,
    allowNull: false
  },
  content:{
    type: Sequelize.STRING,
    allowNull: false
  }
});

//Relationships

Person.hasMany(Post);
Post.belongsTo(Person);

Conn.sync({force: true}).then(()=> {
    _.times(10, ()=>{
      return Person.create({
        firstName: Faker.name.firstName(),
        lastName: Faker.name.lastName(),
        email: Faker.internet.email()
      }).then( person => {
        return person.createPost({
          title: `Sample title by ${person.firstName}`,
          content: 'This is a sample article'
        })
      });
    });
});

export default Conn;