Triangle CMS (Delta)

Headless CMS replacement for The Triangle, with:

• server/ Go API
• frontend/ React frontend
• observability/ Loki + Promtail + Grafana
• scripts/ local setup helpers

API docs and data models: https://github.com/DrexelTriangle/triangle-cms/wiki

Prerequisites

• Python 3.10+
• Git
• Docker + Docker Compose
• Go 1.24+
• Node.js 20+ + npm

First-Time Setup (Recommended)

Create a triangle directory first, then clone triangle-cms into it (triangle-cms contains the setup script):

mkdir triangle
cd triangle
git clone https://github.com/DrexelTriangle/triangle-cms.git
cd triangle-cms

Then run:

python ./scripts/first_time_setup.py

When run from inside triangle/triangle-cms, this installs dependencies for the current checkout and clones:

• wordpress-etl
• Scalene as sibling directories inside triangle/.

If you want a custom location, set --target-dir explicitly.

This prepares and installs dependencies for:

• triangle-cms
• wordpress-etl
• Scalene

Optional flags:

• --pull to update already-cloned repos (git pull --ff-only)
• --skip-embeddings to skip sentence-transformers install in wordpress-etl

First Local Run

0. Create Docker env vars for required secrets:

cp .env.example .env

Update .env with strong values before running Compose.

1. Generate ETL SQL in wordpress-etl:

cd ../wordpress-etl
.venv/bin/python main.py

Windows PowerShell:

cd ../wordpress-etl
.venv/Scripts/python.exe main.py

For embeddings SQL:

cd ../wordpress-etl
.venv/bin/python main.py --generate-embeddings

2. Copy ETL SQL into CMS bootstrap files:

cd ../triangle-cms
python ./scripts/generate_wordpress_sql.py

3. Start services (Path A is recommended):

Path A (recommended): full Docker stack (CMS + observability):

python ./scripts/setup_containers.py

This stack uses a shared Docker bridge network scoped to the Compose project, so services can resolve each other by container/service name (for example mariadb, loki, grafana).

Path B: Docker MariaDB + local Go backend:

docker compose up -d mariadb

Then run backend locally:

cd server
go run ./main.go

4. Verify API (works with either path):

curl -k https://localhost:8080/v1/articles/christmas

5. Run the Triangle CMS frontend dashboard:

cd frontend
npm run dev -- --port 5173

Frontend dashboard: http://localhost:5173

6. Run Scalene frontend:

cd ../Scalene
npm run dev -- --port 4321

Scalene: http://localhost:4321

Common Tasks

Reset DB + logs (fresh install):

python ./scripts/setup_containers.py --reset-data

Run backend locally (instead of Docker cms service):

docker compose stop cms
cd server
go run ./main.go

If running backend locally against Docker MariaDB, create server/.env:

DB_NAME=triangle
DB_USER=triangle_user
DB_PASSWORD=triangle_password
DB_HOST=127.0.0.1
DB_PORT=3306

Run Triangle CMS frontend dashboard:

cd frontend
npm run dev -- --port 5173

Frontend dashboard: http://localhost:5173

Note

If you want Scalene to use your local CMS instead of our production WordPress you need to be on the CMS-Testing branch

Use git switch CMS-Testing to switch

Run Scalene:

cd ../Scalene
npm run dev -- --port 4321

Scalene: http://localhost:4321

ETL SQL Script (Advanced)

Default usage:

python ./scripts/generate_wordpress_sql.py

Optional override usage:

python ./scripts/generate_wordpress_sql.py [source_sql_dir] [output_dir]

Environment variable overrides:

WP_ETL_SQL_DIR=../wordpress-etl/logs/sql WP_ETL_OUT_DIR=server/internal/database/wordpress_etl python ./scripts/generate_wordpress_sql.py

Generated files:

• 01-authors.sql
• 02-articles.sql
• 03-articles-authors.sql
• 04-seo.sql
• 05-article-embeddings.sql (real file when available, placeholder otherwise)
• 06-taxonomy.sql

Testing

cd server
go test ./...

Coverage:

cd server
go test -coverprofile=cover.out ./...