exports.seed = function(knex, Promise) {
  // Deletes ALL existing entries
  return knex('employees').del()
    .then(() => knex('customers').del())
    .then(() => {  // Using promises allows to catch errors during process
      return Promise.all([

      // Inserts seed entries

      /*
      employees -- employee_id, firstName, lastName, city, state, zipcode, phone, email, employee_type = ['admin', 'manager', 'employee']);, dateHired
      */
      knex('employees').insert([
        { employee_id: 1, firstName: 'Patrick', lastName: 'Meaney',
          city: 'Fremont', state: 'CA', zipcode: '94539', phone: '123-456-1234',
          email: 'someEmail@gmail.com', employee_type: 'admin', dateHired: '2018-04-13'},

        { employee_id: 2, firstName: 'Elvis', lastName: 'Presley',
          city: 'Fremont', state: 'CA', zipcode: '94539', phone: '123-456-1234',
          email: 'someEmail@gmail.com', employee_type: 'manager', dateHired: '2018-04-28'},

        { employee_id: 3, firstName: 'John', lastName: 'Doe',
          city: 'Fremont', state: 'CA', zipcode: '94539', phone: '123-456-1234',
          email: 'someEmail@gmail.com', employee_type: 'employee', dateHired: '2018-04-13'},

        { employee_id: 4, firstName: 'Jane', lastName: 'Austen',
          city: 'Fremont', state: 'CA', zipcode: '94539', phone: '123-456-1234',
          email: 'someEmail@gmail.com', employee_type: 'employee', dateHired: '2018-04-13'}
      ]);

      knex('customers').insert([
        /*
        customers -- customer_id, firstName, lastName, city, state, zipcode, phone, email
        */

        {
          customer_id: 1, firstName: 'Sammy', lastName: 'Sosa', city: 'Fremont', state: 'CA', zipcode: '94539', phone: '123-456-1234',
          email: 'someEmail@gmail.com'
        },

        {
          customer_id: 2, firstName: 'Marilyn', lastName: 'Monroe', city: 'Fremont', state: 'CA', zipcode: '94539', phone: '123-456-1234',
          email: 'someEmail@gmail.com'
        },

        {
          customer_id: 3, firstName: 'Shirley', lastName: 'Temple', city: 'Fremont', state: 'CA', zipcode: '94539', phone: '123-456-1234',
          email: 'someEmail@gmail.com'
        },

      ]);



    ]); // end promise.all

  }); // last .then
};