xiyelife commented on a change in pull request #3295: fixed for #3234 and add
the encrypted test case for more than four cipher coloumns
URL:
https://github.com/apache/incubator-shardingsphere/pull/3295#discussion_r335787166
##########
File path:
sharding-core/sharding-core-rewrite/src/main/java/org/apache/shardingsphere/core/rewrite/feature/encrypt/parameter/impl/EncryptAssignmentParameterRewriter.java
##########
@@ -78,22 +81,24 @@ private SetAssignmentsSegment
getSetAssignmentsSegment(final SQLStatement sqlSta
return ((UpdateStatement) sqlStatement).getSetAssignment();
}
- private void encryptParameters(final StandardParameterBuilder
parameterBuilder, final String tableName, final AssignmentSegment
assignmentSegment, final List<Object> parameters) {
+ private void encryptParameters(final StandardParameterBuilder
parameterBuilder, final String tableName, final AssignmentSegment
assignmentSegment, final List<Object> parameters,
+ final Collection<String>
assistedQueryColumns, final int count) {
Review comment:
Rewrite logic according to Assignment is:
original SQL: insert table set a = ?, b = ?, c = ? value (?, ?, ?)
1.replaced original column by the cipher column:
**insert table set a_enc = ?, b_enc = ?, c_enc = ? value (?, ?, ?)**
2.now set the first original column a after a_enc,
the final a's paramterIndex = a'orignalParameterIndex(0) + count(0) + 1= 1
**insert table set a_enc = ?, a= ?, b_enc = ?, c_enc = ? value (?, ?, ?,
?)**
3.now set the second original column b after b_enc,
the fianl b's parameterIndex = b'orignalParameterIndex(1) + count(1) + 1= 3
**insert table set a_enc = ?, a= ?, b_enc = ?, b = ?, c_enc = ? value (?,
?, ?, ?, ?)**
3.now set the third original column c after c_enc,
the final c's parameterIndex = c'orignalParameterIndex(2) + count(2) + 1= 5
**insert table set a_enc = ?, a= ?, b_enc = ?, b = ?, c_enc = ?,c = ? value
(?, ?, ?, ?, ?, ?)**
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
[email protected]
With regards,
Apache Git Services
