Example of using raw SQL SQLAlchemy

#Get Database fromSQLAlchemyImportCreate_enginedb= Create_engine ("sqlite:///:memory:", echo=True)#Create a tableDb.execute ("""CREATE TABLE Users (userid char (), username char ())""")#Inserting RecordsResultproxy = Db.execute ("""INSERT into users (userid,username) VALUES (' User1 ', ' Tony ')""") Resultproxy.rowcount#return rows affected by an UPDATE or DELETE statement#EnquiryResultproxy = Db.execute ("""SELECT * from Users""") Resultproxy.rowcount#return rows affected by an UPDATE or DELETE statement.resultproxy.scalar ()#can return the value of a scalar query#The Resultproxy class is an encapsulation of the cursor class (in file sqlalchemy\engine\base.py),#the Resultproxy class has a property cursor that corresponds to the original cursor.#The Resultproxy class has a number of methods that correspond to the cursor class, and some properties/methods are extended.#Resultproxy.fetchall ()#Resultproxy.fetchmany ()#Resultproxy.fetchone ()#Resultproxy.first ()#resultproxy.returns_rows #True If this resultproxy returns rows.resultproxy.close ()#when Resultproxy is exhausted, close is required.

Example of using raw SQL SQLAlchemy