问使用来自MySQL的数据每5分钟更新一次API数据库

EN

async def update_playlists(self, platform, username):
        print("-----\nUPDATING RL RANKS DB - DO NOT SHUTDOWN")
        async with self.bot.pool.acquire() as conn:
            async with conn.cursor() as cur:
                sql = "SELECT `username`, `platform` FROM `player_ranks`"
                await cur.execute(sql)
                players = await cur.fetchall()
                for player in players:
                    ranks = []
                    username, platform = player
                    print(f"-----\n{username} ranks are being updated")
                    playlists = self.get_playlists(platform, username)
                    for gameMode in GameModes:
                        if gameMode == GameModes.CASUAL.value:
                            continue
                        try:
                            playlist = next((p for p in playlists['data'] if p['attributes']['playlistId'] == gameMode))
                            ranks += (playlist['stats']['tier']['metadata']['name'],
                                      playlist['stats']['division']['metadata']['name'],
                                      playlist['stats']['rating']['value'])

                        except StopIteration:
                            ranks += ("n/a", "n/a", "0")
                            pass
                    sql = "UPDATE player_ranks SET `Duel_Rank`=%s, `Duel_Div`=%s, `Duel_MMR`=%s, `Doubles_Rank`=%s, `Doubles_Div`=%s, `Doubles_MMR`=%s, `Solo_Standard_Rank`=%s, `Solo_Standard_Div`=%s, `Solo_Standard_MMR`=%s, `Standard_Rank`=%s, `Standard_Div`=%s, `Standard_MMR`=%s, `Hoops_Rank`=%s, `Hoops_Div`=%s, `Hoops_MMR`=%s, `Rumble_Rank`=%s, `Rumble_Div`=%s, `Rumble_MMR`=%s, `Dropshot_Rank`=%s, `Dropshot_Div`=%s, `Dropshot_MMR`=%s, `Snowday_Rank`=%s, `Snowday_Div`=%s, `Snowday_MMR`=%s WHERE `username`=%s"
                    await cur.execute(sql, (*ranks, username))
                    await conn.commit()
                    playerdata = self.get_playerinfo(platform, username)
                    wins_: int = playerdata['data']['segments'][0]['stats']['wins']['value']
                    assists_: int = playerdata['data']['segments'][0]['stats']['assists']['value']
                    goals_: int = playerdata['data']['segments'][0]['stats']['goals']['value']
                    goalShotRatio_: float = playerdata['data']['segments'][0]['stats']['goalShotRatio']['value']
                    mvps = playerdata['data']['segments'][0]['stats']['mVPs']['value']
                    saves = playerdata['data']['segments'][0]['stats']['saves']['value']
                    shots = playerdata['data']['segments'][0]['stats']['shots']['value']
                    sql = "UPDATE player_stats SET `wins`=%s, `assists`=%s, `goals`=%s, `goalshot`=%s,`mvp`=%s, `saves`=%s, `shots`=%s WHERE `username`=%s"
                    await cur.execute(sql, (wins_, assists_, goals_, goalShotRatio_, mvps, saves, shots, username))
                    await conn.commit()```