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
0
votes
0
answers
17
views
Flask App - create the admin account (Suggestios or Improvements)
I know this may be a silly question..., but I'm trying to create a function in python that allows me to register an account for the admin user.
If the administrator does not specify any data, be it ...
- 473
2
votes
2
answers
78
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 ...
- 21
0
votes
0
answers
39
views
Looking for best practices/design patterns when working with SqlAlchemy ORM
I am new to python and sqlalchemy and looking for help to cleanup below code or follow a popular design pattern when working with database.
Below sample code is for the use case "User clicks on ...
- 183
0
votes
0
answers
112
views
Asynchronous DB session in Python (used in ASGI framework such as Sanic)
I've been working with Sanic as my default web framework, but coming from Flask, I had some issue with how to handle the database connection.
So I built an asynchronous wrapper around it.
I've also ...
- 245
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
0
votes
1
answer
115
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 ...
- 103
0
votes
1
answer
85
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
0
votes
0
answers
130
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 ?
...
- 123
0
votes
1
answer
101
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 ...
- 1
1
vote
1
answer
111
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 ...
- 255
2
votes
1
answer
39
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 ...
- 501
1
vote
0
answers
441
views
Discord bot using SQLAlchemy
Right now I'm making a Discord Bot written in Python. I'm using SQLAlchemy to deal with the database.
My structure is:
One database.py containing a ...
- 11
1
vote
1
answer
85
views
Filtering data from an exisiting table using psycopg2+sqlalchemy
I am using psycopg2 & sqlalchemy to connect to a database and extract information from a table as follows:
...
- 135
3
votes
1
answer
104
views
Flask Database Design with ORM
I am designing a Stock Currency application and for that, I created a database.
I searched for my question here first but the answerer told me to ask the same question here.
...
- 141
2
votes
0
answers
29
views
A task to store user's favorited projects in postgres using python
I am not happy with two functions calling get_user() since while testing I mock get_user and to test with get_user_returns_null case, it returns Null for both ...
- 195
1
vote
1
answer
258
views
How to make the filtering queries more efficient using flask sqlalchemy?
I have a following table in a flask app
...
- 133
6
votes
2
answers
232
views
Follow Up DinoPass - CLI Password Manager
This is a follow-up (somewhat) to this post. I said somewhat because I've kinda changed most of the logic.
Changes:
I've changed the project name
I've changed the CLI UX
I've added encryption / ...
- 9,112
2
votes
0
answers
63
views
Basic flask template with sessions
This Flask app, which makes use of SQLAlchemy, a MySQL server which is only reachable via SSH and Flask-Login, is the base on which I want to write an application which has login protected pages.
...
- 105
1
vote
0
answers
171
views
querying users from table if user.id is found in another table
I am using flask with sqlAlchemy to connect with a postgresql database with two tables
Users table (id, name)
...
- 111
1
vote
0
answers
53
views
Python: SQL Alchemy. Managing a many-to-many self related table
I am building Twitter. People can follow each other, and hence I have 2 tables, users and followers.
My current problem is ...
- 111
6
votes
3
answers
863
views
Simple Python and SQLAlchemy Text Password Manager
Out of boredom, I decided to start my personal project and I've chosen a simple Text Password Manager.
Note: For anyone out there, I strongly recommend you NOT to use this for any sensitive storage ...
- 9,112
2
votes
0
answers
33
views
Gathering data using sqlalchemy from database and making it available using simplified namedtuple object in an iterable class
I wrote the below code today:
...
- 840
3
votes
0
answers
222
views
Is this a good way to process SQLAlchemy's uniqueness constraint violation in Flask?
I'm using Flask along with Flask-SQLAlchemy and Flask-WTF.
I have a model:
...
- 127
2
votes
1
answer
129
views
Website for allowing data evaluation from submission
I'm making a really basic website where users essentially just submit data into some forms and they will be able to review their data in another page. I feel like I'm going to be repeating myself far ...
- 45
3
votes
0
answers
174
views
Code organization: interacting with SQLAlchemy from inside class
I don't like the way my code is written, but at the moment, I don't see, how I should do it better.
I have a class (let's say MyInvoiceType), which needs to save data to preexisting database. The ...
- 230
1
vote
0
answers
235
views
Setting up user models with Flask-SQLAlchemy
I've recently come across SQLAlchemy, and as I had just been attempting to code something very similar to it, I think it's amazing. I've started on a new website, ...
- 1,115
2
votes
0
answers
217
views
Saving OAuth2 credentials to database with SQLAlchemy
I'm writing web application that uses Google Proximity Beacon API to interact with beacon data. In order to access that data, I need to grant access to use beacons' information for my web application ...
- 121
3
votes
0
answers
122
views
Loading into a target table
Today I tried Bonobo + SQLAlchemy (for the first time), so it's bound to be full of bad practices. However, this is working code. I'm hoping for some feedback to for doing it correctly.
I started out ...
- 139
3
votes
2
answers
133
views
Finding the duration of how long a search has been popular
Program:
I have designed a program in python that does the following (in order):
Webscrapes google trends for the most popular searches
Stores the searches and traffic of the searches in an in-memory ...
7
votes
2
answers
2k
views
A simple library using Flask and SQLAlchemy
This is the main.py script that does most of the work of Adding movies (Movie objects) as well as modifying and removing:
...
- 173
3
votes
1
answer
2k
views
Slow Flask-SQLAlchemy query using association tables
I have two models in Flask-SQLAlchemy (Post and Comment) that have many-to-many relationship that is manifested in the third model (post_mentions):
...
3
votes
0
answers
356
views
Flask-SQLAlchemy model structure
I'm seeking a review of my Flask-SQLAlchemy model structure, particularly adherence to DB best practices, such as avoiding duplication, etc.
The models represent the relations between Departments, ...
- 31
2
votes
1
answer
82
views
SQLAlchemy code for calling parameters
I'm using the following function to process API parameters for an specific endpoint. Using SQLAlchemy and Flask, I want to get feedback in terms of simplifying calling SQL code and nested statements.
...
- 601
2
votes
0
answers
134
views
REST backend app script for doing CRUD transactions
As a side project, I am working on Tiddly which is a simple Python(Flask) based app for a generic REST backend that could be used for CRUD transactions on any kind of database (using ...
- 349
1
vote
1
answer
421
views
Get json format from sqlalchemy class
I have written a small tool to generate a json file from sqlalchemy models files to automate the tedious procedure of writing all the sql raws in a json format. The script works, but there are few ...
- 229
2
votes
1
answer
192
views
SqlAlchemy model for users and timezones
I have a following schema, I would like to query user and all timezones belongs to it including timezone name. Could you please validate if my schema constructed correctly and most efficient way?
<...
- 191
4
votes
0
answers
285
views
SQL-Alchemy session management
I have written a couple of scripts for accessing Twitter REST API, and storing data in a Postgres DB for data extraction purposes. I know how to use django ORM, or plain SQL, but this was my first ...
- 251
3
votes
0
answers
151
views
Constructing queries with SQLAlchemy based on search parameters
I have an app where the user can search for items in my database by entering a set of information, then the server receives it and for each option it queries the database, and stores the result in a ...
- 31
2
votes
1
answer
643
views
Saving items to database w/ sqlalchemy
Can someone please review my code? I'm saving a hotel rate to a database. I want to save the rate twice, one field will update with every new rate, and one field will contain the rate that was found ...
- 199
1
vote
0
answers
1k
views
Parse query filter expression from request URL
I am building a backend APi for which I need to extract query filters from request URL of following pattern:
...
- 111
3
votes
0
answers
2k
views
Simple Payment System Flask App
Can I please get some reviews and suggestions?
This is what this app does:
It picks user login from Users table and compare it with the post in the login ...
- 131
3
votes
1
answer
4k
views
Applying dynamic filters to a SQL query using Python conditional expressions
I wrote this piece of code to eliminate the need for multiple if then statements based on the filters from the incoming REST request.
If the request has category ...
- 133
3
votes
1
answer
288
views
SQLite database for a micro/tumble blog application
I'm creating a personal website where, among other things, there is a blog, or a "microblog" (I'm still not sure how to define the two), where I will be writing articles and having users, who will ...
- 133
3
votes
0
answers
328
views
Implementing Flask create_app function with SqlAlchemy
I have a simple Flask app that realises rest-api with SQLAlchemy. I have written this create_app function:
views.py
...
- 151
3
votes
1
answer
2k
views
Generating string primary keys with sequence in SQLAlchemy
I need improvement on solution to the following problem:
Generating random string keys in SQA is relatively simple, something
like:
...
- 749
3
votes
1
answer
1k
views
Utility Class for CRUD Operations in a Flask App
I'm new to Flask and Python and am trying to sort out the most pythonic way to modularize my utilities. I have models.py which have my sqlalchemy models and ...
- 141
1
vote
1
answer
82
views
Add user to a database and perform relevant checks
Below is a function that adds a new user to the database using their email and password. I am using Flask and SQLAlchemy.
...
user69228
7
votes
1
answer
15k
views
Efficient Pandas to MySQL "UPDATE... WHERE"
I have a pandas DataFrame and a (MySQL) database with the same columns. The database is not managed by me.
I want to update the values in the database in an "UPDATE... WHERE" style, updating only ...
- 171
2
votes
0
answers
447
views
Structure of database model for a Flask project
I'm working on a project with Flask and I'm trying to follow Miguel Grinberg's Flask tutorial as closely as possible while creating what I need for my own project.
Overall, how does it look? Miguel's ...
- 121
3
votes
1
answer
111
views
Catching API changes for a service that doesn't version its API
I'm using the old Google Data API to access several spreadsheets and put their contents in a database using Flask and SQLAlchemy. Each run deletes the contents of the database tables and repopulates ...
- 131