toSql method

  1. @override
String toSql(
  1. Statement? st
)
override

Implementation

@override
String toSql(Statement? st) {
  if (values != null) {
    StringBuffer sb = new StringBuffer();
    sb.write(_exp.toSql(st));
    if (!_inOrNotIn) sb.write(" NOT");
    sb.write(" IN ( ");
    for (Object val in values!) {
      sb.write("(${valueInSql(val)})${' ,'}");
    }

    return "${sb.toString().removeLastChar()} )";
  }
  //======
  if (table != null) {
    return "((${_exp.toSql(st)}) ${_inOrNotIn ? "IN" : "NOT IN"} (${table!._sqlInSelect()})";
  }
  //======
  if (select != null) {
    return "((${_exp.toSql(st)}) ${_inOrNotIn ? "IN" : "NOT IN"} (${select._sqlInSelect()})";
  }
  //not supposed to come here
  return '';
}