fun main()

in documentation-website/Writerside/snippets/exposed-transactions/src/main/kotlin/org/example/App.kt [13:39]

• 24 lines of code
• 1 McCabe index (conditional complexity)

fun main() {
    val h2Db = Database.connect(
        "jdbc:h2:mem:test",
        "org.h2.Driver",
        databaseConfig = DatabaseConfig { useNestedTransactions = true }
    )

    val mysqlDb = Database.connect(
        "jdbc:mysql://localhost:3306/test?allowMultiQueries=true",
        driver = "com.mysql.cj.jdbc.Driver",
        user = "root",
        password = "password",
    )

    transaction(h2Db) {
        addLogger(StdOutSqlLogger)
        SchemaUtils.create(FilmsTable)
        runExecExamples()
        runSavepointExample()
    }

    transaction(mysqlDb) {
        addLogger(StdOutSqlLogger)
        SchemaUtils.create(FilmsTable)
        runExecMySQLExamples()
    }
}