python-Connection Database

From SQLAlchemy import create_engine,text,column,integer,string,sequence
From sqlalchemy.ext.declarative import declarative_base
From Sqlalchemy.orm import Sessionmaker


Base = Declarative_base ()


Db_con_str = ' Mysql+mysqlconnector://root:[email protected]/blog '
# db_con_str = ' Mysql+mysqlconnector://guijianliang:[email protected]/blog '
Engine =create_engine (db_con_str,echo=true)

Session = Sessionmaker (bind=engine)
Session = Session ()

#eg1 via Class
#res = Session.query (Product). Filter (Product.id==1). One ()
# res = session.query (Product). Filter (Text ("Id=1")). One ()


# print (Res.id, res.name, Res.count)

Class Product (Base):
__tablename__= ' Entries '

id = Column (integer,sequence (' id '), primary_key=true)
Name = Column (String)
Count = Column (Integer)

def __repr__ (self):
Return "<product (id= '%d ', name= '%s ', count= '%d ') >"% (self.id,self.name,self.count)

# Print (RES)
#eg2 via SQL
sql = text ("SELECT * from Entries")
res = Session.execute (sql). Fetchall ()
Print (RES)
#
# for row in res:
# for Col in row:
# print (COL)



Session.close ()

python-Connection Database