python - flask-sqlalchemy 怎么設(shè)置json格式的字段
問(wèn)題描述
flask-sqlalchemy 怎么設(shè)置json格式的字段
問(wèn)題解答
回答1:有兩種方法:1.sqlalchemy中PickleType可以對(duì)應(yīng)任何python對(duì)象.2.可以通過(guò)編寫方法的方式生成json.
具體代碼如下:
#!usr/bin/env python# coding:utf-8from flask import Flaskfrom flask_sqlalchemy import SQLAlchemyapp = Flask(__name__)app.config[’SQLALCHEMY_DATABASE_URI’] = ’mysql://root:psw@localhost/test_json’app.config[’SQLALCHEMY_TRACK_MODIFICATIONS’] = Truedb = SQLAlchemy(app)class Users(db.Model): __tablename__ = ’users’ user_id = db.Column(db.Integer, primary_key=True) user_info = db.Column(db.PickleType) def __repr__(self):return self.user_infoclass Students(db.Model): __tablename__ = ’students’ student_id = db.Column(db.Integer, primary_key=True) student_name = db.Column(db.String(80), unique=True) student_age = db.Column(db.Integer) student_sex = db.Column(db.String(20)) def to_json(self):json_student = { ’student_id’: self.student_id, ’student_name’: self.student_name, ’student_sex’: self.student_sex, ’student_age’: self.student_age}return json_student def __repr__(self):return ’%r’ % self.student_idif __name__ == '__main__': #-----------------------生成----------------------- USER_INFO = {'name':'nisiwa', 'mail':'2222233333@qq.com'} db.create_all() USER = Users(user_info=USER_INFO) STUDENT = Students(student_name='nisiwa', student_age='28', student_sex='male') db.session.add(USER) db.session.add(STUDENT) db.session.commit() #-----------------------調(diào)用------------------------ user = Users.query.filter_by(user_id=1).first() student = Students.query.filter_by(student_id=1).first() print ’student:’, student.to_json() print ’user:’, user.user_info
結(jié)果如下:
相關(guān)文章:
1. javascript - sublime快鍵鍵問(wèn)題2. javascript - immutable配合react提升性能?3. css - 寫頁(yè)面遇到個(gè)布局問(wèn)題,求大佬們幫解答,在線等,急!~4. javascript - nodejs關(guān)于進(jìn)程間發(fā)送句柄的一點(diǎn)疑問(wèn)5. Apache 已經(jīng)把網(wǎng)站根目錄的改為allow from all了,但是服務(wù)器還是不能訪問(wèn)?6. 實(shí)現(xiàn)bing搜索工具urlAPI提交7. 配置Apache時(shí),添加對(duì)PHP的支持時(shí)語(yǔ)法錯(cuò)誤8. vue.js - Vue 如何像Angular.js watch 一樣監(jiān)聽數(shù)據(jù)變化9. javascript - 移動(dòng)端上不能實(shí)現(xiàn)拖拽布局嗎?10. phpstudy8.1支持win11系統(tǒng)嗎?

網(wǎng)公網(wǎng)安備