def writelog(s_entry="\n", s_path="S:/Logs/", s_file="Python_log_" + datetime.datetime.now().strftime("%Y%m%d") + ".txt", s_mode='a'): """ Function to create log file :param s_entry: Log file entry :param s_path: Log file path :param s_file: Log file name :param s_mode: File mode :return: Nothing """ # DECLARE VARIABLES if s_path == "": s_path = "S:/Logs/" if s_file == "": s_file = "Python_log_" + datetime.datetime.now().strftime( "%Y%m%d") + ".txt" s_project: str = "FUNCFILE:" + s_file try: with open(s_path + s_file, s_mode, encoding="utf-8") as fl: # file opened for writing. write to it here # Write the log if s_entry == "Now": fl.write("----------------\n") s_entry = datetime.datetime.now().strftime( "%Y-%m-%d %H:%M") + "\n" elif "%t" in s_entry: s_entry = s_entry.replace( "%t", datetime.datetime.now().strftime("%H:%M:%S")) s_entry += "\n" else: s_entry += "\n" fl.write(s_entry) fl.close() pass l_success = True except Exception as err: l_success = False funcsys.ErrMessage(err, funcconf.l_mail_project, "NWUIACA:Fail:" + s_project, "NWUIACA: Fail: " + s_project) return l_success
# IMPORT MODULES import C302_test_student_fee from _my_modules import funcfile from _my_modules import funcsys # OPEN THE LOG WRITER funcfile.writelog("Now") funcfile.writelog("SCRIPT: C302_TEST_STUDENT_FEE_RUN_PREV") funcfile.writelog("--------------------------------------") try: C302_test_student_fee.student_fee("prev") except Exception as e: funcsys.ErrMessage(e) # CLOSE THE LOG WRITER funcfile.writelog("Now") funcfile.writelog("COMPLETED: C302_TEST_STUDENT_FEE_RUN_PREV") funcfile.writelog("-----------------------------------------")
i_records) + " records.</b>\n\n" + s_return_message """***************************************************************************** END OF SCRIPT *****************************************************************************""" funcfile.writelog("END OF SCRIPT") if l_debug: print("END OF SCRIPT") # COMMIT DATA so_conn.commit() # CLOSE THE DATABASE CONNECTION so_conn.close() # CLOSE THE LOG WRITER funcfile.writelog("--------------------------") funcfile.writelog("COMPLETED: D001_ROBOT_NAME") return s_return_message[0:4096] if __name__ == '__main__': try: s_return = robot_name("a", "rensburg", "albert") if funcconf.l_mess_project: print("RETURN: " + s_return) print("LENGTH: " + str(len(s_return))) except Exception as e: funcsys.ErrMessage(e, funcconf.l_mess_project, "D001_robot_name", "D001_robot_name")
BEGIN OF SCRIPT *****************************************************************************""" if l_debug: print("BEGIN OF SCRIPT") funcfile.writelog("BEGIN OF SCRIPT") """ **************************************************************************** END OF SCRIPT *****************************************************************************""" if l_debug: print("END OF SCRIPT") funcfile.writelog("END OF SCRIPT") # CLOSE THE DATABASE CONNECTION so_conn.commit() so_conn.close() # CLOSE THE LOG WRITER funcfile.writelog("------------------------------------") funcfile.writelog("COMPLETED: C202_GL_TEST_TRANSACTIONS") return if __name__ == '__main__': try: gl_test_transactions() except Exception as e: funcsys.ErrMessage(e, funcconf.l_mess_project, "C202_gl_test_transactions", "C202_gl_test_transactions")
print("Inserted " + str(i_tota) + " rows...") funcfile.writelog("%t POPULATE MYSQL: " + str(i_tota) + " STUD DEBT COMPARISON rows (ia_finding_6)") # CLOSE PEOPLE DATABASE so_conn.commit() so_conn.close() """***************************************************************************** END OF SCRIPT *****************************************************************************""" print("END OF SCRIPT") funcfile.writelog("END OF SCRIPT") # CLOSE MYSQL DATABASES ms_cnxn.commit() ms_cnxn.close() # CLOSE THE LOG WRITER funcfile.writelog("---------------------------") funcfile.writelog("COMPLETED: B005_MYSQL_LISTS") return if __name__ == '__main__': try: mysql_lists("Web_ia_nwu") # mysql_lists(("Mysql_ia_server")) except Exception as e: funcsys.ErrMessage(e, funcconf.l_mess_project, "B005_mysql_lists", "B005_mysql_lists")
END OF SCRIPT *****************************************************************************""" print("END OF SCRIPT") funcfile.writelog("END OF SCRIPT") # COMMIT DATA so_conn.commit() # CLOSE THE DATABASE CONNECTION so_conn.close() # CLOSE THE LOG WRITER funcfile.writelog("------------------------------------") funcfile.writelog("COMPLETED: C200_REPORT_STUDDEB_RECON") return if __name__ == '__main__': try: # report_studdeb_recon() # 2021 balances report_studdeb_recon(65676774.13, 61655697.80, 41648563.00, "curr") # 2020 balances # report_studdeb_recon(48501952.09, -12454680.98, 49976048.39, "curr") # 2019 balances # report_studdeb_recon(66561452.48,-18340951.06,39482933.18, "prev") except Exception as e: funcsys.ErrMessage(e, funcconf.l_mess_project, "B003_vss_lists", "B003_vss_lists")
s_return_message = s_message # DELETE THE MAILED FILE if funcfile.file_delete(re_path, s_file): funcfile.writelog("%t Special investigation sir report deleted") if l_debug: print("Delete the report...") """***************************************************************************** END OF SCRIPT *****************************************************************************""" funcfile.writelog("END OF SCRIPT") if l_debug: print("END OF SCRIPT") # CLOSE THE LOG WRITER funcfile.writelog("-" * len("completed: "+s_function)) funcfile.writelog("COMPLETED: " + s_function.upper()) return s_return_message[0:4096] if __name__ == '__main__': try: s_return = robot_report_audit_sir("2022", "0", "Albert", "*****@*****.**") if funcconf.l_mess_project: print("RETURN: " + s_return) print("LENGTH: " + str(len(s_return))) except Exception as e: funcsys.ErrMessage(e, funcconf.l_mess_project, s_function, s_function)
funcmail.Mail("vss_list_idno_curr") # MESSAGE # if funcconf.l_mess_project: # funcsms.send_telegram("", "administrator", "<b>VSS STUDENT</b> master file tests end.") """***************************************************************************** End OF SCRIPT *****************************************************************************""" print("END OF SCRIPT") funcfile.writelog("END OF SCRIPT") # COMMIT DATA so_conn.commit() # CLOSE THE DATABASE CONNECTION so_conn.close() # CLOSE THE LOG WRITER funcfile.writelog("------------------------------------") funcfile.writelog("COMPLETED: C300_TEST_STUDENT_GENERAL") return if __name__ == '__main__': try: test_student_general() except Exception as e: funcsys.ErrMessage(e, funcconf.l_mess_project, "C300_test_student_general", "C300_test_student_general")
# Write the data funccsv.write_data(so_conn, "main", sr_file, sx_path, sx_file, s_head) funccsv.write_data(so_conn, "main", sr_file, sx_path, sx_file_dated, s_head) funcfile.writelog("%t EXPORT DATA: " + sx_path + sx_file_dated) """ **************************************************************************** END OF SCRIPT *****************************************************************************""" funcfile.writelog("END OF SCRIPT") if l_debug: print("END OF SCRIPT") so_conn.commit() so_conn.close() # Close the log writer ********************************************************* funcfile.writelog("-------------------------------") funcfile.writelog("COMPLETED: B006_KFS_PERIOD_LIST") return if __name__ == '__main__': try: kfs_period_list("curr") # kfs_period_list("prev") # kfs_period_list("2018") except Exception as e: funcsys.ErrMessage(e, funcconf.l_mess_project, "B006_kfs_period_list", "B006_kfs_period_list")
so_curs.execute("DROP TABLE IF EXISTS X000aa_sec_assignment_prev") s_sql = s_sql.replace("%PYEARE%", funcdate.prev_yearend()) so_curs.execute(s_sql) so_conn.commit() funcfile.writelog("%t BUILD TABLE: " + sr_file) """***************************************************************************** End OF SCRIPT *****************************************************************************""" print("END OF SCRIPT") funcfile.writelog("END OF SCRIPT") # COMMIT DATA so_conn.commit() # CLOSE THE DATABASE CONNECTION so_conn.close() # CLOSE THE LOG WRITER funcfile.writelog("-----------------------------") funcfile.writelog("COMPLETED: B004_PAYROLL_LISTS") return if __name__ == '__main__': try: payroll_lists() except Exception as e: funcsys.ErrMessage(e, funcconf.l_mess_project, "B004_payroll_lists", "B004_payroll_lists")
so_curs.execute(s_sql) so_conn.commit() funcfile.writelog("%t BUILD TABLE: X002_People_age_master") if funcconf.l_mess_project: i = funcsys.tablerowcount(so_curs, sr_file) funcsms.send_telegram("", "administrator", "<b>" + str(i) + "</b> Age groups") """ **************************************************************************** END OF SCRIPT *****************************************************************************""" print("END OF SCRIPT") funcfile.writelog("END OF SCRIPT") # CLOSE THE WORKING DATABASE so_conn.close() # CLOSE THE LOG funcfile.writelog("--------------------------------------") funcfile.writelog("COMPLETED: C003_PEOPLE_LIST_MASTERFILE") return if __name__ == '__main__': try: people_list_masterfile() except Exception as e: funcsys.ErrMessage(e, funcconf.l_mess_project, "C003_people_list_masterfile", "C003_people_list_masterfile")
funcfile.writelog("SCRIPT: A000_RUN_ALL") funcfile.writelog("--------------------") """**************************************************************************** ORACLE TO SQLITE ****************************************************************************""" if funcdate.today_dayname() in "TueWedThuFriSat": import A001_oracle_to_sqlite try: A001_oracle_to_sqlite.oracle_to_sqlite() if l_mail: funcmail.Mail('std_success_gmail', 'NWUIAPython:Success:A001_oracle_to_sqlite', 'NWUIAPython: Success: A001_oracle_to_sqlite') except Exception as e: funcsys.ErrMessage(e, l_mail, 'NWUIAPython:Fail:A001_oracle_to_sqlite', 'NWUIAPython: Fail: A001_oracle_to_sqlite') else: print("ORACLE to SQLITE do not run on Sundays and Mondays") funcfile.writelog( "SCRIPT: A001_ORACLE_TO_SQLITE: DO NOT RUN ON SUNDAYS AND MONDAYS") """**************************************************************************** LOGS ****************************************************************************""" if funcdate.today_dayname() in "MonTueWedThuFriSatSun": import A002_log try: A002_log.log_capture(funcdate.yesterday(), True) if l_mail: funcmail.Mail('std_success_gmail', 'NWUIAPython:Success:A002_log', 'NWUIAPython: Success: A002_log')
def run_scripts(s_script: str = "a003", s_parameter1: str = "", s_parameter2: str = ""): """ SCRIPT TO RUN OTHER SCRIPTS IT WILL USE GLOBAL l_run VARIABLES :param s_script: Script to run :param s_parameter1: Script first parameter :param s_parameter2: Script second parameter :return: bool: Successful or not """ # VARIABLES l_return = False l_debug = True # DEBUG if l_debug: print("SCRIPT: " + s_script) print("PARAM1: " + s_parameter1) print("PARAM2: " + s_parameter2) # SWITCH ON funcconf.l_run_system = True if s_script in "all|data|kfs": funcconf.l_run_kfs_test = True elif s_script in "all|data|people": funcconf.l_run_people_test = True elif s_script in "all|data|vss": funcconf.l_run_vss_test = True # GENERAL GROUP **************************************************************** # UPDATE LOG s_project: str = "A002_log" if s_script in "a002|all|general": import A002_log try: if s_script == 'a002' and s_parameter1[0:1] == 'y': A002_log.log_capture(funcdate.yesterday(), True) elif s_script == 'all': A002_log.log_capture(funcdate.yesterday(), True) elif s_script == 'general': A002_log.log_capture(funcdate.yesterday(), True) else: A002_log.log_capture(funcdate.today(), False) l_return = True if funcconf.l_mail_project: funcmail.Mail('std_success_gmail', 'NWUIACA:Success:' + s_project, 'NWUIACA: Success: ' + s_project) except Exception as err: l_return = False funcsys.ErrMessage(err, funcconf.l_mail_project, 'NWUIACA:Fail:' + s_project, 'NWUIACA: Fail: ' + s_project) # VACUUM TEST FINDING TABLES s_project: str = "A003_table_vacuum" if s_script in "a003|all|general": import A003_table_vacuum try: A003_table_vacuum.table_vacuum() l_return = True if funcconf.l_mail_project: funcmail.Mail('std_success_gmail', 'NWUIACA:Success:' + s_project, 'NWUIACA: Success: ' + s_project) except Exception as err: l_return = False funcsys.ErrMessage(err, funcconf.l_mail_project, 'NWUIACA:Fail:' + s_project, 'NWUIACA: Fail: ' + s_project) # BACKUP MYSQL s_project: str = "B008_mysql_backup" if s_script in "b008|all|general": import B008_mysql_backup try: l_return = B008_mysql_backup.mysql_backup() if l_return: if funcconf.l_mail_project: funcmail.Mail('std_success_gmail', 'NWUIACA:Success:' + s_project, 'NWUIACA: Success: ' + s_project) else: if funcconf.l_mail_project: funcmail.Mail('std_success_gmail', 'NWUIACA:Fail:' + s_project, 'NWUIACA: Fail: ' + s_project) except Exception as err: l_return = False funcsys.ErrMessage(err, funcconf.l_mail_project, 'NWUIACA:Fail:' + s_project, 'NWUIACA: Fail: ' + s_project) # IMPORT TEMP s_project: str = "A001_oracle_to_sqlite(temp)" if s_script in "a001": if s_script == "a001" and s_parameter1[0:1] == "t": import A001_oracle_to_sqlite try: A001_oracle_to_sqlite.oracle_to_sqlite() l_return = True if funcconf.l_mail_project: funcmail.Mail('std_success_gmail', 'NWUIACA:Success:' + s_project, 'NWUIACA: Success: ' + s_project) except Exception as err: l_return = False funcsys.ErrMessage(err, funcconf.l_mail_project, "NWUIACA:Fail:" + s_project, "NWUIACA: Fail: " + s_project) # PEOPLE GROUP ***************************************************************** # IMPORT PEOPLE s_project: str = "A001_oracle_to_sqlite(people)" if s_script in "a001|all|data|people": if (s_script == "a001" and s_parameter1 == "people") or (s_script in "all|data|people"): import A001_oracle_to_sqlite try: A001_oracle_to_sqlite.oracle_to_sqlite( "000b_Table - people.csv", "PEOPLE") l_return = True if funcconf.l_mail_project: funcmail.Mail('std_success_gmail', 'NWUIACA:Success:' + s_project, 'NWUIACA: Success: ' + s_project) except Exception as err: l_return = False funcconf.l_run_people_test = False funcsys.ErrMessage(err, funcconf.l_mail_project, "NWUIACA:Fail:" + s_project, "NWUIACA: Fail: " + s_project) # PEOPLE MASTER LISTS s_project: str = "B001_people_lists" if funcconf.l_run_people_test: if s_script in "b001|all|people": import B001_people_lists try: B001_people_lists.people_lists() l_return = True if funcconf.l_mail_project: funcmail.Mail('std_success_gmail', 'NWUIACA:Success:' + s_project, 'NWUIACA: Success: ' + s_project) except Exception as err: l_return = False funcconf.l_run_people = False funcsys.ErrMessage(err, funcconf.l_mail_project, "NWUIACA:Fail:" + s_project, "NWUIACA: Fail: " + s_project) # PEOPLE LISTS s_project: str = "C003_people_list_masterfile" if funcconf.l_run_people_test: if s_script in "c003|all|people": import C003_people_list_masterfile try: C003_people_list_masterfile.people_list_masterfile() l_return = True if funcconf.l_mail_project: funcmail.Mail('std_success_gmail', 'NWUIACA:Success:' + s_project, 'NWUIACA: Success: ' + s_project) except Exception as err: l_return = False funcconf.l_run_people = False funcsys.ErrMessage(err, funcconf.l_mail_project, "NWUIACA:Fail:" + s_project, "NWUIACA: Fail: " + s_project) # PEOPLE TEST MASTER FILE s_project: str = "C001_people_test_masterfile" if funcconf.l_run_people_test: if s_script in "c001|all|people": import C001_people_test_masterfile try: C001_people_test_masterfile.people_test_masterfile() l_return = True if funcconf.l_mail_project: funcmail.Mail('std_success_gmail', 'NWUIACA:Success:' + s_project, 'NWUIACA: Success: ' + s_project) except Exception as err: l_return = False funcconf.l_run_people = False funcsys.ErrMessage(err, funcconf.l_mail_project, "NWUIACA:Fail:" + s_project, "NWUIACA: Fail: " + s_project) # PEOPLE TEST CONFLICT s_project: str = "C002_people_test_conflict" if funcconf.l_run_people_test: if s_script in "c002|all|people": import C002_people_test_conflict try: C002_people_test_conflict.people_test_conflict() l_return = True if funcconf.l_mail_project: funcmail.Mail('std_success_gmail', 'NWUIACA:Success:' + s_project, 'NWUIACA: Success: ' + s_project) except Exception as err: l_return = False funcconf.l_run_people = False funcsys.ErrMessage(err, funcconf.l_mail_project, "NWUIACA:Fail:" + s_project, "NWUIACA: Fail: " + s_project) # PEOPLE PAYROLL LISTS if s_script in "b004|all|people": import B004_payroll_lists s_project: str = "B004_payroll_lists" try: B004_payroll_lists.payroll_lists() l_return = True if funcconf.l_mail_project: funcmail.Mail('std_success_gmail', 'NWUIACA:Success:' + s_project, 'NWUIACA: Success: ' + s_project) except Exception as err: l_return = False funcsys.ErrMessage(err, funcconf.l_mail_project, 'NWUIACA:Fail:' + s_project, 'NWUIACA: Fail: ' + s_project) # VSS GROUP ******************************************************************** # IMPORT VSS s_project: str = "A001_oracle_to_sqlite(vss)" if s_script in "a001|all|data|vss": if (s_script == "a001" and s_parameter1 == "vss") or (s_script in "all|data|vss"): import A001_oracle_to_sqlite try: A001_oracle_to_sqlite.oracle_to_sqlite("000b_Table - vss.csv", "VSS") l_return = True if funcconf.l_mail_project: funcmail.Mail('std_success_gmail', 'NWUIACA:Success:' + s_project, 'NWUIACA: Success: ' + s_project) except Exception as err: l_return = False funcconf.l_run_vss_test = False funcsys.ErrMessage(err, funcconf.l_mail_project, "NWUIACA:Fail:" + s_project, "NWUIACA: Fail: " + s_project) # VSS LISTS s_project: str = "B003_vss_lists" if funcconf.l_run_vss_test: if s_script in "b003|all|vss": import B003_vss_lists try: B003_vss_lists.vss_lists() l_return = True if funcconf.l_mail_project: funcmail.Mail('std_success_gmail', 'NWUIACA:Success:' + s_project, 'NWUIACA: Success: ' + s_project) except Exception as err: l_return = False funcconf.l_run_vss = False funcsys.ErrMessage(err, funcconf.l_mail_project, "NWUIACA:Fail:" + s_project, "NWUIACA: Fail: " + s_project) # VSS PERIOD LISTS s_project: str = "B007_vss_period_list" if funcconf.l_run_vss_test: if s_script in "b007|all|vss": if s_script != "b007": s_parameter1 = "curr" if (s_parameter1 in "curr|prev") or (2015 <= int(s_parameter1) <= int(funcdate.cur_year()) - 2): import B007_vss_period_list try: B007_vss_period_list.vss_period_list(s_parameter1) l_return = True if funcconf.l_mail_project: funcmail.Mail('std_success_gmail', 'NWUIACA:Success:' + s_project, 'NWUIACA: Success: ' + s_project) except Exception as err: l_return = False funcconf.l_run_vss = False funcsys.ErrMessage(err, funcconf.l_mail_project, "NWUIACA:Fail:" + s_project, "NWUIACA: Fail: " + s_project) # VSS STUDENT DEFERMENT MASTER LISTS s_project: str = "C301_report_student_deferment" if funcconf.l_run_vss_test: if s_script in "c301|all|vss": if s_script != "c301": s_parameter1 = "curr" if (s_parameter1 in "curr|prev") or (2015 <= int(s_parameter1) <= int(funcdate.cur_year()) - 2): import C301_report_student_deferment try: C301_report_student_deferment.studdeb_deferments( s_parameter1) l_return = True if funcconf.l_mail_project: funcmail.Mail('std_success_gmail', 'NWUIACA:Success:' + s_project, 'NWUIACA: Success: ' + s_project) except Exception as err: l_return = False funcconf.l_run_vss = False funcsys.ErrMessage(err, funcconf.l_mail_project, "NWUIACA:Fail:" + s_project, "NWUIACA: Fail: " + s_project) # # VSS STUDENT DEFERMENT MASTER LISTS s_project: str = "C301_report_student_deferment" if funcconf.l_run_vss_test: if s_script in "c301|all|vss": if s_script != "c301": s_parameter1 = "curr" if (s_parameter1 in "curr|prev") or (2015 <= int(s_parameter1) <= int(funcdate.cur_year()) - 2): import C301_report_student_deferment try: C301_report_student_deferment.studdeb_deferments( s_parameter1) l_return = True if funcconf.l_mail_project: funcmail.Mail('std_success_gmail', 'NWUIACA:Success:' + s_project, 'NWUIACA: Success: ' + s_project) except Exception as err: l_return = False funcconf.l_run_vss = False funcsys.ErrMessage(err, funcconf.l_mail_project, "NWUIACA:Fail:" + s_project, "NWUIACA: Fail: " + s_project) # VSS STUDENT DEFERMENT MASTER LISTS s_project: str = "C301_report_student_deferment" if funcconf.l_run_vss_test: if s_script in "c301|all|vss": if s_script != "c301": s_parameter1 = "curr" if (s_parameter1 in "curr|prev") or (2015 <= int(s_parameter1) <= int(funcdate.cur_year()) - 2): import C301_report_student_deferment try: C301_report_student_deferment.studdeb_deferments( s_parameter1) l_return = True if funcconf.l_mail_project: funcmail.Mail('std_success_gmail', 'NWUIACA:Success:' + s_project, 'NWUIACA: Success: ' + s_project) except Exception as err: l_return = False funcconf.l_run_vss = False funcsys.ErrMessage(err, funcconf.l_mail_project, "NWUIACA:Fail:" + s_project, "NWUIACA: Fail: " + s_project) # VSS STUDENT DEBTOR RECON s_project: str = "C200_report_studdeb_recon" if funcconf.l_run_vss_test: if s_script in "c200|all|vss": if s_script != "c200": s_parameter1 = "curr" # No open balances # r_maf = 0 # r_pot = 0 # r_vaa = 0 # 2020 balances r_maf = 48501952.09 r_pot = -12454680.98 r_vaa = 49976048.39 # 2019 balances # r_maf = 66561452.48 # r_pot = -18340951.06 # r_vaa = 39482933.18 else: r_maf = 0 r_pot = 0 r_vaa = 0 if s_parameter1 in "curr|prev": import C200_report_studdeb_recon try: C200_report_studdeb_recon.report_studdeb_recon( r_maf, r_pot, r_vaa, s_parameter1) l_return = True if funcconf.l_mail_project: funcmail.Mail('std_success_gmail', 'NWUIACA:Success:' + s_project, 'NWUIACA: Success: ' + s_project) except Exception as err: l_return = False funcconf.l_run_vss = False funcsys.ErrMessage(err, funcconf.l_mail_project, "NWUIACA:Fail:" + s_project, "NWUIACA: Fail: " + s_project) # VSS STUDENT MASTER FILE TESTS s_project: str = "C300_test_student_general" if funcconf.l_run_vss_test: if s_script in "c300|all|vss": import C300_test_student_general try: C300_test_student_general.test_student_general() l_return = True if funcconf.l_mail_project: funcmail.Mail('std_success_gmail', 'NWUIACA:Success:' + s_project, 'NWUIACA: Success: ' + s_project) except Exception as err: l_return = False funcconf.l_run_vss = False funcsys.ErrMessage(err, funcconf.l_mail_project, "NWUIACA:Fail:" + s_project, "NWUIACA: Fail: " + s_project) # VSS STUDENT FEE TESTS AND REPORTS s_project: str = "C302_test_student_fee" if funcconf.l_run_vss_test: if s_script in "c302|all|vss": if s_script != "c302": s_parameter1 = "curr" if s_parameter1 in "curr|prev": import C302_test_student_fee try: C302_test_student_fee.student_fee(s_parameter1) l_return = True if funcconf.l_mail_project: funcmail.Mail('std_success_gmail', 'NWUIACA:Success:' + s_project, 'NWUIACA: Success: ' + s_project) except Exception as err: l_return = False funcconf.l_run_vss = False funcsys.ErrMessage(err, funcconf.l_mail_project, "NWUIACA:Fail:" + s_project, "NWUIACA: Fail: " + s_project) # KFS GROUP ******************************************************************** # IMPORT KFS s_project: str = "A001_oracle_to_sqlite(kfs)" if (s_script == "a001" and s_parameter1 == "kfs") or (s_script in "all|data|kfs"): import A001_oracle_to_sqlite try: A001_oracle_to_sqlite.oracle_to_sqlite("000b_Table - kfs.csv", "KFS") l_return = True if funcconf.l_mail_project: funcmail.Mail('std_success_gmail', 'NWUIACA:Success:' + s_project, 'NWUIACA: Success: ' + s_project) except Exception as err: l_return = False funcconf.l_run_kfs_test = False funcsys.ErrMessage(err, funcconf.l_mail_project, "NWUIACA:Fail:" + s_project, "NWUIACA: Fail: " + s_project) # KFS PERIOD LISTS s_project: str = "B006_kfs_period_list" if funcconf.l_run_kfs_test: if s_script in "b006|all|kfs": if s_script != "b006": s_parameter1 = "curr" if (s_parameter1 in "curr|prev") or (2015 <= int(s_parameter1) <= int(funcdate.cur_year()) - 2): import B006_kfs_period_list try: B006_kfs_period_list.kfs_period_list(s_parameter1) l_return = True if funcconf.l_mail_project: funcmail.Mail('std_success_gmail', 'NWUIACA:Success:' + s_project, 'NWUIACA: Success: ' + s_project) except Exception as err: l_return = False funcconf.l_run_kfs = False funcsys.ErrMessage(err, funcconf.l_mail_project, "NWUIACA:Fail:" + s_project, "NWUIACA: Fail: " + s_project) return l_return
# MESSAGE if l_mess: funcsms.send_telegram( "", "administrator", "Finished <b>" + s_function.upper() + "</b> tests.") """ **************************************************************************** END OF SCRIPT *****************************************************************************""" funcfile.writelog("END OF SCRIPT") if l_debug: print("END OF SCRIPT") # CLOSE THE DATABASE CONNECTION so_conn.commit() so_conn.close() # CLOSE THE LOG funcfile.writelog("-" * len("completed: " + s_function)) funcfile.writelog("COMPLETED: " + s_function.upper()) return if __name__ == '__main__': try: people_test_masterfile_xdev() except Exception as e: funcsys.ErrMessage(e, funcconf.l_mess_project, "C001_people_test_masterfile_xdev", "C001_people_test_masterfile_xdev")
YEAR Desc ;""" so_curs.execute("DROP TABLE IF EXISTS " + sr_file) so_curs.execute(s_sql) so_conn.commit() funcfile.writelog("%t BUILD TABLE: " + sr_file) """ **************************************************************************** END OF SCRIPT *****************************************************************************""" print("END OF SCRIPT") funcfile.writelog("END OF SCRIPT") # CLOSE THE DATABASE CONNECTION so_conn.commit() so_conn.close() # CLOSE THE LOG WRITER ********************************************************* funcfile.writelog("--------------------------------") funcfile.writelog("COMPLETED: REPORT_VSS_DEFERMENTS") return if __name__ == '__main__': try: studdeb_deferments() except Exception as e: funcsys.ErrMessage(e, funcconf.l_mess_project, "C301_report_student_deferment", "C301_report_student_deferment")