Exposed 0.10.3 was released (https://bintray.com/kotlin/exposed/exposed/0.10.3) Features: 1. Floating point columns 2. Check constraint functionallity (kudos to @SackCastellon) 3. Possibility to provide custom names for contraints and indexes (thanks to @mduesterhoeft) 4. Added support to delete with limit and offset (thanks @Yuku Kotani for initial PR) 5. Full SQL will be now logged on any SQLException (#288 [Suggestion] Log the SQL query when an exception is thrown) 6. Postgres support for ignore + replace 7. H2 support for INSERT IGNORE for new H2 version 8. Statement interceptors now allow triggering on before commit and rollback 9. Database ENUM types supported (read more [here](https://github.com/JetBrains/Exposed/wiki/DataTypes#how-to-use-database-enum-types)) Bug fixes: 1. #279 'SELECT MAX(datetime)' throws ClassCastException 2. #289 UUID's are not shown in logs 3. #284 Postgres, DSL Approach: primary key with custom names beside `...

@tapac Next release?

I see that there’s an

onDelete = ReferenceOption.CASCADE

for foreign key constraints. Is there support for something like MySQL’s

ON UPDATE CASCADE

?

Hello guys! I am planning on moving to this library for persistence, planning to use the DSL since I want more control of my sqls. Just a general question really, how do one handle nested relations with a dsl approach? One may want to have relations on the domain model but don’t load them all the time, so they would be null, so you would end up with a lot of stuff that is null, which is not nice. How do you guys do this? Remove the relations from the domain model and just keep the relations in the database, i.e dont do

entity.otherEntites

but rather

DB.getOtherEntetiesFor(entity)

or similar. How do you do this, need tips 🙂

That’s fine, but there’s no way for me to specify utf8mb4 as either the

characterEncoding

or the

characterSetResults

. Exposed blows up with an

ExceptionInInitializedError

. If

characterSetResults=utf8mb4

is specified on the connect string, the underlying exception is

java.sql.SQLException: Can't map utf8mb4 given for characterSetResults to a supported MySQL encoding.

, and if I do

characterEncoding=utf8mb4

, it is

java.sql.SQLException: Unsupported character encoding 'utf8mb4'

.

Hi there can I catch specific exceptions instead of just a blanket exception (

ExposedSQLException

)? Right now I have to do string processing on the message given by the exception to perform any task. Something like

RefrentialIntegrityConstraintViolationException

or

UniqueConstraintViolationException

etc would be really helpful.

Hi! I'm a bit new to ORM and DB connection in app. I've switched from DAO to DSL way because of better separation between data and code (multitier architecture). Question - what would you recommend to access values from referenced columns (like in DAO way)? I'm talking about using

data class

in higher tiers. Only possible way I could come up with is to create

Map

for every 1:N relationship, which might be very monstrous in the end. How do you usually deal with that? Thanks for the reply in advance!

Any ideas when 0.10.4 will be out, @tapac?

Hi everyone! Can anyone answer, is there nested transactions support?

So first, how the heck does this even work? I can’t seem to figure it out from reading the source.

inList and other functions declared within SqlExpressionBuilder that’s why you can’t access them out of select {} block, which defined as :

inline fun FieldSet.select(where: SqlExpressionBuilder.()->Op<Boolean>)

Does exposed (DAO) support inheritance of tables? I'm hoping for

abstract class BaseTable : LongIdTable() {
val createdOn = datetime("createdOn")
val lastUpdatedOn = datetime("createdOn")
}

object Page : BaseTable() {
val name = varchar("name",255)
.... *etc*

Does anyone else's brain just hurt trying to build relationships in Exposed DAO? When to use

referrersOn

, when to use

referencedOn

? What's wrong with

hasOne

,

hasMany

? The DSL syntax is so much cleaner, but isn't really an ORM. Why a class and an object? And why do I only have to set up the relationship between two tables on three of these?

Hi. I just noticed that despite be calling

batchInsert()

, requests printed in console are all separate inserts rather than

INSERT INTO table (col1, col2) VALUES (val11, val12), (val21, val22), (val31, val32)

. Am i misunderstanding how batch supposed to work in Exposed?

Another question: can i manually abort transaction from within transaction block? Other than to throw exception?

Tell me how to write such a SQL query?

SELECT IF(myTableColumn<2 OR myTableColumn>4, TRUE, FALSE) as myColumn FROM myTable;

How would I write a query like this using Exposed?

SELECT requested.GroupId, requested.Member, requested.isAdmin, requested.isOwner
  FROM GroupMembers requested, GroupMembers requestor
  WHERE requested.GroupId = 1 AND requested.Member = 1 AND requestor.GroupId = 1 AND requestor.Member = 2

Is there a way to set the timezone for postgres other than

-Duser.timezone=UTC

?

Has support for mysql

USE INDEX

been considered ?

is there any way to begin and commit a transaction in two steps instead of using the

transaction

function that takes a lambda?

@tapac - do you think it can be a good idea to wire up exposed to async driver?

Can anyone point me in the right direction for using Exposed with TornadoFX? Google isn’t giving me much love. Currently getting:

Sep 19, 2018 3:54:51 PM tornadofx.DefaultErrorHandler uncaughtException
SEVERE: Uncaught error
java.lang.IllegalStateException: No transaction in context.

Before I go spelunking deeper into why my code stopped working when I update from

0.10.4

to

0.10.5

, does anyone here have theories as to why this update would fail? There are no changes in the code, just the version change. The failure is in integration tests that start with a clean database every time. This is on a MySQL instance:

2018-09-19 16:41:39.502 [io-thread-1] INFO  Exposed - Transaction attempt #0 failed: java.sql.BatchUpdateException: Cannot add or update a child row: a foreign key constraint fails (`authdb`.`Roles`, CONSTRAINT `Roles_ibfk_1` FOREIGN KEY (`orgId`) REFERENCES `Orgs` (`id`) ON DELETE CASCADE ON UPDATE CASCADE). Statement(s): INSERT INTO Roles (name, orgId, permissions) VALUES (?, ?, ?);
INSERT INTO Roles (name, orgId, permissions) VALUES (?, ?, ?);
INSERT INTO Roles (name, orgId, permissions) VALUES (?, ?, ?);
INSERT INTO Roles (name, orgId, permissions) VALUES (?, ?, ?)
org.jetbrains.exposed.exceptions.ExposedSQLException: java.sql.BatchUpdateException: Cannot add or update a child row: a foreign key constraint fails (`authdb`.`Roles`, CONSTRAINT `Roles_ibfk_1` FOREIGN KEY (`orgId`) REFERENCES `Orgs` (`id`) ON DELETE CASCADE ON UPDATE CASCADE)

How can I get a table object's contains operator to differentiate between parameters corresponding to different fields that are both strings? I'm currently writing out different classes for each string to accomplish this, but if there's an easier way, i'm all ears. e.g.

operator fun contains(username: String): Boolean = UserEntity.find { self.username eq username }.count() > 0
operator fun contains(email: Email): Boolean = UserEntity.find { self.email eq email }.count() > 0

also if there's a more efficient way to write a contains function, i wouldn't be surprised in the slightest

I'm getting an 'IllegalStateException - "countOfOtherEntity" is not in record set' error. Is my understanding of this correct? Should I be able to access this value through val countOfOtherEntity = integer("countOfOtherEntity")?

Hi, I have table song and table genre. Song can contains more genres. So I want reference genreIds from table genre. How I can reference to array of foreign keys? For single reference is syntax (integer(“genre_id”) references GenreTable.id) it is working but what about more values?. Or I use it bad?

Does anyone know how to write something like andWhere if I use many to many reference?

what is the url for the jdbc driver? im using

val jdbc = "jdbc:mysql://$user:$pass@$url"
    Database.connect(jdbc, driver)

with

com.mysql.cj.jdbc.Driver

as driver, and url being

[redacted]:3306/[databaseName]

I'm new to kotlin, not sure how to do it properly