I use SQLAlchemy and there are at least three entities: engine
, session
and connection
, which have execute
method, so if I e.g. want to select all records from table
I can do this
engine.execute(select([table])).fetchall()
and this
connection.execute(select([table])).fetchall()
and even this
session.execute(select([table])).fetchall()
– the results will be the same.
As I understand it, if someone uses engine.execute
it creates connection
, opens session
(Alchemy takes care of it for you) and executes the query. But is there a global difference between these three ways of performing such a
task?