Automated generator models, views and controllers for SailsJS & WaterLine
Sails Inverse Model helps you build models, controllers and views JS Sails from any database. In addition, you can quickly and individually generate each model, view, controller or all three at the same time.
Available for PostgreSQL, MySQL and MongoDB
Installation
Linux or MacOS
$ sudo npm install sails-inverse-model@next -g
Microsoft Windows
$ npm install sails-inverse-model@next -g
Individual generation
You can quickly generate a model, a controller, a view or these three at the same time simply define the attributes of your model. Let's look at an example:
# Generate model $ sails-inverse-model -g model --name Pet -a "name:string:r:u owner:string" # Generate Controller $ sails-inverse-model -g controller --name Pet -a "" # Generate View $ sails-inverse-model -g view --name Pet -a "name:string:r owner:string" # Generate all (Model, View and Controller) $ sails-inverse-model -g all --name Pet -a "name:string:r:k owner:string"
Detail
Param | Description |
---|---|
g | Generate view, model, controller |
name | Name: model, driver, and view folder |
a | Content of the element to generate |
name:string:params | Attribute name: data type: params |
Specifies the type of data that will be stored in this attribute. Here
Params
Param | Description | Example |
---|---|---|
r | Required | catname:string:r |
u | Unique | catname:string:u |
a | Autoincrement | index:integer:a |
k | Primary Key | index:integer:k |
You can also set all three parameters at the same time, for example: index:integer🅰️u:r
Example
sails-inverse-model -g model --name Pet -a "index:integer:r:u:a name:string:r:u owner:string:r" => module.exports = ;
Generator (from Database)
$ sails-inverse-model --help Sails Inverse Model helps you build models, controllers and views JS Sails from any database. In addition, you can quickly and individually generate each model, view, controller or all three at the same time. .-..-. Sails-inverse-model<| .-..-. 2.x.x | ~ ~ ~ /|. ~ ~ / || ~ ~ ,' |' .-'.-==|/_--' `--'-------' _--__--_---__---___--__---__--___ __---__--__---___--__---___--_-_---___ ---------------------------------------------------------- :: Sat Feb 04 2017 22:43:52 GMT-0500 ---------------------------------------------------------- Example: $ mkdir sails-output $ cd sails-output $ sails-inverse-model -u postgres -p root -d almacen -t pg -m -v -c User : postgres Password : root Database : almacen Host : localhost Models : /home/julian/Documents/sails-output/models Views : /home/julian/Documents/sails-output/views Controllers : /home/julian/Documents/sails-output/controllers DB : pg Schema : public ===================================== Views [OK] ===================================== Models [OK] ===================================== Controllers [OK] Note: Copy models => your/project_sails/api Copy controllers => your/project_sails/api Copy views/* => your/project_sails/views/ Then: $ cd your/project_sails/ $ sails lift More info: https://github.com/juliandavidmr/sails-inverse-model --------------------------------------------------------------- Options: -u, --user User of database -p, --pass Password of database -d, --database Database name -h, --host Host server Default: localhost -m, --models Folder output models Default: Folder actual -c, --controllers Folder output controllers Default: Folder actual -v, --views Folder output views Default: Folder actual -t, --type Type gestor database: mysql|postgres|mongodb Default: mysql -s, --schema Schema database postgres: Default: public -f, --file .sql file path entry ====================== Individual generation ================== You can quickly generate a model, a controller, a view or these three at the same time. # Generate model $ sails-inverse-model -g model --name Pet -a "name:string:r:u owner:string" # Generate Controller $ sails-inverse-model -g controller --name Pet -a "name:string:r:u owner:string" # Generate View $ sails-inverse-model -g view --name Pet -a "name:string:r owner:string" # Generate all (Model, View and Controller) $ sails-inverse-model -g all --name Pet -a "name:string:r:k owner:string" Where: -------------------------------------------- |Param | Description | Example | |------|---------------|-------------------| | r | Required | catname:string:r | | u | Unique | catname:string:u | | a | Autoincrement | index:integer:a | | k | Primary Key | index:integer:k | -------------------------------------------- You can also set all three parameters at the same time,
MySQL
sails-inverse-model -u root -p root -d mydbmysql -m -v -c
MySQL from file .sql
sails-inverse-model -f /your/path/to/script.sql -m -v -c
PostgreSQL
sails-inverse-model -u postgres -p root -d almacen -t pg -m -v -c
MongoDB
sails-inverse-model -d blog_db -t mg -m -v -c
Import
Install package
npm install sails-inverse-model --save
Generate from MySQL
var sim = ; var config = host: "localhost" database: "almacen" user: "root" pass: "root" port: 3306 var folder_controllers = "/your/project/sails/api/"; //if folder_models == "" then: no generate controllersvar folder_models = "/your/project/sails/api/"; //if folder_models == "" then: no generate modelsvar folder_views = "/your/project/sails/"; //if folder_models == "" then: no generate views sim;
Generate from PostgreSQL
var sim = ; var config = host: "localhost" database: "example" user: "postgres" pass: "root" port: 5432 schema: "public" var folder_controllers = "/your/project/sails/api/"; //if folder_models == "" then: no generate controllersvar folder_models = "/your/project/sails/api/"; //if folder_models == "" then: no generate modelsvar folder_views = "/your/project/sails/"; //if folder_models == "" then: no generate views sim;
Generate from MongoDB
var sim = ; var folder_controllers = "/your/project/sails/api/"; //if folder_models == "" then: no generate controllersvar folder_models = "/your/project/sails/api/"; //if folder_models == "" then: no generate modelsvar folder_views = "/your/project/sails/"; //if folder_models == "" then: no generate views // host port database views models controllerssim;