0.2.4 • Published 6 years ago
procedural-mysql v0.2.4
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