# 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
