com.scudata.dm.query.utils.ExpressionTranslator Maven / Gradle / Ivy
Go to download
Show more of this group Show more artifacts with this name
Show all versions of esproc Show documentation
Show all versions of esproc Show documentation
SPL(Structured Process Language) A programming language specially for structured data computing.
package com.scudata.dm.query.utils;
import java.util.ArrayList;
import java.util.Arrays;
import java.util.LinkedHashMap;
import java.util.List;
import java.util.Map;
import java.util.Set;
import java.util.regex.Matcher;
import java.util.regex.Pattern;
import com.scudata.common.Logger;
public class ExpressionTranslator //ֻ?ܴ????м?????еı???ʽ??????ֱ??????????SQL???
{
public static List marksList = new ArrayList();
public static List funcsList = new ArrayList();
public static String translateExp(String exp, Map trMap)
{
if(exp == null || exp.isEmpty() || trMap == null || trMap.isEmpty())
{
return exp;
}
//Logger.debug("translateExp beg : "+ exp);
exp = moveOutMarks(exp);//???????ܰ????ֶ??????ַ???""
exp = moveOutFuncs(exp, trMap);//???????ֶ?ͬ???ĺ???fun(
//??????ǰ???̵??ں?ֹ???İ????̵?
String[] keyBuf = new String[trMap.size()];
trMap.keySet().toArray(keyBuf);
Arrays.sort(keyBuf, new NameComprator());
List keyList = new ArrayList();
List valueList = new ArrayList();
for(String key : keyBuf)
{
String value = trMap.get(key);
keyList.add(key);
valueList.add(value);
}
String specials = "^$.[]*\\?+{}|()";//???????ʽ???????ַ?
//?Ը???Сдͬʱ???ڵ????
Map> ignoreCaseMap = new LinkedHashMap>();
for(int i = 0; i < keyList.size(); i++)
{
String key = keyList.get(i);
List ignoreCaseList = ignoreCaseMap.get(key.toLowerCase());
if(ignoreCaseList != null)
{
ignoreCaseList.add(key);
}
else
{
ignoreCaseList = new ArrayList();
ignoreCaseList.add(key);
ignoreCaseMap.put(key.toLowerCase(), ignoreCaseList);
}
}
//???ò??ɼ???ʶ?滻????key????ֹ??;?滻??value?а????????key
for(Map.Entry> ignoreCaseEntry : ignoreCaseMap.entrySet())
{
List ignoreCaseList = ignoreCaseEntry.getValue();
for(String sameKeyIgnoreCase : ignoreCaseList)
{
int index = keyList.indexOf(sameKeyIgnoreCase);
StringBuffer sb = new StringBuffer();
for(int k = 0; k < sameKeyIgnoreCase.length(); k++)
{
char ch = sameKeyIgnoreCase.charAt(k);
if(specials.indexOf(ch) != -1)
{
sb.append('\\');//???????ʽ???????ַ?Ҫ??\
sb.append(ch);
}
else
{
sb.append(ch);
}
}
sameKeyIgnoreCase = sb.toString();
exp = exp.replace(sameKeyIgnoreCase, "" + (char)30 + (index + 1) + (char)31);
}
String sameKeyIgnoreCase = ignoreCaseList.get(0);
int index = keyList.indexOf(sameKeyIgnoreCase);
StringBuffer sb = new StringBuffer();
for(int k = 0; k < sameKeyIgnoreCase.length(); k++)
{
char ch = sameKeyIgnoreCase.charAt(k);
if(specials.indexOf(ch) != -1)
{
sb.append('\\');//???????ʽ???????ַ?Ҫ??\
sb.append(ch);
}
else
{
sb.append(ch);
}
}
sameKeyIgnoreCase = sb.toString();
exp = exp.replaceAll("(?i)" + sameKeyIgnoreCase, "" + (char)30 + (index + 1) + (char)31);
}
//?????value?滻???в??ɼ???ʶ
for(int j = 0; j < valueList.size(); j++)
{
String value = valueList.get(j);
exp = exp.replace("" + (char)30 + (j + 1) + (char)31, value);
}
exp = moveInMarks(exp);
exp = moveInFuncs(exp);
//Logger.debug("translateExp end : "+ exp);
return exp;
}
public static String translateExp2(String exp, Map trMap)
{
if(exp == null || exp.isEmpty() || trMap == null || trMap.isEmpty())
{
return exp;
}
//??????ǰ???̵??ں?ֹ???İ????̵?
String[] keyBuf = new String[trMap.size()];
trMap.keySet().toArray(keyBuf);
Arrays.sort(keyBuf, new NameComprator());
List keyList = new ArrayList();
List valueList = new ArrayList();
for(String key : keyBuf)
{
String value = trMap.get(key);
keyList.add(key);
valueList.add(value);
}
String specials = "^$.[]*\\?+{}|()";//???????ʽ???????ַ?
//?Ը???Сдͬʱ???ڵ????
Map> ignoreCaseMap = new LinkedHashMap>();
for(int i = 0; i < keyList.size(); i++)
{
String key = keyList.get(i);
List ignoreCaseList = ignoreCaseMap.get(key.toLowerCase());
if(ignoreCaseList != null)
{
ignoreCaseList.add(key);
}
else
{
ignoreCaseList = new ArrayList();
ignoreCaseList.add(key);
ignoreCaseMap.put(key.toLowerCase(), ignoreCaseList);
}
}
//???ò??ɼ???ʶ?滻????key????ֹ??;?滻??value?а????????key
for(Map.Entry> ignoreCaseEntry : ignoreCaseMap.entrySet())
{
List ignoreCaseList = ignoreCaseEntry.getValue();
for(String sameKeyIgnoreCase : ignoreCaseList)
{
int index = keyList.indexOf(sameKeyIgnoreCase);
StringBuffer sb = new StringBuffer();
for(int k = 0; k < sameKeyIgnoreCase.length(); k++)
{
char ch = sameKeyIgnoreCase.charAt(k);
if(specials.indexOf(ch) != -1)
{
sb.append('\\');//???????ʽ???????ַ?Ҫ??\
sb.append(ch);
}
else
{
sb.append(ch);
}
}
sameKeyIgnoreCase = sb.toString();
exp = exp.replace(sameKeyIgnoreCase, "" + (char)30 + (index + 1) + (char)31);
}
String sameKeyIgnoreCase = ignoreCaseList.get(0);
int index = keyList.indexOf(sameKeyIgnoreCase);
StringBuffer sb = new StringBuffer();
for(int k = 0; k < sameKeyIgnoreCase.length(); k++)
{
char ch = sameKeyIgnoreCase.charAt(k);
if(specials.indexOf(ch) != -1)
{
sb.append('\\');//???????ʽ???????ַ?Ҫ??\
sb.append(ch);
}
else
{
sb.append(ch);
}
}
sameKeyIgnoreCase = sb.toString();
exp = exp.replaceAll("(?i)" + sameKeyIgnoreCase, "" + (char)30 + (index + 1) + (char)31);
}
//?????value?滻???в??ɼ???ʶ
for(int j = 0; j < valueList.size(); j++)
{
String value = valueList.get(j);
exp = exp.replace("" + (char)30 + (j + 1) + (char)31, value);
}
return exp;
}
public static boolean containExp(String exp, Set scSet)
{
if(exp == null || exp.isEmpty() || scSet == null || scSet.isEmpty())
{
return false;
}
for(String sc : scSet)
{
if(sc != null && !sc.isEmpty() && exp.toLowerCase().indexOf(sc.toLowerCase()) != -1)
{
return true;
}
}
return false;
}
private static String moveOutMarks(String exp)
{
Pattern pattern = Pattern.compile("\"([\\s\\S]*?)\"");
Matcher matcher = pattern.matcher(exp);
while(matcher.find())
{
String marks = matcher.group(0);
marksList.add(marks);
int index = exp.indexOf(marks);
exp = new StringBuffer(exp).replace(index, index + marks.length(), "" + (char)14 + marksList.size() + (char)15).toString();
}
return exp;
}
private static String moveInMarks(String exp)
{
for(int i = 0, sz = marksList.size(); i < sz; i++)
{
String marks = marksList.get(i);
int index = exp.indexOf("" + (char)14 + (i + 1) + (char)15);
exp = new StringBuffer(exp).replace(index, index + ("" + (char)14 + (i + 1) + (char)15).length(), marks).toString();
}
marksList.clear();
return exp;
}
private static String moveOutFuncs(String exp, Map trMap)
{
Next:
for(String name : trMap.keySet())
{
for(int i = 0; i < name.length(); i++)
{
char ch = name.charAt(i);
if(i == 0)
{
if(!Character.isJavaIdentifierStart(ch))
{
continue Next;
}
}
else
{
if(!Character.isJavaIdentifierPart(ch))
{
continue Next;
}
}
}
Pattern pattern = Pattern.compile("(?i)" + name + "\\(");
Matcher matcher = pattern.matcher(exp);
while(matcher.find())
{
String func = matcher.group(0);
funcsList.add(func);
int index = exp.indexOf(func);
exp = new StringBuffer(exp).replace(index, index + func.length(), "" + (char)16 + funcsList.size() + (char)17).toString();
}
}
return exp;
}
private static String moveInFuncs(String exp)
{
for(int i = 0, sz = funcsList.size(); i < sz; i++)
{
String func = funcsList.get(i);
int index = exp.indexOf("" + (char)16 + (i + 1) + (char)17);
exp = new StringBuffer(exp).replace(index, index + ("" + (char)16 + (i + 1) + (char)17).length(), func).toString();
}
funcsList.clear();
return exp;
}
}