TypeScript sequelize-typescript.Sequelize類代碼示例

import { Organization, Logger } from '.';

const chalk = require('chalk')
const now = () => new Date().toISOString().replace(/T/, ' ').replace(/Z/, '')
const logging = process.env.NODE_ENV === 'development'
  ? (sql: string) => {
    sql = sql.replace('Executing (default): ', '')
    console.log(`${chalk.bold('SQL')} ${now()} ${chalk.gray(sql)}`)
  }
  : console.log

const sequelize = new Sequelize({
  database: config.db.database,
  dialect: config.db.dialect,
  username: config.db.username,
  password: config.db.password,
  host: config.db.host,
  port: config.db.port,
  pool: config.db.pool,
  logging: config.db.logging ? logging : false
})

sequelize.addModels([__dirname + '/bo'])
sequelize.authenticate()
  .then((/* err */) => {

    // initialize hooks
    Organization.hook('afterCreate', async(instance: Organization) => {
      await Logger.create({
        userId: instance.creatorId,
        type: 'create',
        organizationId: instance.id

"use strict";

import { Sequelize } from "sequelize-typescript";

import { Account } from "./Account";
import { Provider } from "./Provider";

import { Database } from "../config/-index";

const env = process.env.NODE_ENV || "development";
const db  = Database[env];

const sequelize = new Sequelize({
  host      : db.host,
  database  : db.database,
  dialect   : db.dialect,
  username  : db.username,
  password  : db.password,
  operatorsAliases: false
});


sequelize.addModels([ Account, Provider ]);

export { sequelize, Sequelize };

import {Sequelize} from 'sequelize-typescript';
import { Stem, Track } from './models';

const env = process.env.NODE_ENV || "development";
const dbProdName = "implib.prod.sqlite";
const dbConfig = require(`${__dirname}/config/dbConfig.json`)[env];
const appConfig = require(`${__dirname}/../config/appConfig.json`)[env];

// TODO: Get these paths configured and available in a global settings file
//If in production, make sure to setup the DB in the user's app data folder
if(env === "production") {
  dbConfig.storage = path.join(
    require("electron").remote.app.getPath("appData"),
    appConfig.appName,
    dbProdName);
}
console.log("SQLite DB instantiated at [" + dbConfig.storage + "]");

const sequelize = new Sequelize(dbConfig);
sequelize.addModels([ Stem, Track]);
sequelize.sync({force: true});

const db = {
  sequelize,
  Sequelize,
  Stem: Stem,
  Track: Track
}

export default db;