YZ
если нужна связь не join а left join. то параметр require позволяет менять это
Size: a a a
2021 July 20
A
спасибо
2021 July 21
Kw
Good evening, I am on the backend of my application and during my design linked to the BDD, I had 2 association tables which group together 2 foreign keys at the same time primary key, and the problem I encounter when trying to model this with sequelize, if it's possible to give me a boost I would really appreciate it.
YZ
show your model
Kw
Kw
@Version81 that my post
2021 July 22
•
Hey guys! So I have this:
and I'm trying to do something like this:
Sequelize is generating this:
Can I change the "id" field to something else here ?
class AModel extends Model { }
class BModel extends Model { }
AModel.hasMany(BModel, { foreignKey: 'testFieldFromB' });
BModel.belongsTo(AModel);
and I'm trying to do something like this:
const a = await AModel.findByPk(1);
const b = await a.hasB(123); // returns a boolean value
Sequelize is generating this:
...
SELECT * FROM B where (B.testFieldFromB = 1 AND B.id = 123)
Can I change the "id" field to something else here ?
•
For example: B.abcKey = 123 not B.id = 123
ar
probably you should look for
foreignKey and targetKey
https://sequelize.org/master/manual/assocs.html•
Thanks for the answer. Could you show an example?
2021 July 23
Kw
No one knows what I should do?
YZ
i read, need to debug and read documentation
YZ
for answer
2021 July 24
Kw
To create my database I need to use the alter table because I have a lot of foreign key and I think in orm it not possible
R
Hello. I have a little question please about synchronisation between sequelize and phpmyadmin. I just understood that i need add a new fild in my table. I create that fild with vscode in my model of existing table. How can i update the modification?
R
Thanks
YZ
if it’s impossible by sync than you can use migration and create table by yourself
YZ
sync mechanism of orm or migration. look at docs please
R
Spasibo !
PK
Ребят подскажите. У меня живой чат на вебсокетах. Нужно когда посылаю клиенту историю сообщений нужно также послать ответы сообщений. Какую стратегию выбрать?