gistfile1.txt

object DynamicQuery {

  val connection = DriverManager.getConnection(url, properties)
  
  def dynamicQuery(queries: Seq[(String, String, Int, String)]): Map[(String, String, String, Int), (String, Boolean)] = {
    val variables = scala.collection.mutable.Map[(String, String, String, Int), (String, Boolean)]()
    queries.foreach { case (objectName, typeCode, index, query) =>
      val stmt = connection.createStatement
      val rs = stmt.executeQuery(query)
      if (rs.next) {
        for (i <- 1 to rsm.getColumnCount) {
          val table = rsm.getTableName(i)
          val columnName = rsm.getColumnName(i)
          val columnType = rsm.getColumnType(i) 
          val json = table == "T_TARGET" && columnName == "BLOB"
          variables.put((objectName, columnName, typeCode, index), (rs.getString(i), json))
        }
      }
    }
    variables.toMap
  
  }


}