kotlinlang #exposed

Join the conversation Join Slack

Channels

100daysofcode

100daysofkotlin

androidgithubprojects

cincinnati-user-group

competitive-programming

event21-community-content

java-to-kotlin-refactoring

jvm-ir-backend-feedback

kotlin-multiplatform-contest

kotlinultimatechallenge

myndocs-oauth2-server

naming

navigation-architecture-component

practical-functional-programming

proguard

prozis-android-backup

refactoring-to-kotlin

russian-kotlinasfirst

skia-wasm-interop-temp

stayhungrystayfoolish

swagger-gradle-codegen

tricity-kotlin-user-group

exposed

cedric

03/19/2019, 3:35 AM

Is there an easy way to retrieve the primary key of an

insert

(in the case where it's auto increment, obviously, otherwise I already have it)

avolkmann

03/20/2019, 10:26 AM

Can we somehow replicate the behavior of Spring @Transactional in tests? So that the transaction will be rolled back after each test

arturo

03/22/2019, 3:06 PM

I didn't get with the solution but I've solved using

Table()

instead of

LongIdTable()

and not using

EntityID

at all

Farzad

04/02/2019, 1:50 PM

Hi, is there a way to select from multiple tables using DSL without joining them? For example:

select *
from Orders o,
     Customers c
where o.customerId = c.id
  and c.id = 1234;

Farzad

04/02/2019, 3:46 PM

Another question- how to run a stored procedure using Exposed?

Dennis Schröder

04/04/2019, 8:43 AM

I set up a many-to-many relationship just like they descriped it in the documentation (https://github.com/JetBrains/Exposed/wiki/DAO#many-to-many-reference) But when I call

Entity.getAll()

I still get an

No transaction in context.

Error! I created each entity in an own transaction. Like described in the documentation! Any hints where to look at?

Antanas A.

04/09/2019, 11:02 AM

Hello, are there any plans to deprecate and remove singletons/statics from a library? Now it's complicated to use it in asynchronous environment (coroutines, multi-thread), and not sure if it's compatible with ktor

Nezteb

04/18/2019, 10:48 PM

Does Exposed count as an ORM? Or just a SQL generator?

Kevin Schmeichel

04/24/2019, 6:49 PM

-.kt

pindab0ter

04/26/2019, 11:49 AM

I’m using DAO classes and a

via

for a many to many reference. How do I set up the columns so that it cascades a deletion of either table?

tjohnn

04/27/2019, 8:24 AM

Something like

select users.*, detail.address as location from users innerjoin detail on users.id = deail.user_id

bitkid

04/28/2019, 10:50 AM

hey guys! i am trying exposed for the first time and i have question. are you following a certain pattern when converting DAOs to immutable entity objects? i have a PlayerDAO and atm i do

PlayerDAO.find { Players.email eq "someEmail" }.map { it.toPlayer() }

. is that a sane approach just adding a method to the DAO which does the conversion?

JohnV

04/28/2019, 8:00 PM

This piece of code current errors

var blocks by Block referrersOn Blocks.articleId

Michal Landsman

04/30/2019, 9:06 PM

3. Is possible to force flush (save) of changed entity?

bitkid

05/13/2019, 9:27 AM

suspend fun <T> dbTransaction(database: Database, block: () -> T): T = withContext(Dispatchers.IO) { transaction(database) { block() } }

tapac

05/14/2019, 11:17 AM

Exposed updated to 0.13.7. Full change log is here > https://github.com/JetBrains/Exposed/blob/master/ChangeLog.md#0137

🎊 1

🎉 2

Mihael

05/14/2019, 4:32 PM

[qtp1676605578-16] INFO Exposed - Preparing create tables statements took 1ms
[qtp1676605578-16] INFO Exposed - Executing create tables statements took 3ms
[qtp1676605578-16] INFO Exposed - Extracting table columns took 35ms
[qtp1676605578-16] INFO Exposed - Extracting column constraints took 3ms
[qtp1676605578-16] INFO Exposed - Preparing alter table statements took 38ms
[qtp1676605578-16] INFO Exposed - Executing alter table statements took 1ms
[qtp1676605578-16] INFO Exposed - Checking mapping consistence took 10ms

Jonathan Mew

05/15/2019, 10:55 AM

Is there a way to install a mock TransactionManager which generates no-op Transactions for component tests?

pindab0ter

05/15/2019, 11:50 AM

I’m using the DAO and I have an object with a one-to-many relationship. How can I load the list when I load that object? And if that’s not possible, when is it better to do more things within the transaction context or to open/close multiple transactions within short succession of each other?

Nezteb

05/15/2019, 3:47 PM

Are there any decent examples of using

QueryBuilder

to get plain SQL statements that can be executed? It’s mentioned in the FAQ, but no where else in any documentation that I can find: https://github.com/JetBrains/Exposed/wiki/FAQ#q-how-to-get-a-plain-sql-query-which-will-be-executed

Kevin Schmeichel

05/16/2019, 9:22 PM

I'm slowing figuring out how to do various things that aren't covered in the docs, and wouldn't mind contributing some examples that would probably help others out...

Kevin Schmeichel

05/17/2019, 12:22 AM

Can anyone provide an example of using the

match

operator

IN NATURAL LANGUAGE MODE

Mihael

05/20/2019, 6:31 PM

Sessions.select { Sessions.lastUpdated greaterEq DateTime.now().minusSeconds(5).millis }

Is this the best way of getting current time - 5 seconds with exposed?

Mihael

05/25/2019, 8:29 PM

sql
```SELECT A.script_name, A.count, (A.count * 100) / totalCount AS percentage, totalCount
FROM (SELECT script_name, COUNT(*) AS count FROM sessions WHERE client_username = "Miha" GROUP BY script_name) AS A
         INNER JOIN (SELECT COUNT(*) AS totalCount FROM sessions WHERE client_username = "Miha") AS B
GROUP BY A.script_name

``` Can anyone help me write this in Exposed kotlin? I’ve tried using aliases but was never able to select totalCount from a subquery or the main query.

APXEOLOG

05/28/2019, 6:43 AM

How do i get max id from the table with exposed?

pindab0ter

06/06/2019, 2:50 PM

I’m trying to get ON_DELETE CASCADE working with SQLite. I’ve set up the foreign keys properly, but when deleting the parent, the children stay. I’ve read that SQLite defaults to

PRAGMA foreign_keys = OFF;

. I’ve tried setting that using:

transaction {
    exec("PRAGMA foreign_keys = ON;")
}

But still no luck. Any ideas?

Viet Hoang

06/07/2019, 8:38 AM

Is there anyway to optimize performance for query with multiple join clauses like this one ?

Table1.leftJoin(otherTable = Table2, onColumn = { Table1.id }, otherColumn = { Table2.table1Id })
      .leftJoin(otherTable = Table3, onColumn = { Table1.table3Id }, otherColumn = { Table3.id })
      .join(otherTable = Table4, joinType = JoinType.LEFT, additionalConstraint = { (Table1.table5Id eq Table4.table5Id) and (Table1.table3Id eq Table4.table3Id) })
      .leftJoin(otherTable = Table5, onColumn = { Table1.table5Id }, otherColumn = { Table5.id })
      .leftJoin(otherTable = Table6, onColumn = { Table1.table5Id }, otherColumn = { Table6.table5Id })
      .leftJoin(otherTable = Table7, onColumn = { Table3.table7Id }, otherColumn = { Table7.id })
      .leftJoin(otherTable = Table8, onColumn = { Table7.table8Id }, otherColumn = { Table8.id })
      .leftJoin(otherTable = Table9, onColumn = { Table5.table9Id }, otherColumn = { Table9.id] })
      .leftJoin(otherTable = Table10, onColumn = { Table2.table10Id }, otherColumn = { Table10.id })
      .leftJoin(otherTable = Table11, onColumn = { Table2.table11Id }, otherColumn = { Table11.id })
      .leftJoin(otherTable = Table12, onColumn = { Table2.table12Id }, otherColumn = { Table12.id })
      .select {
          println("JOIN: " + (System.currentTimeMillis() - start)/1000)
          start =  System.currentTimeMillis()
          Table1.id inList ids 
      }
      .map {
          println("EXECUTE: " + (System.currentTimeMillis() - start)/1000)
          it.toMasterData()
      }

It took roughly 3 seconds just for generating query when executed in my local environment.

rapho

06/10/2019, 3:20 PM

I have a tableA with two references, how can I query this table like:

TableA.selectAll().where(TableA.ref1 = object1 and TableA.ref2= object2)

Nikky

06/11/2019, 6:13 PM

message has been deleted

Mihael

06/13/2019, 12:50 PM

SELECT DISTINCT TABLE_NAME 
    FROM INFORMATION_SCHEMA.COLUMNS
    WHERE COLUMN_NAME IN ('SessionId')
        AND TABLE_SCHEMA='YourDatabase';

Title

Mihael

06/13/2019, 12:50 PM

SELECT DISTINCT TABLE_NAME 
    FROM INFORMATION_SCHEMA.COLUMNS
    WHERE COLUMN_NAME IN ('SessionId')
        AND TABLE_SCHEMA='YourDatabase';

tapac

06/13/2019, 5:19 PM

val result = ColumnsTable.
     slice(ColumnsTable.tableName).
     select { 
         ColumnsTable,columnName inList listOf("SessionId") and 
         ( ColumnsTable.tableSchema eq "YourDatabase"}.
      withDistinct().map {             it[ColumnsTable.tableName]
  }

Mihael

06/13/2019, 11:13 PM

Thank you

View count: 2