// case of mysql
// node-make-dummy-data.js
// npm install --save mysql casual lodash

var mysql = require('mysql');
var casual = require('casual').ja_JP;
var _ = require('lodash');

var con = mysql.createConnection({
  host: "localhost",
  user: "docker",
  password: "docker",
  database: "testdb"
});

con.connect(function(err) {
  if (err) throw err;
  console.log("Connected!");
  _.times(10, () => {
    var sql = [
      "INSERT INTO testtable VALUES (",
      "0,",
      "'" + casual.random_element(['あいう', 'かきく', 'さしす']) + "',",
      "'" + casual.integer(from = 9000, to = 9999) + "',",
      "'" + casual.date(format = 'YYYY/MM/DD') + "',",
      "'" + casual.integer(from = 20900001, to = 20999999) + "',",
      "'" + casual.currency_name + "','','',",
      "'" + casual.random_element(['ABC', 'DEF', 'GHI']) + "',",
      "'" + casual.integer(from = 1, to = 10) + "',",
      "'" + casual.integer(from = 1000, to = 30000) + "',",
      "'" + casual.integer(from = 1000, to = 30000) + "',",
      "'" + casual.random_element(['', '備考１', '備考２']) + "',",
      "'" + casual.integer(from = 20900001, to = 20999999) + "',",
      "'" + casual.currency_name + "','',''",
      ")"
    ].join("");
    con.query(sql, function (err, result) {
      if (err) throw err;
      console.log("1 record inserted");
    });
  });
});