ktorm

ktorm copied to clipboard

insertOrUpdate SQLite

2

Since 3.24 SQLite supports [upsert like postgres does](https://www.sqlite.org/lang_UPSERT.html). Consider adding it to SQLite dialect?

carbotaniuman

Add support for DTO Projections

6

``` @Introspected data class EmployeeDTO( val id: Long, val name: String ) val result = database.from(Employees).select(EmployeeDTO::class) ``` This will reduce the boilerplate code that can be deducted from table schema....

raderio

Entities: Allow References to Table with compound primary keys

1

Schema example: ``` interface FinancialAccount : Entity { companion object : Entity.Factory() val accNumber: Long val finInst: FinancialInstitution? val finAccType: FinancialAccountType? } interface FinancialTransaction : Entity { companion object :...

Nobusuma

Any plans on the roadmap to support date addition, such as `mydateval + interval '7 days'` (postgres syntax)? A common use case is to purge records older than a certain...

2x2xplz

Using UNION in a subquery leads to a syntax error in Sqlite

1

Hi, I'm attempting to use a `UNION` in a subquery, and that is leading to a syntax error when executing the query against a Sqlite backend. Based on attempting to...

hakuya

请问对PostgreSQL的jsonb，json字段的kv操作如何呀！？

7

具体此类功能有实现了吗？能提供演示吗？感谢

code33

Add support for subqueries

1

This request was hidden under another issue in [this comment](https://github.com/vincentlauvlwj/Ktorm/issues/45#issuecomment-533135132). I'm creating its own dedicated ticket. From the comment: > I was doing some reading on how people solve this...

ashokgelal

Operator precedence issue

1

for example ` Ts.update { it.companyTaxNo to companyTaxNo where { it.userId eq userId and it.deleted eq false } } ` The format sql is 'where ((user_id=?) and is_deleted)=?'。 In mysql,...

zhanwangls

Support for computed columns?

5

I tried hacking the code to do a computed column, but I didn't figure out how yet.

carbotaniuman

Provide a plugin for Intellij IDEA to generate table and entity definitions.

11

vincentlauvlwj