时间戳

首页 > 解决方案 > scala加载配置地图地图

scala - scala加载配置地图地图

问题描述

我需要从配置文件中读取并将配置映射到案例类。如果我有一个如下表，它可以正常工作

配置

mapping {
   target {
     oracle  = {
         type = "oracle"
         schema    = "orcl"
         tableName = "my_table"
         query = "select key from my_table where dob='2020-01-01'
     }
}

SCALA 代码片段

 val targetConfig:Map[String,QueryEngine] = config.getObject("mapping.target")
    .entrySet()
    .asScala
    .foldLeft(Map.empty[String , QueryEngine]) { case ( acc , entry ) =>
      val target = entry.getKey
      val targetConfig = entry.getValue match {
        case validElement if validElement.valueType() == ConfigValueType.OBJECT  => validElement.asInstanceOf[ConfigObject].toConfig
        case invalidElement => sys.error("illegal syntax at $invalidElement")
      }

      targetConfig.getString("type")    match {

        case "oracle" => acc + (target ->  new OracleQueryEngine(vars,target,targetConfig.getString("schema"),targetConfig.getString("tableName"),targetConfig.getString("query"),targetConfig.getString("param")))

        case  x   => sys.error(s"unknow target not defined $targetConfig with $targetConfig")
      }
    }

现在我用目标映射中的多个表更新了 CONFIG。

mapping {
   target {
     oracle  =   
        emp = {
         type = "oracle"
         schema    = "orcl"
         tableName = "emp"
         query = "select key from emp where dob='2020-01-01'
        }
        dept = {
         type = "oracle"
         schema    = "orcl"
         tableName = "dept"
         query = "select key from dept where dob='2020-01-01'
        }
    }
}

多表场景的代码片段 

This is giving error 
Error:(22, 28) type mismatch;
 found   : scala.collection.mutable.Buffer[scala.collection.immutable.Map[String,QueryEngine]]
 required: scala.collection.immutable.Map[String,QueryEngine]
          objs.asScala.map { obj =>

代码片段

val sourcesConfig: Map[String, QueryEngine] = 
config.getObject("mapping.target")
 .entrySet()
 .asScala
 .foldLeft(Map.empty[String, QueryEngine]) { case (acc, entry) =>
   val source = entry.getKey

   entry.getValue match {
    case objs:ConfigList =>
      objs.asScala.map { obj =>
        val sourceConfig = obj.asInstanceOf[ConfigObject].toConfig
        sourceConfig.getString("type") match {
          case "oracle" => acc + (source -> new OracleQueryEngine(vars,source,sourceConfig.getString("schema"), sourceConfig.getString("tableName"), sourceConfig.getString("query"), sourceConfig.getString("param")))
          case x => sys.error(s"unknown source not defined $source with $sourceConfig")

        }

      }
  }

标签： scalascala-collectionstypesafe-config

解决方案

将“oracle”包裹在大括号中，因为它是JsObject：

mapping {
   target {
     oracle  = {   
        emp = {
         type = "oracle"
         schema    = "orcl"
         tableName = "emp"
         query = "select key from emp where dob='2020-01-01'
        }
        dept = {
         type = "oracle"
         schema    = "orcl"
         tableName = "dept"
         query = "select key from dept where dob='2020-01-01'
        }
    }}
}

它现在有效吗？

如果不使用例如PureConfig。

您的解决方案可以像这样简单：

import pureconfig._
import pureconfig.generic.auto._

case class Mappings(mapping: Mapping)
case class Mapping(target: Oracle)
case class Oracle(oracle: Map[String, Map[String, String]])

ConfigSource.default.load[Mappings]

推荐阅读