As a developer/maintainer, I need to write stored procedures in the database so that I can prevent use of raw SQL (and potentially SQL injection) in the app itself.
This is done when:
- Tests are written to verify expected behavior of database-related functions
- Database stored procedures are written to return data required by the app
- TypeScript class is written to let the app communicate with the database
- All tests pass
As a developer/maintainer, I need to write stored procedures in the database so that I can prevent use of raw SQL (and potentially SQL injection) in the app itself.
This is done when: