Example #1
0
def update_database(name, evnt, minute):

    global match_id

    db_common.start_db_connection()

    result = db_common.get_player_and_team_id(name)

    print result

    event = {}
    event['match_id'] = match_id
    event['team_id'] = int(result[1])
    event['player_id'] = int(result[0])
    event['event_time'] = minute
    event['event_type'] = evnt

    result_record = db_common.add_match_event(event)
Example #2
0
def update_susbsitution_db(outname, inname, evnt, minute):
    global match_id

    db_common.start_db_connection()

    result = db_common.get_player_and_team_id(inname)

    result1 = db_common.get_player_and_team_id(outname)

    print result
    print result1

    event = {}
    event['match_id'] = match_id
    event['team_id'] = int(result[1])
    event['player_id'] = int(result[0])
    event['player_id_out'] = int(result1[0])
    event['event_time'] = minute
    event['event_type'] = evnt

    result_record = db_common.add_match_event(event)