const mysql = require('mysql2/promise')

const pool = mysql.createPool({
  host: 'localhost',
  port: '8889',
  user: 'root',
  password: 'root',
  database: 'db2'
});

(async function () {
    const db = await pool.getConnection()

    await db.beginTransaction()
    try {

      const User = require('./models/user')(db)


    /*1.1 find(id) */
    /*1.4 user.save() */
      const user1 = await User.find(1)
      user1.firstName = 'hello11'
      user1.lastName = 'kitty11'
      user1.save()

    /*1.2 findAll() */
      //const user1 = await User.findAll()

      // console.log(user1[0].id + ':' + user1[0].firstName + ':' + user1[0].lastName) ;
      // console.log(user1[1].id + ':' + user1[1].firstName + ':' + user1[1].lastName) ;
      // console.log(user1[2].id + ':' + user1[2].firstName + ':' + user1[2].lastName) ;
      // console.log(user1[3].id + ':' + user1[3].firstName + ':' + user1[3].lastName) ;
      // console.log(user1[4].id + ':' + user1[4].firstName + ':' + user1[4].lastName) ;

      // user1.forEach(data => {
      //   console.log(data.id + ':' + data.firstName + ':' + data.lastName) ;
      // })

    /*1.3 findByUsername (username) */

      //const user1 = await User.findByUsername('1111')
      //const user2 = await User.findByUsername('2222')


    /*1.5 user.remove() */

      // const user4 = await User.find(4)
      // user4.remove()

      await db.commit()

      const [rows] = await db.execute(`select id, first_name, last_name from users where id = ?`, [1])
      console.log(rows)

    } catch (err) {
      console.log(err)
      await db.rollback()
    }
    await db.release()
  })().then(
    () => { },
    (err) => { console.log(err) }
    )