index.js

import fs from 'fs';
import path from 'path';
import Sequelize from 'sequelize';
import sqlite from 'sqlite3';
import {
    app,
    remote
} from 'electron';

const basename = path.basename(__filename);
const env = process.env.NODE_ENV || 'development';

const config = {
    "dialect": "sqlite",
    "storage": path.join((remote || {
        app
    }).app.getPath('userData'), '/timingExport.data')
};

const db = {};

let sequelize = new Sequelize(config.database, config.username, config.password, config);

fs
    .readdirSync(__dirname)
    .filter(file => {
        return (file.indexOf('.') !== 0) && (file !== basename) && (file.slice(-3) === '.js');
    })
    .forEach(file => {
        const model = sequelize['import'](path.join(__dirname, file));
        db[model.name] = model;
    });

Object.keys(db).forEach(modelName => {
    if (db[modelName].associate) {
        db[modelName].associate(db);
    }
});

db.sequelize = sequelize;
db.Sequelize = Sequelize;

export default db;

log-output

yarn dev
yarn run v1.12.3
$ cross-env START_HOT=1 node -r @babel/register ./internals/scripts/CheckPortInUse.js && cross-env START_HOT=1 yarn start-renderer-dev
$ cross-env NODE_ENV=development webpack-dev-server --config configs/webpack.config.renderer.dev.babel.js

Starting Main Process...
npm WARN lifecycle The node binary used for scripts is /var/folders/_q/z623twbs5yj1b6rzhddsbq2h0000gn/T/yarn--1545278355762-0.6111509485724897/node but npm is using /Users/lordzardeck/.nvm/versions/node/v10.12.0/bin/node itself. Use the `--scripts-prepend-node-path` option to include the path for the node binary npm was executed with.

> electron-react-boilerplate@0.17.1 start-main-dev electron-monorepo/packages/electron-app
> cross-env HOT=1 NODE_ENV=development electron -r ./internals/scripts/RegisterBabelWithOptions.js ./app/main.dev.js

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 ../../node_modules/sequelize/lib/sequelize.js:242:13
    Executing (default): CREATE TABLE IF NOT EXISTS `tasks` (`id` INTEGER PRIMARY KEY AUTOINCREMENT, `name` VARCHAR(255), `createdAt` DATETIME NOT NULL, `updatedAt` DATETIME NOT NULL);
Executing (default): PRAGMA INDEX_LIST(`tasks`)
Executing (default): PRAGMA INDEX_INFO(`tasks_project_id_task_id_task_date`)
    [21:59:18.297] [info] Skip checkForUpdatesAndNotify because application is not packed
2018-12-19 21:59:18.524 Electron[15793:239771] *** WARNING: Textured window <EventDispatchingWindow: 0x7f900c474c40> is getting an implicitly transparent titlebar. This will break when linking against newer SDKs. Use NSWindow's -titlebarAppearsTransparent=YES instead.
2018-12-19 21:59:18.732 Electron Helper[15802:239958] Couldn't set selectedTextBackgroundColor from default ()
✖ ｢wdm｣:
ERROR in electron-monorepo/node_modules/node-pre-gyp/lib/info.js
Module not found: Error: Can't resolve 'aws-sdk' in 'electron-monorepo/node_modules/node-pre-gyp/lib'
@ electron-monorepo/node_modules/node-pre-gyp/lib/info.js 14:14-32
@ electron-monorepo/node_modules/node-pre-gyp/lib sync ^\.\/.*$
@ electron-monorepo/node_modules/node-pre-gyp/lib/node-pre-gyp.js
@ electron-monorepo/node_modules/sqlite3/lib/sqlite3.js
@ ../database/models/index.js
@ ./app/containers/App.js
@ ./app/Routes.js
@ ./app/containers/Root.js
@ ./app/index.js
@ multi (webpack)-dev-server/client?http://localhost:1212 (webpack)/hot/dev-server.js react-hot-loader/patch webpack-dev-server/client?http://localhost:1212/ webpack/hot/only-dev-server ./app/index.js

    ERROR in electron-monorepo/node_modules/node-pre-gyp/lib/publish.js
