Comments (6)
Maybe something like this can help:
fun UpdateBuilder<*>.assign(o: JsonObject) {
val cols = targets.first().columns
for (col in cols) {
var type = col.columnType.sqlType()
val idx = type.indexOfAny(listOf(" ", "("))
type = if (idx > 0) type.substring(0, idx) else type
if (o.containsKey(col.name)) {
if (col.name == "hashedPassword") {
val p = o.getString("hashedPassword")
o.put("hashedPassword", createHashString(p))
}
when (type) {
"INT" -> set(col, o.getInteger(col.name))
"VARCHAR" -> set(col, o.getString(col.name))
"DATE" -> set(col, formateDate(o.getString(col.name)))
"DECIMAL" -> set(col, o.getDouble(col.name))
}
}
}
}
from exposed.
test your code but failed to compile on 4 set method
[ERROR] Failed to execute goal org.jetbrains.kotlin:kotlin-maven-plugin:1.0.5:compile (compile) on project capamc-web: Compilation failure: Compilation failure:
[ERROR] Dao.kt:[67,30] Type inference failed: Cannot infer type parameter S in operator fun set(column: Column, value: S?): Unit
[ERROR] None of the following substitutions
[ERROR] (Column<CapturedTypeConstructor()>,CapturedTypeConstructor()?)
[ERROR] (Column,Int?)
[ERROR] can be applied to
[ERROR] (Column<*>,Int!)
from exposed.
You should cast col to same type as you want to set, e.g.
"INT" -> set(col as Column<Int>, o.getInteger(col.name))
from exposed.
Thanks for a quick response.
I try change my code from assign(it, json) to it.assign(json) style but it won't compile.
I think it might cause by you define a static method, and "it" is a instance. Any way to get it work? Could we use reflection to call a static method from a instance?
from exposed.
I'm not sure that I've understand your problem, but that code compiles just fine:
fun <T:Any> UpdateBuilder<*>.set(col: Column<*>, value: T?) = set(col as Column<T>, value)
fun UpdateBuilder<*>.assign(o: JsonObject) {
val cols = targets.first().columns
for (col in cols) {
var type = col.columnType.sqlType()
val idx = type.indexOfAny(listOf(" ", "("))
type = if (idx > 0) type.substring(0, idx) else type
if (o.containsKey(col.name)) {
if (col.name == "hashedPassword") {
val p = o.getString("hashedPassword")
o.put("hashedPassword", p?.hashCode()?.toString())
}
when (type) {
"INT" -> set(col, o.getInteger(col.name))
"VARCHAR" -> set(col, o.getString(col.name))
"DECIMAL" -> set(col, o.getDouble(col.name))
}
}
}
}
fun usageExample() {
val table = object : IntIdTable() {
val foo = text("foo")
val bar = integer("bar")
}
table.insert {
it[table.foo] = "text"
it.assign(JsonObject())
}
table.update(where = { table.foo eq "text"}){
it[table.foo] = "text2"
it.assign(JsonObject())
}
}
from exposed.
Works to me now, some silly typo error. Thanks a lot
from exposed.
Related Issues (20)
- Make it spring-boot 3 compatible HOT 6
- Lacking documentation HOT 2
- IdentifierManagerApi throws error when it has been accessed from multiple threads HOT 2
- Many to many reference - exception when adding new record HOT 2
- EntityHooks are not invoked when using DSL API
- EntityClass companion object constructor is not invoked because it's not referenced anywhere
- Using exists in subquery HOT 1
- Support quotes when using schema in the tablename HOT 4
- Any way to determine entity state? HOT 1
- Update with join fails on H2 in MySql mode HOT 1
- Is it maintained? HOT 1
- [Crash] ClassNotFound when running with DEBUG environment variable set to false HOT 4
- Can be support regex query dsl?
- Can be support table and column comment? HOT 1
- Provided Column Type Not Included In Operators For Primitive Value Types HOT 7
- Combination of Spring-based transactions and newSuspendedTransaction does not work properly HOT 2
- Unnecessary query after calling with() and iteration. HOT 3
- Design flaws with insert HOT 1
- postgresql plus string HOT 1
- in dsl section dao IntIdTable is proposed HOT 1
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from exposed.