Function getDatabasePath

main.js:6784–6826

()

// Update the database path handling
function getDatabasePath() {
  try {
    const envDb = process.env.PRINTVENTORY_DB_PATH?.trim();
    if (envDb) {
      const resolved = path.isAbsolute(envDb) ? envDb : path.resolve(process.cwd(), envDb);
      const dir = path.dirname(resolved);
      if (!fs.existsSync(dir)) {
        fs.mkdirSync(dir, { recursive: true });
      }
      debugLog('Using database path from PRINTVENTORY_DB_PATH:', resolved);
      return resolved;
    }

    // Local dev (Electron .npm start): keep a single DB in the repo. Server/Docker/docker-entrypoint
    // runs unpackaged Electron which sets isDev, but we must still use userData so compose volumes work.
    if (isDev && !isServerMode) {
      return path.join(__dirname, 'printventory.db');
    }

    // Handle different OS paths
    let userDataPath;
    if (process.platform === 'darwin') { // macOS
      userDataPath = path.join(app.getPath('userData'), 'data');
    } else if (process.platform === 'win32') { // Windows
      userDataPath = path.join(process.env.LOCALAPPDATA, 'Printventory', 'data');
    } else { // Linux and other Unix-like systems
      userDataPath = path.join(app.getPath('userData'), 'data');
    }

    // Ensure the directory exists
    if (!fs.existsSync(userDataPath)) {
      fs.mkdirSync(userDataPath, { recursive: true });
    }

    const dbPath = path.join(userDataPath, 'printventory.db');
    migrateLegacyServerDbIfNeeded(dbPath);
    debugLog('Using database path:', dbPath);
    return dbPath;
  } catch (error) {
    console.error('Error setting up database path:', error);
    throw error;
  }
}

// Add these IPC handlers
// Helper: URL-only models (added by Chrome extension) have filePath "url::https://..."