Mysql in node, async and shutdown?

Question

MySQL

Good day, gentlemen!
I'm trying to ride a recalcitrant asynchronous node.
Essence of the question:
There is a script that works and iterates in a loop, writes to the database at each iteration, exits and hangs because the connection to the database hangs, I don’t understand how to close the connection after the loop is completed. It cuts out all the time.

objectGame = [....]
  number = objectGame.length

  db.connect()

  for game in objectGame
     parserGame(game, getResultOneGame)
  
  db.end()

I tried to do this, but it doesn't work...

objectGame = [....]
  number = objectGame.length

  for game in objectGame
     number--
     parserGame(game, getResultOneGame, number)

parserGame = ( ) ->
   ............
   if namber ==1 
      db.end()

+ the upcoming problem, it is necessary that the script run independently once a day. For the first time I delve into the documentation and configuration of the VPN server, so I ask for advice on how to do it better, run the node and let it run on time, via setTimeout, or somehow better set up on the server, scheduled file launch

Answer 1

Judging by the description of the question, misunderstanding comes from ignorance of the language. The path is simple, learn.

Answer 2

Array.prototype.asyncEach = function (each, done) {
  var i = -1, a = this
  
  function iter() {
    if (++i === a.length) { done && done(); return }
    each.call(a, a[i], iter)
  }

  iter()
}

let objectGame = ["GTA", "CS", "OTHER"]

db.connect()

objectGame.asyncEach(function (item, next) {
  parserGame(item, getResultOneGame)
  next()
}, db.end)