Node.js에서 mysql을 async/await으로 작성하기

https://mylko72.gitbooks.io/node-js/content/index.html

https://holywater-jeong.github.io/blog/node-mysql-async-await/

https://github.com/sidorares/node-mysql2/blob/master/documentation/Promise-Wrapper.md

https://www.npmjs.com/package/mysql2

https://joshua1988.github.io/web-development/javascript/promise-for-beginners/

const mysql = require('mysql2/promise');
 
var opts = {
    host:'localhost',
    user:'root',
    password:'123456',
    database:'smilejsu82'
};
function generateQuickGuid() {
    return Math.random().toString(36).substring(2, 15) +
        Math.random().toString(36).substring(2, 15);
}
const pool = mysql.createPool(opts);
function getRandomInt(min, max){
    return Math.floor(Math.random() * (max - min)) + min;
}
const dbTest = async()=>{
    try{
        const user_id = getRandomInt(0, 1000);
        const access_token = generateQuickGuid();
        //방법3 
        try{
            const connection = await pool.getConnection(async conn=>conn);
            try{
                var sql = 'insert into auth(user_id, access_token) values(?,?)';
                await connection.beginTransaction();
                const [rows] = await connection.query(sql, [user_id, access_token]);
                await connection.commit();
                connection.release();
                return rows;
            }catch(err){
                await connection.rollback();
                connection.release();
                console.log('Query Error!');
                return false;
            }
        }catch(err){
            console.log('DB ERROR');
            return false;
        }
        
        
        
    }catch(err){
        console.log('DB ERROR!');
        return false;
    }    
};
 
 
 
var rows = dbTest();
rows.then((row)=>{
   console.log(row); 
});