Refactor for robustness, maintainability

[tombola]

Aim for simple over complex, well tested, versioned.

Need to get the project well tested and reduce code smell/repetition.

This has been held up by lack of a good testing option to enable repetition, that should now be resolved by abstracting the SQL query construction and saving an anonymised/stripped db straight into the repo.

Methodology

• filemaker-sql package

  • basic sql
  • tests
  • fetch fm metadata (introspect fm)

• vs-data-api

  • lint
    • add precommit
  • use fm-sql to create test database
    • anonymise, truncate
    • get relationships from db report/export
    • test for schema
  • pydantic settings to get db connection
  • orm stub
    • pydantic models for fm tables
    • wc methods using wcapi
      • use pydantic to validate wc entities
    • fm component to be separate fm-sql-orm package later?
  • per endpoint / command
    • create test for current functionality
    • move db settings (remove db injection)
      • test
    • swap queries to fm-sql
      • test
    • move functions to ORM model methods
      • test