Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- const path = require('path');
- module.exports = {
- test: {
- username: 'root',
- password: 'root',
- database: path.join(__dirname, '..', 'database_test.sqlite'),
- host: 'localhost',
- dialect: 'sqlite',
- logging: console.log,
- operatorsAliases: false
- }
- };
- 'use strict';
- module.exports = {
- up: (queryInterface, Sequelize) => queryInterface.createTable('appeals', {
- appealId: {
- allowNull: false,
- primaryKey: true,
- type: Sequelize.UUID
- },
- name: {
- allowNull: false,
- type: Sequelize.STRING
- },
- description: {
- type: Sequelize.STRING(511)
- },
- createdAt: {
- allowNull: false,
- type: Sequelize.DATE
- },
- updatedAt: {
- allowNull: false,
- type: Sequelize.DATE
- }
- }),
- down: queryInterface => queryInterface.dropTable('appeals')
- };
- const fs = require('fs');
- const path = require('path');
- const Sequelize = require('sequelize');
- const basename = path.basename(__filename);
- const env = process.env.NODE_ENV || 'development';
- const config = require(path.join(__dirname, '..', 'config', 'config.js'))[env];
- const db = {};
- let sequelize = new Sequelize(config.database, config.username, config.password, config);
- fs
- .readdirSync(__dirname)
- .filter(file => (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;
- module.exports = db;
- 'use strict';
- module.exports = (sequelize, DataTypes) => {
- const Appeal = sequelize.define('appeals', {
- appealId: {
- allowNull: false,
- defaultValue: DataTypes.UUIDV4,
- primaryKey: true,
- type: DataTypes.UUID,
- validate: {
- isUUID: 4
- },
- get() {
- return this.getDataValue('appealId').toLowerCase();
- }
- },
- name: {
- type: DataTypes.STRING,
- allowNull: false
- },
- description: {
- type: DataTypes.STRING(511)
- }
- }, {
- tableName: 'appeals'
- });
- Appeal.associate = models => {
- // associations can be defined here
- };
- return Appeal;
- };
- const path = require('path');
- module.exports = {
- development: {
- username: 'root',
- password: 'root',
- database: path.join(__dirname, '..', 'database_test.sqlite'),
- host: 'localhost',
- dialect: 'sqlite',
- logging: true,
- operatorsAliases: false
- }
- };
- const path = require('path');
- module.exports = {
- 'models-path': path.resolve('./models'),
- 'seeders-path': path.resolve('./seeders'),
- 'migrations-path': path.resolve('./migrations'),
- 'config': path.resolve('./config', 'config.js')
- };
Add Comment
Please, Sign In to add comment