Framework for Bootstrap, AngularJS, SQLite, Electron
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Failed to load latest commit information.
bin set unix endlines Jan 19, 2018
images logo update Apr 27, 2016
lib Update crud.js Jun 14, 2017
templates Adapt to accept other themes Apr 29, 2016
.gitignore Cloning Apr 15, 2016
.npmignore npm ignore Apr 15, 2016
CHANGELOG.md Deleting CRUD May 30, 2016
LICENSE Initial commit Apr 15, 2016
README.md
package.json set unix endlines Jan 19, 2018

README.md

Framework for Bootstrap, AngularJS, SQLite, Electron

## [Documentation](http://baseljs.github.io/#/)

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