Athena — roomy-mobile/archive/changes/2026-01-05-add-roomy-firestore-mcp/tasks/005-firestore-crud-layer.md

Productdocumentatie

README.md md

analyticslibrary-sql-reference.md md

api.md md

architecture.md md

auditfile-nu-research.md md

bdd-coverage-audit.md md

data-audit-engine-requirements-source.md md

data-leakage-audit.md md

erp-integration-exact-afas-research.md md

feature-toggle-and-user-management-proposal.md md

fiba-design-review.md md

hosting-security-research.md md

kb

README.md md

README.nl.md md

audit-process-overview.md md

audit-process-overview.nl.md md

cash-audit-procedures.md md

cash-audit-procedures.nl.md md

erp-data-and-xaf-standards.md md

erp-data-and-xaf-standards.nl.md md

journal-entry-testing-and-fraud-detection.md md

journal-entry-testing-and-fraud-detection.nl.md md

vat-btw-reconciliation-procedures.md md

vat-btw-reconciliation-procedures.nl.md md

liquide-middelen-audit-research.md md

research-dutch-audit-standards.md md

research-iban-naam-check.md md

research-kvk-sbi-codes.md md

roadmap.md md

scope.md md

setup.md md

sra-research.md md

srs.md md

vision.md md

xas2027-srs-reconciliation.md md

Trainingsdata

Document1.docx docx

audit_training_liquide_middelen_01_auditfile_grootboek_bankmutaties.csv csv

audit_training_liquide_middelen_02_voorbeeld_auditfile_XAF.xml xml

audit_training_liquide_middelen_03_saldibalans_voorbeeld.xlsx xlsx

audit_training_liquide_middelen_04_bankafschrift_rabobank_2025-12.pdf pdf

audit_training_liquide_middelen_05_bankafschrift_ing_2025-12_en_2026-01.pdf pdf

audit_training_liquide_middelen_06_standaard_bankverklaring_voorbeeld.docx docx

audit_training_liquide_middelen_07_bankreconciliatie_met_afwijking.xlsx xlsx

audit_training_liquide_middelen_08_debiteurenontvangsten_lapping_scenario.csv csv

audit_training_liquide_middelen_09_verwachte_controlebevindingen.json json

audit_training_liquide_middelen_10_data_dictionary.json json

audit_training_liquide_middelen_README.md md

audit_training_liquide_middelen_manifest_checksums.json json

demo_xaf_bruisfrisco.xml xml

Werkruimtedocumentatie

README.md md

audit-2026-05-18.md md

auditPic

README.md md

api.md md

architecture.md md

auditPic/business

business-plan.md md

auditPic/compliance

README.md md

bio.md md

dpia.md md

nis2.md md

auditPic/compliance/processes

data-flow.md md

auditPic/compliance

risk-assessment.md md

verwerkingsregister.md md

auditPic

deployment.md md

disaster-recovery.md md

incident-response.md md

auditPic/planning

session-handoff-2026-05-18.md md

auditPic

privacy-training.md md

setup.md md

verification-protocol.md md

ci-cd-reference.md md

claimio

architecture.md md

claimio/compliance

bcdr.md md

bio.md md

dpia.md md

nis2.md md

claimio/compliance/processes

dpa-agreements.md md

incident-handling.md md

claimio/compliance

verwerkingsregister.md md

claimio

deployment.md md

setup.md md

claude-github-app-setup.md md

definition-of-done.md md

design

brand-identities.md md

developer-portal

README.md md

architecture.md md

developer-portal/planning

roadmap.md md

dod-compliance.md md

europeLogin

README.md md

api.md md

architecture.md md

europeLogin/compliance

README.md md

bio.md md

dpia.md md

nis2.md md

europeLogin/compliance/processes

data-flow.md md

europeLogin/compliance

risk-assessment.md md

verwerkingsregister.md md

europeLogin/decisions

ADR-001-test-infrastructure.md md

ADR-002-audit-actor-attribution.md md

ADR-003-db-least-privilege.md md

europeLogin

deployment.md md

manual-setup-checklist.md md

