Repository navigation
Expand file tree
/
Copy pathAdaptersTest.java
More file actions
119 lines (102 loc) · 4.01 KB
/
Copy pathAdaptersTest.java
File metadata and controls
119 lines (102 loc) · 4.01 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
/*-
* #%L
* JSQLParser library
* %%
* Copyright (C) 2004 - 2019 JSQLParser
* %%
* Dual licensed under GNU LGPL 2.1 or Apache License 2.0
* #L%
*/
package net.sf.jsqlparser.statement;
import net.sf.jsqlparser.JSQLParserException;
import net.sf.jsqlparser.expression.BinaryExpression;
import net.sf.jsqlparser.expression.ExpressionVisitorAdapter;
import net.sf.jsqlparser.expression.JdbcNamedParameter;
import net.sf.jsqlparser.expression.operators.conditional.AndExpression;
import net.sf.jsqlparser.parser.CCJSqlParserUtil;
import net.sf.jsqlparser.schema.Column;
import net.sf.jsqlparser.statement.select.PlainSelect;
import net.sf.jsqlparser.statement.select.Select;
import net.sf.jsqlparser.statement.select.SelectVisitorAdapter;
import org.junit.jupiter.api.Test;
import java.util.Stack;
import static org.junit.jupiter.api.Assertions.assertEquals;
public class AdaptersTest {
/**
* Test extracting JDBC named parameters using adapters
*/
@Test
public void testAdapters() throws JSQLParserException {
String sql = "SELECT * FROM MYTABLE WHERE COLUMN_A = :paramA AND COLUMN_B <> :paramB";
Statement stmnt = CCJSqlParserUtil.parse(sql);
final Stack<Pair<String, String>> params = new Stack<>();
stmnt.accept(new StatementVisitorAdapter<Void>() {
@Override
public <S> Void visit(Select select, S context) {
select.accept(new SelectVisitorAdapter<Void>() {
@Override
public <K> Void visit(PlainSelect plainSelect, K context) {
plainSelect.getWhere().accept(new ExpressionVisitorAdapter<Void>() {
@Override
protected <J> Void visitBinaryExpression(BinaryExpression expr,
J context) {
if (!(expr instanceof AndExpression)) {
params.push(new Pair<>(null, null));
}
return super.visitBinaryExpression(expr, context);
}
@Override
public <J> Void visit(Column column, J context) {
params.push(new Pair<>(column.getColumnName(),
params.pop().getRight()));
return null;
}
@Override
public <J> Void visit(JdbcNamedParameter parameter, J context) {
params.push(new Pair<>(params.pop().getLeft(),
parameter.getName()));
return null;
}
}, null);
return null;
}
}, null);
return null;
}
});
assertEquals(2, params.size());
Pair<String, String> param2 = params.pop();
assertEquals("COLUMN_B", param2.getLeft());
assertEquals("paramB", param2.getRight());
Pair<String, String> param1 = params.pop();
assertEquals("COLUMN_A", param1.getLeft());
assertEquals("paramA", param1.getRight());
}
private static class Pair<L, R> {
private final L left;
private final R right;
private Pair(L left, R right) {
this.left = left;
this.right = right;
}
public L getLeft() {
return left;
}
public R getRight() {
return right;
}
public boolean isEmpty() {
return left == null && right == null;
}
public boolean isFull() {
return left != null && right != null;
}
@Override
public String toString() {
String sb = "Pair{" + "left=" + left +
", right=" + right +
'}';
return sb;
}
}
}