Module not found: Error: Can't resolve 'aws-sdk' in 'electron-monorepo/node_modules/node-pre-gyp/lib'
@ electron-monorepo/node_modules/node-pre-gyp/lib/publish.js 18:14-32
@ electron-monorepo/node_modules/node-pre-gyp/lib sync ^\.\/.*$
@ electron-monorepo/node_modules/node-pre-gyp/lib/node-pre-gyp.js
@ electron-monorepo/node_modules/sqlite3/lib/sqlite3.js
@ ../database/models/index.js
@ ./app/containers/App.js
@ ./app/Routes.js
@ ./app/containers/Root.js
@ ./app/index.js
@ multi (webpack)-dev-server/client?http://localhost:1212 (webpack)/hot/dev-server.js react-hot-loader/patch webpack-dev-server/client?http://localhost:1212/ webpack/hot/only-dev-server ./app/index.js

    ERROR in electron-monorepo/node_modules/node-pre-gyp/lib/unpublish.js
Module not found: Error: Can't resolve 'aws-sdk' in 'electron-monorepo/node_modules/node-pre-gyp/lib'
@ electron-monorepo/node_modules/node-pre-gyp/lib/unpublish.js 16:14-32
@ electron-monorepo/node_modules/node-pre-gyp/lib sync ^\.\/.*$
@ electron-monorepo/node_modules/node-pre-gyp/lib/node-pre-gyp.js
@ electron-monorepo/node_modules/sqlite3/lib/sqlite3.js
@ ../database/models/index.js
@ ./app/containers/App.js
@ ./app/Routes.js
@ ./app/containers/Root.js
@ ./app/index.js
@ multi (webpack)-dev-server/client?http://localhost:1212 (webpack)/hot/dev-server.js react-hot-loader/patch webpack-dev-server/client?http://localhost:1212/ webpack/hot/only-dev-server ./app/index.js

    ERROR in electron-monorepo/node_modules/sequelize/lib/dialects/postgres/hstore.js
Module not found: Error: Can't resolve 'pg-hstore' in 'electron-monorepo/node_modules/sequelize/lib/dialects/postgres'
@ electron-monorepo/node_modules/sequelize/lib/dialects/postgres/hstore.js 3:15-35
@ electron-monorepo/node_modules/sequelize/lib/dialects/postgres/data-types.js
@ electron-monorepo/node_modules/sequelize/lib/data-types.js
@ electron-monorepo/node_modules/sequelize/lib/sequelize.js
@ electron-monorepo/node_modules/sequelize/index.js
@ ../database/models/index.js
@ ./app/containers/App.js
@ ./app/Routes.js
@ ./app/containers/Root.js
@ ./app/index.js
@ multi (webpack)-dev-server/client?http://localhost:1212 (webpack)/hot/dev-server.js react-hot-loader/patch webpack-dev-server/client?http://localhost:1212/ webpack/hot/only-dev-server ./app/index.js

    ERROR in electron-monorepo/node_modules/sequelize/lib/dialects/mssql/query.js
Module not found: Error: Can't resolve 'tedious' in 'electron-monorepo/node_modules/sequelize/lib/dialects/mssql'
@ electron-monorepo/node_modules/sequelize/lib/dialects/mssql/query.js 10:14-32
@ electron-monorepo/node_modules/sequelize/lib/dialects/mssql/index.js
@ electron-monorepo/node_modules/sequelize/lib/sequelize.js
@ electron-monorepo/node_modules/sequelize/index.js
@ ../database/models/index.js
@ ./app/containers/App.js
@ ./app/Routes.js
@ ./app/containers/Root.js
@ ./app/index.js
@ multi (webpack)-dev-server/client?http://localhost:1212 (webpack)/hot/dev-server.js react-hot-loader/patch webpack-dev-server/client?http://localhost:1212/ webpack/hot/only-dev-server ./app/index.js
    Not rewriting GET /dist/renderer.dev.js because the path includes a dot (.) character.
✖ ｢wdm｣:
ERROR in electron-monorepo/node_modules/node-pre-gyp/lib/info.js
Module not found: Error: Can't resolve 'aws-sdk' in 'electron-monorepo/node_modules/node-pre-gyp/lib'
@ electron-monorepo/node_modules/node-pre-gyp/lib/info.js 14:14-32
@ electron-monorepo/node_modules/node-pre-gyp/lib sync ^\.\/.*$
@ electron-monorepo/node_modules/node-pre-gyp/lib/node-pre-gyp.js
@ electron-monorepo/node_modules/sqlite3/lib/sqlite3.js
@ ../database/models/index.js
@ ./app/containers/App.js
@ ./app/Routes.js
@ ./app/containers/Root.js
@ ./app/index.js
@ multi (webpack)-dev-server/client?http://localhost:1212 (webpack)/hot/dev-server.js react-hot-loader/patch webpack-dev-server/client?http://localhost:1212/ webpack/hot/only-dev-server ./app/index.js

    ERROR in electron-monorepo/node_modules/node-pre-gyp/lib/publish.js
