Is there any way to execute custom "plain" statements via

Exposed

? Or should I just use plain old Java interface for that? I have these one: (just trying to implement full-text-search in postgres)

Do I need to create a mapper fun to transform ResultRow to the class I want? Something like: Articles.select { Articles.id eq I’d }.map { toArticle(it) }.single()

Hi, how can I reference aliased columns from a subquery and use within a top-level function.. e.g. (greatly simplified for illustrative purposes)

select sum(subQuery.myCol + subQuery.myCol) from (select col as myCol) subQuery

I have my subselect working, have my column alias working, I can select by the alias (e.g.

select subQuery.myCol from (select...)

). But I cannot figure out how to construct further functions from the aliased columns. I essentially have multiple aliased columns in a subselect and I wish to multiply them in some way and query the result. Appreciate any insight! No idea where to start (QueryBuilder?)

I have four tables all with 5 common columns. Is there a way to extract out the common columns into their own class as part of the DSL? Is that what CompositeColumn is for?

Hi probably a dummy question and I am missing something - how do I translate this query in the code:

select *
from regression_notifications rn
         join notification_checks nc on rn.id = nc.regression_id
         join check_issues ci on nc.id = ci.check_id
where ci.status = "Open"

I tried:

RegressionTable.join(CheckTable.join( IssueTable,JoinType.INNER),JoinType.INNER).select { IssueTable.status eq "Open" }

but it return different results thanks

Hey, there's an issue on this already but no response (and nothing on the roadmap) about the ability to have a many-to-many reference setup where the junction table needs an additional attribute, I cannot find anyone else that has tried and succeeded. I'm not quite dangerous enough with Kotlin (yet?) to implement such a feature myself so I was hoping to get some guidance on some options. 🧵

Also is there any planning of doing codegen similar to jooq to generate the tables/entities from the database? We were considering using Flyway for migrations so redefining tables structure entities in sql and again in kotlin code would lead to some duplicated source of truth

Anyone know of a library like Ruby's 'papertrail' for Exposed? I'm subclassing the IntIdTable to add before and after hooks, but if someone else has already done it, no need to reinvent the wheel. 🙂

do read-only queries need to be done in a transaction as well?

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

why does running jars from the command line with kotlin not include the standard java libraries?

Hi! Is anybody aware of whether Kotlin’s value (inline) classes are supported?

Hey guys! Please, does Exposed provide any mechanism how to "intercept" query executions before I call database? My use-case is to store all database operations that were executed. We have Exposed code spreaded on multiple places in code, so it would be perfect to handle this functionality on one place instead of writing some methods to all

transaction {}

blocks. It is possible? Thank you!

Hey, how would you write this query in Exposed?

select name, min(time), max(time) from data group by name

In https://github.com/JetBrains/Exposed/wiki/DSL#group-by there is no good sample

How can you create a table that has two unique constraints? I've found this issue: https://github.com/JetBrains/Exposed/issues/239 And after updating the code to the newer Exposed version... it works on PostgreSQL (yay!) but it fails on SQLite with the following error:

Exception in thread "main" org.jetbrains.exposed.exceptions.UnsupportedByDialectException: Auto-increment could be applied only to primary key column, dialect: sqlite.

Here's the table:

object Abc : LongIdTable() {
    val user = long("user")
    val user2 = long("user2")

    override val primaryKey = PrimaryKey(id, user, user2)
}

So... is that an Exposed issue? Because I have no idea why it thinks it is a auto increment column. The only auto increment column is the "id" but it is also being included as a PrimaryKey

How do I cast a json field to a string in exposed DSL (using postgres db)?

Hello all, I have a model in my android project that has a type converter of a custom class. My android project has a backend built on ktor. The ktor project also has a similar model and am using postress database for storage. The problem that i am facing is storing the type converted class inside my postgress alongside other attributes. Here is the models of the two. Thanks in advance. Android model

@Entity(tableName = "requests")
public class Request extends BaseObservable implements Parcelable {
    @PrimaryKey(autoGenerate = true)
    private int request_id;// Document_id

    private String r_clients_id;
    private int r_tasker_id;
    private User user;// Type converter 
    private String requested_skill;
    private String time_stamp;
}

Same model for my ktor project

class Request(
    val request_id: Int,

    val r_clients_id: Int,
    val r_tasker_id: Int,
    val user: User,
    val requested_skill: String,
    val time_stamp: String,
    val arrival_date: String,
): Serializable, Principal

Here is where am facing the challenge. I really don't know how to insert or reference the Type converter class in my object class.I am new to ktor and exposed.

