database-operations

When performing database operations using SQLAlchemy, follow these guidelines to ensure efficient and maintainable code:

• Avoid for-loops. Instead always prefer bulk operations using SQLAlchemy's built-in methods or use SQL joins to get related data in a single query.
• Database operations should be contained in repository classes