objection-model-generator

generate the model from mysql database

Usage no npm install needed!

<script type="module">
  import objectionModelGenerator from 'https://cdn.skypack.dev/objection-model-generator';
</script>

README

OMG!!!!!

Objection Model Generator is a tool to automagically generate all ObjectionJS models from Mysql data base, using the information_schema table to let us know tables, columns and BelongsToOneRelation.

require('dotenv').config();
const fs = require('fs-extra');
const ObjectionModelGenerator = require('./lib/ObjectionModelGenerator.js');

const main = async () => {
  let omg = new ObjectionModelGenerator({
    host: process.env.DB_HOST,
    port: process.env.DB_PORT,
    user: process.env.DB_USER,
    password: process.env.DB_PASS
  }, process.env.DB_NAME, '../db');
  let ms = await omg.createModels().catch(error=>({error}));
  if(ms.error){
    console.error(error);
    return process.exit(1);
  }
  await fs.writeFile('output/ms.js', ms);
  console.log('\n -> file writed: output/ms.js');
  process.exit();
}

main();