Questions tagged [sqlalchemy]

SQLAlchemy is the Python SQL toolkit and Object Relational Mapper that gives application developers the full power and flexibility of SQL.

13 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
4
votes
0answers
186 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 ...
3
votes
0answers
33 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 ...
3
votes
0answers
67 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 ...
3
votes
0answers
254 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, ...
3
votes
0answers
130 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 ...
3
votes
0answers
882 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 ...
3
votes
0answers
234 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 ...
2
votes
0answers
36 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 ...
2
votes
0answers
115 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 ...
2
votes
0answers
444 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 ...
1
vote
0answers
47 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
vote
0answers
697 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: ...
0
votes
0answers
49 views

Flask database design for a social media site like Twitter

This is a mysql database that is created through sqlalchemy. I really don't want to rewrite all of it in sql code, but the code should be understandable if you know a tiny bit of MySQL. I am ...