Light ORM enabling type-safe SQL with idiomatic syntax. Supports JDBC, R2DBC, Vertx sqlclient, and various databases including PostgreSQL, MySQL, and SQLite. No annotations or code generation required.
A light ORM that offers the idiomatic way to write Kotlin type-safe SQL for JVM and Android
See the project website for documentation and APIs.
Kotysa is easy to use : 3 steps only
data classes are great for that !
data class Role(
val label: String,
val id: UUID = UUID.randomUUID()
)
data class User(
val firstname: String,
val roleId: UUID,
val alias: String? = null,
val id: Int? = null
)
Use our type-safe Tables DSL to map your entities with the database tables, this is the ORM (object-relational mapping) step
object Roles : H2Table<Role>("roles") {
val id = uuid(Role::id)
.primaryKey()
val label = varchar(Role::label)
.unique()
}
object Users : H2Table<User>("users") {
val id = autoIncrementInteger(User::id)
.primaryKey("PK_users")
val firstname = varchar(User::firstname, "f_name")
val roleId = uuid(User::roleId)
.foreignKey(Roles.id, )
alias = varchar(User::alias)
}
tables = tables().h2(Roles, Users)
Use our type-safe SqlClient DSL, Kotysa executes SQL query for you !
val admins = (sqlClient selectFrom Users
innerJoin Roles on Users.roleId eq Roles.id
where Roles.label eq "admin"
).fetchAll() // returns all admin users
No annotations, no code generation, no proxy, no additional plugin, just regular Kotlin code ! No JPA, just pure SQL !
Contributions are welcome.
git clone git@github.com:ufoss-org/kotysa.git
./gradlew clean build
Surfaced from shared tags and platforms — no rankings paid for.