Module not found: Error: Can't resolve 'aws-sdk' in 'electron-monorepo/node_modules/node-pre-gyp/lib'
@ electron-monorepo/node_modules/node-pre-gyp/lib/publish.js 18:14-32
@ electron-monorepo/node_modules/node-pre-gyp/lib sync ^\.\/.*$
@ electron-monorepo/node_modules/node-pre-gyp/lib/node-pre-gyp.js
@ electron-monorepo/node_modules/sqlite3/lib/sqlite3.js
@ ../database/models/index.js
@ ./app/containers/App.js
@ ./app/Routes.js
@ ./app/containers/Root.js
@ ./app/index.js
@ multi (webpack)-dev-server/client?http://localhost:1212 (webpack)/hot/dev-server.js react-hot-loader/patch webpack-dev-server/client?http://localhost:1212/ webpack/hot/only-dev-server ./app/index.js

    ERROR in electron-monorepo/node_modules/node-pre-gyp/lib/unpublish.js
Module not found: Error: Can't resolve 'aws-sdk' in 'electron-monorepo/node_modules/node-pre-gyp/lib'
@ electron-monorepo/node_modules/node-pre-gyp/lib/unpublish.js 16:14-32
@ electron-monorepo/node_modules/node-pre-gyp/lib sync ^\.\/.*$
@ electron-monorepo/node_modules/node-pre-gyp/lib/node-pre-gyp.js
@ electron-monorepo/node_modules/sqlite3/lib/sqlite3.js
@ ../database/models/index.js
@ ./app/containers/App.js
@ ./app/Routes.js
@ ./app/containers/Root.js
@ ./app/index.js
@ multi (webpack)-dev-server/client?http://localhost:1212 (webpack)/hot/dev-server.js react-hot-loader/patch webpack-dev-server/client?http://localhost:1212/ webpack/hot/only-dev-server ./app/index.js

    ERROR in electron-monorepo/node_modules/sequelize/lib/dialects/postgres/hstore.js
Module not found: Error: Can't resolve 'pg-hstore' in 'electron-monorepo/node_modules/sequelize/lib/dialects/postgres'
@ electron-monorepo/node_modules/sequelize/lib/dialects/postgres/hstore.js 3:15-35
@ electron-monorepo/node_modules/sequelize/lib/dialects/postgres/data-types.js
@ electron-monorepo/node_modules/sequelize/lib/data-types.js
@ electron-monorepo/node_modules/sequelize/lib/sequelize.js
@ electron-monorepo/node_modules/sequelize/index.js
@ ../database/models/index.js
@ ./app/containers/App.js
@ ./app/Routes.js
@ ./app/containers/Root.js
@ ./app/index.js
@ multi (webpack)-dev-server/client?http://localhost:1212 (webpack)/hot/dev-server.js react-hot-loader/patch webpack-dev-server/client?http://localhost:1212/ webpack/hot/only-dev-server ./app/index.js

    ERROR in electron-monorepo/node_modules/sequelize/lib/dialects/mssql/query.js
Module not found: Error: Can't resolve 'tedious' in 'electron-monorepo/node_modules/sequelize/lib/dialects/mssql'
@ electron-monorepo/node_modules/sequelize/lib/dialects/mssql/query.js 10:14-32
@ electron-monorepo/node_modules/sequelize/lib/dialects/mssql/index.js
@ electron-monorepo/node_modules/sequelize/lib/sequelize.js
@ electron-monorepo/node_modules/sequelize/index.js
@ ../database/models/index.js
@ ./app/containers/App.js
@ ./app/Routes.js
@ ./app/containers/Root.js
@ ./app/index.js
@ multi (webpack)-dev-server/client?http://localhost:1212 (webpack)/hot/dev-server.js react-hot-loader/patch webpack-dev-server/client?http://localhost:1212/ webpack/hot/only-dev-server ./app/index.js

tasks.js

export default (sequelize, DataTypes) => {
    const tasks = sequelize.define('tasks', {
        name: DataTypes.STRING
    }, {});
    tasks.associate = function(models) {
        // associations can be defined here
    };
    return tasks;
};