kotlinlang #exposed

Hi! Is any of you planning to submit a session about Exposed to KotlinConf? I’m a big fan of Exposed and I’m considering submitting a topic about it. I’d like to double check so that we don’t end up with a topic collision.

🚫 1

oshai

01/23/2018, 1:44 PM

Is there an NotOp similar to OrOp and AndOp?

oshai

01/23/2018, 1:44 PM

didn't find one, but in mysql it is possible to do that

neil

01/25/2018, 5:22 PM

I'm trying to use h2 to test exposed but any time I try to use the database it says that the tables can't be found, am I missing something obvious?

neil

01/25/2018, 5:23 PM

I'm doing

Database.connect("jdbc:h2:mem:test", driver = "org.h2.Driver")

then later just wrapping statments in a

transaction {}

block

neil

01/25/2018, 5:31 PM

I've gotten is working by using a file db

jdbc:h2:./test

bkenn

01/25/2018, 5:42 PM

Have you created the tables?

neil

01/25/2018, 6:49 PM

yeah, I had created the tables but I think that the issue was that the in memory db was being closed

neil

01/25/2018, 6:49 PM

the file db is working now

neil

01/25/2018, 6:49 PM

is there any way to read from the db synchronously? I want to do something like

val user = transaction { Table.find{...} }

neil

01/25/2018, 6:49 PM

or do a read without a transaction block?

fred.deschenes

01/25/2018, 6:54 PM

val user = transaction...

should work, but you do need the

transaction

with Exposed

tapac

01/25/2018, 8:40 PM

@neil you need to add param to url to prevent closing db. Look at exampke here https://github.com/JetBrains/Exposed/blob/6c80f309d4409cadfd1540494683a7a197a4ab08/src/test/kotlin/org/jetbrains/exposed/sql/tests/h2/MultiDatabaseTest.kt

dave08

01/25/2018, 8:51 PM

And only certain fields...

neil

01/25/2018, 9:08 PM

@tapac awesome, thank-you!

dumptruckman

01/25/2018, 10:48 PM

Nevermind... just gonna go with the DSL method

dumptruckman

01/25/2018, 10:48 PM

If I'm expecting 1 result (say because I put a limit of 1), is there a better way to handle the results than forEach?

tapac

01/25/2018, 11:15 PM

YourEntity.find{}.limit(1).singleOrNull()

dumptruckman

01/26/2018, 1:07 AM

dumptruckman

01/26/2018, 1:08 AM

Any idea what is happening here?

-.txt

dumptruckman

01/26/2018, 1:11 AM

Wasn't having any problems until I ran this on windows

dumptruckman

01/26/2018, 1:11 AM

It worked fine initially on Windows too

dumptruckman

01/26/2018, 1:12 AM

and on a subsequent run of the program it did this

dumptruckman

01/26/2018, 1:18 AM

could it be because I'm using long for id?

dumptruckman

01/26/2018, 1:46 AM

ok, i think somehow i was trying to insert when the entity already existed in the table

dumptruckman

01/26/2018, 1:47 AM

ah.. i'm guessing the indexing in exposed starts at 0 instead of 1?

tapac

01/26/2018, 7:14 AM

Indexing?

dave08

01/26/2018, 7:28 AM

Are there any plans for supporting async requests and coroutines? That would be a beautiful pair with Ktor!...

tapac

01/26/2018, 10:05 AM

Yep, we are think about it, but this is a bit problematic due to blocking nature of jdbc.