Files
oci-deal-accelerator/Makefile
root 874d40d38a Improve SKU catalog hygiene and BOM accuracy
- refresh_sku_catalog.py: add --discover to report API SKUs missing from
  catalog, filtered to already-curated serviceCategory values. Auto-runs
  at end of --validate and --refresh so gaps surface on every maintenance
  pass. First run found 162 missing SKUs (Blackwell GPUs, X12 Ax compute,
  VMware reserved tiers, WebLogic-on-OKE, Analytics/OIC BYOL).
- oci_bom_gen.py: fix Cost % column being blank. Back-fill was gated on
  formula detection but data rows write raw numbers, so the predicate
  never matched. Now tracks data_item_rows explicitly.
- .gitea/workflows/sku-catalog-refresh.yaml: monthly automation (1st at
  09:00 UTC). Auto-refresh prices → push branch + open PR; detect new
  SKUs → open issue with labels. Gated on secrets.GITEA_TOKEN.
- kb/pricing/oci-sku-catalog.yaml: add B95714 / B95715 (Autonomous ATP
  Dedicated ECPU, LI + BYOL) — canonical SKUs for ADB-D pricing.
- kb/services/compute.yaml: add X12 family (VM.Standard4.Ax.Flex,
  BM.Standard4.Ax.120), E6.Ax and A4.Ax variants. Verified against
  docs.oracle.com computeshapes.htm. Bump last_verified + changelog.
- templates/bom-spec.yaml: document 730 hrs/month convention as default
  (= real annual billing / 12; 744 overstates by 1.92% on 12-month TCO).
- Makefile: new 'make sku-discover' target.

Co-Authored-By: Claude Opus 4.7 (1M context) <noreply@anthropic.com>
2026-04-24 11:40:53 -03:00

103 lines
4.0 KiB
Makefile

# OCI Deal Accelerator — Build Automation
.PHONY: help install test validate example diagram deck full clean lint codex-package update-icons freshness freshness-refresh sync-skill sku-discover
# Use venv if present, otherwise find best available python3
ifneq (,$(wildcard .venv/bin/python))
PYTHON ?= .venv/bin/python
else ifneq (,$(shell command -v python3.12 2>/dev/null))
PYTHON ?= python3.12
else
PYTHON ?= python3
endif
SPEC_DIR = examples
OUTPUT_DIR = examples/sample-output
help: ## Show this help
@grep -E '^[a-zA-Z_-]+:.*?## .*$$' $(MAKEFILE_LIST) | sort | \
awk 'BEGIN {FS = ":.*?## "}; {printf "\033[36m%-20s\033[0m %s\n", $$1, $$2}'
VENV_PYTHON := $(shell command -v python3.12 2>/dev/null || command -v python3.11 2>/dev/null || command -v python3.10 2>/dev/null || echo python3)
venv: ## Create virtual environment and install dependencies
@echo "Using $(VENV_PYTHON) to create venv..."
$(VENV_PYTHON) -m venv .venv
.venv/bin/pip install --upgrade pip
.venv/bin/pip install -r requirements.txt
@echo "Virtual environment ready. Run: source .venv/bin/activate"
install: ## Install Python dependencies (system-wide)
pip install -r requirements.txt
validate: ## Validate imports and configs
$(PYTHON) -c "from tools.oci_diagram_gen import OCIDiagramGenerator; print('Diagram Generator OK')"
$(PYTHON) -c "from tools.oci_deck_gen import OCIDeckGenerator; print('Deck Generator OK')"
$(PYTHON) -c "import yaml; yaml.safe_load(open('config/workload-profile-schema.yaml')); print('Schema OK')"
$(PYTHON) -c "import yaml; yaml.safe_load(open('config/service-categories.yaml')); print('Categories OK')"
@echo "All validations passed"
example: ## Generate sample architecture diagram (.drawio)
@mkdir -p $(OUTPUT_DIR)
$(PYTHON) tools/oci_diagram_gen.py \
--spec $(SPEC_DIR)/migration-adb-ha-dr.yaml \
--output $(OUTPUT_DIR)/architecture.drawio
@echo "Generated $(OUTPUT_DIR)/architecture.drawio"
diagram: example ## Alias for example
deck: ## Generate sample proposal deck (.pptx)
@mkdir -p $(OUTPUT_DIR)
$(PYTHON) tools/oci_deck_gen.py \
--spec $(SPEC_DIR)/migration-adb-ha-dr.yaml \
--output $(OUTPUT_DIR)/architecture-proposal.pptx
@echo "Generated $(OUTPUT_DIR)/architecture-proposal.pptx"
full: ## Generate all outputs via orchestrator
$(PYTHON) tools/oci_output.py \
--spec $(SPEC_DIR)/migration-adb-ha-dr.yaml \
--output-dir $(OUTPUT_DIR) \
--format full
@echo "Generated all outputs in $(OUTPUT_DIR)/"
codex-package: ## Package as Codex skill
@mkdir -p codex/tools
cp tools/oci_diagram_gen.py codex/tools/
cp tools/oci_deck_gen.py codex/tools/
cp tools/oci_output.py codex/tools/
cp -r kb codex/
cp -r config codex/
@echo "Codex skill package ready in codex/"
update-icons: ## Re-extract OCI icons after updating OCI Library.xml
$(PYTHON) tools/oci_icon_extractor.py
@echo "Updated kb/diagram/oci-icons.json from OCI Library.xml"
clean: ## Remove generated output files
rm -f examples/sample-output/*.drawio
rm -f examples/sample-output/*.pptx
rm -f examples/sample-output/*.xlsx
rm -f examples/sample-output/*.docx
lint: ## Check YAML files for syntax errors and validate SKILL.md sync
@echo "Checking YAML files..."
@find kb/ config/ examples/ -name '*.yaml' -exec $(PYTHON) -c \
"import yaml, sys; list(yaml.safe_load_all(open(sys.argv[1])))" {} \; \
-print 2>&1 | grep -v "^$$" || echo "All YAML files valid."
@echo "Checking SKILL.md sync..."
@$(PYTHON) scripts/sync-skill.py --check
sync-skill: ## Regenerate .agents/skills/oci-deal-accelerator/SKILL.md from root SKILL.md
@$(PYTHON) scripts/sync-skill.py
freshness: ## Report stale KB files (informational, never fails)
-@$(PYTHON) tools/kb_freshness.py --check
kb-check: ## KB freshness JSON (used by skill welcome-flow pre-flight)
@$(PYTHON) tools/kb_freshness.py --check --json
freshness-refresh: ## Run refresh tools for stale KB files that support automation
@$(PYTHON) tools/kb_freshness.py --auto-refresh
sku-discover: ## Report SKUs present in Oracle API but missing from oci-sku-catalog.yaml
@$(PYTHON) tools/refresh_sku_catalog.py --discover