europeLogin/planning

p0-p2-remediation-status.md md

europeLogin

setup.md md

human-actions.md md

interimplaza-audit-2026-07-24.md md

mahmoud-consultancy

README.md md

api.md md

architecture.md md

mahmoud-consultancy/archive/old-docs

ACTION_ITEMS_REVIEW.md md

API_SPECIFICATION.md md

AUTONOMOUS_IMPROVEMENTS_OCT10_2025.md md

AUTONOMOUS_SESSION_COMPLETE_REPORT.md md

AUTONOMOUS_SESSION_SUMMARY.md md

AUTONOMOUS_SESSION_SUMMARY_OCT10_2025.md md

AUTONOMOUS_TEST_IMPROVEMENTS_OCT10_2025.md md

AUTO_RUNNER_COMPLETE.md md

CLAUDE-DESKTOP-SETUP.md md

COMPLETE_STATUS_OCT11_EVENING.md md

COMPLETE_WORK_SUMMARY_OCT16.md md

COMPLETION_PLAN_OCT10_2025.md md

CONTINUOUS_IMPROVEMENTS_OCT9_EVENING.md md

CONTINUOUS_IMPROVEMENTS_OCT9_FINAL.md md

CONTINUOUS_IMPROVEMENT_SESSION.md md

CONTINUOUS_IMPROVEMENT_SESSION_OCT10_2025.md md

CONTINUOUS_IMPROVEMENT_SESSION_OCT10_CONTINUED.md md

CONTINUOUS_IMPROVEMENT_SESSION_OCT10_EVENING.md md

CONTINUOUS_IMPROVEMENT_SESSION_OCT10_FINAL.md md

CONTINUOUS_IMPROVEMENT_SESSION_OCT10_MAPPERS.md md

CONTINUOUS_IMPROVEMENT_SESSION_OCT9.md md

CONTINUOUS_IMPROVEMENT_SESSION_OCT9_2025.md md

CONTINUOUS_IMPROVEMENT_SESSION_OCT9_EVENING.md md

CV_BUILDER_FEATURE_PLAN.md md

CV_BUILDER_SESSION_NOTE.md md

CV_FEATURE_STATUS.md md

DEFINITION_OF_DONE.md md

DEPLOYMENT_GUIDE.md md

DOCKER-CLAUDE.md md

DOD_VERIFICATION_REPORT.md md

EXECUTION_PLAN.md md

FEATURE_COMPARISON.md md

FINAL_SESSION_SUMMARY.md md

FINAL_STATUS_OCT11.md md

FOLDER_ANALYSIS.md md

GITHUB_SECRETS_SETUP.md md

GITHUB_SECRETS_VALUES.md md

GLORYLABS_FINAL_REPORT.md md

GLORYLABS_QUICK_START.md md

GLORYLABS_WEBSITE_ASSESSMENT.md md

GLORYLABS_WEBSITE_COMPLETE.md md

GLORYLABS_WEBSITE_SESSION_PLAN.md md

GLORYLABS_WORK_COMPLETED.md md

IMPROVEMENTS_OCT10_BACKEND_TESTS.md md

IMPROVEMENTS_OCT10_TEST_COVERAGE.md md

IMPROVEMENTS_SESSION_OCT9_CONTINUED.md md

IMPROVEMENTS_SUMMARY.md md

INDEX.md md

K8S_LOCAL_QUICKSTART.md md

LOCAL_STARTUP_GUIDE.md md

MAVEN_FIX_SUMMARY.md md

MOBILE_TESTING_REPORT.md md

NEXT_WORK_PLAN.md md

PERFORMANCE_OPTIMIZATION_SESSION_OCT10_2025.md md

PROJECT_STATUS_OCT10_2025.md md

PROJECT_STATUS_OCTOBER_9_2025.md md

PROJECT_STATUS_UPDATE.md md

QUICK_ACTIONS_CONTINUOUS_IMPROVEMENT.md md

QUICK_ACTIONS_OCT9.md md

QUICK_IMPROVEMENTS_OCT9.md md

QUICK_START.md md

