Exposed SQL Functions examples

A Gradle application that shows how to perform units of work with database transactions using Exposed API. The files are referenced in the Transactions's Working with SQL Strings topic.

Prerequisites

The project contains examples that run against H2 and MySQL databases. While H2 makes use of in-memory storage, in order to run queries against MySQL, you must first install MySQL and create a local database.

To learn how to install MySQL, see the installation guide.

Database configuration

All database connections are configured within the App.kt file located in src/main/kotlin/org/example/. You might want to adjust the MySQL database configuration to match your local setup.

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

Build

To build the application, in a terminal window navigate to the snippets folder and run the following command:

./gradlew :exposed-transactions:build

Run

To run the application, in a terminal window navigate to the snippets folder and run the following command:

./gradlew :exposed-transactions:run

This will run queries to create new tables and run all functions in the /examples folder. To only run a specific example, modify the App.kt file and re-run the project.