Function processBatch

main.js:4032–4082

(entries, currentDir)

function compileSearchTokensToSQL(tokens, params, filters) {
  const t = sanitizeSearchTokensForCompile(tokens);
  if (t.length === 0) return null;
  try {
    const [sql, end] = parseSearchOr(t, 0, params, filters);
    if (end !== t.length) return null;
    return sql;
  } catch (e) {
    console.warn('compileSearchTokensToSQL failed:', e.message);
    return null;
  }
}

/** Multi-value designer / parentModel / license (matches legacy single-value SQL for invert + NULL). */
function pushEqualityListCondition(conditions, params, column, values, combineOp, inverted, useLowerTrim) {
  if (!values.length) return;
  const posJoin = combineOp === 'AND' ? ' AND ' : ' OR ';
  if (!inverted) {
    const posParts = [];
    for (const v of values) {
      if (v === '__none__') {
        posParts.push(`(${column} IS NULL OR ${column} = '')`);
      } else if (useLowerTrim) {
        params.push(v);
        posParts.push(`LOWER(TRIM(${column})) = LOWER(TRIM(?))`);
      } else {
        params.push(v);
        posParts.push(`${column} = ?`);
      }
    }
    conditions.push(posParts.length === 1 ? posParts[0] : `(${posParts.join(posJoin)})`);
    return;
  }
  const negJoin = combineOp === 'OR' ? ' AND ' : ' OR ';
  const negParts = [];
  for (const v of values) {
    if (v === '__none__') {
      negParts.push(`(${column} IS NOT NULL AND ${column} != '')`);
    } else if (useLowerTrim) {
      params.push(v);
      negParts.push(`(${column} IS NULL OR ${column} = '' OR LOWER(TRIM(${column})) != LOWER(TRIM(?)))`);
    } else {
      params.push(v);
      negParts.push(`(${column} IS NULL OR ${column} = '' OR ${column} != ?)`);
    }
  }
  conditions.push(negParts.length === 1 ? negParts[0] : `(${negParts.join(negJoin)})`);
}

function pushTagListSQL(conditions, params, filters) {
  const tagNames = normalizeTagNameList(filters);
  if (!tagNames.length) return false;
  const combine = filters.tagCombine === 'AND' ? 'AND' : 'OR';
  const inverted = !!filters.tagInverted;
  let inner;
  if (combine === 'OR') {