Modelize
Modelize is a NodeJS script which allow you to transform a sql file or a database connexion into several models (one by table) for different ORM.
Compatibility
SQL File
- PostgreSQL syntax
Databases
- PostgreSQL
- MariaDB / MySQL
ORM
- Sequelize
- Eloquent
Configuration
SQL File
A data.sql sql file contains the script of creation of your tables, using syntaxs supported (See category « Compatibility »). Don’t forget to use ; at the end of your requests to make the script work.
Database connection
Create .env file at the root of your project containing the next informations :
DB_HOST=<your_host_address>
DB_PORT=<port_of_the_database> //If it's empty, it will take the default port of your SGBDR
DB_USER=<username>
DB_PASS=<password>
DB_NAME=<name_of_the_database>
Utilisation
Instruction to install the project :
npm install -g modelize-cli
Then you just need to launch the nex instruction from the root of your project :
modelize