47 lines
1.6 KiB
JavaScript
47 lines
1.6 KiB
JavaScript
// const included = require("../../requires")
|
|
pool = mysql.createPool({
|
|
connectionLimit : 10,
|
|
host: config.database.host,
|
|
port: config.database.port,
|
|
user: config.database.username,
|
|
password: config.database.password,
|
|
database: config.database.database,
|
|
charset : 'utf8mb4'
|
|
});
|
|
|
|
|
|
|
|
module.exports = {
|
|
name: "query",
|
|
async function(query, values, verbose){
|
|
// if(values == undefined){
|
|
// values = query
|
|
// query = msg
|
|
// }
|
|
return new Promise((resolve, reject) => {
|
|
// connection.query(query, values, function (error, results, fields) {
|
|
// if (error) throw error;
|
|
// resolve(results)
|
|
// });
|
|
|
|
pool.getConnection(function(err, connection) {
|
|
if (err) throw err; // not connected!
|
|
// Use the connection
|
|
connection.query(query, values, function (error, results, fields) {
|
|
// When done with the connection, release it.
|
|
connection.release();
|
|
// Handle error after the release.
|
|
if (error){
|
|
// console.log(error) //-------------------------------------------------------------------------- DEBUGGING
|
|
if(verbose){
|
|
reject(error.sqlMessage);
|
|
}
|
|
resolve(false)
|
|
}
|
|
resolve(results)
|
|
// Don't use the connection here, it has been returned to the pool.
|
|
});
|
|
});
|
|
})
|
|
}
|
|
} |