Channels
#komapper
Title
# komapper
d
dave08
10/15/2023, 4:34 PMOk, it seems like that AS there is only supported from Mysql version 8.0.20... could you maybe provide an option to not include that alias for less than 8? Or is there a workaround for this?
In the meanwhile I used
executeScript()executeScript()t
Toshihiro Nakamura
10/16/2023, 11:14 AMKomapper supports MySQL version 8 and above. As a workaround, you can create a custom Dialect.
d
dave08
10/16/2023, 11:26 AMCan I just use the current one and swap the implementation for the upsert?
It might also be nice to have a bit of documentation in the source code... if someone would want to contribute or even just understand something there, it's currently a bit hard... like what's cutBack()?
t
Toshihiro Nakamura
10/16/2023, 11:43 AMCan I just use the current one and swap the implementation for the upsert?Please extend
MySqlR2dbcDialectgetEntityUpsertStatementBuilderEntityUpsertStatementBuilder👍🏼 1
d
dave08
10/16/2023, 11:47 AMI need to remove the cutBack too?
Copy code
buf.append(" (")
for (p in properties) {
column(p)
buf.append(", ")
}
buf.cutBack(2)
buf.append(") values ")
for (entity in entities) {
buf.append("(")
for (p in properties) {
buf.bind(p.toValue(entity))
buf.append(", ")
}
buf.cutBack(2)
buf.append("), ")
}
buf.cutBack(2) /// ***This cutBack***
buf.append(" as ")
table(excluded, TableNameType.ALIAS_ONLY)It seems to remove unnecessary things from the sql, but I'm not sure exactly what and how...
t
Toshihiro Nakamura
10/16/2023, 11:51 AMcutBackd
dave08
10/16/2023, 11:51 AMEven though I'm removing
Copy code
buf.append(" as ")
table(excluded, TableNameType.ALIAS_ONLY)(which are the lines that seem to be causing problems with Mysql 5.7)
t
Toshihiro Nakamura
10/16/2023, 11:55 AMYou should be able to simply remove the following two lines. Give it a try.
Copy code
buf.append(" as ")
table(excluded, TableNameType.ALIAS_ONLY)3 Views