# encoding:UTF-8 from Employee import Employee emp = Employee("faker",1000) emp.displayCount() emp.displayEmployee() # 添加,删除,修改类的属性 emp.age = 22 # 添加一个 'age' 属性 emp.age = 12 # 修改 'age' 属性 del emp.age # 删除 'age' 属性 """ getattr(obj, name[, default]) : 访问对象的属性。 hasattr(obj,name) : 检查是否存在一个属性。 setattr(obj,name,value) : 设置一个属性。如果属性不存在,会创建一个新属性。 delattr(obj, name) : 删除属性。 """ print(hasattr(emp, 'age')) # 如果存在 'age' 属性返回 True。 setattr(emp, 'age', 22) # 添加属性 'age' 值为 8 print(hasattr(emp, 'age')) # 如果存在 'age' 属性返回 True。 print(getattr(emp, 'age')) # 返回 'age' 属性的值 delattr(emp, 'age') # 删除属性 'age' print(hasattr(emp, 'age')) # 如果存在 'age' 属性返回 True。
def Add_Employee_csv(path_file): import csv import re # pattern to check the validity of the data pattern_ID = "\d{9}" pattern_name = "\w+\s+\w" pattern_age = "\d" pattern_phone_number = "\d{10}" # print("this function used to read from csv files. delimiter is ,") with open(path_file, "r") as csv_file: csv_read = csv.reader(csv_file, delimiter=",") line = 0 for row in csv_read: if line == 0: print(f'Column names are {", ".join(row)}') line += 1 else: line += 1 if row[0] and re.search(pattern_ID, row[0]): emp = [] try: conn = sqlite3.connect('TryEmp.db') c = conn.cursor() SelectStatement = c.execute( '''SELECT * FROM employees ''') for R in SelectStatement: emp.append(R[0]) except Exception as e: print(e) finally: conn.close a = str(row[0]) # check whether employee already exists if a in emp: print("Employee already exists") else: ID_number = Employee() ID_number.ID = str(row[0]) if row[1] and re.search(pattern_name, row[1]): ID_number.name = str(row[1]) else: print("Employee's name is missing or not valid") if row[2] and re.search(pattern_age, row[2]): ID_number.age = str(row[2]) else: print("Employee's age is missing or not valid") if row[3] and re.search(pattern_phone_number, row[3]): ID_number.phone_number = str(row[3]) else: print( "Employee's phone_number is missing or not valid" ) check = ID_number.no_missing_data() if check == True: # insert into database try: conn = sqlite3.connect('TryEmp.db') c = conn.cursor() InsertStatement = "INSERT INTO employees VALUES(?,?,?,?)" values = [] values.append( (str(ID_number.ID), str(ID_number.name), str(ID_number.age), str(ID_number.phone_number))) c.executemany(InsertStatement, values) conn.commit() except Exception as e: print(e) finally: conn.close() n = str(ID_number.ID) EmpListSTR.append(n) EmpList = [] EmpList.append(ID_number) print("Employee successfully added")
from Employee import Employee emp1 = Employee("Ava", 2000) emp2 = Employee("Emma", 3000) print Employee.empCount print emp1.name print emp2.name print emp1.displayEmployee() print emp2.displayEmployee() emp1.age = 8 print emp1.age emp1.age = 7 emp2.age = 9 print emp1.age print emp2.age del emp1.age del emp2.age