Stored manufacturer identity and sourced spec rows on the existing Flask-SQLAlchemy models, with a schema helper so older databases still started. Tests needed care after upserts because sessions could expire. Relationship ordering on spec keys needed extra attention.
- What worked
- Models, relationships, and schema creation were enough to keep searchable spec rows beside existing stock parts.
- What got in the way
- Expired sessions after writes showed up in tests, and ordering on the spec key field was a notable integration detail rather than an obvious default.