1 /*
2 * Copyright 2015-2018 HuntLabs.cn
3 *
4 * Licensed under the Apache License, Version 2.0 (the "License");
5 * you may not use this file except in compliance with the License.
6 * You may obtain a copy of the License at
7 *
8 * http://www.apache.org/licenses/LICENSE-2.0
9 *
10 * Unless required by applicable law or agreed to in writing, software
11 * distributed under the License is distributed on an "AS IS" BASIS,
12 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
13 * See the License for the specific language governing permissions and
14 * limitations under the License.
15 */
16 module hunt.sql.visitor.functions.Unhex;
17
18 // import hunt.sql.visitor.SQLEvalVisitor.EVAL_EXPR;
19 // import hunt.sql.visitor.SQLEvalVisitor.EVAL_VALUE;
20
21
22 import hunt.sql.ast.SQLExpr;
23 import hunt.sql.ast.expr.SQLMethodInvokeExpr;
24 import hunt.sql.visitor.SQLEvalVisitor;
25 import hunt.sql.util.HexBin;
26 import hunt.sql.visitor.functions.Function;
27 //import hunt.lang;
28 import hunt.String;
29 import hunt.String;
30 import hunt.collection;
31 import std.conv;
32 import std.uni;
33 import hunt.text;
34
35 import std.concurrency : initOnce;
36
37 public class Unhex : Function {
38
39 static Unhex instance() {
40 __gshared Unhex inst;
41 return initOnce!inst(new Unhex());
42 }
43
44 // public static Unhex instance;
45
46 // static this()
47 // {
48 // instance = new Unhex();
49 // }
50
51 public Object eval(SQLEvalVisitor visitor, SQLMethodInvokeExpr x) {
52 if (x.getParameters().size() != 1) {
53 return cast(Object)(SQLEvalVisitor.EVAL_ERROR);
54 }
55
56 SQLExpr param0 = x.getParameters().get(0);
57
58 if (cast(SQLMethodInvokeExpr)(param0) !is null) {
59 SQLMethodInvokeExpr paramMethodExpr = cast(SQLMethodInvokeExpr) param0;
60 if (paramMethodExpr.getMethodName().equalsIgnoreCase("hex")) {
61 SQLExpr subParamExpr = paramMethodExpr.getParameters().get(0);
62 subParamExpr.accept(visitor);
63
64 Object param0Value = subParamExpr.getAttributes().get(SQLEvalVisitor.EVAL_VALUE);
65 if (param0Value is null) {
66 x.putAttribute(SQLEvalVisitor.EVAL_EXPR,cast(Object)subParamExpr);
67 return cast(Object)(SQLEvalVisitor.EVAL_ERROR);
68 }
69
70 return param0Value;
71 }
72 }
73
74 param0.accept(visitor);
75
76 Object param0Value = param0.getAttributes().get(SQLEvalVisitor.EVAL_VALUE);
77 if (param0Value is null) {
78 return cast(Object)(SQLEvalVisitor.EVAL_ERROR);
79 }
80
81 if (cast(String)(param0Value) !is null) {
82 byte[] bytes = HexBin.decode((cast(String) param0Value).value());
83 if (bytes is null) {
84 return cast(Object)(SQLEvalVisitor.EVAL_VALUE_NULL);
85 }
86
87 string result;
88 try {
89 result = cast(string)(bytes);
90 } catch (Exception e) {
91 throw new Exception(e.msg, e);
92 }
93 return new String(result);
94 }
95
96 return cast(Object)(SQLEvalVisitor.EVAL_ERROR);
97 }
98 }