Does Exposed support subqueries in in-clauses like

SELECT * FROM some WHERE id in (SELECT id2 FROM other)

. Can't seem to find it...

It also would need to get off the ThreadLocal hook, which is not trivial at all

@vikingmew try this

A.select { 
   exists(B.select { A.id eq B.id }) 
}

is this possible to concat strings in exposed? like

Employees.lastName.concat(Employees.firstName).like("SmithJohn")

I'm using [ViaTest.kt#L64](https://github.com/JetBrains/Exposed/blob/master/src/test/kotlin/org/jetbrains/exposed/sql/tests/shared/ViaTest.kt#L64) as reference for creating a DAO. I'm looking at ways to append things to a

SizedIterable

, if we take the test as an example the only way I've been able to do so is to do

n1.connectedStrings.toMutableList().add(x)

. Am I going way off base here?

I have this dependency:

<dependency>
            <groupId>com.mysql</groupId>
            <artifactId>jdbc</artifactId>
            <version>5.1.43</version>
        </dependency>

Hi, is it possible to add a unique key that consists of multiple fields?

Still having the same issue from before; if anyone has a project that works with MySQL and is using maven, I'd love to get a look at where you connect/your pom.

Please pay attention when use jdbc mysql driver with server-side prepared statements, there is memory leak in it. (https://bugs.mysql.com/bug.php?id=87429) Our team prepared custom build with fix for that driver, it is available in bug’s comment.

However, the error message is quite misleading

Does Exposed support one-to-many relationships?

To be more specific, will the

posts

property of the

Thread

class contain only elements that I add to it, or is it a reference to the

Posts

table and all of it's rows?

@lifk look for

via

function. Sample use at https://github.com/JetBrains/Exposed/blob/master/src/test/kotlin/org/jetbrains/exposed/sql/tests/shared/ViaTest.kt

Thanks for the advice, Andrey. I did it with a slight modification (because insertAndGetId was an unresolved reference)

val userId = Users.select {
                Users.deviceId eq requestDeviceId
            }.map { it[Users.id] }.singleOrNull() ?: Users.insert {
                it[deviceId] = requestDeviceId
            } get Users.id

@pastjean, it’s not supported right now, but you can find workaround in comments here https://github.com/JetBrains/Exposed/issues/93

Hello. Is there a way to use id value directly in Table operations if i went with DAO's EntityId<*> approach? In other words, how can i use, say, Long value to select from table if i declared table as LongIdTable?

@tapac - I am getting the following error

java.lang.IllegalStateException: can't find primary key of type Int or Long; map['com.outbrain.oen.services.oendblib.dao.ocas.OenCampaignStatusTable.ocas_id']='75191' (where map='{com.outbrain.oen.services.oendblib.dao.ocas.OenCampaignStatusTable.ocas_id=75191}')

Exposed doesn't support coroutines yet. Can you share your use-cases of how you going to use it? Should new short transaction be created for every async block? I hope you understand that you can't share same transaction for couroutines or it became synchronous code.

@wouterdoeland, could you provide code sample ?

let me know if that looks ok: https://github.com/JetBrains/Exposed/wiki/DAO

@wouterdoeland, Why do you need to cache it? In which use-case you want to wark with cache?

soo... might be a weird question: squash or exposed? so far ive been using squash, but seems like exposed has more features and they have roughly the same syntax for table declaration, but exposed looks better in the data access

@damian, I think you doing it right, but you might replace

dao.dependsOnTable.select {...}

with

dao.searchQuery{...}

. And ofc making query with order by and limit is much faster and effective than loading everything into memory, but don’t forget to add index to updated_at if you have large table.

I found HikariCP

I think that Nullable means that you can store null, but also have default value when insert DEFAULT or not provide value for field.

I'm just getting into Kotlin and curious if there was a way to generate Exposed objects from an existing database

Can i specify which scheme

Table

is in? Or are tables always created in default scheme?

Is there a function to create scheme from exposed, other than executing a dialect specific raw sql query?

i have a postgres database that I need to connect to. it contains a couple of columns with data type

timestamp without time zone

and I'm wondering how i should access this via exposed, would that be possible via

datetime

or do i have to create a custom

ColumnType

for this?