Neovictorian Paisley Menswear
Miss any of our Open RFC calls?Watch the recordings here! »

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

4

Version

0.2.4

License

ISC

Unpacked Size

11.6 kB

Total Files

3

Last publish

Collaborators

  • avatar