Mmrz-Sync.py 文件源码

def get_shortest_remind():
    username = request.params.get('username', None)

    if not is_username_available(username):
        dbMgr = MmrzSyncDBManager(username)
        rows = dbMgr.getNearestRemindRow()
        maxID = dbMgr.getMaxWordID()
        dbMgr.closeDB()

        if maxID == 0:
            return "?????????"

        rows = sorted(rows, key=lambda row: row[3]) # from small to big
        word          = rows[0][0]
        pronounce     = rows[0][1]
        memTimes      = rows[0][2]
        remindTime    = rows[0][3]
        remindTimeStr = rows[0][4]
        wordID        = rows[0][5]

        remindTime -= int(time.time())
        days, hours, mins, secs = split_remindTime(remindTime, True)
        remindTimeStr = "{0}d-{1}h-{2}m".format(days, hours, mins)
        remindTimeStr = "???? {0} ???".format(remindTimeStr)
    else:
        remindTimeStr = "??????"

    return remindTimeStr