ttc.py 文件源码

def createBestView(cursor, topXpercent):
    if(topXpercent < 0 or topXpercent > 100):
        print FAIL + "[TTC] ERROR: topXpercent not valid." + ENDC
        exit(-1)

    command = """
    CREATE VIEW IF NOT EXISTS 'fastest%dPercent' AS 
        select * from measurements join (
                select v2.* from (
                        select *,max(bandwidth) as maxBandwidth from variant group by measurement_id
                    ) v1 inner join variant v2 on 
                    v1.measurement_id=v2.measurement_id 
                where v2.bandwidth >= (%f * v1.maxBandwidth)
            ) fast on measurements.measurement_id = fast.measurement_id;
    """%(topXpercent, 1.0 - float(topXpercent)/100.)
    try:
        cursor.execute(command)
    except sqlite3.Error as e:
        print FAIL + "[TTC] ERROR (sql):", e.args[0], ENDC
        traceback.print_stack()   
        exit(-1)