gpt4 book ai didi

node.js - sequelize 种子无法在 SQLite 中插入数据

转载 作者:行者123 更新时间:2023-12-03 22:41:35 26 4
gpt4 key购买 nike

我正在尝试使用 sequelize-cli 命令插入虚拟数据
sequelize db:seed --seed seeders/20170212081140-subject_tags.js
这是我的配置文件

{
"development": {
"username": "root",
"password": null,
"database": "database_development",
"host": "127.0.0.1",
"dialect": "sqlite",
"seederStorage": "sequelize",
"storage": "./test"
}
}

这里是我的播种机文件
use strict';

module.exports = {
up: function(queryInterface, Sequelize) {

return
queryInterface.bulkUpdate('subject_tags', [

{
tag: 'agricultural-sciences',
tag_description: '',
subject_category: 'biological_&_medical_sciences',
createdAt: new Date(),
updatedAt: new Date()
}, {
tag: 'biochemistry',
tag_description: '',
subject_category: 'biological_&_medical_sciences',
createdAt: new Date(),
updatedAt: new Date()
}, {
tag: 'bioinformatics',
tag_description: '',
subject_category: 'biological_&_medical_sciences',
createdAt: new Date(),
updatedAt: new Date()
}
] , {});
},

down: function(queryInterface, Sequelize) {
return
queryInterface.bulkDelete('subject_tags', null, {});

}
};

虽然我得到了状态
Using environment "development".
== 20170212081140-subject_tags: migrating =======
== 20170212081140-subject_tags: migrated (0.053s)

我在种子文件中尝试了 bulkCreatebulkInsert ,它们都运行成功,但数据没有插入到表中
数据没有被插入。我做错了什么吗?

最佳答案

sequlizer 似乎有问题,在 return 语句之后它无法处理带有换行符的空格

module.exports = {
up: function(queryInterface, Sequelize) {
//old code
//return
// queryInterface.bulkUpdate('subject_tags', [

//new code
return queryInterface.bulkUpdate('subject_tags', [
//.........

关于node.js - sequelize 种子无法在 SQLite 中插入数据,我们在Stack Overflow上找到一个类似的问题: https://stackoverflow.com/questions/42326156/

26 4 0
Copyright 2021 - 2024 cfsdn All Rights Reserved 蜀ICP备2022000587号
广告合作:1813099741@qq.com 6ren.com