ksfraser/ksf-modules-dao

Cross-platform DAO abstraction (DB, WordPress, SuiteCRM, FrontAccounting, CSV, XML)

Maintainers

Package info

github.com/ksfraser/ksf_ModulesDAO

pkg:composer/ksfraser/ksf-modules-dao

Statistics

Installs: 3

Dependents: 3

Suggesters: 0

Stars: 0

Open Issues: 0

Security

Advisories: 0

Aikido package health analysis

v0.3.4 2026-02-06 23:58 UTC

Requires

  • php: >=7.3

Requires (Dev)

MIT 3c935e3654de56ca6db2105deb442c2481fd074b

  • KS Fraser

This package is auto-updated.

Last update: 2026-02-14 22:40:13 UTC

README

Cross-platform DAO abstraction for KS Fraser modules.

Related docs (keep in sync)

Goal

Provide small, composable interfaces + adapters so modules can read/write data via:

  • Generic DB tables (PDO)
  • WordPress (options/settings APIs)
  • SuiteCRM (Administration settings)
  • FrontAccounting (sys prefs or DB tables)
  • File-backed key/value stores (INI/JSON/XML/CSV/YAML)
  • CSV (tabular record store)
  • XML (record/document store)

Legacy migration helpers

To help migrate older FrontAccounting-oriented code that builds SQL from arrays (e.g. select_array, where_array, fields_array), ModulesDAO includes:

  • Ksfraser\ModulesDAO\Sql\LegacyArraySqlBuilder
  • Ksfraser\ModulesDAO\Sql\BuiltQuery

These helpers keep schema descriptions in the FA-specific package (e.g. fa_classes) while centralizing SQL construction in one place to eliminate duplication.

Note on Origin and validation

Historically, many classes inherited from a shared origin base to get permissive setters/getters plus runtime validation helpers.

For ModulesDAO, the goal is narrower: adapters + query building. DTO validation should be handled via small validators/helpers (composition) rather than forcing DTOs/Repositories to inherit from origin.

Also, while a ksfraser/origin package exists, it currently uses newer PHP language features and should not be assumed compatible with PHP 7.3 without an explicit compatibility pass.

This is scaffolding intended to be expanded in the dedicated repo: https://github.com/ksfraser/ksf_ModulesDAO