object Requests : Table() {
    val requestId: Column<Int> = integer("request_id").autoIncrement().primaryKey()
    val rClientId: Column<Int> = integer("r_clients_id").references(Users.userId)
    val rTaskerId: Column<Int> = integer("r_tasker_id").references(Taskers.taskerId)
    val user: Column<User> = ?????????????????????????

    val requestedSkill = varchar("requested_skill", 128)
    val timeStamp = varchar("time_stamp", 64)
    val arrivalDate = varchar("arrival_date", 64)
}

Hi, I suspect that what I am doing with Exposed (0.31) is leaking memory and/or resources. Are there ways to disable all of Exposed's caching? What are tools to detect improper use of the Exposed DAO?

Is it possible to validate all Table objects against the database schema when starting the service?

does Exposed uses reflection only for DAO mode, or there is reflection usage in DSL as well?

how do i do one-to-many? i have an entity like this:

class LogChannel(id: EntityID<Long>): LongEntity(id) {
    companion object : LongEntityClass<LogChannel>(LogChannels)
    val guild by GuildConfig referencedOn LogChannels.guild
}

object LogChannels: LongIdTable() {
    val guild = reference("guild", GuildConfigs)
}

and an empty

GuildConfig

entity +

GuildConfigs

table how can i have the

GuildConfig

have a list of all `LogChannel`s that point to it? i've tried this:

val foos by LogChannel via LogChannels

but it says "`Table does not reference target`"

Wondering if the new

KotlinInstantColumnType

can handle an int field that stores a unix timestamp?

It seems like not, but it would be good that if the type is an

Int

, it should use

Instant.fromEpochSeconds

to convert it...

Trying to figure out why

Schema.create

only creates my tables once when running h2 in memory dbs in my tests, I need to recreate the connection and tables for each test, but it doesn't do it after the first time... and then all the following tests fail...

Do you know when implementation of JSON column will be available?

Taking API feedback for an extension library on Exposed: https://github.com/lightningkite/exposed-plus

I'm trying to use Kotlin Exposed on Jetbrains Compose for Desktop, but I keep getting an error when I try to reference a many to one relationship outside of the transaction. Essentially, I have an Event class and a Section class. Events have multiple sections. When I get an event via the transaction and then try to access the sections variable, I get a null pointer exception. I've attached my code below as well as the error message I got. I can't create composables inside of transaction functions which is why I have to get the list of events out of the transactions scope.

I was wondering about a feature in Ktor/Exposed 🙂 Assume i got a table

ID | User | value
1  |  1   | value1
2  |  1   | value2
3  |  2   | value3

In other ORM frameworks, if I want to extract only values from user=1, I could create a DB session and use 

Values.all()

 and it'll fetch only [value1, value2] I don't want to fetch via 

Values.select { Values.user eq user }

Hey all! New to this space 🙂 I’m learning Kotlin with a PHP / Laravel background. Covered the basics and these make sense. As a next step, I’m looking into Ktor and Exposed. This tutorial helped me with Ktor: https://ktor.io/docs/creating-http-apis.html Next step would be to include Exposed in there as well, using their getting started: https://github.com/JetBrains/Exposed/wiki/Getting-Started#download Coming from a different background, I feel I miss some background on the installation process and frameworks so feeling a little lost there. It’s hard to assess resources I found, as they refer to different Kotlin/Ktor versions and I’m not so sure what’s still up to date (enough) and what is not. Any tips on what I could read into to get a better grasp? TL;DR: how can I properly install Exposed in Ktor?

Okay here is my short experience with Exposed. I was thinking of developing a REST api with ktor. Ktor's documentations are awesome. It took me little time to get started. Connecting to a database is also a crucial part for developing an api. A quick search landed me on the Exposed page. There were nothing but a bunch of code in the README file. I understand Exposed has not even reached version 1, so I am not blaming it. All experience in regard to database connection I had was just using the sqlite library in python and executing bare sql queries. I was blown up with all the new terms like ORM, DAO, Hikari and so on. Tutorials wasn't helpful either. I was frustrated and overwhelmed. Then I tried to find what people use with Java. A name Hibernate popped out. I went on the docs. And fortunately it pointed me to a great article that pointed me to another one. Now, finally I am getting it. The bare SQL version for the JVM world is JDBC. And there are stable libraries other than exposed. Like JPA, Hibernate, JOOQ. I am finally able to connect to my database and run sql queries (using JDBC though 😅). I would look into some lightweight stable libraries other than Exposed as of now. Once I get comfortable with accessing databases, only then I would look into Exposed. This database thing became an ugly nightmare to me. Finally I will be sleeping peacefully tonight. 🙃