getImportDataString method

String? getImportDataString(
  1. String tableName,
  2. String fileName,
  3. String? fieldSeparator,
  4. String? fieldEnclose,
  5. String? lineTerminator,
)
override

Implementation

String? getImportDataString(String tableName, String fileName, String? fieldSeparator, String? fieldEnclose, String? lineTerminator) {
  StringBuffer sb= StringBuffer();
  sb.write("LOAD DATA INFILE '$fileName' ");
  sb.write("     INTO TABLE $tableName ");
  if(fieldSeparator==null) fieldSeparator='|';
  sb.write("     FIELDS TERMINATED BY '$fieldSeparator' ");
  if(fieldEnclose!=null) {
    sb.write("    ENCLOSED BY \"$fieldEnclose\" ");
  }
  if(lineTerminator==null) lineTerminator="\n";
  sb.write("     LINES TERMINATED BY '$lineTerminator' ");
  return sb.toString();
}