kotlinlang #exposed

Hi everyone, I'm curious about the Spring Boot Starter. Could some please link me to an example project that uses it? Also I don't get why it is good to be able to use the spring-transaction library (vs Exposed's transaction handling)? Thx, Best regards

maxmello

06/22/2021, 3:52 PM

I want to be able to implement something like a GIN index in Postgres using Exposed, and I’ve already figured out that one can pass the

indexType

Table.index

such that it uses the

USING GIN (...);

syntax, but the

class Index

only allows indices on `Column`s, not on something like

ExpressionWithColumnType

, so something like this seems impossible:

Copy code

CREATE INDEX idx_fts_post ON post USING gin((setweight(to_tsvector(title),'A') || setweight(to_tsvector(content), 'B')));

Is there a workaround for that? Sadly the

Index

class is not open, and therefore I cannot create a subclass with modified behavior. Can one create something like a fake column and get away with it? (Note: I already created custom Exposed functions to use the postgres-specific functions like

to_tsvector

) Maybe it would also be possible to modify the Exposed code to allow something like this in the future? When I see the usage of

columns

Index

, it really seems that if one would provide a custom name for the index and add some

if(columnLike is Column<*>)

to the parts where behavior is dependent on the it actually being a column of the table, this would not be a breaking change to make.

Jgafner

07/02/2021, 5:43 AM

Hi Is there a way to have a data class from IntEntity ? Something like that ?

Copy code

data class AClass (id: EntityID<Int>) : IntEntity(id)

If not any documentation on how to transform the AClass to a data class to be serialize ? Tnx

Imran/Malic

07/14/2021, 8:24 AM

Does someone know how to resolve a breaking change in

0.32.1

? previously, when I would execute

Copy code

exec("EXEC sp_msforeachtable @command1 = \"ALTER TABLE ? NOCHECK CONSTRAINT all\";")

in the case that there is no ResultSet it doesn't blow up, but now it does - in the case that the ResultSet is empty or non-existent. it fails with:

Copy code

WARN -Transaction attempt #1 failed: com.microsoft.sqlserver.jdbc.SQLServerException: The statement did not return a result set.. Statement(s): EXEC sp_msforeachtable @command1 = "ALTER TABLE ? NOCHECK CONSTRAINT all"; org.jetbrains.exposed.exceptions.ExposedSQLException: com.microsoft.sqlserver.jdbc.SQLServerException: The statement did not return a result set.
    	at org.jetbrains.exposed.sql.statements.Statement.executeIn$exposed_core(Statement.kt:62)
    	at org.jetbrains.exposed.sql.Transaction.exec(Transaction.kt:135)
    	at org.jetbrains.exposed.sql.Transaction.exec(Transaction.kt:121)
    	at org.jetbrains.exposed.sql.Transaction.exec(Transaction.kt:97)
    	at org.jetbrains.exposed.sql.Transaction.exec(Transaction.kt:83)
    	at org.jetbrains.exposed.sql.Transaction.exec$default(Transaction.kt:82)

Lbenyehu

07/20/2021, 11:18 AM

Hi guys! I didn’t find any explanation how to create a table (postgres in my case) with partitions… someone know?? 🙂

Łukasz Bednarczyk

07/20/2021, 1:21 PM

Open GitHub - JetBrains/Exposed: Kotlin SQL Framework and use “ctrl/cmd + f” with phrase “.create (” 😛

🧵 2

Phil Richardson

08/07/2021, 8:04 PM

Hi, I am looking to understand how I can back reference in entities. I note we have

(optional)BackReferencedOn

for use in my entity, but there is scant examples out there. I note issue 583 covering an example of this, but it doesn't seem anything got back into the Wiki It states

... you expect zero or one additional info for a user, but every info has user

It should be expected to be a 1-to-1 mapping only The wider crux of this means the following expanded knowledge For 1-to-1 mapping Use

(optional)BackReferencedOn

on the entity that will always exist Use

referencedOn

on the entity that may or may not exist, but will never exist unless the parent does Accessing either value in a entity will only ever return a single entity (or null depending on use) For 1-to-many mapping Use

referrersOn

the left hand side entity - The 1 entity, that can have many children refer to it - Its value in a entity will be a list (0 or more entries) Use

referencedOn

the right hand side entity - The many entities, that can refer to a single parent entity - Its value will be a entity (always 1) Is this (weird, if convoluted) interpretation correct?

tapac

08/08/2021, 8:53 PM

Exposed 0.33.1 released with math and trigonometrical functions, bitwise operators and some broken changes. Please check the recent change log for more information

🎉 7

Łukasz Bednarczyk

08/09/2021, 6:35 AM

Can you show how can I use

SchemaUtils.crerateDatabase?

Should I call it outside a transaction?

Nayeem Zen

08/09/2021, 6:14 PM

Hello friends 👋 I’m new to the Slack, pleased to (virtually) meet you all!

Nayeem Zen

08/09/2021, 6:18 PM

We were considering using Exposed in our Kotlin backend stack and currently deciding between Exposed and JOOQ. I love Exposed and the design behind it but I don’t have too much experience with it. I’ve read online about concerns about production-readiness, outstanding issues and lack of developers on the project (but seems pretty active on Github). I wanted some feedback and insights from y’all in terms of using Exposed in production for a large backend project with a fairly complex domain.

Łukasz Bednarczyk

08/12/2021, 11:11 AM

Hi folks 😉 how can I set in exposed column createdAt default value from PSQL function now()?

tapac

09/01/2021, 5:13 PM

Exposed 0.34.1 released with

Op.nullOp()

function to represent NULL in queries,

Table.Dual

object to make selects on dummy table,

Table.batchReplace

and low-level performance optimizations + several bug fixes. Please check the recent change log for more information.

🎉 8

dave08

09/05/2021, 11:18 AM

Hi! It seems like the fact that an id needs to be an EntityID makes it impossible to have the domain layer not have a dependency on Exposed for DAO classes... ideally I would have defined them as interfaces in the domain layer and implemented them in exposed in the data module, is this possible in any way?

dave08

09/05/2021, 12:52 PM

In general, it looks like there's already an issue in Github about making Exposed more testable... but that's a more general issue, here this is just making entity structures a bit easier to re-use.

dave08

09/05/2021, 1:27 PM

Also, is there support for kotlinx.datetime?

dave08

09/05/2021, 1:44 PM

Oh... https://github.com/JetBrains/Exposed/issues/1325

tapac

09/15/2021, 9:56 AM

Exposed bug fix release 0.34.2 is here https://github.com/JetBrains/Exposed/blob/master/docs/ChangeLog.md#0342

👍🏼 1

🙏 1

👍 5

tapac

09/22/2021, 7:25 PM

Greetings everyone, I want to announce huge feature-rich release 0.35.1: • kotlin-datetime module • NULL FIRST/LAST ordering support • New way to configure Exposed specific database settings via DatabaseConfig • Configurable limit of how many entities will be cached in the EntityCache • Access to entity refererences outside the transaction • INSTERSECT and EXCEPT set operators. Please check the change log for a details and examples. Feel free to report any found issues or performance problems on the github.

🎉 6

nullium21

09/27/2021, 4:38 PM

i think i found it (

referrersOn

)

👍 1

dave08

09/29/2021, 10:17 AM

Is there a way to transform a value to/from a different form at the Table definition (temporarily solving the problem...)?

dave08

09/29/2021, 10:59 AM

I hope this is right... I did this in the meantime:

dave08

09/29/2021, 10:59 AM

Copy code

class InstantFromEpochSecondsColumnType : ColumnType() {
    override fun sqlType(): String = currentDialect.dataTypeProvider.integerType()
    override fun valueFromDB(value: Any): Instant = when (value) {
        is Int -> Instant.fromEpochSeconds(value.toLong(), 0)
        is Number -> Instant.fromEpochSeconds(value.toLong(), 0)
        is String -> Instant.fromEpochSeconds(value.toLong(), 0)
        else -> error("Unexpected value of type Int: $value of ${value::class.qualifiedName}")
    }

    override fun notNullValueToDB(value: Any): Any = when {
        value is Instant -> value.epochSeconds
        else -> error("Invalid value $value")
    }
}

fun Table.timestampFromEpochSeconds(name: String): Column<Instant> = registerColumn(name, InstantFromEpochSecondsColumnType())

than_

10/05/2021, 9:08 AM

have anyone managed to implement virtual columns (at least for mysql)?

tapac

10/09/2021, 8:08 PM

Exposed gradle plugin 0.2.1 released. Support for custom

connectionProperties

added. Support for relocating Exposed (or another kotlin libs) with Shadow plugin (doc).

👍 5

tapac

10/12/2021, 11:40 AM

Exposed bug fixes release 0.35.2 - Change log

🎉 7

John Pali

10/15/2021, 3:28 PM

Hoping maybe someone here could help 🙂

tapac

10/20/2021, 9:31 AM

Exposed 0.35.3 was released with a critical bug fix for adjusting default column values when

SchemaUtils.createMissingTablesAndColumns

is used.

👍 1

Lbenyehu

10/20/2021, 1:03 PM

Hi guys! There is any build in future in Exposed that add “PARTITION BY RANGE” to the create table statement?? if not… How can I split my table to partitions by range (Date for example) ?? Tnx!

👀 1

subashz

10/26/2021, 4:32 PM

Can we get to get both the query result and the total number of results before

limit

and

offset

is applied in 1 query. For clarification see this previous thread: https://kotlinlang.slack.com/archives/C0CG7E0A1/p1591256151141300