danielm
05/30/2018, 9:49 AMtapac
05/30/2018, 11:31 AMdanielm
05/30/2018, 11:52 AMimport org.jetbrains.exposed.dao.IntIdTable
import org.jetbrains.exposed.sql.Column
import org.jetbrains.exposed.sql.Table
import org.jetbrains.exposed.sql.count
import org.jetbrains.exposed.sql.select
fun main(args: Array<String>) {
(Players innerJoin StarWarsFilms)
.slice(Players.name.count(), StarWarsFilms.name)
.select { StarWarsFilms.sequelId eq Players.sequelId }
.groupBy(StarWarsFilms.name)
}
object StarWarsFilms : IntIdTable() {
val sequelId: Column<Int> = integer("sequel_id").uniqueIndex()
val name: Column<String> = varchar("name", 50)
val director: Column<String> = varchar("director", 50)
}
object Players : Table() {
val sequelId: Column<Int> = integer("sequel_id").uniqueIndex()
val name: Column<String> = varchar("name", 50)
}
tapac
05/30/2018, 2:48 PMPlayers innerJoin StarWarsFilms
with Players.innerJoin(StarWarsFilms, { Players.sequeld}. { StarWarsFilms.sequelId })
danielm
05/31/2018, 4:45 AMPlayers.innerJoin(StarWarsFilms, { Players.sequelId}, { StarWarsFilms.sequelId })
tapac
05/31/2018, 10:02 AMdanielm
05/31/2018, 2:02 PM