QUICK_START_IMPROVEMENTS.md md

QUICK_SUMMARY_AUTONOMOUS_SESSION_OCT10.md md

QUICK_SUMMARY_OCT10_CONTINUOUS.md md

QUICK_SUMMARY_OCT9_EVENING.md md

QUICK_WINS_OCT10_CONTINUED.md md

QUICK_WINS_OCT10_MAPPERS.md md

QUICK_WINS_SUMMARY_OCT9.md md

RAPID_COMPLETION_PLAN.md md

README.md md

REMAINING_SESSIONS_PLAN.md md

SECURITY_IMPROVEMENTS_OCT10_2025.md md

SECURITY_TESTING_QUICK_REFERENCE.md md

SECURITY_TEST_IMPLEMENTATION_REPORT.md md

SENTIOR_ALL_87_SOURCES_COMPLETE.md md

SENTIOR_ALL_SOURCES_LIST.md md

SENTIOR_COMPLETE_87_SOURCES.json json

SENTIOR_COMPLETE_87_SOURCES.md md

SENTIOR_CRAWLING_SOURCES_PLAN.md md

SENTIOR_SOURCES_COMPLETE_LIST.md md

SENTIOR_SOURCES_STATUS.md md

SESSION1_PROMPT.md md

SESSIONS_1_TO_9_COMPLETE.md md

SESSION_2025-10-14_ANGULAR_FORMS_FIX_FINAL.md md

SESSION_2025-10-14_HIGH_PRIORITY_COMPLETION.md md

SESSION_2025-10-14_HIGH_PRIORITY_FIXES.md md

SESSION_2025-10-14_IT_CLEANUP.md md

SESSION_OCT17_SUMMARY.md md

SESSION_PLAN.md md

SESSION_PROGRESS_SUMMARY.md md

SESSION_RUNNER_README.md md

SESSION_SETUP_COMPLETE.md md

SESSION_SUMMARY.md md

SESSION_SUMMARY_OCT10.md md

SESSION_SUMMARY_OCT10_IMPROVEMENTS.md md

SESSION_SUMMARY_OCT11.md md

SESSION_SUMMARY_OCT11_EVENING.md md

SPRINT1_COMPLETE_SUMMARY.md md

SPRINT1_COMPLETION_REPORT.md md

SPRINT1_COMPLETION_REPORT_OCT9_2025.md md

SPRINT_COMPLETION_STATUS.md md

SPRINT_PROGRESS_OCT10_2025_EVENING.md md

SPRINT_PROGRESS_OCT11_2025.md md

START_HERE.md md

STATUS_UPDATE_OCT17_2025.md md

STRIIVE_ANALYSIS.md md

TEST_FIXES_SUMMARY.md md

TEST_STATUS_RAPPORT.md md

WORKTREE_QUICKSTART.md md

WORKTREE_SETUP_COMPLETE.md md

WORKTREE_STRATEGY.md md

WORK_COMPLETED_OCT15_2025.md md

mahmoud-consultancy/archive/old-docs/implementation

API_DOCUMENTATION.md md

FRONTEND_IMPLEMENTATION_GUIDE.md md

IMPLEMENTATION_STATUS_OCT15_2025.md md

KB_CONTENT_WRITING_GUIDE.md md

mahmoud-consultancy/archive/old-docs/setup

DEFINITION_OF_DONE.md md

DEPLOYMENT_GUIDE_PRODUCTION_CHECKLIST.md md

DEVELOPMENT_SETUP.md md

FLEXTENDER_SCRAPER_SETUP.md md

TESTING_STRATEGY_QA_CHECKLIST.md md

mahmoud-consultancy/archive/old-docs/sprints

ROADMAP.md md

SPRINT4_DETAILED_EXECUTION_PLAN.md md

SPRINT4_UI_IMPROVEMENTS.md md

SPRINT5_DETAILED_EXECUTION_PLAN.md md

SPRINT5_KNOWLEDGE_BASE_PLAN.md md

START_HERE.md md

mahmoud-consultancy/archive/sessions

