示例#1
0
 /**
  * Executes a constant value
  *
  * @param sql
  * @param qr
  * @param constant
  * @param row
  * @return result
  * @throws PageException
  */
 private Object executeConstant(SQL sql, Query qr, ZConstant constant, int row)
     throws PageException {
   switch (constant.getType()) {
     case ZConstant.COLUMNNAME:
       {
         if (constant.getValue().equals(SQLPrettyfier.PLACEHOLDER_QUESTION)) {
           int pos = sql.getPosition();
           sql.setPosition(pos + 1);
           if (sql.getItems().length <= pos)
             throw new DatabaseException("invalid syntax for SQL Statment", null, sql, null);
           return sql.getItems()[pos].getValueForCF();
         }
         return qr.getAt(List.last(constant.getValue(), ".", true), row);
       }
     case ZConstant.NULL:
       return null;
     case ZConstant.NUMBER:
       return Caster.toDouble(constant.getValue());
     case ZConstant.STRING:
       return constant.getValue();
     case ZConstant.UNKNOWN:
     default:
       throw new DatabaseException("invalid constant value", null, sql, null);
   }
 }
示例#2
0
  /**
   * Executes a Expression
   *
   * @param sql
   * @param qr
   * @param expression
   * @param row
   * @return result
   * @throws PageException
   */
  private Object executeExpression(
      PageContext pc, SQL sql, Query qr, ZExpression expression, int row) throws PageException {
    String op = StringUtil.toLowerCase(expression.getOperator());
    int count = expression.nbOperands();

    if (op.equals("and")) return executeAnd(pc, sql, qr, expression, row);
    else if (op.equals("or")) return executeOr(pc, sql, qr, expression, row);
    if (count == 0 && op.equals("?")) {
      int pos = sql.getPosition();
      if (sql.getItems().length <= pos)
        throw new DatabaseException("invalid syntax for SQL Statment", null, sql, null);
      sql.setPosition(pos + 1);
      return sql.getItems()[pos].getValueForCF();
    }
    // 11111111111111111111111111111111111111111111111111111
    else if (count == 1) {
      Object value = executeExp(pc, sql, qr, expression.getOperand(0), row);

      // Functions
      switch (op.charAt(0)) {
        case 'a':
          if (op.equals("abs")) return new Double(MathUtil.abs(Caster.toDoubleValue(value)));
          if (op.equals("acos")) return new Double(Math.acos(Caster.toDoubleValue(value)));
          if (op.equals("asin")) return new Double(Math.asin(Caster.toDoubleValue(value)));
          if (op.equals("atan")) return new Double(Math.atan(Caster.toDoubleValue(value)));
          break;
        case 'c':
          if (op.equals("ceiling")) return new Double(Math.ceil(Caster.toDoubleValue(value)));
          if (op.equals("cos")) return new Double(Math.cos(Caster.toDoubleValue(value)));
          break;
        case 'e':
          if (op.equals("exp")) return new Double(Math.exp(Caster.toDoubleValue(value)));
          break;
        case 'f':
          if (op.equals("floor")) return new Double(Math.floor(Caster.toDoubleValue(value)));
          break;
        case 'i':
          if (op.equals("is not null")) return Boolean.valueOf(value != null);
          if (op.equals("is null")) return Boolean.valueOf(value == null);
          break;
        case 'u':
          if (op.equals("upper") || op.equals("ucase")) return Caster.toString(value).toUpperCase();
          break;

        case 'l':
          if (op.equals("lower") || op.equals("lcase")) return Caster.toString(value).toLowerCase();
          if (op.equals("ltrim")) return StringUtil.ltrim(Caster.toString(value), null);
          if (op.equals("length")) return new Double(Caster.toString(value).length());
          break;
        case 'r':
          if (op.equals("rtrim")) return StringUtil.rtrim(Caster.toString(value), null);
          break;
        case 's':
          if (op.equals("sign")) return new Double(MathUtil.sgn(Caster.toDoubleValue(value)));
          if (op.equals("sin")) return new Double(Math.sin(Caster.toDoubleValue(value)));
          if (op.equals("soundex")) return StringUtil.soundex(Caster.toString(value));
          if (op.equals("sin")) return new Double(Math.sqrt(Caster.toDoubleValue(value)));
          break;
        case 't':
          if (op.equals("tan")) return new Double(Math.tan(Caster.toDoubleValue(value)));
          if (op.equals("trim")) return Caster.toString(value).trim();
          break;
      }

    }

    // 22222222222222222222222222222222222222222222222222222
    else if (count == 2) {

      if (op.equals("=") || op.equals("in")) return executeEQ(pc, sql, qr, expression, row);
      else if (op.equals("!=") || op.equals("<>")) return executeNEQ(pc, sql, qr, expression, row);
      else if (op.equals("<")) return executeLT(pc, sql, qr, expression, row);
      else if (op.equals("<=")) return executeLTE(pc, sql, qr, expression, row);
      else if (op.equals(">")) return executeGT(pc, sql, qr, expression, row);
      else if (op.equals(">=")) return executeGTE(pc, sql, qr, expression, row);
      else if (op.equals("-")) return executeMinus(pc, sql, qr, expression, row);
      else if (op.equals("+")) return executePlus(pc, sql, qr, expression, row);
      else if (op.equals("/")) return executeDivide(pc, sql, qr, expression, row);
      else if (op.equals("*")) return executeMultiply(pc, sql, qr, expression, row);
      else if (op.equals("^")) return executeExponent(pc, sql, qr, expression, row);

      Object left = executeExp(pc, sql, qr, expression.getOperand(0), row);
      Object right = executeExp(pc, sql, qr, expression.getOperand(1), row);

      // Functions
      switch (op.charAt(0)) {
        case 'a':
          if (op.equals("atan2"))
            return new Double(Math.atan2(Caster.toDoubleValue(left), Caster.toDoubleValue(right)));
          break;
        case 'b':
          if (op.equals("bitand"))
            return new Double(
                Operator.bitand(Caster.toDoubleValue(left), Caster.toDoubleValue(right)));
          if (op.equals("bitor"))
            return new Double(
                Operator.bitor(Caster.toDoubleValue(left), Caster.toDoubleValue(right)));
          break;
        case 'c':
          if (op.equals("concat")) return Caster.toString(left).concat(Caster.toString(right));
          break;
        case 'l':
          if (op.equals("like")) return executeLike(pc, sql, qr, expression, row);
          break;
        case 'm':
          if (op.equals("mod"))
            return new Double(
                Operator.modulus(Caster.toDoubleValue(left), Caster.toDoubleValue(right)));
          break;
      }

      throw new DatabaseException("unsopprted sql statement [" + op + "]", null, sql, null);
    }
    // 3333333333333333333333333333333333333333333333333333333333333333333
    else if (count == 3) {
      if (op.equals("between")) return executeBetween(pc, sql, qr, expression, row);
    }

    if (op.equals("in")) return executeIn(pc, sql, qr, expression, row);

    /*

    addCustomFunction("cot",1);
    addCustomFunction("degrees",1);
    addCustomFunction("log",1);
    addCustomFunction("log10",1);

    addCustomFunction("pi",0);
    addCustomFunction("power",2);
    addCustomFunction("radians",1);
    addCustomFunction("rand",0);
    addCustomFunction("round",2);
    addCustomFunction("roundmagic",1);
    addCustomFunction("truncate",2);
    addCustomFunction("ascii",1);
    addCustomFunction("bit_length",1);
    addCustomFunction("char",1);
    addCustomFunction("char_length",1);
    addCustomFunction("difference",2);
    addCustomFunction("hextoraw",1);
    addCustomFunction("insert",4);
    addCustomFunction("left",2);
    addCustomFunction("locate",3);
    addCustomFunction("octet_length",1);
    addCustomFunction("rawtohex",1);
    addCustomFunction("repeat",2);
    addCustomFunction("replace",3);
    addCustomFunction("right",2);
    addCustomFunction("space",1);
    addCustomFunction("substr",3);
    addCustomFunction("substring",3);
    addCustomFunction("curdate",0);
    addCustomFunction("curtime",0);
    addCustomFunction("datediff",3);
    addCustomFunction("dayname",1);
    addCustomFunction("dayofmonth",1);
    addCustomFunction("dayofweek",1);
    addCustomFunction("dayofyear",1);
    addCustomFunction("hour",1);
    addCustomFunction("minute",1);
    addCustomFunction("month",1);
    addCustomFunction("monthname",1);
    addCustomFunction("now",0);
    addCustomFunction("quarter",1);
    addCustomFunction("second",1);
    addCustomFunction("week",1);
    addCustomFunction("year",1);
    addCustomFunction("current_date",1);
    addCustomFunction("current_time",1);
    addCustomFunction("current_timestamp",1);
    addCustomFunction("database",0);
    addCustomFunction("user",0);
    addCustomFunction("current_user",0);
    addCustomFunction("identity",0);
    addCustomFunction("ifnull",2);
    addCustomFunction("casewhen",3);
    addCustomFunction("convert",2);
    //addCustomFunction("cast",1);
    addCustomFunction("coalesce",1000);
    addCustomFunction("nullif",2);
    addCustomFunction("extract",1);
    addCustomFunction("position",1);
    */

    // print(expression);
    throw new DatabaseException(
        "unsopprted sql statement (op-count:" + expression.nbOperands() + ";operator:" + op + ") ",
        null,
        sql,
        null);
  }