scbc_repos/ssat_sdk/MenuTree3/TData.py

# -*- coding:utf-8 -*-
from ssat_sdk.MenuTree3.TExcelParser import CExcelParser

from ssat_sdk import getMenuTree3SelectedProjectCfgPath, getMenuTree3SelectedPExcelPath


class CTData():
    def __init__(self):
        # excel路径,根据界面选择的项目来确定;
        # self.xlspath = getMenuTree3SelectedProjectCfgPath() + '\\MenuTree.xls'
        self.xlspath = getMenuTree3SelectedPExcelPath()
        # excel解析器对象;
        self.xlsparser = CExcelParser(self.xlspath)
        # 读取excel并解析出内容;
        self.xlsparser.read_excel()
        # 新增表格查询接口

    # 获取表格Value层级中，value_name下包含的value列表
    def getSubValueList(self, value_name):
        return self.xlsparser.getSubValueList(value_name)

    # 获取表格First~Sixth层级中，parent下包含的option列表
    def getSubOptionList(self, parent):
        return self.xlsparser.getSubOptionList(parent)

    # 获取表格Value层级中，value_name下的指定value的ocr列表
    def getValueTextList(self, value_name, value):
        return self.xlsparser.getValueTextList(value_name, value)

    # 获取表格First~Sixth层级中，parent下的指定option的ocr列表
    def getOptionTextList(self, parent, option):
        return self.xlsparser.getOptionTextList(parent, option)


if __name__ == "__main__":
    tData = CTData()

    value_name = "source"
    subValueList = tData.getSubValueList(value_name)
    print u"获取Value层级中value_name为source下包含的value列表：", subValueList
    # 执行结果：[u'atv', u'dtv', u'tv', u'av', u'hdmi1', u'hdmi2', u'hdmi3', u'usb']

    parent = "picture"
    subOptionList = tData.getSubOptionList(parent)
    print u"获取First~Sixth层级中parent为picture下包含的value列表：", subOptionList
    # 执行结果：[u'picture_preset', u'backlight', u'overscan', u'content_type', u'screen_mode', u'advanced_settings_picture',u'picture_reset']

    value_name = "source"
    value = "atv"
    valueTextList = tData.getValueTextList(value_name, value)
    print u"获取表格Value层级中，value_name:source 下的value:atv 的ocr列表：", valueTextList
    # 执行结果：[u'tv', u'atv']

    parent = "picture"
    option = "picture_reset"
    optionTextList = tData.getOptionTextList(parent, option)
    print u"获取表格First~Sixth层级中，parent:picture  下的option:picture_reset的ocr列表：", optionTextList
    # 执行结果：[u'picture reset']