const csvtojson = require(
'csvtojson'
);
const mysql = require(
"mysql"
);
const hostname =
"localhost"
,
username =
"root"
,
password =
"root"
,
databsename =
"csvtomysql"
let con = mysql.createConnection({
host: hostname,
user: username,
password: password,
database: databsename,
});
con.connect((err) => {
if
(err)
return
console.error(
'error: '
+ err.message);
con.query(
"DROP TABLE sample"
,
(err, drop) => {
var
createStatament =
"CREATE TABLE sample(Name char(50), "
+
"Email char(50), Age int, city char(30))"
con.query(createStatament, (err, drop) => {
if
(err)
console.log(
"ERROR: "
, err);
});
});
});
const fileName =
"sample.csv"
;
csvtojson().fromFile(fileName).then(source => {
for
(
var
i = 0; i < source.length; i++) {
var
Name = source[i][
"Name"
],
Email = source[i][
"Email"
],
Age = source[i][
"Age"
],
City = source[i][
"City"
]
var
insertStatement =
`INSERT INTO sample values(?, ?, ?, ?)`;
var
items = [Name, Email, Age, City];
con.query(insertStatement, items,
(err, results, fields) => {
if
(err) {
console.log(
"Unable to insert item at row "
, i + 1);
return
console.log(err);
}
});
}
console.log(
"All items stored into database successfully"
);
});