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)
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)