Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- require('dotenv').load();
- var mysql = require('mysql');
- exports.doQuery = function(sqlQuery) {
- var con = mysql.createConnection({
- host: process.env.DB_HOST,
- user: process.env.DB_USERNAME,
- password: process.env.DB_PASSWORD,
- database: process.env.DB_NAME
- });
- con.connect(function(err) {
- if (err) throw err;
- console.log("Connected!");
- con.query(sqlQuery, function (err, result) {
- if (err) throw err;
- console.log("1 record inserted");
- });
- });
- };
Add Comment
Please, Sign In to add comment