gistfile1.txt

import org.slf4j.MDC
import scalikejdbc._

GlobalSettings.taggedQueryCompletionListener = (sql: String, params: Seq[Any], millis: Long, tags: Seq[String]) => {
      if (millis > warningThresholdMillis) {
        MDC.put("sql", sql)
        MDC.put("params", params.mkString("[", ",", "]"))
        MDC.put("millis", millis.toString)
        MDC.put("error", null)
        setExtraProps(tags)
        logger.warn(s"completion")
      }
}

def setExtraProps(tags: Seq[String]) {
  MDC.put("app", appName)

  if (tags.size > 0)
    MDC.put("server", tags(0))
  else
    MDC.put("server", null)
  if (tags.size > 1)
    MDC.put("database", tags(1))
  else
    MDC.put("database", null)

  if (tags.size > 2)
    MDC.put("url", tags(2))
  else
    MDC.put("url", null)

  if (tags.size > 3)
    MDC.put("user", tags(3))
  else
    MDC.put("user", null)

  if (tags.size > 4)
    MDC.put("driver", tags(4))
  else
    MDC.put("driver", null)

}