Discover LoopBack models

discovery.js

'use strict';

const loopback = require('loopback');
const promisify = require('util').promisify;
const fs = require('fs');
const writeFile = promisify(fs.writeFile);
const mkdirp = promisify(require('mkdirp'));

const app = loopback();
const db = app.dataSource('db', {
  connector: 'mysql',
  user: 'root',
});


discover().then(
  success => process.exit(),
  error => { console.error('UNHANDLED ERROR:\n', error); process.exit(1); },
);

async function discover() {
  const schema = await db.discoverSchema(
    'salaries', // the table name
    {
      schema: 'employees' // the database/schema name
    },
  );

  await mkdirp('common/models');
  await writeFile(
    'common/models/salaries.json',
    JSON.stringify(schema, null, 2)
  );
}

package.json

{
  "name": "discover-models",
  "version": "1.0.0",
  "license": "MIT",
  "dependencies": {
    "loopback": "^3.19.0",
    "loopback-connector-mysql": "^5.2.0",
    "mkdirp": "^0.5.1"
  }
}