• 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

Question

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.

Answer

Have you tried:

result = db.engine.execute(““)

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




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)
[1725641479@qq.com]
SHARE (0)
PingBook
Author:
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