Noticeably Playful Monkeys

    procedural-mysql

    0.2.4 • Public • Published

    PROCEDURAL MYSQL

    CLI to make more easy write functions on mysql and uploads to mysql server

    Installation

        npm install -g procedural-mysql

    The configuration file is on the root project folder and it's called procedural-mysql.config.json

    config file

    {
        "directory": "sql",
        "db": {
            "user": "root",
            "host": "localhost",
            "database": "test",
            "password": "root",
            "charset": "utf8"
        }
    }

    Basic usage

        procedural-mysql -c config.json # sets the configuration file 
        procedural-mysql -w  # watch in config directory for changes 
        procedural-mysql -w -g  # upload all functions in config directory and watch cahnges on it 
        procedural-mysql -h # shows all commands to upload files 

    A basic mySQL function

    CREATE FUNCTION test (number int) RETURNS int 
    BEGIN
        return number;
    END

    Install

    npm i procedural-mysql

    DownloadsWeekly Downloads

    1

    Version

    0.2.4

    License

    ISC

    Unpacked Size

    11.6 kB

    Total Files

    3

    Last publish

    Collaborators

    • kourad