Class Delete

src/main/java/com/sql/parse/statement/impl/druid/Delete.java:24–243

@date 2019年4月30日上午09:58:02 @desc Delete语法操作类

 * @desc Delete语法操作类
 */
public class Delete extends com.sql.parse.statement.Delete {
    private SQLDeleteStatement delete;

    public Delete(SQLDeleteStatement delete) {
        this.delete = delete;
    }

    public Delete(String tableName) {
        SQLDeleteStatement delete = new SQLDeleteStatement(SqlParseConfig.getDbType());
        delete.setTableName(tableName);
        this.delete = delete;
    }

    @Override
    public String getSql(boolean safe) {
        Delete myDelete = this.clone();
        if (safe && myDelete.getDelete().getWhere() == null) {
            myDelete.where("1 = 2");
        }
        return SQLUtils.toSQLString(myDelete.getDelete());
    }

    public SQLDeleteStatement getDelete() {
        return this.delete;
    }

    /**
     * @title: where
     * @desc "WHERE"符号
     */
    public Delete where(String expr) {
        SQLExpr expression = new SQLExprParser(expr).expr();
        where(expression);
        return this;
    }

    public Delete where(SQLExpr where) {
        SQLExpr oldWhere = delete.getWhere();
        if (oldWhere == null) {
            delete.setWhere(where);
        } else {
            throw BaseException.errorCode(SqlParseConstant.CODE_004);
        }
        return this;
    }

    /**
     * @title: and
     * @desc 移除where条件
     */
    public Delete removeAllWhere() {
        delete.setWhere(null);
        return this;
    }

    /**
     * @title: and
     * @desc "AND"符号