Function syncDbToEnvFile

lib/services/env.ts:159–199

(projectId: string)

}

export async function syncDbToEnvFile(projectId: string): Promise<number> {
  const project = await ensureProject(projectId);
  const repoEnvPath = envFilePath(project);

  const envVars = await prisma.envVar.findMany({
    where: { projectId },
    orderBy: { key: 'asc' },
  });

  const entries = envVars.reduce<{ key: string; value: string }[]>((acc, envVar) => {
    try {
      acc.push({ key: envVar.key, value: decrypt(envVar.valueEncrypted) });
    } catch (error) {
      console.warn(`[EnvService] Failed to decrypt env var ${envVar.key}:`, error);
    }
    return acc;
  }, []);

  const header =
    '# Environment Variables\n# This file is automatically synchronized with Project Settings\n\n';

  const contents =
    header +
    entries
      .map(({ key, value }) => {
        if (value === undefined || value === null) {
          return `${key}=`;
        }
        if (/[ \t#"$']/u.test(value)) {
          return `${key}="${value.replace(/"/g, '\\"')}"`;
        }
        return `${key}=${value}`;
      })
      .join('\n') +
    (entries.length > 0 ? '\n' : '');

  await fs.mkdir(path.dirname(repoEnvPath), { recursive: true });
  await fs.writeFile(repoEnvPath, contents, 'utf8');

  return entries.length;
}

function parseEnvFile(contents: string): Record<string, string> {
  const result: Record<string, string> = {};