__pycache__/

classEmployee:

def__init__(self,first,last,pay):

self.first=first

self.last=last

self.pay=pay

defemail(self):

return'{}.{}@email.com'.format(self.first,self.last)

deffullname(self):

return'{} {}'.format(self.first,self.last)

def__repr__(self):

return"Employee('{}', '{}', {})".format(self.first,self.last,self.pay)

def insert_emp(emp):

pass

def get_emps_by_name(lastname):

pass

def update_pay(emp, pay):

pass

def remove_emp(emp):

pass

def update_pay(emp, pay):

with conn:

c.execute("""UPDATE employees SET pay = :pay

WHERE first = :first AND last = :last""",

{'first': emp.first, 'last': emp.last, 'pay': pay})

def remove_emp(emp):

with conn:

c.execute("DELETE from employees WHERE first = :first AND last = :last",

{'first': emp.first, 'last': emp.last})

conn=sqlite3.connect(':memory:')

c=conn.cursor()

c.execute("""CREATE TABLE employees (

)""")

definsert_emp(emp):

withconn:

c.execute("INSERT INTO employees VALUES (:first, :last, :pay)", {'first':emp.first,'last':emp.last,'pay':emp.pay})

defget_emps_by_name(lastname):

c.execute("SELECT * FROM employees WHERE last=:last", {'last':lastname})

returnc.fetchall()

defupdate_pay(emp,pay):

withconn:

c.execute("""UPDATE employees SET pay = :pay

WHERE first = :first AND last = :last""",

{'first':emp.first,'last':emp.last,'pay':pay})

defremove_emp(emp):

withconn:

c.execute("DELETE from employees WHERE first = :first AND last = :last",

{'first':emp.first,'last':emp.last})

emp_1=Employee('John','Doe',80000)

emp_2=Employee('Jane','Doe',90000)

insert_emp(emp_1)

insert_emp(emp_2)

emps=get_emps_by_name('Doe')

print(emps)

update_pay(emp_2,95000)

remove_emp(emp_1)

emps=get_emps_by_name('Doe')

print(emps)

conn.close()