Monitor websites uptime using Cloudflare Workers
Something went wrong. Try again.
12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667#!/usr/bin/env bashset -euo pipefailroot="$(cd -- "$(dirname -- "${BASH_SOURCE[0]}")/../.." && pwd)"scratch="$(mktemp -d)"trap 'rm -r "$scratch"' EXITexport BOOTSTRAP_TEST_PROD_CONTROL="$scratch/production-control.sqlite"export BOOTSTRAP_TEST_PROD_MAIN="$scratch/production-main.sqlite"export BOOTSTRAP_TEST_CALLS="$scratch/calls"for migration in "$root/packages/cloudflare/src/control-migrations/"*.sql; do sqlite3 "$BOOTSTRAP_TEST_PROD_CONTROL" < "$migration"; donegit() { printf '%s\n' "${BOOTSTRAP_TEST_BRANCH:-codex/product-release-plan}"; }uuidgen() { printf '%s\n' '00000000-0000-4000-8000-000000000002'; }pnpm() { local database="" sql="" previous="" argument rows printf '%s\n' "$*" >> "$BOOTSTRAP_TEST_CALLS" for argument in "$@"; do [[ "$previous" != execute ]] || database="$argument" [[ "$previous" != --command ]] || sql="$argument" previous="$argument" done case "$database" in CONTROL_DB) database="$BOOTSTRAP_TEST_PROD_CONTROL" ;; PRODUCTION_IMPORTED_DB) database="$BOOTSTRAP_TEST_PROD_MAIN" ;; *) return 1 ;; esac rows="$(sqlite3 -json "$database" "$sql")" || return 1 printf '[{"success":true,"results":%s}]\n' "${rows:-[]}"}export -f git uuidgen pnpm
# Staging D1 is retired: both the default branch target and an explicit request fail before any D1 call.if "$root/scripts/bootstrap-operator-workspace.sh" --dry-run >/dev/null 2>&1; then exit 1; fiif "$root/scripts/bootstrap-operator-workspace.sh" --environment staging >/dev/null 2>&1; then exit 1; fiif "$root/scripts/bootstrap-operator-workspace.sh" --environment production >/dev/null 2>&1; then exit 1; fi[[ ! -f "$BOOTSTRAP_TEST_CALLS" ]]
sqlite3 "$BOOTSTRAP_TEST_PROD_CONTROL" <<'SQL'INSERT INTO users(did,handle,state,created_at,updated_at,last_seen_at)VALUES('did:plc:lmkzmvv6sdxntwtyxpg7fqqq','noz.am','active','2026-01-01T00:00:00.000Z','2026-01-01T00:00:00.000Z','2026-01-01T00:00:00.000Z');INSERT INTO workspaces(id,owner_did,name,state,plan,created_at,updated_at,last_seen_at)VALUES('00000000-0000-4000-8000-000000000002','did:plc:lmkzmvv6sdxntwtyxpg7fqqq','Existing workspace','active','free','2026-01-01T00:00:00.000Z','2026-01-01T00:00:00.000Z','2026-01-01T00:00:00.000Z');INSERT INTO memberships(workspace_id,did,role,created_at)VALUES('00000000-0000-4000-8000-000000000002','did:plc:lmkzmvv6sdxntwtyxpg7fqqq','owner','2026-01-01T00:00:00.000Z');INSERT INTO tenant_slots(binding_name,workspace_id,database_id,schema_version,status)VALUES('PRODUCTION_IMPORTED_DB','00000000-0000-4000-8000-000000000002','17c009df-5b56-44cc-9776-73e0f1775b0f',12,'assigned');SQLsqlite3 "$BOOTSTRAP_TEST_PROD_MAIN" <<'SQL'CREATE TABLE production_workspace_identity(id INTEGER PRIMARY KEY CHECK(id=1),workspace_id TEXT NOT NULL,database_id TEXT NOT NULL);INSERT INTO production_workspace_identity VALUES(1,'00000000-0000-4000-8000-000000000002','17c009df-5b56-44cc-9776-73e0f1775b0f');SQLexport BOOTSTRAP_TEST_BRANCH=main"$root/scripts/bootstrap-operator-workspace.sh" --environment production --dry-run >/dev/null[[ ! -f "$BOOTSTRAP_TEST_CALLS" ]]: > "$BOOTSTRAP_TEST_CALLS""$root/scripts/bootstrap-operator-workspace.sh" --environment production >/dev/null[[ "$(sqlite3 "$BOOTSTRAP_TEST_PROD_CONTROL" 'SELECT count(*) FROM workspaces')" == 1 ]][[ "$(sqlite3 "$BOOTSTRAP_TEST_PROD_CONTROL" "SELECT binding_name || ':' || status FROM tenant_slots")" == PRODUCTION_IMPORTED_DB:assigned ]][[ "$(sqlite3 "$BOOTSTRAP_TEST_PROD_MAIN" 'SELECT count(*) FROM production_workspace_identity')" == 1 ]]! grep -q 'INSERT INTO workspaces\|UPDATE tenant_slots\|workspace_metadata' "$BOOTSTRAP_TEST_CALLS"
sqlite3 "$BOOTSTRAP_TEST_PROD_CONTROL" "UPDATE tenant_slots SET workspace_id=NULL,status='available' WHERE binding_name='PRODUCTION_IMPORTED_DB';": > "$BOOTSTRAP_TEST_CALLS"if "$root/scripts/bootstrap-operator-workspace.sh" --environment production >/dev/null 2>&1; then exit 1; fi[[ "$(sqlite3 "$BOOTSTRAP_TEST_PROD_CONTROL" 'SELECT count(*) FROM workspaces')" == 1 ]][[ "$(sqlite3 "$BOOTSTRAP_TEST_PROD_CONTROL" "SELECT status FROM tenant_slots WHERE binding_name='PRODUCTION_IMPORTED_DB'")" == available ]]! grep -q 'INSERT INTO workspaces\|UPDATE tenant_slots\|workspace_metadata' "$BOOTSTRAP_TEST_CALLS"printf 'bootstrap-operator-workspace tests passed\n'