toSql method

String toSql()

Implementation

String toSql() {
  StringBuffer sb = new StringBuffer();
  sb.write(this._sqlInSelect());
  //order by
  if (_sortList != null) {
    sb.write(" ORDER BY ");

    sb.writeAll(_sortList!.map((s) => s._toSql()), " , ");
  }
  //page
  if (_pageSize > 0) {
    sb.write(
        " LIMIT ${_pageSize} OFFSET ${_pageSize * _pageIndex}");
  }
  //
  return sb.toString();
}