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