companion object : IntEntityClass<StarWarsFilm>(StarWarsFilms)

What exactly is this line?

I’m getting this test failure:

java.lang.AssertionError: Failed on sqlite expected:<2020-04-28T13:36:40.867901> but was:<2020-04-28T13:36:40.867>
	at org.junit.Assert.fail(Assert.java:88)
	at org.junit.Assert.failNotEquals(Assert.java:834)
	at org.junit.Assert.assertEquals(Assert.java:118)
	at kotlin.test.junit.JUnitAsserter.assertEquals(JUnitSupport.kt:32)
	at kotlin.test.AssertionsKt__AssertionsKt.assertEquals(Assertions.kt:51)
	at kotlin.test.AssertionsKt.assertEquals(Unknown Source)
	at org.jetbrains.exposed.JavaTimeTestsKt.assertEqualDateTime(JavaTimeTests.kt:57)

Good day! Is there any way to specify transaction isolation level for suspended transaction?

I have a branch where i replaced mysql-mxj with testcontainers. we could possibly use testcontainers for all databases.

related question: what code formatter settings does exposed use? or just no automatic formatting at all?

Say I have a

VARCHAR

column in MySQL with charset

LATIN1

. Can I specify this in the table object so it will create the correct

CREATE TABLE

statement ?

Hi, I was wondering, if I want to create a reference between one table and multiple other tables. is this possible? For example: Lets say I have an Uploads table and I want Users table to have uploads and Posts table to have uploads as well. Can this be done with exposed? I mean with the

referencedOn

and

referrersOn

functions

Is there a select method by Primary Key, where you know that only one row will be returned?

Not sure if this is intentional, but... If you use

suspendedTransactionAsync

and a normal blocking

transaction

in the same coroutine, Exposed (well, in this case, HikariCP) throws a

Connection is closed

exception. Is this intentional? If I change the

suspendedTransactionAsync

to a normal

transaction

again, the issue goes away. If I change every

transaction

to a

suspendedTransactionAsync

, the issue also goes away. I found that bug when I found out that Exposed does support coroutines so I decided to start replacing some of my old blocking transactions with coroutine-aware methods

Does exposed only support a global app level database? I cant connect to 3 different databases and do queries?

@tapac At some point, will Exposed have Redis interfaces/support?

Hey! How's the coroutine support on this library? I'm looking for a coroutine-powered library to interact with postgres, but I can't really find any 😕

Hello all. How can i do this?

This message was deleted.

Hi everyone, I'm struggling to achieve a Postgres distinct on/order by query using the Exposed DSL... I'm looking to execute something like this

select distinct on
    (cats.name) cats
from 
    groups_cats
inner join
    cats
on
    groups_cats.cat_id = cats.id
where
    groups_cats.cat_id = 25
order by 
    cats.name, groups.created desc

I've managed to come up with this

GroupsCats
    .join(Cats, JoinType.INNER) { Cats.id eq GroupsCats.catId }
    .select { GroupsCats.catId eq catId }
    .orderBy(Cats.created to SortOrder.DESC)

But I can't figure out how to make the result distinct on a particular column (cat name in this case)... the

withDistinct()

method sounded hopeful but doesn't seem to work in the way that I need. If anyone has any ideas/suggestions I would really appreciate it.

has anyone made the jump from spring-boot/spring-data/JPA to spring-boot/exposed?

We have a strange behaviour using Exposed with spring boot and hikari with maximum pool size 1. We use this size of pool in local/test environments, and we get an error:

HikariPool-1 - Connection is not available, request timed out after 30005ms

Quick debugging showed, that Exposed is trying to acquire some metadata about database before transaction started. This is as far as I can get before error: org/jetbrains/exposed/sql/Database.kt:22. Is it an expected behaviour and exposed requires minimum amount of connections when used with spring, or is it something that can be fixed?

I was using driver class

com.impossibl.postgres.jdbc.PGDriver

, since

24.1

it doesn't seem to be recognized as a postgre dialect 🤔 . Anyone got a hint before I go debugging? EDIT: nvm, found it, has it's own dialect name ("pgsql") now

@tapac Hello! Is there any information about reviewing this PR: https://github.com/JetBrains/Exposed/pull/915?

I am currently on Exposed

0.17.3

and I'm trying to upgrade to

0.25.1

. A recent change has meant that I am seeing the following error when using

Database.connect

with `org.apache.tomcat.jdbc.pool.DataSource`:

