node.js - 如何 INSERT 到包含自动生成值(如 "createdAt"和 "updatedAt")的列的表？

Question

我刚开始使用 express.js 和 postgresql 开发 API。

我只是想插入一个表，但不知道这样做的合适方法。

我正在尝试做的请求:(在我知道其他列是自动创建之前，我创建了一个列 'dateCreated')

router.post('/', (req, res, next) => {
    models.sequelize.query("INSERT INTO carts ("dateCreated") VALUES (?,?,?)").then(() => {
            console.log("done")
        });
});

PSQL 购物车表

购物车型号:

module.exports = (sequelize, DataTypes) => {
    const Cart = sequelize.define("cart", {
        id: {
            type: DataTypes.INTEGER,
            primaryKey: true,
            autoIncrement: true,
        },
        dateCreated: DataTypes.STRING
    });
    return Cart;
}

Sequelize 设置(index.js):

const Sequelize = require('sequelize');

const sequelize = new Sequelize('shoptest', 'neymgm', 'password', {
  dialect: 'postgres',
  operatorsAliases: false,
  // logging: true
})

const models = {
  Cart: sequelize.import('./cart'),
  CartItem: sequelize.import('./cartItem'),
  Product: sequelize.import('./product'),
};

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

models.sequelize = sequelize;
models.Sequelize = Sequelize;

module.exports = models;

Answer 1

试试这个……它会自动生成dateCreated

module.exports = (sequelize, DataTypes) => {
    const Cart = sequelize.define("cart", {
        id: {
            type: DataTypes.INTEGER,
            primaryKey: true,
            autoIncrement: true,
        }
    }, { dateCreated: 'Created'});
    return Cart;
}