How to use the sequelize function in sequelize

To help you get started, we’ve selected a few sequelize examples, based on popular ways it is used in public projects.

Secure your code as it's written. Use Snyk Code to scan source code in minutes - no build needed - and fix issues immediately.

github ronmamo / star / web-server / routes / sequelizeRouter.js View on Github external
import Sequelize from 'sequelize';
import bodyParser from 'body-parser';
import chalk from 'chalk';
import * as response from './response';
import config from '../config';

// sequelize
const conf = config.webserver.sequelize;

export const sequelize = new Sequelize(conf.database, conf.username, conf.password, conf.options);
if (!sequelize) {
  console.log(chalk.red.bold('Could not connect sequelize'), err);
}

const connect = (models, force = true) => {
  Object.keys(models).map(model => {
    return models[model](sequelize);
  });

  sequelize.authenticate()
    .then(() => {
      console.log(chalk.bold.green('Sequelize connected'), sequelize.config);
    }, (err) => {
      console.log(chalk.red.bold('Unable to connect to the database:'), err);
    });
github mtmendonca / ace-boilerplate / api / src / adapters / db / index.js View on Github external
import uuid from 'uuid';
import { SequelizeModel } from '../../types';

const session = createNamespace('atlas-express-app');
Sequelize.useCLS(session);

/**
 * If the model has an id field, presume it's a uuid field and populate it
 */
export const beforeCreate = (instance: SequelizeModel, { fields }: { fields: [string] }) => {
  if (instance.constructor.name !== 'AddonSettings' && fields.includes('id')) {
    instance.id = uuid.v4(); // eslint-disable-line
  }
};

export default new Sequelize(process.env.DATABASE_URL, {
  dialect: process.env.DB_DIALECT,
  define: {
    underscored: true,
    paranoid: true,
    freezeTableName: false,
    charset: process.env.DB_CHARSET || 'utf8',
    dialectOptions: {
      collate: process.env.DB_DIALECT_OPTIONS_COLLATE || 'utf8_general_ci',
    },
    timestamps: true,
    hooks: {
      beforeCreate,
    },
  },
  // pool configuration used to pool database connections
  pool: {
github bradleyboy / tuql / src / __tests__ / arguments.js View on Github external
import Sequelize from 'sequelize';
import { TEXT, INTEGER, REAL, NUMERIC, BLOB } from 'sequelize';

import {
  getPkFieldKey,
  makeCreateArgs,
  makeUpdateArgs,
  makeDeleteArgs,
  makePolyArgs,
} from '../builders/arguments';
import { GraphQLString, GraphQLNonNull, GraphQLInt } from 'graphql';

const db = new Sequelize({
  dialect: 'sqlite',
  storage: ':memory:',
  logging: false,
});

const model = db.define(
  'posts',
  {
    id: {
      type: INTEGER,
      primaryKey: true,
    },
    title: {
      type: TEXT,
      allowNull: true,
    },
github leohmoraes / rocketseat-02 / src / database / index.js View on Github external
init() {
    this.connection = new Sequelize(databaseConfig);

    models
      .map(model => model.init(this.connection))
      .map(model => model.associate && model.associate(this.connection.models));
  }
github plotly / falcon / backend / persistent / datastores / Sql.js View on Github external
* port is mutually exclusive with instance name
             * see https://github.com/sequelize/sequelize/issues/3097
             */
            options = omit(['port'], options);
            options.dialectOptions.instanceName = trimmedInstanceName;
        }
        ['connectTimeout', 'requestTimeout'].forEach(timeoutSetting => {
            if (has(timeoutSetting, connection) &&
                !isNaN(parseInt(connection[timeoutSetting], 10))) {
                options.dialectOptions[timeoutSetting] =
                    connection[timeoutSetting];
            }
        });
    }

    return new Sequelize(
        database, username, password, options,
    );
}
github atanasster / crypto-grommet / server / db / index.js View on Github external
import Sequelize from 'sequelize';
import config from '../config';

const connection = new Sequelize(process.env.DATABASE_URL || config.DATABASE_URL, {
  operatorsAliases: Sequelize.Op,
  host: 'localhost',
  dialect: 'postgres',
});

connection.authenticate()
  .then(() => {
    console.log('Database connection has been established successfully.');
  })
  .catch((err) => {
    console.error('Unable to connect to the database:', err);
  });

export default connection;
github ramsaylanier / WordExpressSchema / src / db.js View on Github external
connect() {
    const { name, username, password, host, port } = this.settings.privateSettings.database

    const Conn = new Sequelize(
      name,
      username,
      password,
      {
        logging: false,
        dialect: 'mysql',
        host: host,
        port: port || 3306,
        define: {
          timestamps: false,
          freezeTableName: true,
        }
      }
    )

    return Conn
github reactGo / reactGo / server / db / sequelize / models / index.js View on Github external
import Sequelize from 'sequelize';
import sequelizeConfig from '../sequelize_config';
import { ENV } from '../../../../config/env';
import tokenModel from './tokens';
import topicModel from './topics';
import userModel from './users';

const config = sequelizeConfig[ENV];

const db = {};
const dbUrl = process.env[config.use_env_variable];

const sequelize = dbUrl ? new Sequelize(dbUrl) : new Sequelize(config.database, config.username, config.password, config);

db.Token = sequelize.import('Token', tokenModel);
db.Topic = sequelize.import('Topic', topicModel);
db.User = sequelize.import('User', userModel);

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

export { db as Models, sequelize };
github ayakashi-io / ayakashi / src / coreScripts / saveToSQL.ts View on Github external
if (global[`dbconnection-${system.operationId}-${hashedParams}`]) {
        //@ts-ignore
        sequelize = global[`dbconnection-${system.operationId}-${hashedParams}`];
    } else {
        if (useStorage) {
            //@ts-ignore
            sequelize = new Sequelize({
                dialect: "sqlite",
                storage: useStorage,
                logging: false
            });
            //@ts-ignore
            global[`dbconnection-${system.operationId}-${hashedParams}`] = sequelize;
        } else if (params.connectionURI) {
            //@ts-ignore
            sequelize = new Sequelize(params.connectionURI, {
                pool: {
                    max: 1,
                    min: 1
                },
                logging: false
            });
            //@ts-ignore
            global[`dbconnection-${system.operationId}-${hashedParams}`] = sequelize;
        } else {
            //@ts-ignore
            sequelize = new Sequelize(params.database, params.username, params.password, {
                dialect: params.dialect,
                host: params.host || "localhost",
                port: params.port,
                pool: {
                    max: 1,

sequelize

Sequelize is a promise-based Node.js ORM tool for Postgres, MySQL, MariaDB, SQLite, Microsoft SQL Server, Amazon Redshift and Snowflake’s Data Cloud. It features solid transaction support, relations, eager and lazy loading, read replication and more.

MIT
Latest version published 26 days ago

Package Health Score

95 / 100
Full package analysis