LoopBack 4 MySQL Database Connection and Migration

[jamsoft]

I've just started my first Loopback API project and all was going great until trying to connect to a MySql Database and start using migrations.

I've been running through the docs here and here.

I have a data source setup with the following config:

const config = {
    name: 'adxds',
    connector: 'mysql',
    url: 'mysql://user:password@host:3307/adx',
    host: 'host',
    port: 3307,
    user: 'user',
    password: 'pass',
    database: 'adx'
};

I also have a model set up with some simple string properties and this in the model function:

@model({
  settings: {
    mysql: {schema: 'adx', table: 'observer'},
  },
})

When I run the following commands:

npm run build
npm run migrate -- --rebuild

Everything seems to run fine, without any errors but it never creates any tables. I think I've read the docs correctly in that these commands should be creating the tables.

Or do I need to move on in the tutorial and create a repository before tables are actually generated?

I've also tried doing the migration in the index.ts by calling await app.migrateSchema(); after boot() but that doesn't do anything either. It doesn't error either.

Bit confused to be honest. Not sure what to look at in order to progress at this point. It's not working but not giving me any errors either. Showstopper.

> [email protected] premigrate
> npm run build

> [email protected] build
> lb-tsc

> [email protected] migrate
> node ./dist/migrate

Migrating schemas (alter existing schema)

Is there any way to run this and maybe get some debug info?