如何从python获取BQL (bLOOMBERG)查询

import blpapi
import pandas as pd

sessionOptions = blpapi.SessionOptions()
session = blpapi.Session(sessionOptions)

session.start()

request = session.createRequest("bqlRequest")
request.set("query", "your_bql_query_here")

session.sendRequest(request)
while True:
    event = session.nextEvent()
    if event.eventType() == blpapi.Event.RESPONSE:
        break

data = []
while True:
    event = session.nextEvent()
    if event.eventType() == blpapi.Event.PARTIAL_RESPONSE or event.eventType() == blpapi.Event.RESPONSE:
        for msg in event:
            securityData = msg.getElement("securityData")
            fieldDataArray = securityData.getElement("fieldData")
            for i in range(fieldDataArray.numValues()):
                fieldData = fieldDataArray.getValue(i)
                fieldValues = fieldData.getElement("fieldValues")
                data.append([fieldValues.getElementAsString(j) for j in range(fieldValues.numElements())])
    if event.eventType() == blpapi.Event.RESPONSE:
        break

df = pd.DataFrame(data)

session.stop()