Exemple #1
0
def getSubItemsGantt():

    # 显示的空白行列数
    show_cloumns = 7
    total_bar_width = 1200 # 满格宽度为1200px

    # 父亲节点id
    parent_audit_id = request.query.parent_audit_id

    #时间下限值
    low_times = request.query.low_times

    if low_times is None or len(low_times) == 0:
        low_times = 0
    else:
        try:
            low_times = int(low_times)
        except:
            low_times = 0

    result = {}
    dbPersisted = DbPersisted()

    # 父节点记录信息
    parent_audit_item = dbPersisted.query_operation(op_mode='query_transaction_real_data_by_id', low_times=low_times)(parent_audit_id)

    #原始的最长时间
    org_parent_time_show = int(parent_audit_item['durable_time'])
    # 显示的最长时间设定为花费时间的1.25倍
    parent_time_show = int((org_parent_time_show + show_cloumns - org_parent_time_show % show_cloumns) * 5 / 4)

    # # 组装表头数据, 满页为7列(页面上显示的是约6.3列)
    time_split = int(parent_time_show/(show_cloumns-2))#让最长时间的进度条占满前5列
    result['tr_items'] = map(lambda x:{'tr_no':x, 'tr_time':(x-1)*time_split}, xrange(1,8))

    # 函数调用的入口方法名称
    result['parent_url'] = parent_audit_item['url']

    # 函数调用入口的起始时间
    p_begin_time = long(parent_audit_item['begin_time'])

    # 组装表内容数据
    result['sub_items'] = map(
        lambda item: {'left':(long(item['begin_time']) - p_begin_time) * total_bar_width / parent_time_show,
                      'middle':int((long(item['end_time']) - long(item['begin_time'])) * 1200 / parent_time_show),
                      'url':item['url'].replace('java.lang.', ''),
                      'd_time':int(long(item['begin_time']) - p_begin_time),
                      'c_time':int(long(item['end_time']) - long(item['begin_time']))
        }, dbPersisted.query_operation(op_mode='query_transaction_real_data', low_times = low_times)(parent_audit_id))

    return template("gantt", viewmodel = result)
Exemple #2
0
def getSubItems():
    # 查询模式, 1, 表示查询明细, 0, 表示该蓝
    timeType = request.query.timeType

    # 为显示控制样式缩进用的层级标识
    nodeIndex = request.query.nodeIndex
    if len(nodeIndex) == 0 or nodeIndex < 0:
        nodeIndex = 0
    else:
        nodeIndex = int(nodeIndex)

    layer_no = request.query.layerno
    parent_order_nos = request.query.parentordernos
    finger_print = request.query.fingerprint
    data_time = request.query.data_time

    dbPersisted = DbPersisted()

    result = {}

    #时间下限值
    low_times = request.query.low_times
    if low_times is None or len(low_times) == 0:
        low_times = 0
    else:
        try:
            low_times = int(low_times)
        except:
            low_times = 0

    result['low_times'] = low_times
    result['finger_print'] = finger_print
    result['node_index'] = nodeIndex
    result['text_indent'] = nodeIndex * 10
    result['b_color'] = table_colors[nodeIndex%len(table_colors)]

    if timeType == '1':
        result['rows'] = dbPersisted.query_operation(op_mode="query_transaction_real_data", low_times = low_times)(finger_print)
        return template("subitem_real", viewmodle = result)
    else:
        result['rows'] = dbPersisted.query_operation(op_mode="query_transaction_data", low_times = low_times)(layer_no, parent_order_nos, finger_print, data_time)
        return template("subitem", viewmodle = result)
Exemple #3
0
def showVMStatus():

    # 传入的时间有两种,一种是单个时间,格式是%Y-%m-%d; 另一种是两个时间,格式是%Y-%m-%d %H:%M:%S
    def format_date():
        # 查询模式, 1, 表示查询明细, 0, 表示概览
        timeType = request.query.timeType
        if not timeType:
            timeType = 0

        # 概揽开始时间
        data_time = request.query.data_time
        # 详请开始时间
        start_time = request.query.start_time
        # 详情结束时间
        end_time = request.query.end_time

        start_time = int(start_time if start_time else time.time())
        end_time = int(end_time if end_time else time.time())
        data_time = int(data_time if data_time else time.time())
            
        start_time_str = datetime.datetime.fromtimestamp(start_time).strftime("%Y-%m-%d %H")
        end_time_str = datetime.datetime.fromtimestamp(end_time).strftime("%Y-%m-%d %H")
        data_time_str = datetime.datetime.fromtimestamp(data_time).strftime("%Y-%m-%d")

        return {"start_time": start_time, "s_time": start_time_str, "end_time": end_time, "e_time": end_time_str, "data_time": data_time, "d_time":data_time_str, "time_type":timeType}
    
    dbPersisted = DbPersisted()
    apps = dbPersisted.query_operation(op_mode='query_all_apps')()
    app = request.query.app
    ip = request.query.ip
    
    # model
    result={}

    if app:
        result['app'] = app
        ls = filter(lambda k : k['audit_app'] == app, apps)
        result['ip'] = ip if ip else (ls[0]['audit_ip'] if ls else (apps[0]['audit_ip'] if apps else 'N/A'))
    else:
        result["app"] = apps[0]['audit_app'] if apps else 'N/A'
        result["ip"] = ip if ip else (apps[0]['audit_ip'] if apps else 'N/A')

    # 左面应用名称
    result["left"] = Set(map(lambda a:a['audit_app'], apps))
    result["apps"] = filter(lambda x:x['audit_app'] == result['app'], apps)
        
    # start end time
    time_result = format_date()
    result["data_time"] = time_result["d_time"]
    result["start_time"] = time_result["s_time"]
    result["end_time"] = time_result["e_time"]
    result['timeType'] = time_result["time_type"]
    
    return template("vm", viewmodel = result)
