Skip to content

Open source website builder and Webflow alternative. Webstudio is an advanced visual builder that connects to any headless CMS, supports all CSS properties, and can be hosted anywhere, including with us.

6.2 KB
Raw Blame
#!/usr/bin/env bash

builder_backend_init() {
  local mode="${1:?Builder backend mode is required}"
  ROOT_DIR="${ROOT_DIR:-$(cd "$(dirname "${BASH_SOURCE[0]}")/../../.." && pwd)}"
  local backend_dir="$ROOT_DIR/apps/builder/backend"
  local compose_override="$backend_dir/compose.${mode}.yaml"
  if [ ! -f "$compose_override" ]; then
    echo "Unknown Builder backend mode: $mode" >&2
    return 1
  fi

  if [ "$mode" = "development" ]; then
    export COMPOSE_PROJECT_NAME="${COMPOSE_PROJECT_NAME:-builder}"
  else
    # Disposable modes must never share the persistent development volume.
    export COMPOSE_PROJECT_NAME="${COMPOSE_PROJECT_NAME:-builder-e2e}"
  fi

  COMPOSE_ENV=(
    --env-file "$ROOT_DIR/apps/builder/.env"
  )
  if [ -f "$ROOT_DIR/apps/builder/.env.development" ]; then
    COMPOSE_ENV+=(--env-file "$ROOT_DIR/apps/builder/.env.development")
  fi
  COMPOSE_FILES=(
    -f "$backend_dir/compose.yaml"
    -f "$compose_override"
  )
}

builder_backend_schema_fingerprint() {
  (
    cd "$ROOT_DIR"
    {
      find packages/prisma-client/prisma/migrations \
        -mindepth 1 -maxdepth 1 -type d -print
      find packages/prisma-client/prisma/migrations \
        -type f \( -name migration.sql -o -name migration.ts \) -print
      find apps/builder/backend -type f ! -name '*.test.*' -print
    } | LC_ALL=C sort | while IFS= read -r file; do
      if [ -f "$file" ]; then
        printf '%s ' "$file"
        git hash-object "$file"
      else
        printf '%s directory\n' "$file"
      fi
    done
  ) | git hash-object --stdin
}

builder_backend_init_schema_snapshot() {
  SCHEMA_SNAPSHOT="${SCHEMA_SNAPSHOT:-$ROOT_DIR/.cache/builder-e2e/schema-$(builder_backend_schema_fingerprint).sql}"
}

builder_compose() {
  docker compose "${COMPOSE_ENV[@]}" "${COMPOSE_FILES[@]}" "$@"
}

builder_backend_down() {
  builder_compose down "$@"
}

builder_backend_pull_db() {
  builder_compose pull --policy missing db
}

builder_backend_start_db() {
  builder_compose up -d db
}

builder_backend_start_postgrest() {
  builder_compose up -d postgrest
}

builder_backend_wait_for_postgrest() {
  local timeout_seconds="${1:-60}"
  local port
  port="$(builder_compose port postgrest 3000)"
  local url="http://127.0.0.1:${port##*:}/UserProduct?select=userId&limit=0"
  local timeout_at
  timeout_at="$(($(date +%s) + timeout_seconds))"

  until {
    local status
    status="$(curl -s -o /dev/null -w "%{http_code}" "$url" || true)"
    [ "$status" -ge 200 ] && [ "$status" -lt 300 ]
  }; do
    if [ "$(date +%s)" -ge "$timeout_at" ]; then
      echo "Timed out waiting for PostgREST" >&2
      return 1
    fi
    sleep 0.2
  done
}

builder_backend_wait_for_db() {
  local timeout_seconds="${1:-60}"
  local timeout_at
  timeout_at="$(($(date +%s) + timeout_seconds))"

  # Connect over TCP, not the unix socket: the postgres image's entrypoint
  # runs a temporary socket-only server (listen_addresses='') during init,
  # which lets a socket probe pass while host clients (prisma migrate,
  # postgrest) still get connection refused.
  until builder_compose exec -T db \
    sh -c 'PGPASSWORD="$POSTGRES_PASSWORD" psql -q -h 127.0.0.1 -U "$POSTGRES_USER" -d "$POSTGRES_DB" -v ON_ERROR_STOP=1 -c "SELECT 1"' \
    >/dev/null 2>&1; do
    if [ "$(date +%s)" -ge "$timeout_at" ]; then
      echo "Timed out waiting for database" >&2
      return 1
    fi
    sleep 0.2
  done
}

