create_mod_sheets module

create_mod_sheets.create_comparison_data(list_df, drs_df, ec2_df, drs_vols_df, ec2_vols_df, old_mod_df, old_vol_df)

Generates and returns the data to put into modification worksheets

Parameters:

  • list_df (list) – List of servers

  • drs_df (list) – DRS data

  • ec2_df (list) – EC2 data

  • drs_vols_df (list) – DRS volume data

  • ec2_vols_df (list) – EC2 volume data

  • old_mod_df (list) – Existing general modification data

  • old_vol_df (list) – Existing volume modification data

Returns:

gnrl_data, vol_data

Return type:

list, list

create_mod_sheets.get_excel_data(file_path)

Returns data from existing worksheets realted to EC2 and DRS

Parameters:

file_path (string) – path to the XLS doc

Returns:

list_df, drs_df, ec2_df, drs_vols_df, ec2_vols_df

Return type:

list, list, list, list, list

create_mod_sheets.get_existing_mod_worksheets(file_path)

Returns data from existing modification worksheets

Parameters:

file_path (string) – path to the XLS doc

Returns:

Existing data

Return type:

list

create_mod_sheets.logActions(level, short_desc, long_desc)

Formats and prints logs

Parameters:

  • level (string) – Log level (INF,ERR)

  • short_desc (string) – Short log message

  • long_desc (string) – Long log message

create_mod_sheets.update_workbook(gnrl_data, vol_data, file_path)

Updates the XLS doc with modification related info

Parameters:

  • gnrl_data (list) – General modification data

  • vol_data (list) – Volume related modification data

  • file_path (string) – Path to the XLS doc