def special_job_validate_and_verify(special_job_dict): select_sql = '''select account, special_job, special_job_code from employ''' update_sql = '''update employ set special_job_code = %s where account = %s and special_job = %s''' cursor = employ_conn.cursor() cursor.execute(select_sql) results = cursor.fetchall() with open("../log/special_job", "a") as w: for res in results: account = res[0] special_job = res[1] special_job_code = res[2] if special_job is not None and special_job != '': if special_job in special_job_dict and str(special_job_code) == special_job_dict[special_job]: print(account + '--校验通过!') elif special_job in special_job_dict and str(special_job_code) != special_job_dict[special_job]: print(account + '--代码不匹配!') cursor.execute(update_sql, (special_job_dict[special_job], account, special_job)) employ_conn.commit() w.write(account + '修改成功!\n')
def ethnicity_validate_and_verify(ethnicity_dict): select_sql = '''select username, ethnicity, ethnicity_code from student''' update_sql = '''update student set ethnicity_code = %s where username = %s and ethnicity = %s''' cursor = employ_conn.cursor() cursor.execute(select_sql) results = cursor.fetchall() # output_file = r"G:\ethnicity.txt" with open("../log/ethnicity", "a") as w: for res in results: username = res[0] ethnicity = res[1] ethnicity_code = res[2] if ethnicity is not None and ethnicity != '': if ethnicity in ethnicity_dict and str(ethnicity_code) == ethnicity_dict[ethnicity]: print(username + '--校验通过!') w.write(username + '--校验通过!\n') elif ethnicity in ethnicity_dict and str(ethnicity_code) != ethnicity_dict[ethnicity]: print(username + '--代码不匹配!') cursor.execute(update_sql, (ethnicity_dict[ethnicity], username, ethnicity)) employ_conn.commit() w.write(username + '修改成功!\n')
def industry_validate_and_verify(industry_dict): select_sql = '''select account, industry, industry_code from employ''' update_sql = '''update employ set industry_code = %s where account = %s and industry = %s''' cursor = employ_conn.cursor() cursor.execute(select_sql) results = cursor.fetchall() with open("../log/industry", "a") as w: for res in results: account = res[0] industry = res[1] industry_code = res[2] if industry is not None and industry != '': if industry in industry_dict and str( industry_code) == industry_dict[industry]: print(account + '--校验通过!') elif industry in industry_dict and str( industry_code) != industry_dict[industry]: print(account + '--代码不匹配!') cursor.execute( update_sql, (industry_dict[industry], account, industry)) employ_conn.commit() w.write(account + '修改成功!\n')
def property_validate_and_verify(property_dict): select_sql = '''select account, property, property_code from employ''' update_sql = '''update employ set property_code = %s where account = %s and property = %s''' cursor = employ_conn.cursor() cursor.execute(select_sql) results = cursor.fetchall() with open("../log/property", "a") as w: for res in results: account = res[0] property = res[1] property_code = res[2] if property is not None and property != '': if property in property_dict and str( property_code) == property_dict[property]: print(account + '--校验通过!') elif property in property_dict and str( property_code) != property_dict[property]: print(account + '--代码不匹配!') cursor.execute( update_sql, (property_dict[property], account, property)) employ_conn.commit() w.write(account + '修改成功!\n')
def political_validate_and_verify(political_dict): select_sql = '''select username, political, political_code from student''' update_sql = '''update student set political_code = %s where username = %s and political = %s''' cursor = employ_conn.cursor() cursor.execute(select_sql) results = cursor.fetchall() with open("../log/political", "a") as w: for res in results: username = res[0] political = res[1] political_code = res[2] if political is not None and political != '': if political in political_dict and str( political_code) == political_dict[political]: print(username + '--校验通过!') elif political in political_dict and str( political_code) != political_dict[political]: print(username + '--代码不匹配!') cursor.execute( update_sql, (political_dict[political], username, political)) employ_conn.commit() w.write(username + '修改成功!\n')
def addr_update(addr_type, student_code, addr, addr_code): cursor = employ_conn.cursor() if addr_type == 'enrollment_addr': update_sql = '''update student set enrollment_addr = %s, enrollment_code = %s where username = %s''' cursor.execute(update_sql, (addr, addr_code, student_code)) employ_conn.commit() # '''select account, implement_comp_addr, implement_comp_code from record''' elif addr_type == 'implement_comp_addr': update_sql = '''update record set implement_comp_code = %s where account = %s and implement_comp_addr = %s''' cursor.execute(update_sql, (addr_code, student_code, addr)) employ_conn.commit() # company_addr, company_addr_code elif addr_type == 'company_addr': update_sql = '''update employ set company_addr_code = %s where account = %s and company_addr = %s''' cursor.execute(update_sql, (addr_code, student_code, addr)) employ_conn.commit()