• Now all data be ready for publish, We had made our blog alive now. Haha.

  • These days CCP GFW blocked all the IPs from US and when I switch my IP in google Cloud, the disk data cannot be restore again. I have to restart my blog totally, Now the website is still building…

How to execute raw SQL in Flask-SQLAlchemy app- Stack Overflow

Python PingBook 2 months ago (10-23) 17 0


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( )

But I keep getting gateway errors.


Have you tried:

result = db.engine.execute(““)


from sqlalchemy import text

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

Copyright from PingBook Blog, If not specified, they are original. This site uses BY-NC-SAProtocol authenticated.
For reprinting, please indicate the link of the original text:How to execute raw SQL in Flask-SQLAlchemy app- Stack Overflow
LIKE (0)
We create, We sharing! Tag every value data your sharing
Submit comments
Cancel comments
emoji picture bold strikethrough center italic check in

Hi,you need to provide your name and email adress!

  • Name (Required)
  • Email (Required)
  • Website