Beispiel #1
0
def fix_file():
    people_map_dict={}
    people_map_dict = identity.people_mapping_init()

    spamReader = csv.reader(open(config.io_betweenness_file, 'rb'),delimiter='\t', quotechar='|')
    spamWriter = csv.writer(open(config.io_betweeness_output, 'w'),delimiter=',', quotechar='"')

    conn = db.get_alert_connection()
    cursor=conn.cursor()

    first = False

    for row in spamReader:
#
#        if not first:
#            first = True
#            continue

        edge_identity_id=people_map_dict[int(row[0])]
        no_edge_identity_id=people_map_dict[int(row[2])]

        edge_btness=row[1]
        no_edge_btness=row[3]


        cursor.execute("SELECT * FROM identity_csvid WHERE identity_id=%s",edge_identity_id)
        edge_row = cursor.fetchone()

        cursor.execute("SELECT * FROM identity_csvid WHERE identity_id=%s",no_edge_identity_id)
        no_edge_row = cursor.fetchone()

        spamWriter.writerow([
            edge_row[0],
            edge_row[1],
            edge_btness,
            edge_row[2],
            edge_row[3],
            no_edge_row[0],
            no_edge_row[1],
            no_edge_btness,
            no_edge_row[2],
            no_edge_row[3]
            ])

    cursor.close()
    conn.close()
    # Go over the enabled metrics and create the heading
    for metric_name, values in metrics.iteritems():

        if values[0] >= 1:
            bugAWriter.writelines("@ATTRIBUTE %s NUMERIC\n" % metric_name)



    bugAWriter.writelines("@ATTRIBUTE betweeness NUMERIC\n")
    bugAWriter.writelines("\n@DATA\n")



    people_map_dict={}
    people_map_dict = identity.people_mapping_init()

    alert_conn = db.get_alert_connection()
    spamReader = csv.reader(open(config.io_betweenness_file, 'rb'),delimiter='\t', quotechar='|')

    for row in spamReader:

        identity_id=people_map_dict[int(row[0])]
        btness=row[1]

        #tdesc = "select m.id,quantity,m.identity_id,created_at from scm_activity_metric as scm inner join metric_quantitative as mq on scm.id=mq.id inner join metric as m on scm.id=m.id where m.identity_id='"+str(identity_id)+"' order by quantity desc limit 1;"

        result =[]
        result.append(identity_id)

        for metric_name, values in metrics.iteritems():
    # Go over the enabled metrics and create the heading
    for metric_name, values in metrics.iteritems():

        if values[0] >= 1:
            bugAWriter.writelines("@ATTRIBUTE %s NUMERIC\n" % metric_name)



    bugAWriter.writelines("@ATTRIBUTE betweeness NUMERIC\n")
    bugAWriter.writelines("\n@DATA\n")



    people_map_dict={}
    people_map_dict = identity.people_mapping_init()

    alert_conn = db.get_alert_connection()
    spamReader = csv.reader(open(config.io_betweenness_file, 'rb'),delimiter='\t', quotechar='|')

    for row in spamReader:

        identity_id=people_map_dict[int(row[0])]
        btness=row[1]

        #tdesc = "select m.id,quantity,m.identity_id,created_at from scm_activity_metric as scm inner join metric_quantitative as mq on scm.id=mq.id inner join metric as m on scm.id=m.id where m.identity_id='"+str(identity_id)+"' order by quantity desc limit 1;"

        result =[]
        result.append(identity_id)

        for metric_name, values in metrics.iteritems():