How to execute raw SQL in Flask-SQLAlchemy app

python sql sqlalchemy flask flask-sqlalchemy
starwing123 picture starwing123 · Jul 31, 2013 · Viewed 267.3k times · Source

How do you execute raw SQL in SQLAlchemy?

I have a python web app that runs on flask and interfaces to the database through SQLAlchemy.

I need a way to run the raw SQL. The query involves multiple table joins along with Inline views.

I've tried:

connection = db.session.connection()
connection.execute( <sql here> )

But I keep getting gateway errors.

Answer

Miguel picture Miguel · Aug 1, 2013

Have you tried:

result = db.engine.execute("<sql here>")

or:

from sqlalchemy import text

sql = text('select name from penguins')
result = db.engine.execute(sql)
names = [row[0] for row in result]
print names

Related questions

flask sqlalchemy query with keyword as variable

Let's say I have a model like this: class User(db.Model): id = db.Column(db.Integer, primary_key=True) hometown = db.Column(db.String(140)) university = db.Column(db.String(140)) To get a list of users from New York, this …

Read More
SqlAlchemy and Flask, how to query many-to-many relationship

I need help creating SqlAlchemy query. I'm doing a Flask project where I'm using SqlAlchemy. I have created 3 tables: Restaurant, Dish and restaurant_dish in my models.py file. restaurant_dish = db.Table('restaurant_dish', db.Column('dish_id', db.…

Read More
sqlalchemy: how to join several tables by one query?

I have the following SQLAlchemy mapped classes: class User(Base): __tablename__ = 'users' email = Column(String, primary_key=True) name = Column(String) class Document(Base): __tablename__ = "documents" name = Column(String, primary_key=True) author = Column(String, ForeignKey("users.email")) class DocumentsPermissions(…

Read More