builder_backend_schema_exists() {
  [ "$(
    builder_compose exec -T db \
      sh -c 'PGPASSWORD="$POSTGRES_PASSWORD" psql -q -U "$POSTGRES_USER" -d "$POSTGRES_DB" -tAc "SELECT to_regclass('\''public.\"Project\"'\'') IS NOT NULL"'
  )" = "t" ]
}

builder_backend_bootstrap_schema_snapshot() {
  if [ ! -f "$SCHEMA_SNAPSHOT" ]; then
    return 1
  fi

  builder_compose exec -T db \
    sh -c 'PGPASSWORD="$POSTGRES_PASSWORD" psql -q -U "$POSTGRES_USER" -d "$POSTGRES_DB" -v ON_ERROR_STOP=1' \
    <"$SCHEMA_SNAPSHOT" >/dev/null
}

builder_backend_migrate() {
  pnpm --dir "$ROOT_DIR" --filter=@webstudio-is/prisma-client migrations migrate --dev --cwd ../../apps/builder
  if ! builder_backend_schema_exists; then
    echo "Migrations completed without creating the Builder schema" >&2
    return 1
  fi
}

builder_backend_bootstrap() {
  case "${1:-auto}" in
    schema)
      builder_backend_bootstrap_schema_snapshot
      ;;
    migrations)
      builder_backend_migrate
      ;;
    auto)
      if [ -f "$SCHEMA_SNAPSHOT" ]; then
        builder_backend_bootstrap_schema_snapshot
        echo "Bootstrapped database from cached schema $SCHEMA_SNAPSHOT"
      else
        echo "No cached schema found at $SCHEMA_SNAPSHOT; running migrations"
        builder_backend_migrate
        builder_backend_write_schema_snapshot
      fi
      ;;
    *)
      echo "Unknown database bootstrap mode: $1" >&2
      exit 1
      ;;
  esac
}

builder_backend_bootstrap_if_empty() {
  if builder_backend_schema_exists; then
    echo "Database schema already exists; skipping bootstrap"
  else
    builder_backend_bootstrap auto
  fi
}

builder_backend_write_schema_snapshot() {
  mkdir -p "$(dirname "$SCHEMA_SNAPSHOT")"
  local temporary_snapshot="${SCHEMA_SNAPSHOT}.tmp.$$"
  # Dump only the application-owned public schema so the snapshot can be
  # restored without replacing database-owned schemas.
  if builder_compose exec -T db \
    sh -c 'PGPASSWORD="$POSTGRES_PASSWORD" pg_dump -U "$POSTGRES_USER" -d "$POSTGRES_DB" --schema=public --schema-only --clean --if-exists --no-owner --no-privileges' \
    >"$temporary_snapshot"; then
    mv "$temporary_snapshot" "$SCHEMA_SNAPSHOT"
  else
    rm -f "$temporary_snapshot"
    return 1
  fi
  echo "Wrote $SCHEMA_SNAPSHOT"
}

builder_prisma_client_exists() {
  [ -f "$ROOT_DIR/packages/prisma-client/src/__generated__/index.js" ]
}

builder_generate_prisma_client() {
  case "${1:-auto}" in
    true)
      pnpm --dir "$ROOT_DIR" --filter=@webstudio-is/prisma-client generate
      ;;
    false)
      echo "Skipping Prisma client generation"
      ;;
    auto)
      if builder_prisma_client_exists; then
        echo "Skipping Prisma client generation; generated client already exists"
      else
        pnpm --dir "$ROOT_DIR" --filter=@webstudio-is/prisma-client generate
      fi
      ;;
    *)
      echo "Unknown Prisma generation mode: $1" >&2
      exit 1
      ;;
  esac
}