ORM　＋ SQLAlchemy

ORM SQLAlchemyORM对象关系映射SQLAlchemyTypesIntegerFloatBooleanDateDatetimeStringForeignKeyfromsqlalchemyimportcreate_enginefromsqlalchemy.ormimportsessionmakerfromsqlalchemy.ext.declarativeimportdeclarative_basefromsqlalchemyimportColumn,Integer,String,Datetime,Boolean,Enum enginecreate_engine(mysql://root:localhost:3306/class?charsetutf8)Basedeclarative_base()Sessionsessionmaker(bindengine)classStudent(Base):学生信息类__tablename__studentidColumn(Integer,primary_keyTrue)nameColumn(String(16),nullableFalse)ageColumn(Interger,nullableFalse)date_of_birthColumn(Datetime)genderColumn(Enum(0,1))is_validColumn(Boolean)classOrmTest(object):def__init__(self):self.sessinSession()defadd_one(self):添加数据stuStudent(namezhangsan,age20,gender1)self.session.add(stu)# self.session.add_all() 添加多条数据self.session.commit()returnstudefget_one(self):获取一条数据returnself.session.query(Student).get(1)defget_more(self):获取多条数据returnself.session.query(Student).filter_by(is_valid1)defupdate(self):修改数据objself.session.query(Student).get(id2)obj.namelisiself.session.add(obj)self.session.commit()returnobjdefdelete(self):删除数据objself.session.query(Student).get(3)self.session.delete(obj)self.session.commit()