from data_reconfiguration import reconfigure_contestants_data as rc
from data_reconfiguration import reconfigure_question_data as rcq
from data_reconfiguration import reconfigure_game_contestant_location_data as rc_game_player_loc
if __name__ == '__main__':
# Parse command line arguments
input_config, output_config = ap.argument_parser()
# Retrieve csv locations from the config
contestants_csv_location = input_config.get('files', 'contestants')
game_contestant_csv_location = input_config.get('files', 'locations')
questions_csv_location = input_config.get('files', 'questions')
trend_csv_location = input_config.get('files', 'trend')
final_results_csv_location = input_config.get('files', 'final_results')
# Request data-frame from CSVs
contestants_df = CSVReader.get_dataframe(contestants_csv_location)
game_contestant_df = CSVReader.get_dataframe(game_contestant_csv_location)
questions_df = CSVReader.get_dataframe(questions_csv_location)
trend_df = CSVReader.get_dataframe(trend_csv_location)
final_results_df = CSVReader.get_dataframe(final_results_csv_location)
# Reconfiguration
rc.generate_contestant_and_occupation(contestants_df, input_config,
output_config)
df_player_loc = rc_game_player_loc.generate_sql_statements(
game_contestant_df, input_config, output_config, rc)
# Reconfiguration of questions
rcq.generate_sql_statements(questions_df, trend_df, final_results_df,
df_player_loc, input_config, output_config)
