SQLAlchemy is the Python SQL toolkit and Object Relational Mapper that gives application developers the full power and flexibility of SQL.
2
votes
1answer
48 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 ...
1
vote
0answers
44 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
...
3
votes
0answers
104 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:
...
2
votes
1answer
168 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 ...
1
vote
1answer
55 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.
...
5
votes
1answer
2k 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 ...
2
votes
0answers
205 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 ...
3
votes
1answer
86 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 ...
3
votes
1answer
564 views
2
votes
1answer
157 views
Insert or update a user in database
The code uses SQLAlchemy Core. However, what I want to know is if writing code in this pattern is recommendable.
...
