generateSQLSearch static method

String generateSQLSearch(
  1. List values,
  2. List<String> columns, [
  3. string? quoteChar,
  4. String dataBaseProvider = "",
])

Implementation

static String generateSQLSearch(List<dynamic> values, List<String> columns, [string? quoteChar, String dataBaseProvider = ""]) {
  var whereClause = "";

  for (string column in columns.whereValid) {
    for (var value in values.whereValid) {
      if (whereClause.isNotEmpty) {
        whereClause += ' OR ';
      }
      whereClause += "${SqlUtil.wrap(column, quoteChar, dataBaseProvider)} LIKE ${SqlUtil.value(value, true)}";
    }
  }

  return whereClause.wrap("(");
}