基于fastapi写的一个简单写入mysql程序

from fastapi import FastAPI
app = FastAPI()

import pymysql
def adduser():
    db = pymysql.connect("127.0.0.1","root","root","havi" )
    cursor = db.cursor()
    sql = "INSERT INTO bdUser(User,Password,GroupID,Valid)values('%s','%s','%s','%s')"%("mayun","222222",1,1)
    try:
        cursor.execute(sql)
        db.commit()
        return "ok"
    except:
        db.rollback()
        return "err"
    db.close()

@app.get("/adduser")
def read_root():
    mss = adduser()

    return mss