vertx-ktx-sql

This is a DSL of Vertx-Database-Access with Kotlin.

It's very simple and lightweight, but it might be useful to you.

For example:

suspend fun main() {

    val vertx = Vertx.vertx()

    //vertx api,create a AsyncClient
    val client = MySQLClient.createShared(vertx, json {
        obj(
            "username" to "root",
            "password" to "root",
            "database" to "study"
        )
    })

    //extension create a connection
    client.connection {
    
        queryJsonWithParams(json {
            array(1)
        }) {
            //build a sql
            sql {
                this select all from "user" where "id" eql param
            }
        }.forEach {
            println(it)
        }

    }.join()

    client.close()

    vertx.close()
}

---

If you just want to build a sql string with dsl, you can just download the SQL.kt and SQLBuilderExt.kt

Support following function to append a sql keyword, but not all.

You can see more at SQL.kt

• select
• from
• where
• eql
• insert_into
• value
• values
• inner_join
• left_join
• right_join
• update