How to make this code with the sequelize? I used include, but it brings all the user data but I only need the name my code: Answer If you just want to reduce User model attributes then just indicate needed attributes in the attributes option: If you want to add a user’s name as a string prop at the same
Tag: sequelize.js
Sequelize – is it possible to limit the number of record in junction table
There are 3 tables student_teacher, student, teacher with below relationship. Each teacher will be responsible for 5 students, so the relationship should be 1 to Many, but I decide to create a junction table for storing extra information for this relationship. When I create a student_teacher record, the paylo…
Order By two columns but have one order
This question is sequelize specific but I’d figure if I found a way to do in SQL then I could find a way to do it in sequelize I need for the request to be ordered back by user.fullname which is joined by using include and by mockUser.fullname which is a JSON field. One important thing to keep in mind
Sequelize – Include based on specific attribute
I have a model defined as follows: I’m trying to use Sequelize to load all game object and include the User with the id equal to the playerId field. The problem is I have two attributes (leaderId, playerId) which reference the User model so using include as follows does not work: Is there a way to speci…
SQL Query return extra column depending of condition
I want to make a query which will add a column depending of what condition is meet(I have tried with sequelize without obtaining the result that I wanted) therefore I want to try with plain SQL because It does not have as many limitations. EXAMPLE: SELECT * FROM db.messages WHERE user_id = userID OR $contacts…
How to pass a seed value to random order function in Sequelize
In SQL dialects you can sort by random and you can pass a seed to the random function in order to get a repeatable random order of rows. In MySQL you’d do it like this: SELECT * FROM `users` ORDER BY …
SQL database design: many to many relationship between ‘accounts’ and ‘transactions’ tables such that a transaction can have ‘from’ and ‘to’
I’m trying to create a many-to-many relationship between two tables: ‘accounts’ and ‘transactions’, but with a catch. Every transaction must be related to two accounts, but each of those accounts must be specified as either the sender or receiver. Likewise, each account should re…
Sequelize foreign key reference composite primary key
i’m trying to create with sequelize (postgre) ‘Ingredient’ table, with columns normalizedName/userId where normalizedName is unique per userId. The second table is ‘IngredientQuantity’, with columns …
sequelize updating multiple rows
Update multiple rows , is using a bulk update a good solution or something like the code below works ? . I supposed wanted to update all the records with the id and filename. I did try to update …
N:M Relationship between users and guests
I’m building an app that can assign guests to an existing user. Those guests can see some information about the users they are associated with. It’s N:M: Users can have multiple guests associated Guests can be associated to multiple users Under the hood they are stored in the same table, the only …