Is there a way to run raw sql with Kotlin's Exposed library

kotlin ktor kotlin-exposed
pondermatic picture pondermatic · Dec 5, 2016 · Viewed 8.9k times · Source

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

Answer

Kiskae picture Kiskae · Dec 6, 2016

Exposed has the Transaction.exec(String) method which probably does what you want. See https://github.com/JetBrains/Exposed/blob/master/exposed-tests/src/test/kotlin/org/jetbrains/exposed/sql/tests/mysql/MysqlTests.kt

Related questions

java.lang.UnsupportedOperationException: Reflective setAccessible(true) disabled

When I run my Ktor application with gradle run then I've got the following exception: 19:21:11.795 [main] DEBUG io.netty.util.internal.logging.InternalLoggerFactory - Using SLF4J as the default logging framework 19:21:11.810 [main] DEBUG io.netty.util.internal.PlatformDependent0 - …

Read More
Unfortunately MyApp has stopped. How can I solve this?

I am developing an application, and everytime I run it, I get the message: Unfortunately, MyApp has stopped. What can I do to solve this? About this question - obviously inspired by What is a stack trace, and how can …

Read More
Alarm Manager Example

I want to implement a schedule function in my project. So I Googled for an Alarm manager program but I can`t find any examples. Can anyone help me with a basic alarm manager program?

Read More