setField method

void setField(String field, String? alias)

Add the given field to the final result. @param field Field to add @param alias Field's alias

Implementation

void setField(String field, String? alias) {
  var fieldValue = field; //Validator.sanitizeField(field.trim(), mOptions!);

  final aliasValue = alias;
  //Validator.sanitizeFieldAlias(alias, mOptions!) : null;

  /// quote table and field string with dot, example:
  /// db.select().fields(['tablename.fieldname']).from('tablename') result in
  ///  SELECT "tablename"."fieldname" FROM tablename
  // if (mOptions!.quoteStringWithFieldsTablesSeparator) {
  //   if (fieldValue.contains(mOptions!.fieldsTablesSeparator)) {
  //     fieldValue = fieldValue
  //         .split(mOptions!.fieldsTablesSeparator)
  //         .map((f) => f)
  //         .join(
  //             '${mOptions!.fieldAliasQuoteCharacter}${mOptions!.fieldsTablesSeparator}${mOptions!.fieldAliasQuoteCharacter}');
  //   }
  // }

  /// allow alias in fields, example:
  /// db.select().fields(['tablename.fieldname as f']).from('tablename') result in
  ///  SELECT "tablename"."fieldname" as "f" FROM tablename
  // if (mOptions!.allowAliasInFields) {
  //   final reg = RegExp(r'\s+\b|\b\s');
  //   if (fieldValue.contains(reg)) {
  //     fieldValue = fieldValue.replaceAll(' as ', ' ');
  //     fieldValue = fieldValue.replaceAll(reg, '" as "');
  //   }
  // }

  doSetField(fieldValue, aliasValue);
}