Tool mysql

Mysql용 쿼리 빌더입니다. npm으로 배포 되고 있습니다.

Feature

• Create mysql table query

Install

npm install tool-mysql

Quick start

const toolMysql = require('./tool-mysql');
const tableConfig = {
    tableName: "product_order",
    reference: [
        {
            tableName: "product",
            keyColumns: ["product_category", "product_id"],
            columns: ["category", "id"],
            options: [
                {
                    actionName: "update",
                    optionValue: "cascade"
                },
                {
                    actionName: "delete",
                    optionValue: "restrict"
                }
            ]
        },
        {
            tableName: "customer",
            keyColumns: ["customer_id"],
            columns: ["id"]
        }
    ],
    columnData: [
        {
            name: "no",
            ai: 1,
            primaryKey: 1
        },
        {
            name: "product_category",
        },
        {
            name: "product_id",
            index: 1,
        },
        {
            name: "customer_id",
            index: 1,
        }
    ]
}
let query = toolMysql.createTable(tableConfig);

Return Values

CREATE TABLE IF NOT EXISTS `product_order` (
    `no` INT NOT NULL AUTO_INCREMENT , 
    `product_category` INT NOT NULL , 
    `product_id` INT NOT NULL , 
    `customer_id` INT NOT NULL , 
    PRIMARY KEY (`no`), 
    KEY `index_product_id` (`product_id`), 
    KEY `index_customer_id` (`customer_id`), 
    FOREIGN KEY (`product_category`, `product_id`) 
        REFERENCES `product`(`category`, `id`) 
        ON UPDATE CASCADE ON DELETE RESTRICT, 
    FOREIGN KEY (`customer_id`) 
        REFERENCES `customer`(`id`)
) ENGINE = innoDB

Input table config

{
    "tableName": {table_name}, //required
    "character": {
        "set": {table default charset}, //binary | utf8(default) ...
        "collate": {table collate} //utf8_ganeral_ci(default) | latin1_general_cs ...
    },
    //https://dev.mysql.com/doc/refman/5.7/en/storage-engines.html
    "engine": {your table engine} //InnoDB(default) | MyISAM | Memory | CSV | Archive | Blackhole | Merge | Federated | Example 
    "comment": {your table comment},
    "reference": [
        {
            "tableName": {reference_table_name},
            "columns": [{reference_column_name1}, {reference_column_name2}...],
            "keyColumns": [{key_column_name1}, {key_column_name2}...],
            "options": [
                {
                    "actionName": {action name}, //DELETE | UPDATE
                    "optionValue": {option value}//RESTRICT | CASCADE | SET NULL | NO ACTION | SET DEFAULT
                }
            ]
        }
    ],
    "columnData": [
        {
            "name": {column name}, //required
            "type": { //string | object
                "name": {type}, //INT(default), INTEGER, BIGINT, VARCHAR, DATE, TIMESTAMP...
                "size": {type size} //(default size is 11)
            },
            "character": {
                "set": {column charset}, //binary | utf8(default) ...
                "collate": {column collate} //utf8_ganeral_ci(default) | latin1_general_cs ...
            },
            "primaryKey": {primary key flag}, //0(default) | 1
            "default": {default value},
            "null": {default null flag}, //0(default) | 1
            "ai": {auto increment flag}, //0(default) | 1
            "index": {column index flag}, //0(default) | 1
            "comment": {your column comment}
        }
    ]
}