ktorm
ktorm copied to clipboard
A lightweight ORM framework for Kotlin with strong-typed SQL DSL and sequence APIs.
在 [实体查询](https://www.ktorm.org/zh-cn/entity-finding.html) 中有这样的一段描述 观察生成的 SQL,我们发现 Ktorm 自动使用外键 left join 了 t_employee 的关联表 t_department。这是因为我们在表对象中声明 departmentId 这一列时使用 references 函数将此列绑定到了 Departments 表。在使用序列 API 的时候,Ktorm 会自动递归地 left join 所有关联的表,将部门表的数据一并查询出来,填充到 Employee.department 属性中 在使用了 references 函数来作为一对一join支持中...
I can't connect the Ktorm to my kobweb compose project I need help
请问作者大佬后续是否会提供自动填充策略器的实现,用于插入和更新时的匹配列名填充。例如 `create_time` 和 `update_time` 在插入或者更新时候的缺省自动填充。—— 来自菜鸟请求 Can you provide a configuration interface/annotation type for customization, to match and fill in interpolation based on column names when inserting or updating data....
After updating [jackson-module-kotlin](https://github.com/FasterXML/jackson-module-kotlin) to v2.16.0 we get the following error: ``` java.lang.NoSuchMethodError: 'void com.fasterxml.jackson.module.kotlin.KotlinModule.(int, boolean, boolean, boolean, com.fasterxml.jackson.module.kotlin.SingletonSupport, boolean, int, kotlin.jvm.internal.DefaultConstructorMarker)' at org.ktorm.jackson.JsonSqlTypeKt.(JsonSqlType.kt:34) ``` Seems like jackson-module-kotlin v2.16.0 is not...
I have a table Users(id, name, role) and another Departments(id, name). Each user can be in several departments and each department can have several users, so i create a table...
Tracks an entities changed properties and the values loaded from SQL. I needed this to implement an auditing system like #135 seems to be asking for, but how that should...
o.s.jdbc.support.AbstractFallbackSQLExceptionTranslator#translate has been allowed nullable return value in new version See:https://github.com/spring-projects/spring-framework/commit/e9cded560d6ecb73aa5bfca57e06b09fa0013294
将 BaseTable 的 asExpression 为 open, 如此 BaseTable 可以通过重写 asExpression 方法在 extraProperties 放入一些信息. 在自定义实现的 Dialect 中实现一些操作, 例如: 逻辑删除, 更新/新增时的自动填充 详细可以参考这个仓库 [逻辑删除, 自动填充](https://github.com/qumn/ktorm-interceptors) 一个逻辑删除的案例: 定义一个 BaseTable 的基类集成自 Table ```Kotlin const val...
Hi! I haven't found networks types in KTORM (inet, macaddress and etc - https://www.postgresql.org/docs/current/datatype-net-types.html#DATATYPE-NET-TYPES ). Is it possible to use those types in KTORM?