今天通过flask的jsonify处理mysql获取的数据为在这里记录下以备不时之需
Decimal，flask默认使用的stdlib json包不支持处理Decimal格式的数据。 安装simplejson软件包。 此软件包包含Decimalaxdqq，flask默认使用Simplask
http://www.Sina.com/: centos 6.8http://www.Sina.com/:3.7. 0
http://www.Sina.com/: jsonifytypeerror : objectoftypedecimalisnotjsonserializable
14.23.96.10---- [ 11/jun/20201133605336034 ] ' get/time http/1.1 ' 200-14.23.96.10-[ 11/jun/20000 ] in _ call _ _ return self.wsgi _ app (环境， start_response ) file '/usr/local/python3/lib/python 3.7 in wsgi _ app response=self.handle _ exception (e ) fsgi python 3.7/site-packages/python in handle _ exception reraise (exc _ type，exc_value， tb )文件'/usr/local/python3/lib/python 3.7/site-PAC ce inreraiseraisevaluefile '/usr/local/python3/lib/PAC in wsgi _ app response=self.full _ dispatch _ request (文件'/usr/local/python3/lib/python 3.7/site-packack in full _ dispatch _ request RV=self.handle _ user _ exception (e ) file '/usr/local/python3/lib exc_value，tb )文件'/usr/local/python3/lib/python 3.7/siit hon 3.7 inreraiseraisevaluefile '/usr/local/python 3. line 1950， in full _ dispatch _ request RV=self.dispatch _ request () file '/usr/local/python3/lib/python 3.7/site-PAC ce in dispatch _ requestreturnself.view _ functions [ rule.endpoint ] (* * req.view _ args )文件'/data/appt inget _ C1 _ datareturnjsonify (confirm ' : data (0)、suspect':data)、heal':data )2)、 ' dead ' : data [3] } file '/usr/local/python3/lib/python 3.7/site-packages/flask/JSON/_ _ init _ } * kwargs (文件)/usr/local/python3/lib/python 3.7/JSON/_ init _.py )，line 238， indumps**kw(.encode(obj ) file '/usr/local/python3/lib/python 3.7/JSON/encoder.py '，line 201， nencodechunks=list(chunks ) file '/usr/local/python3/lib/python 3.7/JSON/encoder.py '，line 431， in _ it hon _ current _ indent _ level ]文件'/usr/local/python3/lib/python 3.7/JSON/encoder.py '，line 405 in _ ITER encode _ dictyieldfromchunksfile '/usr/local/python3/lib/python 3.7/JSON/encoder.py '，线438， in_iterencodeo=_default(o ) file '/usr/local/python3/lib/python 3.7/site-packages/flask/JSON/__ ) ) ) ) ) ) ) indefaultreturn _ JSON.JSON encoder.default (self， o )文件'/usr/local/python3/lib/python 3.7/JSON/encoder indefaultraisetypeerror (f ' objecto ftype (o._ _ CLL
环境