Overload resolution ambiguity. All these functions match.
public final fun connect(datasource: ConnectionPoolDataSource, setupConnection: (Connection) → Unit = ..., manager: (Database) → TransactionManager = ...): Database defined in org.jetbrains.exposed.sql.Database.Companion
public final fun connect(datasource: DataSource, setupConnection: (Connection) → Unit = ..., manager: (Database) → TransactionManager = ...): Database defined in org.jetbrains.exposed.sql.Database.Companion

is there a way to set the “default slice” for a table? like let’s say there’s a column that i want to read in literally one codepath in my entire codebase and it doesn’t need to ever get read unless i actively add it with

.slice

. is that possible (if i do want to be able to be lazy and use the default ‘all columns’ slice in many places)?

Hi everyone, when handling a pagination query, to get both the query result and the total number of results before

limit

and

offset

is applied in 1 query, you have to use a window function:

SELECT foo
     , count(*) OVER() AS full_count
FROM   bar
WHERE  <some condition>
ORDER  BY <some col>
LIMIT  <pagesize>
OFFSET <offset>;

or in case of MySQL, the FOUND_ROWS feature:

SELECT SQL_CALC_FOUND_ROWS * FROM tbl_name WHERE id > 100 LIMIT 10;
SELECT FOUND_ROWS();

Is there a way to achieve the same thing with Exposed ?

Hi, I’ve just raised a PR to implement replace in h2sql using the native

MERGE INTO

syntax. The wiki says I should look for builds of my PR in teamcity, but it isn’t showing up. Is there anything else I need to do? Here’s the PR: https://github.com/JetBrains/Exposed/pull/942

I feel like I haven’t quite figured out the right tricks for using the boolean expression operators (

Expression<Boolean>.and

and friends) w.r.t. operator precedence. Do I just need to always parenthesize every sub-expression? I guess Kotlin doesn’t really do precedence levels of custom infix operators?

Hey, I’ve raised a pull request to improve (in my opinion) the implementation of

replace

for h2sql. It passes the standard build, but I’m not really sure where to proceed from here. The Contribution guide says to

Submit Pull Request on review.

but I’m not sure what that actually means. What are the next steps after creating a PR?

How can I declare a timestamp type to match with timestamp column in MySQL. I read the document and it shows ‘datetime’ type. But intelliJ cant import it.

Hello everyone. I have a little problem.

Hey guys, I’m using Netty with Kotlin Exposed. The console prints out the database transactions that look like this:

DEBUG Exposed - INSERT INTO ...

Would anyone know how to suppress these messages?

I'm writing a Snowflake dialect for exposed. The good news is that 11/19 tests pass 🙂 If you're interested in this work, my fork and branch https://github.com/dmitchell/Exposed/tree/snowflake. I'd welcome critiques and help. Right now, it's failing on the prepared statements where somehow the values are not properly going to the payload.

org.jetbrains.exposed.JavaTimeBaseTest > javaTimeFunctions STANDARD_OUT
    20:41:39,049  WARN Test worker Exposed:invoke:183 - Transaction attempt #0 failed: java.sql.SQLFeatureNotSupportedException. Statement(s): INSERT INTO CITIESTIME (LOCAL_TIME, "NAME") VALUES (?, ?)
    org.jetbrains.exposed.exceptions.ExposedSQLException: java.sql.SQLFeatureNotSupportedException
    SQL: [INSERT INTO CITIESTIME (LOCAL_TIME, "NAME") VALUES (?, ?)]
        at org.jetbrains.exposed.sql.statements.Statement.executeIn$exposed_core(Statement.kt:50)
...
org.jetbrains.exposed.JavaTimeBaseTest > javaTimeFunctions FAILED
    org.jetbrains.exposed.exceptions.ExposedSQLException: java.sql.SQLFeatureNotSupportedException
    SQL: [Failed on expanding args for INSERT: org.jetbrains.exposed.sql.statements.InsertStatement@3f32f77b]
        at org.jetbrains.exposed.sql.statements.Statement.executeIn$exposed_core(Statement.kt:50)
...
WARNING: An illegal reflective access operation has occurred
WARNING: Illegal reflective access by net.snowflake.client.jdbc.internal.io.netty.util.internal.ReflectionUtil (file:/Users/dmitchell/.gradle/caches/modules-2/files-2.1/net.snowflake/snowflake-jdbc/3.12.7/e47fa73b85037285b887c63602f9c509df27b2be/snowflake-jdbc-3.12.7.jar) to constructor java.nio.DirectByteBuffer(long,int)
WARNING: Please consider reporting this to the maintainers of net.snowflake.client.jdbc.internal.io.netty.util.internal.ReflectionUtil
WARNING: Use --illegal-access=warn to enable warnings of further illegal reflective access operations
WARNING: All illegal access operations will be denied in a future release