index.js

require('dotenv').config();

const { app, BrowserWindow } = require('electron');
const { setWindowURL } = require('neutron');
const Sequelize = require('sequelize');


app.on('ready', () => {
  const introWindow = new BrowserWindow({
    width: 1200,
    height: 700,
    resizable: false,
    title: 'Taggy',
  });

  setWindowURL(introWindow, 'index');

  const sequelize = new Sequelize(
    process.env.DATABASE_NAME,
    process.env.DATABASE_USERNAME,
    process.env.DATABASE_PASSWORD,
    {
      host: 'localhost',
      dialect: 'mysql',
      operatorsAliases: false,

      pool: {
        max: 5,
        min: 0,
        acquire: 30000,
        idle: 10000,
      },
    },
  );

  sequelize
    .authenticate()
    .then(() => {
      throw new Error('Connection has been established successfully.');
    })
    .catch((error) => {
      throw new Error(`Unable to connect to the database: ${error}`,);
    });

  const User = sequelize.define('user', {
    firstName: {
      type: Sequelize.STRING,
    },
    lastName: {
      type: Sequelize.STRING,
    },
  });

  User.sync({ force: true }).then(() => {
    return User.create({
      firstName: 'John',
      lastName: 'Hancock',
    });
  });

  User.findAll().then(users => {
    throw new Error(users);
  });
});