ktor_part3_AppDatabase

AppDatabase.kt

@KtorExperimentalAPI
class AppDatabase(
    private val config: ApplicationConfig
) {
    lateinit var dataSource: DataSource
    fun init() {
        connectionPool()
        orm()
    }
    private fun connectionPool() {
        val dbConfig = this.config.config("ktor.database")
        val config = HikariConfig().apply {
            jdbcUrl = dbConfig.property("connection.jdbc").getString()
            username = dbConfig.property("connection.user").getString()
            password = dbConfig.property("connection.password").getString()
            isAutoCommit = false
            maximumPoolSize = 3
            transactionIsolation = "TRANSACTION_REPEATABLE_READ"
            validate()
        }
        dataSource = HikariDataSource(config)
    }
    private fun orm() = Database.connect(dataSource)
}