select method

String select(
  1. FieldData fieldData,
  2. WhereData? whereData
)

Implementation

String select(FieldData fieldData,WhereData? whereData) {
  StringBuffer sql = StringBuffer();
  sql.write(" SELECT ");
  bool isFirst=true;
  fieldData.getFieldStructList.forEach((sd) {
    if(!isFirst) {
      sql.write(",");
    }
    if(sd.fieldName!=null) {
      sql.write("             " + sd.fieldName!);
    } else {
      if(sd.value is SqlKeyword) {
        sql.write(
            "             " + (sd.value as SqlKeyword).getKeywordString);
      }
    }
    isFirst=false;
  });
  if(whereData!=null) {
    sql.write("     FROM $tableName");
    WhereGenerator wg = WhereGenerator(dbType, smd);
    sql.write(wg.getWhereString(whereData));
    sql.write(wg.getOrderString(whereData));
    if(whereData.limit!=null) sql.write(" LIMIT "+whereData.limit.toString());
  }
  return StringUtils.formatSql(sql.toString());
}