CODEWITHSUNDEEP
sqlitesqlalchemyflask-sqlalchemyflask-admin
fzsdi
fzsdi

Reputation: 23

flask-sqlalchemy and pure sql commands

I'm new to sqlalchemy, I have a flask app and I want to use flask-sqlalchemy with sqlite for flask-admin in it. I wanted to know if I could use pure sql commands while I'm using sqlalchemy or not.

Upvotes: 0

Views: 226

Answers (1)

Logovskii Dmitrii
Logovskii Dmitrii

Reputation: 2943

Yes you can, for example:

import sqlalchemy
from sqlalchemy.orm import sessionmaker, scoped_session

engine = sqlalchemy.create_engine('sqlite:///foo.db')
Session = scoped_session(sessionmaker(bind=engine))
session = Session()

sql = text('SELECT id FROM users')
result = session.execute(sql)
ids = [row[0] for row in result]
print(ids)

Upvotes: 1

Related Questions