Please wait. This can take some minutes ...
Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $
You can buy this project and download/modify it how often you want.
db.sql.api.impl.cmd.struct.ConditionChain Maven / Gradle / Ivy
package db.sql.api.impl.cmd.struct;
import db.sql.api.Cmd;
import db.sql.api.Getter;
import db.sql.api.SqlBuilderContext;
import db.sql.api.cmd.GetterColumnField;
import db.sql.api.cmd.LikeMode;
import db.sql.api.cmd.basic.ICondition;
import db.sql.api.cmd.executor.IQuery;
import db.sql.api.cmd.struct.conditionChain.IConditionChain;
import db.sql.api.impl.cmd.ConditionFactory;
import db.sql.api.impl.cmd.basic.ConditionBlock;
import db.sql.api.impl.cmd.basic.Connector;
import db.sql.api.impl.cmd.basic.TableField;
import db.sql.api.impl.tookit.SqlConst;
import db.sql.api.tookit.CmdUtils;
import java.io.Serializable;
import java.util.ArrayList;
import java.util.Collection;
import java.util.List;
import java.util.Objects;
import java.util.function.Function;
public class ConditionChain implements IConditionChain, ICondition {
private final ConditionFactory conditionFactory;
private final ConditionChain parent;
private List conditionBlocks;
private Connector connector = Connector.AND;
public ConditionChain(ConditionFactory conditionFactory) {
this(conditionFactory, null);
}
public ConditionChain(ConditionFactory conditionFactory, ConditionChain parent) {
this.conditionFactory = conditionFactory;
this.parent = parent;
}
@Override
public ConditionChain setIgnoreNull(boolean bool) {
conditionFactory.setIgnoreNull(bool);
return this;
}
@Override
public ConditionChain setIgnoreEmpty(boolean bool) {
conditionFactory.setIgnoreEmpty(bool);
return this;
}
@Override
public ConditionChain setStringTrim(boolean bool) {
conditionFactory.setStringTrim(bool);
return this;
}
@Override
public ConditionChain and(ICondition condition) {
this.and();
if (Objects.nonNull(condition)) {
conditionBlocks().add(new ConditionBlock(this.connector, condition));
}
return this;
}
@Override
public ConditionChain or(ICondition condition) {
this.or();
if (Objects.nonNull(condition)) {
conditionBlocks().add(new ConditionBlock(this.connector, condition));
}
return this;
}
@Override
public boolean hasContent() {
return conditionBlocks != null && !conditionBlocks.isEmpty();
}
@Override
public ConditionChain newInstance() {
return new ConditionChain(conditionFactory, this);
}
private List conditionBlocks() {
if (conditionBlocks == null) {
conditionBlocks = new ArrayList<>();
}
return this.conditionBlocks;
}
public List getConditionBlocks() {
return conditionBlocks;
}
@Override
public ConditionChain and() {
this.connector = Connector.AND;
return this;
}
@Override
public ConditionChain or() {
this.connector = Connector.OR;
return this;
}
@Override
public ConditionChain and(boolean when, Getter column, int storey, Function function) {
this.and();
if (!when) {
return this;
}
return this.and(function.apply(this.conditionFactory.getCmdFactory().field(column, storey)));
}
@Override
public ConditionChain or(boolean when, Getter column, int storey, Function function) {
this.or();
if (!when) {
return this;
}
return this.or(function.apply(this.conditionFactory.getCmdFactory().field(column, storey)));
}
@Override
public ConditionChain and(boolean when, Function function, int storey, Getter... columns) {
this.and();
if (!when) {
return this;
}
return this.and(function.apply(this.conditionFactory.getCmdFactory().fields(storey, columns)));
}
@Override
public ConditionChain or(boolean when, Function function, int storey, Getter... columns) {
this.or();
if (!when) {
return this;
}
return this.or(function.apply(this.conditionFactory.getCmdFactory().fields(storey, columns)));
}
@Override
public ConditionChain and(boolean when, Function function, GetterColumnField... getterColumnFields) {
if (!when) {
return this;
}
return this.and(function.apply(this.conditionFactory.getCmdFactory().fields(getterColumnFields)));
}
@Override
public ConditionChain or(boolean when, Function function, GetterColumnField... getterColumnFields) {
if (!when) {
return this;
}
return this.or(function.apply(this.conditionFactory.getCmdFactory().fields(getterColumnFields)));
}
@Override
public ConditionChain empty(boolean when, Getter column, int storey) {
ICondition condition = conditionFactory.empty(when, column, storey);
if (condition != null) {
conditionBlocks().add(new ConditionBlock(this.connector, condition));
}
return this;
}
@Override
public ConditionChain empty(Cmd column) {
ICondition condition = conditionFactory.empty(column);
if (condition != null) {
conditionBlocks().add(new ConditionBlock(this.connector, condition));
}
return this;
}
@Override
public ConditionChain notEmpty(boolean when, Getter column, int storey) {
ICondition condition = conditionFactory.notEmpty(when, column, storey);
if (condition != null) {
conditionBlocks().add(new ConditionBlock(this.connector, condition));
}
return this;
}
@Override
public ConditionChain notEmpty(Cmd column) {
ICondition condition = conditionFactory.notEmpty(column);
if (condition != null) {
conditionBlocks().add(new ConditionBlock(this.connector, condition));
}
return this;
}
@Override
public ConditionChain eq(Cmd column, Object value) {
ICondition condition = conditionFactory.eq(column, value);
if (condition != null) {
conditionBlocks().add(new ConditionBlock(this.connector, condition));
}
return this;
}
@Override
public ConditionChain ne(Cmd column, Object value) {
ICondition condition = conditionFactory.ne(column, value);
if (condition != null) {
conditionBlocks().add(new ConditionBlock(this.connector, condition));
}
return this;
}
@Override
public ConditionChain gt(Cmd column, Object value) {
ICondition condition = conditionFactory.gt(column, value);
if (condition != null) {
conditionBlocks().add(new ConditionBlock(this.connector, condition));
}
return this;
}
@Override
public ConditionChain gte(Cmd column, Object value) {
ICondition condition = conditionFactory.gte(column, value);
if (condition != null) {
conditionBlocks().add(new ConditionBlock(this.connector, condition));
}
return this;
}
@Override
public ConditionChain lt(Cmd column, Object value) {
ICondition condition = conditionFactory.lt(column, value);
if (condition != null) {
conditionBlocks().add(new ConditionBlock(this.connector, condition));
}
return this;
}
@Override
public ConditionChain lte(Cmd column, Object value) {
ICondition condition = conditionFactory.lte(column, value);
if (condition != null) {
conditionBlocks().add(new ConditionBlock(this.connector, condition));
}
return this;
}
@Override
public ConditionChain between(Cmd column, Serializable value, Serializable value2) {
ICondition condition = conditionFactory.between(column, value, value2);
if (condition != null) {
conditionBlocks().add(new ConditionBlock(this.connector, condition));
}
return this;
}
@Override
public ConditionChain notBetween(Cmd column, Serializable value, Serializable value2) {
ICondition condition = conditionFactory.notBetween(column, value, value2);
if (condition != null) {
conditionBlocks().add(new ConditionBlock(this.connector, condition));
}
return this;
}
@Override
public ConditionChain isNull(Cmd column) {
ICondition condition = conditionFactory.isNull(column);
if (condition != null) {
conditionBlocks().add(new ConditionBlock(this.connector, condition));
}
return this;
}
@Override
public ConditionChain isNotNull(Cmd column) {
ICondition condition = conditionFactory.isNotNull(column);
if (condition != null) {
conditionBlocks().add(new ConditionBlock(this.connector, condition));
}
return this;
}
@Override
public ConditionChain like(LikeMode mode, Cmd column, String value) {
ICondition condition = conditionFactory.like(mode, column, value);
if (condition != null) {
conditionBlocks().add(new ConditionBlock(this.connector, condition));
}
return this;
}
@Override
public ConditionChain notLike(LikeMode mode, Cmd column, String value) {
ICondition condition = conditionFactory.notLike(mode, column, value);
if (condition != null) {
conditionBlocks().add(new ConditionBlock(this.connector, condition));
}
return this;
}
@Override
public ConditionChain between(boolean when, Getter column, int storey, Serializable value, Serializable value2) {
ICondition condition = conditionFactory.between(when, column, storey, value, value2);
if (condition != null) {
conditionBlocks().add(new ConditionBlock(this.connector, condition));
}
return this;
}
@Override
public ConditionChain eq(boolean when, Getter column, int storey, Object value) {
ICondition condition = conditionFactory.eq(when, column, storey, value);
if (condition != null) {
conditionBlocks().add(new ConditionBlock(this.connector, condition));
}
return this;
}
@Override
public ConditionChain eq(boolean when, Getter column, int columnStorey, Getter value, int valueStorey) {
ICondition condition = conditionFactory.eq(when, column, columnStorey, value, valueStorey);
if (condition != null) {
conditionBlocks().add(new ConditionBlock(this.connector, condition));
}
return this;
}
@Override
public ConditionChain gt(boolean when, Getter column, int storey, Object value) {
ICondition condition = conditionFactory.gt(when, column, storey, value);
if (condition != null) {
conditionBlocks().add(new ConditionBlock(this.connector, condition));
}
return this;
}
@Override
public ConditionChain gt(boolean when, Getter column, int columnStorey, Getter value, int valueStorey) {
ICondition condition = conditionFactory.gt(when, column, columnStorey, value, valueStorey);
if (condition != null) {
conditionBlocks().add(new ConditionBlock(this.connector, condition));
}
return this;
}
@Override
public ConditionChain gte(boolean when, Getter column, int storey, Object value) {
ICondition condition = conditionFactory.gte(when, column, storey, value);
if (condition != null) {
conditionBlocks().add(new ConditionBlock(this.connector, condition));
}
return this;
}
@Override
public ConditionChain gte(boolean when, Getter column, int columnStorey, Getter value, int valueStorey) {
ICondition condition = conditionFactory.gte(when, column, columnStorey, value, valueStorey);
if (condition != null) {
conditionBlocks().add(new ConditionBlock(this.connector, condition));
}
return this;
}
@Override
public ConditionChain like(boolean when, LikeMode mode, Getter column, int storey, String value) {
ICondition condition = conditionFactory.like(when, mode, column, storey, value);
if (condition != null) {
conditionBlocks().add(new ConditionBlock(this.connector, condition));
}
return this;
}
@Override
public ConditionChain lt(boolean when, Getter column, int storey, Object value) {
ICondition condition = conditionFactory.lt(when, column, storey, value);
if (condition != null) {
conditionBlocks().add(new ConditionBlock(this.connector, condition));
}
return this;
}
@Override
public ConditionChain lt(boolean when, Getter column, int columnStorey, Getter value, int valueStorey) {
ICondition condition = conditionFactory.lt(when, column, columnStorey, value, valueStorey);
if (condition != null) {
conditionBlocks().add(new ConditionBlock(this.connector, condition));
}
return this;
}
@Override
public ConditionChain lte(boolean when, Getter column, int storey, Object value) {
ICondition condition = conditionFactory.lte(when, column, storey, value);
if (condition != null) {
conditionBlocks().add(new ConditionBlock(this.connector, condition));
}
return this;
}
@Override
public ConditionChain lte(boolean when, Getter column, int columnStorey, Getter value, int valueStorey) {
ICondition condition = conditionFactory.lte(when, column, columnStorey, value, valueStorey);
if (condition != null) {
conditionBlocks().add(new ConditionBlock(this.connector, condition));
}
return this;
}
@Override
public ConditionChain ne(boolean when, Getter column, int storey, Object value) {
ICondition condition = conditionFactory.ne(when, column, storey, value);
if (condition != null) {
conditionBlocks().add(new ConditionBlock(this.connector, condition));
}
return this;
}
@Override
public ConditionChain ne(boolean when, Getter column, int columnStorey, Getter value, int valueStorey) {
ICondition condition = conditionFactory.ne(when, column, columnStorey, value, valueStorey);
if (condition != null) {
conditionBlocks().add(new ConditionBlock(this.connector, condition));
}
return this;
}
@Override
public ConditionChain notBetween(boolean when, Getter column, int storey, Serializable value, Serializable value2) {
ICondition condition = conditionFactory.notBetween(when, column, storey, value, value2);
if (condition != null) {
conditionBlocks().add(new ConditionBlock(this.connector, condition));
}
return this;
}
@Override
public ConditionChain notLike(boolean when, LikeMode mode, Getter column, int storey, String value) {
ICondition condition = conditionFactory.notLike(when, mode, column, storey, value);
if (condition != null) {
conditionBlocks().add(new ConditionBlock(this.connector, condition));
}
return this;
}
@Override
public ConditionChain isNotNull(boolean when, Getter column, int storey) {
ICondition condition = conditionFactory.isNotNull(when, column, storey);
if (condition != null) {
conditionBlocks().add(new ConditionBlock(this.connector, condition));
}
return this;
}
@Override
public ConditionChain isNull(boolean when, Getter column, int storey) {
ICondition condition = conditionFactory.isNull(when, column, storey);
if (condition != null) {
conditionBlocks().add(new ConditionBlock(this.connector, condition));
}
return this;
}
@Override
public ConditionChain in(Cmd cmd, IQuery query) {
ICondition condition = conditionFactory.in(cmd, query);
if (condition != null) {
conditionBlocks().add(new ConditionBlock(this.connector, condition));
}
return this;
}
@Override
public ConditionChain in(Cmd cmd, Serializable... values) {
ICondition condition = conditionFactory.in(cmd, values);
if (condition != null) {
conditionBlocks().add(new ConditionBlock(this.connector, condition));
}
return this;
}
@Override
public ConditionChain in(Cmd cmd, Collection extends Serializable> values) {
ICondition condition = conditionFactory.in(cmd, values);
if (condition != null) {
conditionBlocks().add(new ConditionBlock(this.connector, condition));
}
return this;
}
@Override
public ConditionChain in(boolean when, Getter column, int storey, IQuery query) {
ICondition condition = conditionFactory.in(when, column, storey, query);
if (condition != null) {
conditionBlocks().add(new ConditionBlock(this.connector, condition));
}
return this;
}
@Override
public ConditionChain in(boolean when, Getter column, int storey, Serializable[] values) {
ICondition condition = conditionFactory.in(when, column, storey, values);
if (condition != null) {
conditionBlocks().add(new ConditionBlock(this.connector, condition));
}
return this;
}
@Override
public ConditionChain in(boolean when, Getter column, int storey, Collection extends Serializable> values) {
ICondition condition = conditionFactory.in(when, column, storey, values);
if (condition != null) {
conditionBlocks().add(new ConditionBlock(this.connector, condition));
}
return this;
}
@Override
public ConditionChain exists(boolean when, IQuery query) {
ICondition condition = conditionFactory.exists(when, query);
if (condition != null) {
conditionBlocks().add(new ConditionBlock(this.connector, condition));
}
return this;
}
@Override
public ConditionChain notExists(boolean when, IQuery query) {
ICondition condition = conditionFactory.notExists(when, query);
if (condition != null) {
conditionBlocks().add(new ConditionBlock(this.connector, condition));
}
return this;
}
@Override
public ConditionChain notIn(Cmd cmd, IQuery query) {
ICondition condition = conditionFactory.notIn(cmd, query);
if (condition != null) {
conditionBlocks().add(new ConditionBlock(this.connector, condition));
}
return this;
}
@Override
public ConditionChain notIn(Cmd cmd, Serializable... values) {
ICondition condition = conditionFactory.notIn(cmd, values);
if (condition != null) {
conditionBlocks().add(new ConditionBlock(this.connector, condition));
}
return this;
}
@Override
public ConditionChain notIn(Cmd cmd, Collection extends Serializable> values) {
ICondition condition = conditionFactory.notIn(cmd, values);
if (condition != null) {
conditionBlocks().add(new ConditionBlock(this.connector, condition));
}
return this;
}
@Override
public ConditionChain notIn(boolean when, Getter column, int storey, IQuery query) {
ICondition condition = conditionFactory.notIn(when, column, storey, query);
if (condition != null) {
conditionBlocks().add(new ConditionBlock(this.connector, condition));
}
return this;
}
@Override
public ConditionChain notIn(boolean when, Getter column, int storey, Serializable[] values) {
ICondition condition = conditionFactory.notIn(when, column, storey, values);
if (condition != null) {
conditionBlocks().add(new ConditionBlock(this.connector, condition));
}
return this;
}
@Override
public ConditionChain notIn(boolean when, Getter column, int storey, Collection extends Serializable> values) {
ICondition condition = conditionFactory.notIn(when, column, storey, values);
if (condition != null) {
conditionBlocks().add(new ConditionBlock(this.connector, condition));
}
return this;
}
@Override
public StringBuilder sql(Cmd module, Cmd parent, SqlBuilderContext context, StringBuilder sqlBuilder) {
if (conditionBlocks == null || conditionBlocks.isEmpty()) {
return sqlBuilder;
}
if ((!(parent instanceof Where) && !(parent instanceof On)) || this.parent != null) {
sqlBuilder.append(SqlConst.BLANK).append(SqlConst.BRACKET_LEFT);
}
boolean isFirst = true;
for (ConditionBlock conditionBlock : this.conditionBlocks) {
if (conditionBlock.getCondition() instanceof ConditionChain) {
ConditionChain conditionChain = (ConditionChain) conditionBlock.getCondition();
if (!conditionChain.hasContent()) {
continue;
}
}
if (!isFirst) {
sqlBuilder.append(SqlConst.BLANK).append(conditionBlock.getConnector()).append(SqlConst.BLANK);
}
conditionBlock.getCondition().sql(module, this, context, sqlBuilder);
isFirst = false;
}
if ((!(parent instanceof Where) && !(parent instanceof On)) || this.parent != null) {
sqlBuilder.append(SqlConst.BRACKET_RIGHT).append(SqlConst.BLANK);
}
return sqlBuilder;
}
@Override
public boolean contain(Cmd cmd) {
return CmdUtils.contain(cmd, this.conditionBlocks);
}
}