Questions tagged [sqlalchemy]
SQLAlchemy is the Python SQL toolkit and Object Relational Mapper that gives application developers the full power and flexibility of SQL.
52 questions
4
votes
1
answer
69
views
sqlalchemy and alembic integration in FastAPI
I am building a fastAPI + sqlalchemy + alembic + docker-compose reusable template.
Full source code: https://github.com/mascai/fastapi_template (commit 77ce7f2)
I would appreciate pull-requests =)
The ...
- 459
2
votes
1
answer
51
views
Type-agnostic configuration-table in sqlalchemy
I'm building my first bigger database-backend with sqlalchemy and need a table to store configurations (key-value pairs). Keys are strings, values can be quite different, and I'd like to keep the ...
- 193
2
votes
1
answer
82
views
Python SQLAlchemy database model for Version Control system
This is my first time creating a non-trivial database and I was wondering what I could do better. As the title says this will be used a in toy version control system. Most of my choices feel "...
- 423
1
vote
1
answer
133
views
Managing users via SQLAlchemy DB model (updated)
I am currently in the process of writing a system application that will be operated by multiple users. This will require individual users to access the application while limiting access to those that ...
- 303
1
vote
0
answers
79
views
A server side for a Premier League score guessing app
So I'm writing a Premier League score prediction app with Python, Flask and SQLalchemy and have almost finished the server side of it. I realised that no one has ever looked at my code and there could ...
- 11
1
vote
1
answer
131
views
Getting one company from two tables [closed]
Currently I'm working with fastapi, sqlalchemy to connect to multiple databases. It checks params to ensure it has company_name, ...
- 111
2
votes
0
answers
106
views
YouTube to LBRY Video Uploader - V0.1.0
I have developed a Python script that allows users to upload videos from YouTube to LBRY. The script also performs video post-processing and database operations. I would like to request a code review ...
2
votes
2
answers
582
views
DDD architecture pattern
I'm trying to understand the DDD architecture pattern. I wrote a simple project in which I tried to use DDD arch. Here are my doubts after implementing it:
Does it make sense to use an ORM for a DDD ...
- 23
8
votes
2
answers
1k
views
High traffic website that shows users subscription status
I was in two minds as whether to post this question on stackoverflow or dba stackexchange but because I am asking for review, I thought of posting here.
I am new to Python and looking for feedback on ...
- 183
1
vote
1
answer
244
views
Retrieve, parse and export data to tables via sqlalchemy
The project I've working on is designed with the intent of being able to quickly and efficiently identify discrepancies in live sports betting data that comes from web API's in json format. The first ...
- 113
1
vote
1
answer
124
views
User, Company, Company User and Post relationship
The use case of an application is there will be two kinds of user. One normal user and another company user. The requirement is
Normal user can follow company and see their posts
A company has ...
- 211
2
votes
1
answer
185
views
Many to many relationship in Flask with SQLAlchemy
I want to create a family tree where the relationships are only godfather and godson. Is this the right way to declare the personn class ?
...
- 153
1
vote
1
answer
220
views
Flask-SQLAlchemy achieve 1 to many relationship that backfills parent when child is updated
Currently I have two tables Plan (plans) and User (users) and there is a foreign key constraint on users which references plans.id
When I create a new user I want to assign a plan to that user via ...
- 11
2
votes
1
answer
213
views
Inserting Data to three linked table with SQLAlchemy
I am inserting data from a dict type object into three different tables in the SQL database. I am using Sqlalchemy as my ORM. My code is working but I think it is not very readable, is it any way to ...
- 265
2
votes
1
answer
150
views
Linking a count to an object in SQLAlchemy
I'm not sure if the problem here is how I'm wording the question or going about finding an answer, but I have what I think is a relatively trivial task: getting fact-check claims from the Google Fact ...
- 511