Exemple #4
0
def content():

    # 传入的时间有两种,一种是单个时间,格式是%Y-%m-%d; 另一种是两个时间,格式是%Y-%m-%d %H:%M:%S
    def format_date():
        # 查询模式, 1, 表示查询明细, 0, 表示概览
        timeType = request.query.timeType

        # 概揽开始时间
        data_time = request.query.data_time
        # 详请开始时间
        start_time = request.query.start_time
        # 详情结束时间
        end_time = request.query.end_time

        start_time = int(start_time if start_time else time.time())
        end_time = int(end_time if end_time else time.time())
        data_time = int(data_time if data_time else time.time())
            
        start_time_str = datetime.datetime.fromtimestamp(start_time).strftime("%Y-%m-%d %H:%M:%S")
        end_time_str = datetime.datetime.fromtimestamp(end_time).strftime("%Y-%m-%d %H:%M:%S")
        data_time_str = datetime.datetime.fromtimestamp(data_time).strftime("%Y-%m-%d")

        return {"start_time": start_time, "s_time": start_time_str, "end_time": end_time, "e_time": end_time_str, "data_time": data_time, "d_time":data_time_str, "time_type":timeType}

    # 格式化分页信息
    def format_page():
        page = request.query.page

        if len(page) == 0 or page <= 0:
            page = 1
        else:
            page = int(page)
        offset = (page -1) * PAGE_SIZE

        return {"page":page, "offset":offset}

    # 格式化 app 信息, 默认取第一个app
    def format_app(app_ip_result):
        audit_app = request.query.audit_app

        if len(app_ip_result) > 0:
            if len(audit_app) <= 0:
                result["audit_app"] = app_ip_result[0]["audit_app"]
            else:
                result["audit_app"] = audit_app
        return

    # 格式化 app 信息, 默认取第一个app
    def format_ip(app_ip_result, app_name):
        audit_ip = request.query.audit_ip

        if len(app_ip_result) > 0:
            if len(audit_ip) <= 0:
                for audit_app_tp in app_ip_result:
                    if audit_app_tp["audit_app"] == app_name:
                        result['audit_ip'] = audit_app_tp['audit_ip']
                        break;
            else:
                result['audit_ip'] = audit_ip
        return

    dbPersisted = DbPersisted()

    # model
    result={}

    # 左面应用名称
    apps = dbPersisted.query_operation(op_mode='query_all_apps')()

    result["left"] = Set(map(lambda x:x['audit_app'], apps))
    format_app(apps)
    result["ips"] = filter(lambda x: x['audit_app'] == result['audit_app'], apps)
    format_ip(apps, result["audit_app"])

    # page info
    page_result = format_page()
    result["curpage"] = page_result["page"]
    result["prepage"] = page_result["page"] - 1 if page_result["page"] > 1 else 1
    result["afterpage"] = page_result["page"] + 1

    # start end time
    time_result = format_date()
    result["data_time"] = time_result["d_time"]
    result["start_time"] = time_result["s_time"]
    result["end_time"] = time_result["e_time"]

    #排序类型
    orderType = request.query.orderType
    if orderType == '0':
        orderType = False
        result['order_type'] = '0'
    else:
        orderType = True
        result['order_type'] = '1'

    #时间下限值
    low_times = request.query.low_times
    if low_times is None or len(low_times) == 0:
        low_times = 0
    else:
        try:
            low_times = int(low_times)
        except:
            low_times = 0

    result['low_times'] = low_times

    if(time_result["time_type"] == '1'): # 查询明细
        result['timeType'] = '1'
        # 记录集合
        result["rows"] = dbPersisted.query_operation(result["audit_ip"], result["audit_app"], result['low_times'], "query_real_data_page")(time_result["start_time"], time_result["end_time"], page_result["offset"], PAGE_SIZE, orderType)

        #记录数量
        result["rowcount"] = dbPersisted.query_operation(result["audit_ip"], result["audit_app"], result['low_times'], "query_real_data_count")(time_result["start_time"], time_result["end_time"])

        result["maxpage"] = result["rowcount"] / PAGE_SIZE + 1

        return template("ta_real", viewmodel = result)
    else:
        result['timeType'] = '0'
        # 记录集合
        result["rows"] = dbPersisted.query_operation(result["audit_ip"], result["audit_app"], result['low_times'], "query_finger_data_page")(time_result["data_time"], page_result["offset"], PAGE_SIZE, orderType)

        #记录数量
        result["rowcount"] = dbPersisted.query_operation(result["audit_ip"], result["audit_app"], result['low_times'], "query_finger_count")(time_result["data_time"])

        result["maxpage"] = result["rowcount"] / PAGE_SIZE + 1

        return template("ta", viewmodel = result)