compile method

String compile({ String? tableName, })

Implementation

String compile({String? tableName}) {
  var b = StringBuffer();
  var i = 0;

  for (var builder in expressionBuilders) {
    var key = builder.columnName;
    if (tableName != null) key = '$tableName.$key';
    if (builder.hasValue) {
      if (i++ > 0) b.write(' AND ');
      if (builder is DateTimeSqlExpressionBuilder ||
          (builder is JsonSqlExpressionBuilder && builder.hasRaw)) {
        if (tableName != null) b.write('$tableName.');
        b.write(builder.compile());
      } else {
        b.write('$key ${builder.compile()}');
      }
    }
  }

  for (var raw in _raw) {
    if (i++ > 0) b.write(' AND ');
    b.write(' ($raw)');
  }

  for (var other in _and) {
    var sql = other.compile();
    if (sql.isNotEmpty) b.write(' AND ($sql)');
  }

  for (var other in _not) {
    var sql = other.compile();
    if (sql.isNotEmpty) b.write(' NOT ($sql)');
  }

  for (var other in _or) {
    var sql = other.compile();
    if (sql.isNotEmpty) b.write(' OR ($sql)');
  }

  return b.toString();
}