7第一次求3將用戶信息寫入mysql數(shù)據(jù)庫天下無魚

將用戶信息寫?MySQLORM的方式將用戶注數(shù)據(jù)庫的信息（如地址、端口、用戶名和密碼等）存放在base.py中，model.py中定義了數(shù)據(jù)庫表并從base.py中獲取數(shù)據(jù)庫信息。當(dāng)main.py啟動(dòng)時(shí)，其將調(diào)用model.py初始化數(shù)據(jù)庫。而用戶名為root，密碼為pwd@demo，mysqlmysql-usetpasswordfor'root'@localhostCREATECREATEDATABASEdemoCHARACTERSET'utf8'showdatabasesbase.pyconf/base.py，增fromsqlalchemyimportcreate_enginefromfromsqlalchemyimportcreate_enginefromsqlalchemy.ext.declarativeimportengine=06/demo?charset=utf8',encoding="utf8",BaseDB=表的定義及初始化。從第6小節(jié)中看到，用戶注冊(cè)信息包含手機(jī)這些信息作為數(shù)據(jù)庫表項(xiàng)，在models.py中定義，在models.py#!#-*-coding:utf-8-fromconf.baseimportBaseDB,engineimportsysfromsqlalchemyimport(Column,)classUsers(BaseDB):"""tableforusers =id=Column(Integer,primary_key=True)phone=Column(String(50),nullable=False)password=Column(String(50),nullable=True)createTime=Column(DateTime, init(self,phone,password,self.phone=self.password=passwordself.createTimeself.password=passwordself.createTime=createTimedefifname=='mainprint("Initializemain.pymodels.py#!#!#-*-coding:utf-8-*-#Author:demo#Email:demo@#Version:demoimporttornado.webimportosimportfromtornado.optionsimportdefine,optionsfromcommon.url_routerimportinclude,fromtornado.optionsimportdefine,optionsfrommodelsimportinitdbfromsqlalchemy.ormimportscoped_session,fromconf.baseimportBaseDB, init(self):handlers=url_wrapper([(r"/users/",settingsdict(static_path=os.path.join(os.path.dirname(),template_path=os.path.join(os.path.dirname(),)tornado.web.Application.init(self,handlers,**settings)self.db=ifname=='mainprint("Tornadoserverisreadyfor修改users_views.py，將用戶數(shù)據(jù)寫?數(shù)據(jù)庫中，修改內(nèi)容包括modelsUsers類表，并判斷用戶是否在數(shù)據(jù)庫中。如果#!#!#-*-coding:utf-8-importtornado.webimportsysfromtornado.escapeimportjson_decodeimportloggingfromlogging.handlersimportfromdatetimeimportdatetimefrommonsimport()fromconf.baseimport)frommodelsimport(Users)##########Configurelogging#############logFilePath="log/users/users.log"logger=logging.getLogger("Users")handler=formatter=logging.Formatter('%(asctime)shandler.suffix="%Y%m%d""""handle/user/registrequest:paramphone:userssignup:parampassword:userssignup:paramcode:userssignupcode,mustsixdigitalcodedefdb(self):returndefpost(self):args=phone=args['phone']password=args['password']verify_code=args['code']("RegistHandlerequestargumentERROR_CODE['1001'],1001)ex_user=ifERROR_CODE['1002'],logger.debug("RegistHandleinsertdb,user:%s"create_time=add_user=Users(phone,

修改base.py，增加錯(cuò)誤碼"1