const MariaDB = require('mariadb');
const dbConfig = require('../config').db;

const MariaDBConnectionPool = MariaDB.createPool({
    user: dbConfig.user,
    password: dbConfig.password,
    host: dbConfig.dburl,
    database: dbConfig.database,
    connectionLimit: 10
});

const query = '<쿼리문>';
const params = [<파라미터1>, <파라미터2>, ...];

const promise = new Promise((resolve, reject)=> {
    let DBconn;
    MariaDBConnectionPool.getConnection()
    .then((conn) => {
        DBconn = conn;
        return DBconn.query(query, params)
    }).then(result => {
        DBconn.end();
        return resolve(result)
    }).catch(e => {
        DBconn.end();
        reject(e);
    })
})

promise.then( result => {
    //result에 쿼리에 대한 결과가 담긴다.
}).catch(e => {
    //에러 처리
})