SiMLa - Simple Migration Language

I created this language or compiler just to create knex migration easily for my projects.

Install

Open your terminal and type:

npm install -g simla

Usage

simla [-i <input file>] [-o <output file>] [-p] [-s]

-i  Input file
-o  Output file
-p  Print output to terminal
-s  Open interactive compiler

PS: Interactive compiler won't start if -i parametr is presented.

If you want to compile structure.sml to migration.js, then type:

simla -i structure.sml -o migration.js

Structure

TABLE <table name> {
    <type>(<size>) <name> <props>
    <type>(<size>) <name> <props> > <reference>
    <type>(<size>) <name> <props> > <table>.<field>
}

Example

TABLE products {
    ID
    STRING(100) name NOT NULL
    STRING(100) details
    DECIMAL(8, 2) price
    UINT seller_id > sellers.id
    TS
}

Types

|Name|Description| |--|--| |ID|Autoincrement primary key| |TS|Timestamps (created_at, updated_at)| |UINT|Unsigned integer| |INT|Integer| |BOOL|Boolean| |*|Any exists type with UPPERCASE characters|

Props

|Name|Alias|Description| |--|--|--| |NOT NULL|NN, NOT_NULL|Property is not nullable| |DEFAULT|DEF|Sets default value for property. Eg.: INT price DEF 0| |UNSIGNED|US|Makes property un-signed|

Enums?

Here's an example to know how to model enums with SiMLa.

TABLE car {
    ID
    STRING name
    ENUM(['red', 'green', 'blue']) color DEFAULT red
    TS
}

And, Interactive compiler

It looks like that. To launch compiler open terminal and type: simla -s

Open local compiler