const mysql = require("mysql2/promise")

const {host, port, user, database, password} = require("./settings").db

/////////////////////////////////////////////////////////////////////////

run()
   .then(console.log)
   .catch(console.error)
   .finally(process.exit)

/////////////////////////////////////////////////////////////////////////

async function run () {
   // Create the connection to database
   console.log(111111111111,mysql)
   const connection = await mysql.createConnection({
      host,
      port,
      database,
      user,
      password,
   })

// A simple SELECT query
   try {
      const [results, fields] = await connection.query(
         `SELECT ud.* FROM ilias.usr_data AS ud WHERE login = '242424'`
      )

      console.log(results) // results contains rows returned by server
      console.log(fields) // fields contains extra meta data about results, if available
   } catch (err) {
      console.log(err)
   }
}