def test_create_tasks_for_waterfalls_Baseline(self, setup_and_teardown): description = 'Waterfall needs to be baselined' setup_and_teardown.at[0, 'Grandchild'] = 'TEST' setup_and_teardown.at[0, 'Program_Manager'] = 'Michael Howard' assert ct.create_tasks_for_waterfalls(setup_and_teardown, False) == description
def main(): # TODO Create Docstring file_yaml = read_yaml('files.yaml', './configs') project_data_filename = file_yaml['Project_Data_Spreadsheet']['filename'] # project_data_filename='All Project Data Report Metro West or Mike.xlsx' schedules_filename = file_yaml['Schedules_Spreadsheet']['filename'] budget_item_filename = file_yaml['Budget_Item_Spreadsheet']['filename'] relay_setters_filename = file_yaml['Relay_Setters_Spreadsheet']['filename'] material_data_filename = file_yaml['Material_Data_Spreadsheet']['filename'] myprojectbudgetitmes = [ '00003212', '00003201', '00003203', '00003206', '00003226' ] """ Main entry point of the app """ change_working_path('./Data') try: project_data_df = excel_to_pandas(project_data_filename, True) except: logger_obj.error('Can not find Project Data file') raise try: project_schedules_df = excel_to_pandas(schedules_filename, True) except: logger_obj.error('Can not find Schedule Data file') raise # try: # budget_item_df = excel_to_pandas(budget_item_filename) # except: # logger_obj.error('Can not find Budget Item Data file') try: relay_setters_df = excel_to_pandas(relay_setters_filename) except: logger_obj.error('Can not find Relay Setters Data file') project_schedules_all_data_df = pd.merge(project_schedules_df, project_data_df, on='PETE_ID', sort=False, how='outer') # myprojectsdf.to_csv('myprojects.csv') project_schedules_all_data_df.to_csv('scheduledf.csv') # res = Popen('tasks=$(task tag=PMH _ids) && task delete $tasks', shell=True, stdin=PIPE) # res.stdin.write(b'a\n') # res.stdin.flush() # res.stdin.close() # res = Popen('task sync', shell=True, stdin=PIPE) # res.wait() # res.stdin.close() # Return the day of the week as an integer, where Monday is 0 and Sunday is 6 # if dt.date.today().weekday() == 3: # res = Popen('tasks=$(task tag=PMH_E _ids) && task delete $tasks', shell=True, stdin=PIPE) # res.stdin.write(b'a\n') # res.stdin.flush() # res.wait() # res.stdin.close() # res = Popen('task sync', shell=True, stdin=PIPE) # res.stdin.flush() # res.wait() # res.stdin.close() # Create_tasks_for_Precon_meetings(project_schedules_all_data_df) ct.create_task_for_final_engineering_with_draft_schedules( project_schedules_all_data_df) ct.create_task_for_released_projects_missing_construnction_ready_date( project_schedules_all_data_df) ct.create_task_for_relay_settings(project_schedules_all_data_df) ct.create_tasks_for_engineering_activities_start_dates( project_schedules_all_data_df) ct.create_tasks_for_engineering_activities_finish_dates( project_schedules_all_data_df) ct.create_task_for_relay_settings(project_schedules_all_data_df) ct.create_task_for_eisd_before_energiztion(project_schedules_all_data_df) ct.create_task_for_add_wa_to_schedule(project_schedules_all_data_df, myprojectbudgetitmes) ct.create_tasks_for_waterfalls(project_schedules_all_data_df) ct.create_task_for_missing_tiers(project_schedules_all_data_df) ct.create_tasks_toa_outside_waterfalls(project_schedules_all_data_df) ct.create_tasks_toa_no_active(project_schedules_all_data_df) ct.create_tasks_construnction_summary_before_construnction_ready( project_schedules_all_data_df) ct.create_tasks_line_design_finish_after_construction_ready_date( project_schedules_all_data_df) ct.create_tasks_station_activities_conflict(project_schedules_all_data_df) res = Popen('task sync', shell=True, stdin=PIPE) res.wait() res.stdin.close() if dt.date.today().weekday() == 4: Reports.Genrate_Relay_Settings_Report(project_schedules_all_data_df, relay_setters_df) Reports.Genrate_Electrical_Prints_Report(project_schedules_all_data_df) Reports.Genrate_Physical_Prints_Report(project_schedules_all_data_df) if dt.date.today().weekday() == 4: try: material_data_df = excel_to_pandas(material_data_filename) except: logger_obj.error('Can not find Project Data file') raise Reports.Genrate_Matrial_Report(material_data_df, project_schedules_all_data_df)