Briven/apps/studio/components/layouts/ProjectLayout/LogicalBackupCliInstructions.utils.ts

export const DB_PASSWORD_PLACEHOLDER = '[YOUR-PASSWORD]'

export function buildDirectPostgresConnectionUri(settings: {
  db_user: string
  db_host: string
  db_port: number
  db_name: string
}): string {
  return `postgresql://${settings.db_user}:${DB_PASSWORD_PLACEHOLDER}@${settings.db_host}:${settings.db_port}/${settings.db_name}`
}

export function buildLogicalBackupShellScript(connectionUri: string): string {
  return [
    `npx briven db dump --db-url '${connectionUri}' -f roles.sql --role-only`,
    `npx briven db dump --db-url '${connectionUri}' -f schema.sql`,
    `npx briven db dump --db-url '${connectionUri}' -f data.sql --use-copy --data-only -x "storage.buckets_vectors" -x "storage.vector_indexes"`,
  ].join('\n')
}