basel

basel

Framework for Bootstrap, AngularJS, SQLite, Electron

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
    -d, --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

Examples

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

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

Help

Init

basel-init --help

Database

basel-database --help

CRUD

basel-crud --help