var MySqlConnect = require('./dbMySql');

var app = express();
var dbConnect = MySqlConnect("localhost", "root", "root", "mydb");

dbConnect.getQuery("select * from `test`");
console.log(dbConnect.resD);

function MySqlConnect(dbhost, dbuser, dbpassword, dbname) {
                var MySqlConnect = require('mysql');
                var con;
                this.dbhost = dbhost;
                this.dbuser = dbuser;
                this.dbpassword = dbpassword;
                this.dbname = dbname;
                this.resultData = 'Def';
                con = MySqlConnect.createConnection({
                    host: dbhost,
                    user: dbuser,
                    password: dbpassword,
                    database: dbname
                })
                con.connect(function (err) {
                    if (err) throw err;
                })

                function getQuery(query1) {
                    con.query(query1, function (err, res) {
                        if (err) throw err;

                    })
                    return {


                        resD: res

                    };

                }

                return {

                    getQuery: getQuery,

                };


            };

            module.exports = MySqlConnect;