so I want to build a intventory Management database. My schema looks like this: Database Schema An Itemclass (screwdriver, hammer, measuring device,...) can have many items (screwdriver1, screwdriver2,...) Everything is fine and working as expected. But now i want to…
First of all, I tried my best through other stackoverflow posts and Googling, but the same error keeps occurring. docker run --rm --name mysql-container -e MYSQL_ROOT_PASSWORD=password -d -p 3305:3306 mysql:latest First, if I run the mysql container with the above…
I am trying to call 2 different .then() on the same Sequelize promise. I do not need to chain the then(), I just want to call 2 different effects when the promise is resolved. The first then() is called just…
`I am having an issue with a Quiz I am developing where I am logging the Score count at the end of each game. At the end of the game, I sent a PUT request to update my totalscore in…
let data = await Category.findAll({ where: { list_category_id: body.category_id }, attributes: { include: [ [ sequelize.literal(`COALESCE ( CASE WHEN youtube_id_id IS NOT NULL THEN ROW_NUMBER() OVER (ORDER BY random(), youtube_id_id) END, CASE WHEN instagram_id_id IS NOT NULL THEN ROW_NUMBER() OVER…
I'm starting out with Sequelize and got kind of stuck right there. I try to connect my controller, route, model and stuff and I get this error when trying to access my route (localhost:3000/api/carousel) : TypeError: Cannot read properties of…
This is my User Model module.exports = (sequelize, DataTypes) => { const User = sequelize.define("User", { email: { type: DataTypes.STRING, allowNull: false, unique: true }, password: { type: DataTypes.STRING, allowNull: false } }) return User } and i am try…
I am building a sequelize query. While doing some debugging I was surprised to find that I couldn't access the properties of my options.where object, but that console.log still returned the expected object structure. My question is (1) why does…
I'm using Nextjs 13 to create a full-stack app and use Sequelize to handle the MySQL database. I have api folder to handle my admin form. in src/pages/api/test.js when I call my model It works correctly and without error and…
I have a unique index for a model that's not working. Here is my model const Script = sequelize.define('Script', { name: { type: DataTypes.STRING, allowNull: false, }, deletedAt: { type: DataTypes.DATE, allowNull: true }, }, { indexes: [ { unique:…