Postkantoor project

C# 64.8%
Python 30.1%
Dockerfile 5.1%

Find a file

Cillus den Brok 9f9c59caeb Some checks failed Build, push and deploy / build-and-push (push) Has been cancelled Details Build, push and deploy / deploy (push) Has been cancelled Details docs: csv-processor werking, health check en beheerstappen gedocumenteerd Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>		2026-06-03 07:37:15 +00:00
.github/workflows	Add complete scaffold: SFTP, CSV processor, Postgres, OData, k8s manifests, CI and docs	2026-05-30 14:26:26 +02:00
csv-processor	fix: csv-processor poll thread bewaken via health endpoint	2026-06-03 07:36:12 +00:00
deploy	feat: voeg /auth/token/ endpoint toe voor JWT token uitgifte	2026-06-03 07:29:17 +00:00
docs	docs: csv-processor werking, health check en beheerstappen gedocumenteerd	2026-06-03 07:37:15 +00:00
odata-service	feat: voeg /auth/token/ endpoint toe voor JWT token uitgifte	2026-06-03 07:29:17 +00:00
sql	Add complete scaffold: SFTP, CSV processor, Postgres, OData, k8s manifests, CI and docs	2026-05-30 14:26:26 +02:00
.gitignore	Add complete scaffold: SFTP, CSV processor, Postgres, OData, k8s manifests, CI and docs	2026-05-30 14:26:26 +02:00
2d26a3311bda7df21ee1d4e24bf77122b96b3a87	Initial scaffold: SFTP, CSV processor, Postgres, OData, k8s manifests, CI and docs	2026-05-30 14:12:54 +02:00
README.md	docs: volledige documentatie bijgewerkt en JWT_SECRET fix	2026-06-02 10:07:35 +00:00

README.md

postkantoor

SFTP → CSV → PostgreSQL → OData API pipeline, draaiend op Kubernetes (k3s).

Externe partijen uploaden CSV-bestanden via SFTP. De csv-processor pikt ze automatisch op, slaat ze als batches + records op in PostgreSQL, en de OData-service stelt de data beschikbaar via een JWT-beveiligde OData v4 API.

Componenten

Component	Technologie	Poort
SFTP server	atmoz/sftp	30022 (NodePort)
CSV verwerker	Python FastAPI	8000 (intern)
Database	PostgreSQL 15	5432 (intern)
OData API	ASP.NET Core 8 + OData v4	80 (via ingress)

Publieke URL: http://postkantoor.pocfactory.nl/odata/

Documentatie

Volledige Nederlandstalige documentatie — installeren, testen, JWT tokens, OData queries
Kubernetes deployment — manifests, secrets, rollout

Snelle start

# CSV uploaden
sftp -P 30022 foo@178.104.227.79
# wachtwoord: password

# OData bevragen (na JWT token genereren, zie docs/README_nl.md)
curl -H "Authorization: Bearer <TOKEN>" http://postkantoor.pocfactory.nl/odata/Batches

Namespace

Alle Kubernetes resources zitten in namespace sftp-ingest.