/**
* Copyright 2006-2016 the original author or authors.
*
* Licensed under the Apache License, Version 2.0 (the "License");
* you may not use this file except in compliance with the License.
* You may obtain a copy of the License at
*
* http://www.apache.org/licenses/LICENSE-2.0
*
* Unless required by applicable law or agreed to in writing, software
* distributed under the License is distributed on an "AS IS" BASIS,
* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
* See the License for the specific language governing permissions and
* limitations under the License.
*/
package org.mybatis.generator.codegen.ibatis2.sqlmap.elements;
import static org.mybatis.generator.internal.util.StringUtility.stringHasValue;
import org.mybatis.generator.api.IntrospectedColumn;
import org.mybatis.generator.api.dom.xml.Attribute;
import org.mybatis.generator.api.dom.xml.TextElement;
import org.mybatis.generator.api.dom.xml.XmlElement;
/**
*
* @author Jeff Butler
*
*/
public class ExampleWhereClauseElementGenerator extends
AbstractXmlElementGenerator {
public ExampleWhereClauseElementGenerator() {
super();
}
@Override
public void addElements(XmlElement parentElement) {
XmlElement answer = new XmlElement("sql"); //$NON-NLS-1$
answer.addAttribute(new Attribute(
"id", introspectedTable.getExampleWhereClauseId())); //$NON-NLS-1$
context.getCommentGenerator().addComment(answer);
XmlElement outerIterateElement = new XmlElement("iterate"); //$NON-NLS-1$
outerIterateElement.addAttribute(new Attribute(
"property", "oredCriteria")); //$NON-NLS-1$ //$NON-NLS-2$
outerIterateElement.addAttribute(new Attribute("conjunction", "or")); //$NON-NLS-1$ //$NON-NLS-2$
outerIterateElement.addAttribute(new Attribute("prepend", "where")); //$NON-NLS-1$ //$NON-NLS-2$
outerIterateElement.addAttribute(new Attribute(
"removeFirstPrepend", "iterate")); //$NON-NLS-1$ //$NON-NLS-2$
answer.addElement(outerIterateElement);
XmlElement isEqualElement = new XmlElement("isEqual"); //$NON-NLS-1$
isEqualElement.addAttribute(new Attribute(
"property", "oredCriteria[].valid")); //$NON-NLS-1$ //$NON-NLS-2$
isEqualElement.addAttribute(new Attribute("compareValue", "true")); //$NON-NLS-1$ //$NON-NLS-2$
outerIterateElement.addElement(isEqualElement);
isEqualElement.addElement(new TextElement("(")); //$NON-NLS-1$
XmlElement innerIterateElement = new XmlElement("iterate"); //$NON-NLS-1$
innerIterateElement.addAttribute(new Attribute("prepend", "and")); //$NON-NLS-1$ //$NON-NLS-2$
innerIterateElement.addAttribute(new Attribute(
"property", "oredCriteria[].criteriaWithoutValue")); //$NON-NLS-1$ //$NON-NLS-2$
innerIterateElement.addAttribute(new Attribute("conjunction", "and")); //$NON-NLS-1$ //$NON-NLS-2$
innerIterateElement.addElement(new TextElement(
"$oredCriteria[].criteriaWithoutValue[]$")); //$NON-NLS-1$
isEqualElement.addElement(innerIterateElement);
innerIterateElement = new XmlElement("iterate"); //$NON-NLS-1$
innerIterateElement.addAttribute(new Attribute("prepend", "and")); //$NON-NLS-1$ //$NON-NLS-2$
innerIterateElement.addAttribute(new Attribute(
"property", "oredCriteria[].criteriaWithSingleValue")); //$NON-NLS-1$ //$NON-NLS-2$
innerIterateElement.addAttribute(new Attribute("conjunction", "and")); //$NON-NLS-1$ //$NON-NLS-2$
innerIterateElement
.addElement(new TextElement(
"$oredCriteria[].criteriaWithSingleValue[].condition$ #oredCriteria[].criteriaWithSingleValue[].value#")); //$NON-NLS-1$
isEqualElement.addElement(innerIterateElement);
innerIterateElement = new XmlElement("iterate"); //$NON-NLS-1$
innerIterateElement.addAttribute(new Attribute("prepend", "and")); //$NON-NLS-1$ //$NON-NLS-2$
innerIterateElement.addAttribute(new Attribute(
"property", "oredCriteria[].criteriaWithListValue")); //$NON-NLS-1$ //$NON-NLS-2$
innerIterateElement.addAttribute(new Attribute("conjunction", "and")); //$NON-NLS-1$ //$NON-NLS-2$
innerIterateElement.addElement(new TextElement(
"$oredCriteria[].criteriaWithListValue[].condition$")); //$NON-NLS-1$
XmlElement innerInnerIterateElement = new XmlElement("iterate"); //$NON-NLS-1$
innerInnerIterateElement.addAttribute(new Attribute("property", //$NON-NLS-1$
"oredCriteria[].criteriaWithListValue[].values")); //$NON-NLS-1$
innerInnerIterateElement.addAttribute(new Attribute("open", "(")); //$NON-NLS-1$ //$NON-NLS-2$
innerInnerIterateElement.addAttribute(new Attribute("close", ")")); //$NON-NLS-1$ //$NON-NLS-2$
innerInnerIterateElement
.addAttribute(new Attribute("conjunction", ",")); //$NON-NLS-1$ //$NON-NLS-2$
innerInnerIterateElement.addElement(new TextElement(
"#oredCriteria[].criteriaWithListValue[].values[]#")); //$NON-NLS-1$
innerIterateElement.addElement(innerInnerIterateElement);
isEqualElement.addElement(innerIterateElement);
innerIterateElement = new XmlElement("iterate"); //$NON-NLS-1$
innerIterateElement.addAttribute(new Attribute("prepend", "and")); //$NON-NLS-1$ //$NON-NLS-2$
innerIterateElement.addAttribute(new Attribute(
"property", "oredCriteria[].criteriaWithBetweenValue")); //$NON-NLS-1$ //$NON-NLS-2$
innerIterateElement.addAttribute(new Attribute("conjunction", "and")); //$NON-NLS-1$ //$NON-NLS-2$
innerIterateElement.addElement(new TextElement(
"$oredCriteria[].criteriaWithBetweenValue[].condition$")); //$NON-NLS-1$
innerIterateElement.addElement(new TextElement(
"#oredCriteria[].criteriaWithBetweenValue[].values[0]# and")); //$NON-NLS-1$
innerIterateElement.addElement(new TextElement(
"#oredCriteria[].criteriaWithBetweenValue[].values[1]#")); //$NON-NLS-1$
isEqualElement.addElement(innerIterateElement);
// if any of the columns have a user defined type handler, then we need
// to add additional inner iterate elements that specify the type
// handler
for (IntrospectedColumn introspectedColumn : introspectedTable
.getNonBLOBColumns()) {
if (stringHasValue(introspectedColumn
.getTypeHandler())) {
// name the property based on the column name, then
// add the type handler to the parameter declaration
StringBuilder sb1 = new StringBuilder();
StringBuilder sb2 = new StringBuilder();
innerIterateElement = new XmlElement("iterate"); //$NON-NLS-1$
innerIterateElement
.addAttribute(new Attribute("prepend", "and")); //$NON-NLS-1$ //$NON-NLS-2$
sb1.append("oredCriteria[]."); //$NON-NLS-1$
sb1.append(introspectedColumn.getJavaProperty());
sb1.append("CriteriaWithSingleValue"); //$NON-NLS-1$
innerIterateElement.addAttribute(new Attribute(
"property", sb1.toString())); //$NON-NLS-1$
innerIterateElement.addAttribute(new Attribute(
"conjunction", "and")); //$NON-NLS-1$ //$NON-NLS-2$
sb2.append(sb1);
sb1.insert(0, '$');
sb1.append("[].condition$ ");//$NON-NLS-1$
sb2.insert(0, '#');
sb2.append("[].value,handler=");//$NON-NLS-1$
sb2.append(introspectedColumn.getTypeHandler());
sb2.append('#');
sb1.append(sb2);
innerIterateElement.addElement(new TextElement(sb1.toString()));
isEqualElement.addElement(innerIterateElement);
sb1.setLength(0);
sb2.setLength(0);
sb1.append("oredCriteria[]."); //$NON-NLS-1$
sb1.append(introspectedColumn.getJavaProperty());
sb1.append("CriteriaWithListValue"); //$NON-NLS-1$
innerIterateElement = new XmlElement("iterate"); //$NON-NLS-1$
innerIterateElement
.addAttribute(new Attribute("prepend", "and")); //$NON-NLS-1$ //$NON-NLS-2$
innerIterateElement.addAttribute(new Attribute(
"property", sb1.toString())); //$NON-NLS-1$
innerIterateElement.addAttribute(new Attribute(
"conjunction", "and")); //$NON-NLS-1$ //$NON-NLS-2$
sb2.append('$');
sb2.append(sb1);
sb2.append("[].condition$"); //$NON-NLS-1$
innerIterateElement.addElement(new TextElement(sb2.toString()));
sb2.setLength(0);
sb2.append(sb1);
sb2.append("[].values"); //$NON-NLS-1$
innerInnerIterateElement = new XmlElement("iterate"); //$NON-NLS-1$
innerInnerIterateElement.addAttribute(new Attribute("property", //$NON-NLS-1$
sb2.toString()));
innerInnerIterateElement
.addAttribute(new Attribute("open", "(")); //$NON-NLS-1$ //$NON-NLS-2$
innerInnerIterateElement.addAttribute(new Attribute(
"close", ")")); //$NON-NLS-1$ //$NON-NLS-2$
innerInnerIterateElement.addAttribute(new Attribute(
"conjunction", ",")); //$NON-NLS-1$ //$NON-NLS-2$
sb2.setLength(0);
sb2.append('#');
sb2.append(sb1);
sb2.append("[].values[],handler="); //$NON-NLS-1$
sb2.append(introspectedColumn.getTypeHandler());
sb2.append('#');
innerInnerIterateElement.addElement(new TextElement(sb2
.toString()));
innerIterateElement.addElement(innerInnerIterateElement);
isEqualElement.addElement(innerIterateElement);
sb1.setLength(0);
sb2.setLength(0);
sb1.append("oredCriteria[]."); //$NON-NLS-1$
sb1.append(introspectedColumn.getJavaProperty());
sb1.append("CriteriaWithBetweenValue"); //$NON-NLS-1$
innerIterateElement = new XmlElement("iterate"); //$NON-NLS-1$
innerIterateElement
.addAttribute(new Attribute("prepend", "and")); //$NON-NLS-1$ //$NON-NLS-2$
innerIterateElement.addAttribute(new Attribute(
"property", sb1.toString())); //$NON-NLS-1$
innerIterateElement.addAttribute(new Attribute(
"conjunction", "and")); //$NON-NLS-1$ //$NON-NLS-2$
sb2.append('$');
sb2.append(sb1);
sb2.append("[].condition$"); //$NON-NLS-1$
innerIterateElement.addElement(new TextElement(sb2.toString()));
sb2.setLength(0);
sb2.append(sb1);
sb1.insert(0, '#');
sb1.append("[].values[0],handler="); //$NON-NLS-1$
sb1.append(introspectedColumn.getTypeHandler());
sb1.append("# and"); //$NON-NLS-1$
sb2.insert(0, '#');
sb2.append("[].values[1],handler="); //$NON-NLS-1$
sb2.append(introspectedColumn.getTypeHandler());
sb2.append('#');
innerIterateElement.addElement(new TextElement(sb1.toString()));
innerIterateElement.addElement(new TextElement(sb2.toString()));
isEqualElement.addElement(innerIterateElement);
}
}
isEqualElement.addElement(new TextElement(")")); //$NON-NLS-1$
if (context.getPlugins()
.sqlMapExampleWhereClauseElementGenerated(answer,
introspectedTable)) {
parentElement.addElement(answer);
}
}
}