时间戳

首页 > 解决方案 > 如何使 sequalize createTable 支持下划线？

format - 如何使 sequalize createTable 支持下划线？

问题描述

我试图使用 sequalize seed 来初始化表行，但我得到了错误返回：

关系“用户”的“createdAt”列不存在

它实际上是“created_at”作为字段，所以我的问题是如何使用蛇或下划线选项为表格播种？

我的种子代码如下：

"use strict";

module.exports = {
  up: (queryInterface, Sequelize) => {
    return queryInterface.bulkInsert(
      "users",
      [
        {
          firstname: "John",
          lastname: "Doe",
          email: "demo@demo.com",
          createdAt: new Date(),
          updatedAt: new Date()
        }
      ],
      {}
    );
  },

  down: (queryInterface, Sequelize) => {
    return queryInterface.bulkDelete("users", null, {});
  }
};

标签： formatsequelize.js

解决方案

您在定义数据库连接配置时传递这些信息，如下所示。

'use strict';
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(__dirname + '/../config/config.json')[env];
const db = {};
let sequelize;
if (config.use_env_variable) {
  sequelize = new Sequelize(process.env[config.use_env_variable], config);
} else {
    config.define = {
      "timestamps":true,
      "createdAt":"created_at",
      "updatedAt":"updated_at"
  }
  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;

module.exports = db;

这config是您的数据库配置。您将其他配置添加到单独的define

推荐阅读