sequelize.js – Page 2

Node + Sequelize: How to check if item exists before adding? (async confusion)

December 16, 2023 by Tarik

Author.count isn’t really needed, unless you need the count. See findOrCreate(). With findOrCreate() you could have the following. (Edited trex005’s snippet for this) async.eachSeries(authors, function(item, callback) { Author.sync().then(function() { Author.findOrCreate({ where: { name: item.trim() }, defaults: { // set the default properties if it doesn’t exist name: item.trim() } }).then(function(result) { var author = result[0], … Read more

Set defaultValue to todays date in a Sequelize migration

December 8, 2023 by Tarik

You need to use as a default value the MySQL function NOW(). So your column declaration should look like : { type: Sequelize.DATEONLY, allowNull: false, defaultValue: Sequelize.NOW } Keep in mind that this will not populate the fields in your migration. They will be empty, since they were not created with sequelize.

Sequelize composite unique constraint

December 8, 2023 by Tarik

Recently, in V4, Sequelize has a method addConstraint on the query interface: queryInterface.addConstraint(‘Items’, { fields: [‘minor’, ‘major’], type: ‘unique’, name: ‘custom_unique_constraint_name’ });

How to get the ID of an inserted or updated record in Sequelize upsert?

December 1, 2023 by Tarik

I don’t think that returning the upserted record was available when the OP asked this question, but it has since been implemented with this PR. As of Sequelize v4.32.1, you can pass a boolean returning as a query param to select between returning an array with the record and a boolean, or just a boolean … Read more

How to insert initial data using sequelize migrations/seeds?

September 23, 2023 by Tarik

You can use next: const City = sequelize.define(‘city’, { name: { type: Sequelize.STRING }, order_: { type: Sequelize.INTEGER } }); City.sync().then(() => { City.create({ name: ‘Neuquen’, order_: 0 }); City.create({ name: ‘General Roca’, order_: 1 }); }); Or read about “migrations” at http://docs.sequelizejs.com/en/latest/docs/migrations/

GraphQL queries with tables join using Node.js

September 23, 2023 by Tarik

The concept you are refering to is called batching. There are several libraries out there that offer this. For example: Dataloader: generic utility maintained by Facebook that provides “a consistent API over various backends and reduce requests to those backends via batching and caching” join-monster: “A GraphQL-to-SQL query execution layer for batch data fetching.”

How to prevent sql-injection in nodejs and sequelize? [closed]

September 23, 2023 by Tarik

Sequelize escapes replacements, which avoids the problem at the heart of SQL injection attacks: unescaped strings. It also supports binding parameters when using SQLite or PostgreSQL, which alleviates the risk further by sending the parameters to the database separately to the query, as documented here: Bind parameters are like replacements. Except replacements are escaped and … Read more

Want to get crystal clear about NodeJS app structure (Full JavaScript Stack) [closed]

September 22, 2023 by Tarik

Alright, this is a pretty broad question and I’m definitely no expert, but I’ll do my best here. TL;DR routes are controllers that tell what logic to execute when a user navigates their browser to a certain path within your app, including which views to render and what data to send to those views models … Read more

Check mysql connection in sequelize

September 19, 2023 by Tarik

As of latest version of Sequelize (i.e. 3.3.2), authenticate can be used to check the connection: var sequelize = new Sequelize(“db”, “user”, “pass”); sequelize.authenticate().then(function(errors) { console.log(errors) }); authenticate simply runs SELECT 1+1 AS result query to check the db connection. UPDATE: Errors by the newest API need to be handled in catch: sequelize .authenticate() .then(() … Read more

Error [ERR_UNSUPPORTED_DIR_IMPORT]: Directory import when attempting to start Nodejs App locally

September 18, 2023 by Tarik

Explicitly, point to your main file (usually index.js). E. g. import … from ‘./models’ // ❌ import … from ‘./models/index.js’ // ✅ Alternative way (see the below UPDATE): Use –experimental-specifier-resolution=node flag. For example: node –experimental-specifier-resolution=node main.js See: https://nodejs.org/api/esm.html#esm_customizing_esm_specifier_resolution_algorithm UPDATE (Node.js v19+): Node.js has removed the –experimental-specifier-resolution flag. Its functionality can now be achieved via custom … Read more