Usage

Install

npm install -g basel

Create App

basel-init myApp

Install dependencies

cd myApp && npm install

Run

npm start

Database

To create a new table in the database of your BASEL app.

basel-database --table USERS --columns "id:INTEGER, name:TEXT" --pk id

And manipulate the database.

Options

    -h, --help                        output usage information
    -p, --password <password>         Data base encripted passowrd
    -a, --algorithm <algorithm>       Data base encripted algorithm
    -s, --sql <sql>                   Sql to run
    -t, --table <table>               Create database table
    -c, --columns <columns>           Database table columns. Ex: "id:INTEGER, name:TEXT"
    -p, --pk <primary>                Database table primary key
    -r, --references <references>     Refences. Ex: "id":"table.id_table"
    -i, --incremental <incremental>   incremental columns. Ex: id or "id, number, ..."

Example:

basel-database --table USERS --columns "id:INTEGER, name:CHAR(100), email:TEXT, profile:INTEGER" --pk id --incremental id --references "profile:profiles.id"

Mean:

CREATE table USERS(
  id INTEGER PRIMARY KEY AUTOINCREMENT,
  name CHAR (100),
  email TEXT,
  profile INTEGER REFERENCES profiles(id)
);

CRUD - Creating

To create CRUD from database tables.

basel-crud users --table USERS

Options

    -h, --help                       output usage information
    -t, --table <table>              Database Table
    -n, --columns <columns>          For new tables. Table columns. Ex: "id:INTEGER, name:TEXT"
    -p, --pk <primary>               Primary key of new table
    -f, --references <references>    Refences of new table. Ex: "profile:profiles.id"
    -i, --incremental <incremental>  incremental columns. Ex: id or "id, number, ..."
    -b, --database <database>        Database
    -c, --controller <controller>    Controller name
    -v, --view <view>                View name (.html)
    -r, --route <route>              Route (Ex.: persons)
    -m, --menu <menu>                Show in main menu (1 - Yes, 0 - No) Default 1
    -d, --delete <id>                To delete CRUD by ID
    -l, --list                       To list CRUDS

Examples

basel-crud users --table USERS -c userController -v user -r users

Create a CRUD on Controller and view based in table USERS.

Create CRUD and Table

you can create the CRUD and at the same time the table. Inform the table columns using the short -n or --columns "id:INTEGER, name:TEXT, ... ".

basel-crud users --table USERS -n "id:INTEGER, name:TEXT" 

Help

Init

basel-init --help

Database

basel-database --help

CRUD

basel-crud --help