flask:小项目（医生与病人）

Bertha 。 2022-01-29 05:05 188阅读 0赞

# 医生和病人案例 增删改查 #

from flask import Flask,request,redirect
    from flask_sqlalchemy import SQLAlchemy
    from flask import  render_template
    from flask_wtf import  FlaskForm
    from wtforms import  StringField,SubmitField
    from wtforms.validators import  DataRequired
    
    app = Flask(__name__)
    
    #1配置数据库信息
    class Config(object):
        # 连接数据库
        SQLALCHEMY_DATABASE_URI = 'mysql://root:123@127.0.0.1:3306/fk02'
        # 设置sqlalchemy 自动更新
        SQLALCHEMY_TRACK_MODIFICATIONS = True
        #配置secret_key
        SECRET_KEY='avav'

方法二 \# \# 1.项目路径  
\# import os  
\# basedir = os.path.abspath(os.path.dirname(**file**)) \# E:\\flask\_pro\\day02\\blogProject  
\#  
\# app = Flask(**name**)  
\# app.config\[‘SQLALCHEMY\_DATABASE\_URI’\] = ‘sqlite:///’ + os.path.join(basedir, ‘blog.sqlite’)

app.config.from_object(Config)
    
    #创建SQLALchemy 对象
    db=SQLAlchemy(app)
    
    #创建数据模型
    class Doctor(db.Model):
        __tablename__='tb1_doctor'
        id=db.Column(db.Integer,primary_key=True)
        name=db.Column(db.String(32),nullable=False)
        patient=db.relationship('Patient',backref='doctor')#关系字段
    
        def __repr__(self):
            return '<obj:name:{}>'.format(self.name)
    
    
    class  Patient(db.Model):
        __tablename__ = 'tb1_patient'
        id = db.Column(db.Integer, primary_key=True)
        name = db.Column(db.String(32), nullable=False)
        doctor_id=db.Column(db.Integer,db.ForeignKey('tb1_doctor.id'))#外键
    
        def __repr__(self):
            return '<obj:name:{}>'.format(self.name)
    
    
    #7创建路由和视图
    @app.route('/')
    def index():
        #1获取数据库中所有的医生和病人
        doctor_obj_list=Doctor.query.all()
    
       #返回页面
        return  render_template('index.html',doctor_obj_list=doctor_obj_list)
    
    class DoctorPatientForm(FlaskForm):
        doctor_name=StringField(label='主治医生',validators=[DataRequired('必填！！！')])
        patient_name=StringField(label='患者',validators=[DataRequired('必填！！！')])
        submit=SubmitField(label='添加')
    
    #8添加医生
    @app.route('/add_doctor',methods=['GET','POST'])
    def add_doctor():
        #1创建模型类对象
        dpf=DoctorPatientForm()
        if request.method=='POST':
            #校验
            if dpf.validate_on_submit():
                #获取表单提交过来的信息
                doctor_name=dpf.doctor_name.data
                patient_name=dpf.patient_name.data
                #保存数据库
                #创建医生
                doctor_obj=Doctor(name=doctor_name)
                db.session.add(doctor_obj)
                db.session.commit()
                #创建病人
                patient_obj=Patient(name=patient_name,doctor_id=doctor_obj.id)
                db.session.add(patient_obj)
                db.session.commit()
                #重定向到首页
                return redirect('/')
    
       返回界面
        return render_template('add_doctor.html',dpf=dpf)
    
    #删除病人
    @app.route('/delete_patient')
    def delete_patient():
        #1获取id
        id=request.args.get('id')
        #删除数据库中的记录
        patient_obj=Patient.query.get(id)
        db.session.delete(patient_obj)
        db.session.commit()
        #重定向到首页
        return redirect('/')
    
    
    ##修改病人或医生
    @app.route('/xiugai')
    def xiugai_patient():
    
    
    
    
    if __name__ == '__main__':
    
    #导入pymysql
    import pymysql
    pymysql.install_as_MySQLdb()
    #创建表格
    # db.drop_all()#删除所有表格
    # db.create_all()#创建所有表格
    #
    # #添加数据
    # d1=Doctor(name='刘争争')
    # d2=Doctor(name='刘小争')
    # d3=Doctor(name='刘大争')
    # db.session.add_all([d1,d2,d3])
    # db.session.commit()
    #
    # p1=Patient(name='刘争1',doctor_id=d1.id)
    # p2=Patient(name='刘争2',doctor_id=d2.id)
    # p3=Patient(name='刘争3',doctor_id=d3.id)
    # p4=Patient(name='刘争4',doctor_id=d1.id)
    # p5=Patient(name='刘争5',doctor_id=d2.id)
    # db.session.add_all([p1,p2,p3,p4,p5])
    # db.session.commit()
    
    app.run(debug=True)

# HTML #

## index ##

<!DOCTYPE html>
    <html lang="en">
    <head>
        <meta charset="UTF-8">
        <title>首页</title>
    </head>
    <body>
    <a href="/add_doctor">添加</a>
    
    <ul>
        {% for doctor_obj in doctor_obj_list %}
            <li>主治医生:{
       {doctor_obj.name}}<a href="/xiugai_patient?id={
       {patient_obj.id}}">修改</a></li>
            {% for patient_obj in doctor_obj.patient %}
                    <li>
                        病人:{
       {patient_obj.name}}<a href="/delete_patient?id={
       {patient_obj.id}}">删除</a>
                        <a href="/xiugai_patient?id={
       {patient_obj.id}}">修改</a>
                    </li>
            {% endfor %}
    
        {% endfor %}
    
    </ul>
    </body>
    </html>

## add\_doctor ##

<!DOCTYPE html>
    <html lang="en">
    <head>
        <meta charset="UTF-8">
        <title>添加医生</title>
    </head>
    <body>
    
    <form action="/add_doctor" method="post">
        {
       {dpf.csrf_token}}
        {
       {dpf.doctor_name.label}}:{
       {dpf.doctor_name}}
        <span>{
       {dpf.doctor_name.errors.0}}</span>
        <br/>
        {
       {dpf.patient_name.label}}:{
       {dpf.patient_name}}
        <span>{
       {dpf.patient_name.errors.0}}</span>
        <br/>
        {
       {dpf.submit}}
    
    </form>
    
    </body>
    </html>