ANGULAR_FORMS_FIX_REPORT.md md

APPLICATION_TESTING_REPORT_OCT17.md md

DEFINITION_OF_DONE_OCT31.md md

E2E_TESTING_REPORT_OCT19.md md

INTERIMPLAZA_SESSION_REPORT_OCT24.md md

NEXT_SESSION_PROMPT.md md

NEXT_SESSION_PROMPT_NOV1.md md

PDF_GENERATION_FIX_COMPLETE_OCT20.md md

PDF_GENERATOR_BUG_FIX_REPORT_OCT20.md md

PROJECT_STATUS_OCT20.md md

SESSION_2025-10-31_TEST_FIXES_COMPLETE.md md

SESSION_2025-11-01_E2E_TESTING.md md

SESSION_2025-11-02_K8S_DEPLOYMENT.md md

SESSION_2025-11-03_K8S_SUCCESS.md md

SESSION_2025-11-07_FEATURE_TOGGLE.md md

SESSION_COMPLETE_OCT20.md md

SESSION_COMPLETE_OCT31_SUMMARY.md md

SESSION_SUMMARY_OCT24.md md

readme.md md

mahmoud-consultancy/business

business-plan-nl.md md

business-plan.md md

market-landscape-2026-08.md md

sna-keurmerk.md md

mahmoud-consultancy/compliance

README.md md

bio.md md

dpia.md md

nis2.md md

mahmoud-consultancy/compliance/processes

data-flow.md md

mahmoud-consultancy/compliance

risk-assessment.md md

verwerkingsregister.md md

mahmoud-consultancy

deployment.md md

disaster-recovery.md md

mahmoud-consultancy/features

ai-rewriting.md md

job-scraping.md md

timetracking.md md

mahmoud-consultancy

frontend-setup.md md

mahmoud-consultancy/planning

backlog.md md

final-summary.md md

roadmap-nl.md md

sprint-plan.md md

vacancy-content-features-scoping-2026-08.md md

mahmoud-consultancy/requirements

requirements-moscow.md md

requirements.md md

mahmoud-consultancy

requirements.md md

setup.md md

mvp-readiness.md md

ops

analytics-posthog-plan.md md

ops/archive

openclaw-headless-laptop2-proposal.md md

ops

ci-alternatives-proposal.md md

claude-usage-tracking.md md

cluster.md md

dedicated-ci-runner-laptop2-runbook.md md

infra-cost-research.md md

interimplaza-rename-plan.md md

node-capacity-guardrail-proposal.md md

swarm-improvements-proposal.md md

owner-messages.md md

roomy-mobile

README.md md

architecture.md md

roomy-mobile/archive/changes/2025-12-24-add-maestro-screenshot-automation

design.md md

proposal.md md

roomy-mobile/archive/changes/2025-12-24-add-maestro-screenshot-automation/specs/screenshot-automation

spec.md md

roomy-mobile/archive/changes/2025-12-24-add-maestro-screenshot-automation

tasks.md md

roomy-mobile/archive/changes/2025-12-24-add-missing-screenshot-screens

proposal.md md

roomy-mobile/archive/changes/2025-12-24-add-missing-screenshot-screens/specs/screenshot-automation

spec.md md

roomy-mobile/archive/changes/2025-12-24-add-missing-screenshot-screens

tasks.md md

roomy-mobile/archive/changes/2025-12-24-fix-auth-flow-idempotency

proposal.md md

roomy-mobile/archive/changes/2025-12-24-fix-auth-flow-idempotency/specs/screenshot-automation

spec.md md

roomy-mobile/archive/changes/2025-12-24-fix-auth-flow-idempotency

tasks.md md

roomy-mobile/archive/changes/2025-12-24-fix-maestro-settings-selector

proposal.md md

roomy-mobile/archive/changes/2025-12-24-fix-maestro-settings-selector/specs/screenshot-automation

spec.md md

roomy-mobile/archive/changes/2025-12-24-fix-maestro-settings-selector

tasks.md md

roomy-mobile/archive/changes/2025-12-24-fix-seed-avatar-urls

