Advertisements I have a for loop. And I inserted each value into a table. After that when I query using findAll/findOne method, it says null. I want to get the data of User_Paper table after executing for loop. const newPaper = new Paper({ title, abstract, contributor, contributor: authors, paper_file: file, paper_topicId: ptopic.id, categoryId: c1.id, postingDate,… Read More How to execute find all method after executing for loop in Sequelize Node.Js?

Advertisements My sequelize.js query is not giving me correct result, I am trying to create a query based on the below sql query: select views from userblogs where id=4; current sequelize.js one- this is not working . Could someone please advise what correction need to do const usersBlogSchema = require(‘./modals/userblogs’); const BlogModel = usersBlogSchema(sequelize, DataTypes);… Read More How can I get a column based on id using sequelize query

Advertisements I am using postgres I want to create self-reference many-to-many association for the User model as User can follow many users and can be followed by many users but I got this error User is not associated to Follow this is User model class UserModel extends Model implements User { readonly id!: number; email!:… Read More Sequelize.ts – "is not associated to"

Advertisements While trying to save data into postgres database using sequelize BlogModel.create() system failed to save the data into table and server is returning columns createdat, updatedat, multiple times in console. ( please see below ). In the scheme I have added the column only once, can someone advise on this issue here ? Executing… Read More Failed to save data into postgres database using sequelize.js, but system return column multiple times

Advertisements How could I simplify this action below. I realize this is ridiculous. But everything I’m trying to do, either one works and one doesn’t and vice versa. I need to send data if this field is not empty. if it is empty, then don’t send it: admin|power it’s either null or not const mreq… Read More JS is or is not if else

Advertisements Let’s say I have two tables. Animals: animal_Id name color 1 Mouse Yellow 2 Elephant Green 3 Mouse Red 4 Bear Purple Zoo: cage_Id size animal_Id (foreign key) 1 Large 2 2 Small 1 3 Small 3 Am I right in assuming that I could create code which would: Allow a user to view… Read More Am I misunderstanding how foreign keys work? Using Sequelize

Advertisements I have looked extensively for an answer but could not find a simple solution. I have a table that contains a column subscriptionHistory The data can look like so: [ { "fromDate": "2023-01-24T10:11:57.150Z", "userSubscribedToo": "EuuQ13" }, { "fromDate": "2022-01-24T10:11:57.150Z", "tillDate": "2022-02-24T22:59:59.999Z", "userSubscribedToo": "a4ufoAB" } ] I’m trying to find the records of the subscriptions.… Read More sequelize, query property on array of objects

Advertisements Let’s say you have 4 types of data that are displayed similarly across 4 pages of a website like videos, articles, posts, etc. Would you have individual routes to get the most recent 10 for each like /type1/getall, /type2/getall, etc…, Or would you have one route like getAllByType that takes the type as a… Read More How would you structure these rest api endpoints

Advertisements I have a table of book users and a table of movie users. I’m trying to return a list of the top 100 movie viewers, along with their book profile information. I want to join on ids, but I can’t seem to find the right syntax. This is what I’ve tried: const mostActiveMovieWatchers =… Read More Sequelize join two tables on id

Advertisements Working on an already setup db and also new to sequelize. I have like four tables customer library books excerpt excerpt has redundant book_id from books. books has redundant library_id from library, and library has redundant customer_id from customer. They were not declared foreign in db but its kinda acting the foreign key type… Read More sequelize join up the tables