有没有一种方法可以使用Kotlin的Exposed库运行原始sql [英] Is there a way to run raw sql with Kotlin's Exposed library

问题描述

我正在尝试运行一些特定于postgres的sql，并希望在Exposed中重用事务管理.

I'm trying to run some sql specific to postgres and would like to reuse the transaction management within Exposed.

推荐答案

借助Kiskae的回答，我能够使用以下命令运行原始sql:

With help from Kiskae's answer, I was able to run the raw sql with:

transaction {
     val conn = TransactionManager.current().connection
     val statement = conn.createStatement()
     val query = "REFRESH MATERIALIZED VIEW someview"
     statement.execute(query)
}

这篇关于有没有一种方法可以使用Kotlin的Exposed库运行原始sql的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！