Function pushEqualityListCondition

main.js:3459–3492

Multi-value designer / parentModel / license (matches legacy single-value SQL for invert + NULL).

(conditions, params, column, values, combineOp, inverted, useLowerTrim)

/** Add rating (0-5) and favorite (0/1) columns for model engagement. */
function migrateRatingFavoriteColumns() {
  try {
    console.log('Checking for rating/favorite column migration...');
    const tableInfo = db.prepare('PRAGMA table_info(models)').all();
    const hasRating = tableInfo.some(col => col.name === 'rating');
    const hasFavorite = tableInfo.some(col => col.name === 'favorite');
    if (!hasRating) {
      console.log('rating column not found. Adding it...');
      db.prepare('ALTER TABLE models ADD COLUMN rating INTEGER DEFAULT 0').run();
      db.prepare('UPDATE models SET rating = 0 WHERE rating IS NULL').run();
    }
    if (!hasFavorite) {
      console.log('favorite column not found. Adding it...');
      db.prepare('ALTER TABLE models ADD COLUMN favorite INTEGER DEFAULT 0').run();
      db.prepare('UPDATE models SET favorite = 0 WHERE favorite IS NULL').run();
    }
    return true;
  } catch (error) {
    console.error('Error migrating rating/favorite columns:', error);
    return false;
  }
}

function migratePrintLifecycleColumns() {
  try {
    printEvents.migratePrintLifecycle(db);
    return true;
  } catch (error) {
    console.error('Error migrating print lifecycle columns:', error);
    return false;
  }
}

/** Zip bundle columns for grouped browsing (folder siblings are not bundled). */
function migrateBundleColumns() {
  try {
    console.log('Checking for bundle column migration...');
    const tableInfo = db.prepare('PRAGMA table_info(models)').all();