chenwu
da0502c369
modified: Evaluate_Result/admin_example_1.xlsx modified: Evaluate_Result/admin_example_2.xlsx new file: __pycache__/compareData.cpython-313.pyc new file: __pycache__/config.cpython-313.pyc new file: __pycache__/getDataFromAS.cpython-313.pyc new file: __pycache__/getQueries.cpython-313.pyc modified: app.py new file: build/Compare-PBI-Data/Analysis-00.toc new file: build/Compare-PBI-Data/Compare-PBI-Data.pkg new file: build/Compare-PBI-Data/EXE-00.toc new file: build/Compare-PBI-Data/PKG-00.toc new file: build/Compare-PBI-Data/PYZ-00.pyz new file: build/Compare-PBI-Data/PYZ-00.toc new file: build/Compare-PBI-Data/base_library.zip new file: build/Compare-PBI-Data/generated-2c83337f9fff21d32f0901febbdb8eec9b843eb92a216cf8171391083f1c5046.ico new file: build/Compare-PBI-Data/localpycs/pyimod01_archive.pyc new file: build/Compare-PBI-Data/localpycs/pyimod02_importers.pyc new file: build/Compare-PBI-Data/localpycs/pyimod03_ctypes.pyc new file: build/Compare-PBI-Data/localpycs/pyimod04_pywin32.pyc new file: build/Compare-PBI-Data/localpycs/struct.pyc new file: build/Compare-PBI-Data/warn-Compare-PBI-Data.txt new file: build/Compare-PBI-Data/xref-Compare-PBI-Data.html new file: build_exe.py modified: config.py new file: dist/Compare-PBI-Data.exe new file: dist/Evaluate_Result/admin_example_1.xlsx new file: dist/Evaluate_Result/admin_example_2.xlsx new file: dist/Export_Json/example.json modified: getDataFromAS.py modified: getQueries.py new file: icon.jpg modified: requirements.txt deleted: run.py modified: templates/index.html
42 lines
1.3 KiB
Python
42 lines
1.3 KiB
Python
import json
|
|
import pandas as pd
|
|
|
|
|
|
def getQueries_From_json(json_name):
|
|
# 打开并读取JSON文件
|
|
try:
|
|
with open(json_name + ".json", "r", encoding="utf-8-sig") as file:
|
|
data = json.load(file)
|
|
# 从JSON数据中提取所有名为"Execute DAX Query"的事件中的QueryText
|
|
queries = [
|
|
event["metrics"]["QueryText"]
|
|
for event in data["events"]
|
|
if event["name"] == "Execute DAX Query"
|
|
]
|
|
return queries
|
|
except Exception as e:
|
|
print(f"读取JSON文件错误: {e}，文件路径: {json_name}.json")
|
|
raise
|
|
|
|
|
|
def getQueries_From_excel(excel_name):
|
|
# 使用pandas读取Excel文件
|
|
df = pd.read_excel(excel_name, engine="openpyxl")
|
|
# 在DataFrame中添加一个新的列"NAME"，其值为"EVALUATE '" + 原始的"NAME"列值 + "'"
|
|
df["NAME"] = "EVALUATE '" + df["NAME"] + "'"
|
|
# 将新的"NAME"列转换为列表
|
|
queries = df["NAME"].to_list()
|
|
return queries
|
|
|
|
|
|
if __name__ == "__main__":
|
|
import os
|
|
from config import CURRENT_DIR_PATH, EXPORT_PAGE_JSON_NAME_1
|
|
|
|
# 获取当前脚本所在的目录路径
|
|
EXPORT_PAGE_JSON_PATH_1 = os.path.join(
|
|
CURRENT_DIR_PATH, "Export_Json", EXPORT_PAGE_JSON_NAME_1
|
|
)
|
|
queries = getQueries_From_json(EXPORT_PAGE_JSON_PATH_1)
|
|
print(queries)
|