一、每日站立式会议

昨天完成的工作：

• 完成了注册和登录功能
• 研究如何从python传数组到js

工作中遇到的困难：

• 与前端对接数据结构
• 服务器收到请求之后没有应答
• 请求头跨域
• 如何将python的list直接导入sql表中

今天计划完成的工作：

• 开始开发查询单词
• 完成背单词功能的开发
• 完成复习单词功能的开发
• 将数据转至前端

二、项目燃尽图

三、成员代码

选择需要复习的单词

def getquestion(userid,number):#随机选择number个单词
    db = pymysql.connect(host="localhost",user="root",password="28853379", database="group6")
    cursor=db.cursor()
    sql=" select wordid,english from group6.word where wordid in(select wordid from group6.user_"+str(userid)+" where status='0') order by rand() limit "+str(number)+";"
    #print(sql)
    cursor.execute(sql)
    #db.commit()
    results=cursor.fetchall()
    return results

生成背单词选项

def getanswer(word):#获得四个中文选项，返回一个正确的和三个错误的
    db = pymysql.connect(host="localhost",user="root",password="28853379", database="group6")
    cursor=db.cursor()
    sql=" select  chinese  from  group6.word where wordid!="+"'"+word+"'"+" order by rand() limit 3;"
    cursor.execute(sql)
    #db.commit()
    results=cursor.fetchall()
    sql="select chinese from group6.word where english="+"'"+word+"'"+";"
    print(sql)
    cursor.execute(sql)
    rightanswer=cursor.fetchall()
    return rightanswer,results

前端访问数据的接口

# get_qu
def get_qu(body):
    conc = pymysql.Connect(host='127.0.0.1', port=3306, user='root', password='28853379', database='group6', charset='utf8')
    cur = conc.cursor()
    try:
        sql = "SELECT plan FROM user WHERE id = "+str(body[0])+";"
        cur.execute(sql)
        plan = cur.fetchall()[0][0]

        sql = "select wordid,english from group6.word where wordid in(select wordid from group6.user_" + str(body[0]) + " where status='0') order by rand() limit "+str(plan)+";"
        cur.execute(sql)
        result = cur.fetchall()

        data_list = []
        for each in result:
            sql = " select  chinese  from  group6.word where wordid!=" + "'" + str(each[1]) + "'" + " order by rand() limit 3;"
            cnAns = cur.fetchall()
            cnAns_list = [cnAns[0][0], cnAns[1][0], cnAns[2][0], each[2]]
            random.shuffle(cnAns_list)
            data_list.append({
                "cn": each[2],
                "en": each[1],
                "cnAns": [cnAns_list[0], cnAns_list[1], cnAns_list[2], cnAns_list[3]]
            })

    except Exception as e:
        print('操作失败:', e)
        data_list = []
        data_list.append({
            "ret": 1,
            "msg": str(e)
        })
        # 回滚数据
        conc.rollback()
    finally:
        # 关闭游标对象
        cur.close()
        # 关闭连接
        conc.close()

    # 状态信息
    status = "200 OK"
    # 响应头信息
    response_header = [
        ("Server", "PWS/1.1"),
        # 指定编码格式，因为没有模板文件，可以通过响应头指定编码格式
        ("Content-Type", "text/html;charset=utf-8")
    ]
    return status, response_header, str(data_list)

四、程序运行截图

五、每日总结

啊啦，暂时没有哦