Exposed

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

select subQuery.myCol from (select...)

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"

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

transaction {}

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

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

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

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

@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;
}

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

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)
}

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)
}

GuildConfig

GuildConfigs

GuildConfig

val foos by LogChannel via LogChannels

KotlinInstantColumnType

Int

Instant.fromEpochSeconds

Schema.create

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

Values.all()

Values.select { Values.user eq user }