不带HOCON的ScalikeJDBC配置

Question

我需要从~/myConfig.json进行初始化，如下所示：

{
  "databaseActive": "production",
  "databases": [
    {
      "name": "localhost",
      "PGDB": "asdf",
      "PGHOST": "localhost",
      "PGPASSWORD": "asdf",
      "PGPORT": "5432",
      "PGUSER": "asdf"
    },
    {
      "name": "production",
      "PGDB": "asdf",
      "PGHOST": "asdf.rds.amazonaws.com",
      "PGPASSWORD": "asdf",
      "PGPORT": "5432",
      "PGUSER": "asdf"
    }
  ]
}

这意味着我不能调用scalikejdbc.config.DBs.setupAll()。根据databaseActive的值，如何使用这个JSON文件从适当的数据库设置中初始化scalikeJDBC

Answer 1

ScalikeJDBC只提供HOCON阅读器。如果您使用自己的JSON配置文件，则需要编写自己的JSON解析器来检查databaseActive。

解析您的配置并将其绑定到ScalikeJDBC的配置类将非常简单：

• https://github.com/scalikejdbc/scalikejdbc/blob/3.3.5/scalikejdbc-config/src/main/scala/scalikejdbc/config/DBs.scala#L10-L17
• https://github.com/scalikejdbc/scalikejdbc/blob/3.3.5/scalikejdbc-config/src/main/scala/scalikejdbc/config/TypesafeConfigReader.scala#L59-L124