dbSetup_local.js

const mysql = require('mysql');
const dbSetting = require('./models/settings/dbConnectionSettings')
const sqls = require('./models/settings/sqlDispenser')
const encode = require('./utils/encode')

let rootSettingObj = {
    host: dbSetting.host,
    port: dbSetting.port,
    user: dbSetting.yourLocalMySQLUsername,
    password: dbSetting.yourLocalMySQLPassword,
    multipleStatements: true,
}
let settingObj = {
    host: dbSetting.host,
    port: dbSetting.port,
    user: dbSetting.user,
    password: dbSetting.password,
    multipleStatements: true,
}

let testMember = [
    process.env.DUMMY_USERNAME || 'test',
    process.env.DUMMY_PASSWORD || 'abcd1234',
    200,
]

const sql_addMember =
    `insert into ${dbSetting.table_member}
    (username,password,servings) 
    values(?,?,?);`

const sql_insertRecipe1 =
    `insert into ${dbSetting.table_recipe}
    (name,style,img,memberId,ingredientId) 
    values ('닭볶음탕','KOR',
    'https://cloudfront.haemukja.com/vh.php?url=https://d1hk7gw6lgygff.cloudfront.net/uploads/direction/image_file/26152/pad_thumb_ch15.jpg',
    1,1);`

const sql_insertRecipe2 =
    `insert into ${dbSetting.table_recipe}
    (name,style,img,memberId,ingredientId) 
    values ('멸치국수','KOR',
    'https://cdn.pixabay.com/photo/2015/04/06/16/32/if-709614__340.jpg',
    1,2);`

const sql_insertRecipe3 =
    `insert into ${dbSetting.table_recipe}
    (name,style,img,memberId,ingredientId) 
    values ('마파두부','CHN',
    'https://cloudfront.haemukja.com/vh.php?url=https://d1hk7gw6lgygff.cloudfront.net/uploads/direction/image_file/1168/pad_thumb_m.png&convert=jpgmin&rt=600',
    1,3);`

const sql_insertRecipe4 =
    `insert into ${dbSetting.table_recipe}
    (name,style,img,memberId,ingredientId) 
    values ('닭칼국수','KOR',
    'https://imagescdn.gettyimagesbank.com/500/201708/a10968180.jpg',
    1,4);`

const sql_insertRecipe5 =
    `insert into ${dbSetting.table_recipe}
    (name,style,img,memberId,ingredientId) 
    values ('소고기콩나물비빔밥','KOR',
    'https://img1.daumcdn.net/thumb/R720x0.q80/?scode=mtistory2&fname=http%3A%2F%2Fcfile25.uf.tistory.com%2Fimage%2F143948354FB8FDF6296B73',
    1,5);`

const sql_insertRecipe6 =
    `insert into ${dbSetting.table_recipe}
    (name,style,img,memberId,ingredientId) 
    values ('순대국밥','KOR',
    'https://encrypted-tbn0.gstatic.com/images?q=tbn%3AANd9GcSyOmrqbHnyUqJfVUMxY6l_my0eyw_twRPGEw&usqp=CAU',
    1,6);`

const sql_insertRecipe7 =
    `insert into ${dbSetting.table_recipe}
    (name,style,img,memberId,ingredientId) 
    values ('짜장면','CHN',
    'https://recipe1.ezmember.co.kr/cache/recipe/2016/07/02/40c4f639ca973d9acccecdf7cbe0cbc41.jpg',
    1,7);`

const sql_insertRecipe8 =
    `insert into ${dbSetting.table_recipe}
    (name,style,img,memberId,ingredientId) 
    values ('유산슬밥','CHN',
    'https://www.sk5.co.kr/img_src/s600/a897/a8970355.jpg',
    1,8);`

const sql_insertRecipe9 =
    `insert into ${dbSetting.table_recipe}
    (name,style,img,memberId,ingredientId) 
    values ('돈까스','WES',
    'http://cdn.011st.com/11dims/resize/600x600/quality/75/11src/pd/20/1/4/9/3/1/8/yVdYI/2827149318_B.jpg',
    1,9);`

const sql_insertRecipe10 =
    `insert into ${dbSetting.table_recipe}
    (name,style,img,memberId,ingredientId) 
    values ('해물파스타','WES',
    'https://recipe1.ezmember.co.kr/cache/recipe/2015/06/08/f368e4342174431947ba86ea4ec0fe28.jpg',
    1,10);`

const sql_insertRecipe11 =
    `insert into ${dbSetting.table_recipe}
    (name,style,img,memberId,ingredientId) 
    values ('햄버그스테이크','WES',
    'http://image.gsshop.com/image/55/31/55314791_L1.jpg',
    1,11);`

const sql_insertInventory =
    `insert into ${dbSetting.table_inventory}
    (memberId,meat,fish,misc,sauce) values(1,1,1,1,1);`

let additionalSqls =
    sql_insertRecipe1 + sql_insertRecipe2
    + sql_insertRecipe3 + sql_insertRecipe4
    + sql_insertRecipe5 + sql_insertRecipe6
    + sql_insertRecipe7 + sql_insertRecipe8
    + sql_insertRecipe9 + sql_insertRecipe10
    + sql_insertRecipe11
    + sql_insertInventory


function db_initSetting() {
    return new Promise((resolve, reject) => {
        const conn_init1 = mysql.createConnection(rootSettingObj)
        conn_init1.connect();
        conn_init1.query(sqls.initialSetup, (err) => {
            conn_init1.destroy();
            if (err) return reject(err);
            const conn_init2 = mysql.createConnection(settingObj)
            conn_init2.connect()
            conn_init2.query(sqls.newDB, (err) => {
                conn_init2.destroy();
                if (err) return reject(err);
                settingObj.database = dbSetting.database
                const conn_init3 = mysql.createConnection(settingObj)
                conn_init3.connect()
                conn_init3.query(sqls.createDummy, err => {
                    if (err) {
                        conn_init3.destroy()
                        return reject(err)
                    }
                    encode(testMember[1])
                        .then(hash => {
                            testMember[1] = hash
                            conn_init3.query(sql_addMember, testMember, err => {
                                if (err) {
                                    conn_init3.destroy();
                                    return reject(err);
                                }
                                conn_init3.query(additionalSqls, err => {
                                    conn_init3.destroy()
                                    if (err) return reject(err)
                                    resolve()
                                })
                            })
                        })
                        .catch(err => reject(err))
                })
            })
        })
    })
}

async function dbSetup() {
    await db_initSetting().then(
        console.log('DB setup complete!')
    ).catch(err => console.log(err))
}
dbSetup()