loopbackio / loopbackio/loopback-next
Adding a new datasource not used make fail "npm run migrate" if models are given as property
Open
@hacksparrow is already working on this.
Since Jul 28, 2020.
bug
- Dominant language
- TypeScript
- Stars
- 5.1k
- Forks
- 1.1k
- Avg merge
- 2d 21h
- Merged PRs (30d)
- 27
Description
Steps to reproduce
- Create multiple model with foreign key like in the documentation tutorial :
https://loopback.io/doc/en/lb4/todo-list-tutorial-sqldb.html#database-migration-using-npm-run-migrate-command - Update the
migrate.jsfile with amodelsproperty to change the order of table creation (as writting in the tutorial)

- run
npm run build - run
npm run migrate
Current Behavior
I get this error:
Cannot migrate database schema Error: Cannot migrate models not attached to this data source: User Status Logs Queue"
Expected Behavior
To migrate well.
Additional information
- If I remove the "models" property + removing the foreign keys + run
npm run migrate=> it's working. - If I remove the "models" property + I create the table without the foreign keys + run
npm run migrate=> it's working. - I have 3 different data sources declared in the project but only one is linked in the 4 repositories (It's a MySQL database connector)
There is a screenshot of the behavior:
At first, I run npm run migrate => everything goes well.
Second I add a new Mysql datasource and run npm run migrate again => it fail.
I suppose that it tries to migrate on all datasource instead of only the one referenced in the repositories.

Related Issues
Maybe: https://github.com/strongloop/loopback-next/issues/3819 ?
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Assessment
This issue has not been assessed yet.