A
Now when i add i want this to be 1,2 = 2,1
Size: a a a
2020 September 29
A
Photo from AN1RUDH
A
This is how i am trying to add this relationship
YZ
Where do u define UserOne?
A
UserOne is here, i am trying to use self association
YZ
UserOne is here, i am trying to use self association
I think u need to check methods in user object
A
Now when i add i want this to be 1,2 = 2,1
i want something like this in db, so that if 1,2 is there then 2,1 should not be allowed
2020 October 04
M
Hello
I want get last 5 records in order.
I found this:
SELECT * FROM mytable ORDER BY rec_date DESC LIMIT 5;
And as it inverses ordering, I have to do this, instead:
SELECT *
FROM (SELECT * FROM mytable ORDER BY rec_date DESC LIMIT 5)
ORDER BY rec_date ASC;
How do you do the second query in Sequelize?
I want get last 5 records in order.
I found this:
SELECT * FROM mytable ORDER BY rec_date DESC LIMIT 5;
And as it inverses ordering, I have to do this, instead:
SELECT *
FROM (SELECT * FROM mytable ORDER BY rec_date DESC LIMIT 5)
ORDER BY rec_date ASC;
How do you do the second query in Sequelize?
YZ
Look final sql query and coreecting by it
M
?
I'm rather noob, and my problem is how to order After a limiting, in sequelize.
I'm rather noob, and my problem is how to order After a limiting, in sequelize.
YZ
If i remember correct limit don't work in subquery, needto check
M
I handled it by Array.inverse for now, but if someone found better solution, share it please.
2020 October 06
AG
Hi guys, how can I remove read-only DB connection from pool in pool.validate?
AG
Or is there a hook for Sequelize errors?
2020 October 09
in
Hi guys, please send me guide how to get include queries?
in
Postgres
YZ
Hi guys, please send me guide how to get include queries?
Look in pinned
2020 October 12
in
Look in pinned
I saw, there is just good answers for associations, but im need querying
YZ
I saw, there is just good answers for associations, but im need querying
What do you mean?