Define models to be used across multiple databases

[kartsims]

Sorry if this doesn't belong here but I am having an issue to re-use models across multiple databases. I think this is related to sequelize-typescript.

When I define my model I am able to add it to a sequelize instance, but when I add it to another instance it fails.

StackOverflow post

[RobinBuschmann]

Hey @kartsims, you could use the respositoryMode for that. This mode lets you re-use your models. See https://github.com/RobinBuschmann/sequelize-typescript#how-to-enable-repository-mode for details.

[kangzj]

@RobinBuschmann hey awesome work man.
Just got a question here as well. I found out how to create / find using repository mode, but how to do updates and deletes?
Can I please have some examples? As sequelize static update/delete are all for bulk operations.
Thanks.

[RobinBuschmann]

Hey @kangzj , save and update should still work on your instances (instance.save();) So the created objects are still active records.
Otherwise you have to do it like you said: Using repository.update/delete like so:
await MyModel.update(instance.toJSON(), {where: {id: instance.id}});

Hope this helps.

[redevill]

Still on the topic of the re-use models / repository mode:
My understanding (and it seems to work in practice) is the following.

const myRepo1 = sequelizeConnection1.getRepository(MyModel);
const myRepo2 = sequelizeConnection2.getRepository(MyModel);

Now when I do something like myRepo1.findAll() the data is distinct from myRepo2.findAll() according to the respective databases that are connected to the instances of sequelize above.

Now, I was wondering, how to protect against someone writing this code in the repository mode:
MyModel.findAll() ?? not using the repository but the Model directly...
Not sure where the data would be sourced for this? or if it would work?

[redevill]

... AAAhhh - clever:
With respect to my own question above, I did a test (MyModel.findAll() ), and got the following error.
"Error: Model not initialized: Member "findAll" cannot be called. "MyModel" needs to be added to a Sequelize instance."
In repository mode, the models that were defined previously, no longer respond, as don't appear to be registered with the sequelize instance.

[redevill]

Still on the topic of the re-use models / repository mode:
(Maybe I get to answer my own question again ;))

Can transactions be used with the repository model. So far, did not have much luck. Is there a trick?

[ghost]

Can transactions be used with the repository model. So far, did not have much luck. Is there a trick?

Start the transaction using the sequelizeConnection object rather than the repository instance.

[redevill]

That's the trick - THANK YOU.