python (65.2k questions)

javascript (44.3k questions)

reactjs (22.7k questions)

java (20.8k questions)

c# (17.4k questions)

html (16.3k questions)

r (13.7k questions)

android (13k questions)

Questions - sequelize.js

Sequelize Insert transaction (two tables, multiple rows)

Two tables: post and post_resources. The logic I want to implement: Whenever I add data to post table, I want to add resources as well to the post_resources table, with the same foreign key of PostId ...
test-img

Mr Smiley

transactions

sequelize.js

multiple-insert

Votes: 0

Answers: 1

Latest Answer

You used await and then in the same time, which is a mistake because they are similar. Your error says that you already commited the transaction so a solution would be like this: const post = { n...
test-img

Alexandru DuDu

MySQL + Sequelize - tables was created with a capital letter, but Sequelize generate query with a lower letter

I have such Sequelize migration: await queryInterface.createTable("Organizations", { ... but in some moments the Sequelize generated request in this way: ALTER TABLE `organizations`... wit...
test-img

Vladimir Mironov

mysql

sql

node.js

sequelize.js

Votes: 0

Answers: 1

Latest Answer

Sequlize models have 2 options that can help you. tableName https://sequelize.org/docs/v6/core-concepts/model-basics/#providing-the-table-name-directly freezeTableName https://sequelize.org/docs/v6/c...
test-img

Aaron613

not null violation: model.field cannot be null

I have sequelize models and everything is synced up with the db: supplier: class Suppliers extends Model {} Suppliers.init({ id: { type: DataTypes.UUID, defaultValue: DataTypes.UUIDV4,...
test-img

Abdulsalam Almahdi

javascript

next.js

sequelize.js

mysql2

Votes: 0

Answers: 1

Latest Answer

You shouldn't wrap all fields into values prop. Just pass them directly: nwUser = await Suppliers.create({name:user.name, password:user.hash, email:user.email, phone: user.phone, firstName: user.first...
test-img

Anatoly

How to perform chaining in sequelize association?

Suppose i have 3 models. Model 1: (author) hasMany: books Model 2: (book) belongsTo: author hasOne: category foreign key: authorId Model 3: (category) belongsTo: book foreign key: bookId Now if i do, ...
test-img

abhisek mishra

node.js

sequelize.js

Votes: 0

Answers: 1

Latest Answer

On Sequelize v6, you can perform a nested eager loading as follows: author.findOne({ where: {id: 1}, include: { model: Book, include: { model: Category } } }) Note that Book a...
test-img

hawschiat

Posts

Questions

Blogs

Jobs