1. let sql = `INSERT INTO user
    2. (name, createAt, updateAt) 
    3. VALUES 
    4. (:name, :createAt, :updateAt)
    5. `;
    7. let param = `{
    8.   "name": "",
    9.   "createAt":"",
    10.   "updateAt":"",
    11. }`;
    14. const queryFormat = function (query, values) {
    15.   if (!values) return query;
    17.   query = query.replace(/:(\w+)/g, function (txt, key) {
    18.     if (values.hasOwnProperty(key)) {
    19.       const v = values[key];
    21.       if (typeof v === 'number') {
    22.         return v;
    23.       } else {
    24.         return '"' + this.escape(v) + '"';
    25.       }
    26.     }
    28.     return txt;
    29.   }.bind(this));
    31.   // log.info('[mysql query]', query);
    33.   return query;
    34. };
    36. process.argv.forEach((val, index) => {
    37.   console.log(`${index}: ${val}`);
    38.   if (index === 2) {
    39.     sql = val;
    40.   }
    42.   if (index === 3) {
    43.     param = JSON.parse(val);
    44.   }
    45. });
    47. if (param) {
    48.     sql = queryFormat(sql, JSON.parse(param));
    49.     param = undefined;
    50. }
    52. const mysql = require('mysql');
    54. console.log(sql);
    56. var connection = mysql.createConnection({
    57.   host: 'url',
    58.   port: 3306,
    59.   user: 'username',
    60.   password: 'password',
    61.   database: 'database',
    62.   dateStrings: true
    63. });
    65. connection.connect();
    67. connection.query(sql, function (error, results) {
    68.   if (error) throw error;
    69.   console.log('The solution is: ', results);
    70. });
    73. connection.end();