Function getDuplicatesHandler

main.js:7854–7908

(event, includeZip = false)

    const writeStart = Date.now();
    const transaction = db.transaction(() => {
      for (let i = 0; i < iterations; i++) {
        insertStmt.run(`benchmark_test_${i}`, `test_value_${i}`);
      }
    });
    transaction();
    const writeTime = Date.now() - writeStart;
    const writeOpsPerSec = (iterations / (writeTime / 1000)).toFixed(2);
    
    // Read benchmark - select test records
    const selectStmt = db.prepare('SELECT value FROM settings WHERE key = ?');
    const readStart = Date.now();
    for (let i = 0; i < iterations; i++) {
      selectStmt.get(`benchmark_test_${i}`);
    }
    const readTime = Date.now() - readStart;
    const readOpsPerSec = (iterations / (readTime / 1000)).toFixed(2);
    
    // Cleanup - delete test records
    const deleteStmt = db.prepare('DELETE FROM settings WHERE key LIKE ?');
    deleteStmt.run('benchmark_test_%');
    
    return {
      success: true,
      write: {
        time: writeTime,
        operations: iterations,
        opsPerSec: writeOpsPerSec
      },
      read: {
        time: readTime,
        operations: iterations,
        opsPerSec: readOpsPerSec
      }
    };
  } catch (error) {
    console.error('Error benchmarking database:', error);
    return { success: false, error: error.message };
  }
});

ipcMain.handle('rename-metadata', async (event, type, oldName, newName) => {
  try {
    if (!oldName || !newName || oldName.trim() === '' || newName.trim() === '') {
      throw new Error('Name cannot be empty');
    }

    // Validate type
    const validTypes = ['designer', 'parentModel', 'license'];
    if (!validTypes.includes(type)) {
      throw new Error('Invalid metadata type');
    }

    // Check if new name already exists for this type (for merge information)
    const existing = db.prepare(`
      SELECT COUNT(*) as count 
      FROM models 
      WHERE ${type} = ? AND ${type} IS NOT NULL AND ${type} != ''
    `).get(newName.trim());