0

I have a situation where the model in the database does not match the model in the API. Specifically, my products' API contains contract price, which is in a separate table, and that table has price specific to each customer/product combination.

Outside of StrongLoop, I would typically solve this with custom/native SQL, but I read in the documentation that such is ill advised in StrongLoop. I have other situations like this where the database model does not efficiently represent the API model, typically due to legacy data definitions in the databases.

  1. Should I go down the path of custom/native SQL anyway?
  2. If so, are there examples and/or best practices I should follow?
  3. If not, what other ways should I solve the problem?
antinome
  • 3,408
  • 28
  • 26
Scot
  • 1
  • 1
  • It is preferred if you can post separate questions instead of combining your questions into one. That way, it helps the people answering your question and also others hunting for at least one of your questions. Thanks! – Rohit Gupta Jul 01 '15 at 20:22

1 Answers1

1

It is possible to run a native SQL query in your case, which would work for your issue. However, not the warning on the documentation page for the Native SQL docs here

This feature has not been fully tested and is not officially supported: the API may change in future releases. In general, it is always better to perform database actions through connected models. Directly executing SQL may lead to unexpected results, corrupted data, and other issues.

You can also find an example of a similar situation in a previous question asked here:

Execute raw query on MySQL Loopback Connector

Community
  • 1
  • 1
JSimonsen
  • 2,642
  • 1
  • 13
  • 13
  • Thank you, that is pretty much what I have seen, and thanks for the referral to the other question, I didn't find that in my searches. Until StrongLoop supports a custom/native SQL option, I think I will have to go down the route of straight Node/Express (unless there is another option I'm missing). I think the StrongLoop product suite has a lot of promise, and hope this gets addressed soon. – Scot Jul 02 '15 at 13:58