node mysql lasting connection

lastingConnection.coffee

# How to make a lasting connection in node mysql


client = null
db = null
tries = 0
makeLastingConnection = =>
  tries++
  client = new Client
  client.host = config.db.host
  client.user = config.db.user
  client.password = config.db.password
  db = new MySqlHelper client
  console.log "trying to make a lasting connection for the #{tries} time"
  client.connect (err) =>
    if err
      console.log "error connecting to db"
      return _.wait 5000, makeLastingConnection
    client._connection.on "close", () =>
      _.wait 1000, makeLastingConnection
  client.query("Use #{config.db.db};")

makeLastingConnection()