Skip to main content

Questions tagged [sqlalchemy]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
0 answers
46 views

Storing SqlAlchemy models for database with >20 tables

I'm working on a pet project for a web shop that uses SQLAlchemy (SA) and connects to a database with over 25 tables (thus, I have 25+ SA models - one for each table). What would be the best practices ...
Max Azatian's user avatar
1 vote
2 answers
397 views

Splitting up large SQLAlchemy model

Anybody have advice on splitting up a large SQLAlchemy model into smaller parts? I have a ~2000 line model called Article that is becoming difficult to manage. We often have to scroll and scroll to ...
caseym's user avatar
  • 119
2 votes
1 answer
645 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 ...
Ash's user avatar
  • 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 ...
user avatar
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 ...
Hey's user avatar
  • 159
1 vote
0 answers
995 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 ...
Paulo Schreiner's user avatar
0 votes
0 answers
100 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 ...
nakb's user avatar
  • 119
4 votes
1 answer
114 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 ...
user27886's user avatar
  • 151
1 vote
2 answers
191 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 ...
turnip's user avatar
  • 1,677
6 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 | +-------+--------+ ...
hambos22's user avatar
  • 169
1 vote
2 answers
5k 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 ...
Roman Susi's user avatar
  • 1,773