// The e2e database: E2E_DATABASE_URL, or backend/.env's DATABASE_URL with "_e2e" added
// to the database name — always separate from the database you develop against.
const path = require('path');

function e2eDatabaseUrl() {
  if (process.env.E2E_DATABASE_URL) return process.env.E2E_DATABASE_URL;
  const backend = path.join(__dirname, '..', '..', 'backend');
  require(require.resolve('dotenv', { paths: [backend] })).config({ path: path.join(backend, '.env'), quiet: true });
  if (!process.env.DATABASE_URL) throw new Error('Set E2E_DATABASE_URL (or DATABASE_URL in backend/.env) for the e2e tests.');
  const u = new URL(process.env.DATABASE_URL);
  const name = u.pathname.replace(/^\//, '');
  u.pathname = `/${name.endsWith('_e2e') ? name : `${name}_e2e`}`;
  return u.toString();
}

module.exports = { e2eDatabaseUrl };