proposal.md md

roomy-mobile/archive/changes/2025-12-24-fix-seed-avatar-urls/specs/screenshot-automation

spec.md md

roomy-mobile/archive/changes/2025-12-24-fix-seed-avatar-urls

tasks.md md

roomy-mobile/archive/changes/2025-12-28-fix-home-expense-widget-reactivity

proposal.md md

roomy-mobile/archive/changes/2025-12-28-fix-home-expense-widget-reactivity/specs/home-expenses

spec.md md

roomy-mobile/archive/changes/2025-12-28-fix-home-expense-widget-reactivity/tasks

001-add-viewmodel-state.md md

002-update-view-widget.md md

003-verify-and-test.md md

roomy-mobile/archive/changes/2025-12-28-fix-runtime-locale-switching

design.md md

proposal.md md

roomy-mobile/archive/changes/2025-12-28-fix-runtime-locale-switching/tasks

001-delete-stale-files.md md

002-migrate-enums.md md

003-migrate-services.md md

004-migrate-dtos.md md

roomy-mobile/archive/changes/2026-01-05-add-per-screen-maestro-flows

design.md md

proposal.md md

roomy-mobile/archive/changes/2026-01-05-add-per-screen-maestro-flows/specs/maestro-screenshot-automation

spec.md md

roomy-mobile/archive/changes/2026-01-05-add-per-screen-maestro-flows/tasks

001-setup-infrastructure.md md

002-create-utility-flows.md md

003-add-semantic-identifiers.md md

004-create-auth-flows.md md

005-create-home-flows.md md

006-create-cleaning-flows.md md

007-create-shopping-flows.md md

008-create-payments-flows.md md

009-create-settings-misc-flows.md md

010-create-orchestration-flows.md md

011-create-agent-documentation.md md

012-review-changes.md md

013-validate-behavior.md md

roomy-mobile/archive/changes/2026-01-05-add-roomy-firestore-mcp

design.md md

proposal.md md

roomy-mobile/archive/changes/2026-01-05-add-roomy-firestore-mcp/specs/firestore-mcp

spec.md md

roomy-mobile/archive/changes/2026-01-05-add-roomy-firestore-mcp/tasks

001-package-skeleton.md md

002-project-config-firebase-admin.md md

003-datamodel-registry.md md

004-timestamps-zod-schemas.md md

005-firestore-crud-layer.md md

006-register-crud-tools.md md

007-mcp-wiring-validation.md md

roomy-mobile/archive/changes/2026-01-05-fix-notification-permissions

proposal.md md

request.md md

roomy-mobile/archive/changes/2026-01-05-fix-notification-permissions/specs/notification-preferences

spec.md md

roomy-mobile/archive/changes/2026-01-05-fix-notification-permissions/tasks

001-add-permission-handler.md md

002-update-preferences-dto.md md

003-implement-permission-sync.md md

004-create-analytics.md md

005-create-consent-widgets.md md

006-integrate-banner-home.md md

007-update-settings-view.md md

008-review-implementation.md md

009-test-permission-flow.md md

roomy-mobile/archive/changes/2026-01-05-implement-notifications

design.md md

proposal.md md

request.md md

roomy-mobile/archive/changes/2026-01-05-implement-notifications/specs/notification-preferences

spec.md md

roomy-mobile/archive/changes/2026-01-05-implement-notifications/specs/notifications

spec.md md

roomy-mobile/archive/changes/2026-01-05-implement-notifications/tasks

001-configure-fcm-infrastructure.md md

002-implement-fcm-token-service.md md

003-implement-notification-cloud-functions.md md

004-implement-notification-service.md md

005-implement-push-notification-handler.md md

006-implement-notification-preferences.md md

007-enhance-inbox-ui.md md

008-review-implementation.md md

009-test-notification-flow.md md

roomy-mobile

changelog.md md

roomy-mobile/compliance

README.md md

bio.md md

dpia.md md

nis2.md md

roomy-mobile/compliance/processes

data-flow.md md

roomy-mobile/compliance

risk-assessment.md md

verwerkingsregister.md md

