Questions tagged [sqlalchemy]
The sqlalchemy tag has no usage guidance.
9
questions
2
votes
1
answer
566
views
Should integration tests of a repository pattern use low-level ORM calls
Problem summary:
In an application with wrapper methods over SQLAlchemy add() and query() methods, can integration tests that use the add() method wrapper use the query() method wrapper to validate ...
- 131
0
votes
0
answers
51
views
Database-driven application. Code pattern to establish relationships
I have an application that mostly is composed of forms that create, modify, read, and deletes tables and establish relationships. I use SQLAlchemy. If, for example, I need to create an invoice and ...
user403463
2
votes
1
answer
2k
views
How to organize ORM models and business logic
I have a Python application using SQLAlchemy. It uses around 15 database tables.
For example, I have an image table that lists image files manipulated by the application. Most operations involving ...
- 159
1
vote
0
answers
900
views
How to store articles (with text and images) in SQLAlchemy database
I'm working on a blog-like application with Flask and SQLAlchemy and I'm unsure how to store the blog posts (articles) in the database. These are going to contain text and images (placed between ...
0
votes
0
answers
96
views
Flask/SQLAlchemy Object Classes across app layers
I’m looking for advice where the business logic and data layers in a Flask/SQLAlchemy-based app all use essentially the same object class.
As an example, my app includes a task scheduler.
Tasks ...
- 119
4
votes
1
answer
105
views
Maintaining parallel libraries: Binary files access + Metadata Database ORM design
I'm dealing with a higher-level data abstraction that I would appreciate some input on.
I'm working on an application that uses a large data lake. The data lake is consisted of thousands of large ...
- 151
1
vote
2
answers
186
views
When using an ORM when should I sacrifice performance for convenience?
I work with SQL Alchemy a lot and, as a "lazy programmer", I enjoy the convenience it offers. But the "diligent programmer" in me often worries about optimisation and the performance of the queries ...
- 1,657
5
votes
2
answers
2k
views
Separate business logic from ORM models in SQLAlchemy
I have a Flask application with tens of complex models, almost all of them related to each other.
A simple pseudo-schema of some of them:
+----------------+
| FoodGroup |
+-------+--------+
...
- 159
1
vote
2
answers
4k
views
SQLAlchemy and DDD: It's own pattern?
While reading "Patterns, Principles, and Practices of Domain-Driven Design" by Nick Tune; Scott Millett (certainly not the first book on DDD I've read) I started to understand usage of Martin Fowler's ...
- 1,773