ktorm

ktorm copied to clipboard

In our upgrade to ktorm 3.6, we've found an issue related to the typeName being incorrect for mysql when visitCasting runs on CastingExpressions. For example, from https://www.w3schools.com/sql/func_mysql_cast.asp the VarCharSqlType yields...

dchung-cargurus

We are trying to upgrade from ktorm 3.5 to 3.6, and are getting a lot of spurious errors related to the ColumnNameChecker. It seems to trigger for all select clauses...

dchung-cargurus

使用 dsl 关联查询时，createEntity 无法填充 referenceTable 里的值

7

结构定义 ```kotlin interface User : Entity { companion object : Entity.Factory() var id: String var name: String } open class Users(alias: String?) : Table("user", alias) { companion object : Users(null)...

Darkbish

Trying to trigger an `onConflict` with a `LOWER` variant of the column, is this possible? ```kotlin return db.insertOrUpdate(UsersTable) { set(it.email, emailFormatted) set(it.username, emailFormatted) set(it.firstName, firstName) set(it.surname, surname) set(it.dob, dateOfBirth) set(it.mobile,...

DiogoTheCoder

https://www.ktorm.org/en/transaction-management.html#Transaction-Manager > You may want to control your transactions more precisely, like setting the isolation level of them, or rollinkg back them only when some special exceptions thrown in some...

doctor911

I know that since the 2.5 version, It is possible create an entity with data class through `BaseTable`. But how could I define a foreign key in the `BaseTable`? In...

UkiDelly

Mysql supports several modifiers for an insert statement, e.g. `INSERT IGNORE/DELAYED/HIGH_PRIORITY into tbl_name`. It will be great if Ktorm supports such use case, especially `insert ignore into`

bringyou

[added array sql type for postgres](https://github.com/kotlin-orm/ktorm/commit/987c6db137d7b54d2f15b3bc50d737e160a3243e)

csrawat

afaict, to use `exists` as a query (not a subquery), you need to not only wrap the query with `exists` but also call `.exists` on it to force the execution....

dmitchell

Support for the INTERVAL type

4

To agreggrate multiple rows with TIMESTAMPs a given duration i want to use the date_bin function from PostgresSQL. As it seems this function is not native available in ktorm, i...

Voidi