ktorm

ktorm copied to clipboard

groupingBy multiple columns?

1

Is it possible to use the native entity DSL to perform a `group by` on multiple columns? ``` database.sales.groupingBy { it.salesRegion, it.productFamily, it.month, it.channel }.aggregateColumns { sum(it.salesVolume) } ``` I...

2x2xplz

I used `org.ktorm.ksp.api.EnumConverter` for defining column converter in version `1.0.0-RC3`. ```kotlin import org.ktorm.ksp.api.EnumConverter import org.ktorm.schema.BaseTable import org.ktorm.schema.Column import org.ktorm.schema.int import kotlin.reflect.KClass object IntEnumConverter : EnumConverter { override fun convert(table: BaseTable,...

okfanger

This issue is created for PR #524. The origin PR was closed accidentally because the target branch was deleted.

vincentlauvlwj

This resolved #512

bringyou

I'm very new to kotlin and to ktorm too, so may be I'm missing something simple ... However I was not able to plain read an Oracle Timestamp columns (oracle.sql.TIMESTAMP)...

filippo-baccani

🧐为什么不添加支持分页的函数呢

4

DSL例如 ``` data class Page(val pageNo: Int, val pageSize: Int, val totalRecords: Int, val records: Query) fun Query.paging(pageNo: Int, pageSize: Int): Page { val records = this.limit(pageSize).offset((pageNo - 1) *...

DULLONEX

使用实体查询,框架会拼接字段名称为【表别名_字段】而遭到 ColumnNameChecker 字段名称过长拦截

6

通过元数据里的**maxColumnNameLength** 和拼接后的字段 来进行比较长度,导致因为拼接了表别名的原因遭到ColumnNameChecker 拦截   

canmengqian

Implement SuperTableClass annotation

1

实现 `@SuperTableClass` 注解, 使用案例见 https://github.com/kotlin-orm/ktorm/pull/561#issuecomment-2167999715

qumn

Given the simple example as provided in the documentation provided (see https://www.ktorm.org/en/query.html) ```kt val query = database.from(Employees).select() query .map { row -> Emp(row[Employees.id], row[Employees.name], row[Employees.salary]) } ``` this will actually...

AlexRiedler

We're using the data class based table definitions by subclassing the BaseTable class so we can write generics for the sql dsl. We are constantly running into the issue that...

alekmus