deped-dcp-template

deped-dcp-template is the shared runtime package for DepEd DCP data-cleaning projects. It bundles the canonical Excel collection templates, extracts their controlled lists into SQLite lookup tables, and exposes common helpers that downstream personnel, equipment, connectivity, and registry packages should reuse instead of copying locally.

The package is currently versioned as 0.7.0.

Install

Published package:

uv add deped-dcp-template

Sibling checkout during local development:

[tool.uv.sources]
deped-dcp-template = { path = "../deped-dcp-template" }

Main Commands

Build a template-derived lookup database:

uv run deped-dcp-template extract \
  --templates-dir templates \
  --output artifacts/base.db

Show a lookup summary:

uv run deped-dcp-template show --db artifacts/base.db

Upload the canonical templates to R2:

uv run deped-dcp-template r2 upload \
  --source templates \
  --prefix deped-dcp-template/templates

Profile a SQLite table:

uv run profile-table path/to/data.db table_name

What This Package Owns

• canonical v1.16 workbook templates in templates/
• lookup database extraction from the school, division, and region templates
• R2 source-artifact upload, download, and listing helpers
• Rich console, logging, status, and progress helpers
• CSV, workbook, timestamp, SQL-file, and normalization helpers
• read-only SQLite raw-source helpers for downstream loaders
• governance entity and personnel primitives with no consumer schema dependency
• the profile-table SQLite profiling CLI

Consumer repos still own operational source ingestion, domain schemas, views, promotion workflows, public table contracts, and final audit artifacts.

Documentation

• Docs index
• Architecture
• Lookup extraction
• R2 transfer
• Normalization helpers
• File and SQL helpers
• Rich logging and progress
• Dataset loaders and SQLite raw sources
• SQLite profiling
• Downstream adoption

Build the docs:

uv run zensical build

Development

uv run pytest -q
uv run zensical build

Publish, when credentials are available:

just publish