roomy-mobile/decisions/decisions

20251213-1411-environment.md md

20251218-1145-fix-approach.md md

20260517-1530-ios-notification-permission-macro.md md

roomy-mobile

deployment.md md

roomy-mobile/features/archive/2025-12-24-add-maestro-screenshot-automation

proposal.md md

roomy-mobile/features/archive/2025-12-24-add-missing-screenshot-screens

proposal.md md

roomy-mobile/features/archive/2025-12-24-fix-auth-flow-idempotency

proposal.md md

roomy-mobile/features/archive/2025-12-24-fix-maestro-settings-selector

proposal.md md

roomy-mobile/features/archive/2025-12-24-fix-seed-avatar-urls

proposal.md md

roomy-mobile/features/archive/2025-12-28-fix-home-expense-widget-reactivity

proposal.md md

roomy-mobile/features/archive/2025-12-28-fix-runtime-locale-switching

proposal.md md

roomy-mobile/features/archive/2026-01-05-add-per-screen-maestro-flows

proposal.md md

roomy-mobile/features/archive/2026-01-05-add-roomy-firestore-mcp

proposal.md md

roomy-mobile/features/archive/2026-01-05-fix-notification-permissions

proposal.md md

roomy-mobile/features/archive/2026-01-05-implement-notifications

proposal.md md

roomy-mobile

session-handoff-2026-05-18.md md

setup.md md

runbooks

codemagic-auditpic-testflight-external-gate.md md

codemagic-new-app-on-roomy-team.md md

node-reboot-pv-recovery.md md

staging-capacity-plan.md md

valideerleeftijd

README.md md

architecture.md md

business-plan.md md

valideerleeftijd/compliance

README.md md

bio.md md

dpia.md md

nis2.md md

valideerleeftijd/compliance/processes

data-flow.md md

valideerleeftijd/compliance

risk-assessment.md md

verwerkingsregister.md md

valideerleeftijd/decisions

ADR-001-eudi-wallet-priority.md md

valideerleeftijd

deployment.md md

Datadump

README.md md

sample_balans_snapshot.json json

sample_grootboek_export.csv csv

status: done

Task: Firestore CRUD helpers

End Goal

A CRUD layer with single-doc operations that MCP tools will call.

Currently

Firestore env works, datamodel entities exist, serialization works.

Should

Build entity collection paths from templates
Single doc operations: list, get, create, update, delete, upsert
Handle doc ID generation and timestamp fields

Constraints

[ ] Throw if doc exists on create
[ ] Throw if doc missing on update (unless upsert)
[ ] Auto-ensure createdAt/updatedAt on creates
[ ] Auto-ensure updatedAt on updates

Acceptance Criteria

[ ] CRUD functions compile and behave correctly with emulator
[ ] createDoc throws if document already exists
[ ] updateDoc throws if document missing (without upsert)
[ ] deleteDoc returns { id, deleted: false } if doc missing

Implementation Checklist

[x] 5.1 Create src/firestore/crud.ts
[x] 5.2 Implement buildEntityCollectionPath(entity, pathParams)
[x] 5.3 Implement buildEntityDocRef({ firestore, entity, pathParams, id })
[x] 5.4 Implement listDocs({ firestore, entity, pathParams, limit? }) → array of docs
[x] 5.5 Implement getDoc({ firestore, entity, pathParams, id }) → doc or null
[x] 5.6 Implement createDoc({ firestore, entity, pathParams, id?, data })
[x] 5.7 Write payload including id: ref.id and { [docIdParamName]: ref.id } if different
[x] 5.8 Implement updateDoc({ firestore, entity, pathParams, id, data })
[x] 5.9 Implement deleteDoc({ firestore, entity, pathParams, id }) → { id, deleted }
[x] 5.10 Implement upsertDoc({ firestore, entity, pathParams, id, data, merge? })
[x] 5.11 Ensure createdAt on new docs, updatedAt always

Notes

Use fromJsonSafeToFirestore before writing
Use toJsonSafe after reading
Default merge: true for upsert

Reacties

Nog geen reacties