def getHighestSalary(l): """Returns the employee in l with the highest salary""" highest = Employee("Test", "Test", "test", 0) for e in l: if e.getSalary() > highest.getSalary(): highest = e return e
def __init__(self, firstname, lastname, socialSecurity, salary, title, bonus): """ Sets firstname, lastname, SSN, salary, title and bonus. """ Employee.__init__(self, firstname, lastname, socialSecurity, salary) self.title = title self.bonus = bonus
class TestEmployee(unittest.TestCase): def setUp(self): self.employee = Employee('Joe', 'Blow', 100000) def test_give_default_raise(self): self.employee.give_raise() self.assertEqual(self.employee.salary, 105000) def test_give_custom_raise(self): self.employee.give_raise(17000) self.assertEqual(self.employee.salary, 117000)
class EmployeeTestCase(unittest.TestCase): def setUp(self): self.test_emp = Employee("Dan", "Gaylord", 60000) self.amount = 10000 def test_give_default_raise(self): self.test_emp.give_raise() self.assertEqual(self.test_emp.salary, 65000) def test_give_custom_raise(self): self.test_emp.give_raise(self.amount) self.assertEqual(self.test_emp.salary, 70000)
class TestEmployee(unittest.TestCase): def setUp(self): """Create default employee instance.""" self.employee = Employee('zheng hong', 'tan', 7000) def test_give_default_raise(self): self.employee.give_raise() self.assertEqual(12000, self.employee.annual_salary) def test_give_custom_raise(self): self.employee.give_raise(400) self.assertEqual(7400, self.employee.annual_salary)
def init_table(self): self.cursor = self.db.cursor() columns = Employee().to_dict() del columns['id'] request = 'CREATE TABLE IF NOT EXISTS employees ' request += "(id INTEGER PRIMARY KEY UNIQUE" for column, value in columns.items(): request += ', ' + column + ' ' + \ sql_types[type(value).__name__] request += ")" self.cursor.execute(request) self.db.commit()
def __init__(self, title, annualBonus): """ Sets the employee default values, title, and annual bonus. It also checks to see if values are valid and sets them to default values if they aren't. """ Employee.__init__(self, "Generic First Name", "Generic Last Name", 123456789, 60000) if type(title) == str: self.title = title else: self.title = "Head Manager" if type(annualBonus) == int or type(annualBonus) == float: self.annualBonus = annualBonus else: self.annualBonus = 5000.0
class TestEmployeeSalary(unittest.TestCase): """Tests for the class employee.py""" def setUp(self): """Create instance of class""" self.my_employee = Employee('Joel', 'Kitchen', 10000) def test_give_default_raise(self): """Tests employee gets default raise""" self.my_employee.give_raise() self.assertEqual(15000, self.my_employee.annual_salary) def test_give_custom_raise(self,raise_amount=10000): """Tests employee gets custom raise""" self.my_employee.give_raise(raise_amount) self.assertEqual(20000, self.my_employee.annual_salary)
def load_employees(self, filters = None, #sorting = 'id', first_index = 0, last_index = 10000): limit = last_index - first_index + 1 offset = first_index columns = Employee().to_dict().keys() request = 'SELECT ' for column in columns: request += column + ', ' request = request[0:-2] + ' FROM employees ' if filters != None and len(filters) != 0: request = request + 'WHERE ' for key in filters.keys(): request += key + ' = ' + self.f + ' AND ' request = request[0:-5] #request += ' ORDER BY ' + sorting #request += ' LIMIT ' + str(limit) #request += ' OFFSET ' + str(offset) try: if filters != None and len(filters) != 0: self.cursor.execute(request, filters.values()) else: self.cursor.execute(request) rows = self.cursor.fetchall() except Exception as e: print traceback.format_exc() print e rows = [] employees = [] for row in rows: values_dict = {} for i in xrange(len(columns)): values_dict[columns[i]] = row[i] employee = Employee() employee.set_values(values_dict) employees.append(employee) return employees
def getCrew(self, date, shift, satisfactory): employees = [] list = Constrain.query(Constrain.constrainDate == date, Constrain.ShiftType == shift, Constrain.constrainKind == satisfactory).fetch() if list: for l in list: shiftHead = Employee.getEmployeeByUserName(l.employeeUN) if shiftHead: employees.append(shiftHead.userName) return employees else: return None
class TestEmployee(unittest.TestCase): """Test for the class Employee.""" def setUp(self): """ Create an employee for use in all test methods """ self.employee = Employee("Test", "Testerson", 30000) def test_give_default_raise(self): """Test give_raise method with default value.""" current_salary = self.employee.salary self.employee.give_raise() self.assertEqual(current_salary + 5000, self.employee.salary) def test_give_custom_raise(self): """Test give_raise method with custom value.""" custom_raise = 10000 current_salary = self.employee.salary self.employee.give_raise(custom_raise) self.assertEqual(current_salary + custom_raise, self.employee.salary)
class Employee_test(unittest.TestCase): def setUp(self): self.employee = Employee() def set_values_tests(self): values = {'id' : 10, 'name' : 'John', 'age' : 30} self.employee.set_values(values) assert self.employee.id == values['id'] assert self.employee.name == values['name'] assert self.employee.age == values['age'] values2 = self.employee.to_dict() for key in values.keys(): assert values[key] == values2[key] def add_working_seconds_test(self): hours = 5 seconds = hours * 60 * 60 self.employee.add_working_seconds(seconds) self.employee.add_working_seconds(seconds) assert self.employee.get_working_hours(utils.current_month()) == hours * 2 assert self.employee.get_working_hours('01 1999') == 0
def setUp(self): """ Create an employee for use in all test methods """ self.employee = Employee("Test", "Testerson", 30000)
'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 }) #c.execute("""CREATE TABLE employees(first text,last text,pay integer)""") emp_1 = Employee('John', 'Doe', 80000) emp_2 = Employee('Jane', 'Doe', 90000) #c.execute("insert into employees values('shivam','puri',100000)") #c.execute("insert into employees values(?,?,?)",(emp_1.first,emp_1.last,emp_1.pay)) #one way #conn.commit() #c.execute("INSERT INTO employees VALUES (:first, :last, :pay)", {'first': emp_2.first, 'last': emp_2.last, 'pay': emp_2.pay}) #another way #conn.commit() #c.execute("select * from employees where last ='puri'") #c.fetchmany(5) #print c.fetchall() #c.execute("select * from employees where last=:ls")
def setUp(self): self.snape = Employee('severus', 'snape', 100000)
class TestEmployee(unittest.TestCase): # one is before anything @classmethod def setUpClass(cls): print('setupClass') # one is after everything @classmethod def tearDownClass(cls): print('teardownClass') # before each test def setUp(self): print('setUp') self.emp_1 = Employee('Corey', 'Schafer', 50000) self.emp_2 = Employee('Sue', 'Smith', 60000) # after each test def tearDown(self): print('tearDown\n') def test_email(self): print('test_email') self.assertEqual(self.emp_1.email, '*****@*****.**') self.assertEqual(self.emp_2.email, '*****@*****.**') self.emp_1.first = 'John' self.emp_2.first = 'Jane' self.assertEqual(self.emp_1.email, '*****@*****.**') self.assertEqual(self.emp_2.email, '*****@*****.**') def test_fullname(self): print('test_fullname') self.assertEqual(self.emp_1.fullname, 'Corey Schafer') self.assertEqual(self.emp_2.fullname, 'Sue Smith') self.emp_1.first = 'John' self.emp_2.first = 'Jane' self.assertEqual(self.emp_1.fullname, 'John Schafer') self.assertEqual(self.emp_2.fullname, 'Jane Smith') def test_apply_raise(self): print('test_apply_raise') self.emp_1.apply_raise() self.emp_2.apply_raise() self.assertEqual(self.emp_1.pay, 52500) self.assertEqual(self.emp_2.pay, 63000) def test_monthly_schedule(self): with patch('employee.requests.get') as mocked_get: mocked_get.return_value.ok = True mocked_get.return_value.text = 'Success' schedule = self.emp_1.monthly_schedule('May') mocked_get.assert_called_with('http://company.com/Schafer/May') self.assertEqual(schedule, 'Success') mocked_get.return_value.ok = False schedule = self.emp_2.monthly_schedule('June') mocked_get.assert_called_with('http://company.com/Smith/June') self.assertEqual(schedule, 'Bad Response!')
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}, ) emp_1 = Employee("John", "Doe", 80000) emp_2 = Employee("Jane", "Doe", 90000) #### Vulnerable of SQL injection # c.execute( # f'INSERT INTO employees VALUES ("{emp_1.first}", "{emp_1.last}", {emp_1.pay})' # ) # c.execute( # "INSERT INTO employees VALUES (?, ?, ?)", (emp_1.first, emp_1.last, emp_1.pay) # ) # c.execute( # "INSERT INTO employees VALUES (:first, :last, :pay)", # {"first": emp_2.first, "last": emp_2.last, "pay": emp_2.pay}, # )
def setUp(self): """Create instance of class""" self.my_employee = Employee('Joel', 'Kitchen', 10000)
def setUp(self): print('setup') self.levin = Employee('levin', 'batallones', 2000000) self.martin = Employee('martin', 'briceno', 1999999) self.cristina = Employee('cristina', 'nguyen', 100000)
def setUp(self): self.emp_1 = Employee('Corey', 'Schafer', 50000) self.emp_2 = Employee('Julio', 'Cezar', 100000) print("SetUp")
class TestEmployee(unittest.TestCase): @classmethod def setUpClass(cls): print("setupclass\n") @classmethod def tearDownClass(cls): print('terDownClass') def setUp(self): self.emp_1 = Employee('Corey', 'Schafer', 50000) self.emp_2 = Employee('Julio', 'Cezar', 100000) print("SetUp") def tearDown(self): print("SetDown") def test_email(self): self.assertEqual(self.emp_1.email, '*****@*****.**') self.assertEqual(self.emp_2.email, '*****@*****.**') self.emp_1.first = 'John' self.emp_2.second = 'Jane' self.assertEqual(self.emp_1.email, '*****@*****.**') self.assertEqual(self.emp_2.email, '*****@*****.**') print("test_email") def test_fullname(self): self.assertEqual(self.emp_1.fullname, 'Corey Schafer') self.assertEqual(self.emp_2.fullname, 'Julio Cezar') self.emp_1.first = 'John' self.emp_2.second = 'Jane' self.assertEqual(self.emp_1.fullname, 'John Schafer') self.assertEqual(self.emp_2.fullname, 'Julio Jane') print("test_fullname") def test_apply_raise(self): self.emp_1.apply_raise() self.emp_2.apply_raise() self.assertEqual(self.emp_1.pay, 52500) self.assertEqual(self.emp_2.pay, 105000) print("test_apply_raise") def test_monthly_schedule_true(self): with patch('employee.requests.get') as mocked_get: mocked_get.return_value.ok = True mocked_get.return_value.text = "You answer was sent with success" schedule = self.emp_1.monthly_schedule('May') mocked_get.assert_called_with('htpp://company.com/Schafer/May') self.assertEqual(schedule, 'You answer was sent with success') def test_monthly_schedule_false(self): with patch('employee.requests.get') as mocked_get: mocked_get.return_value.ok = False schedule = self.emp_2.monthly_schedule('June') mocked_get.assert_called_with('htpp://company.com/Cezar/June') self.assertEqual(schedule, 'Bad Response!')
def test_give_default_raise(): """Test that a default raise works correctly.""" maria = Employee("Maria", "Hernandez", 5000) maria.give_raise() assert maria.salary == 10000
import csv import sys import Pyro4 import Pyro4.util from employee import Employee sys.excepthook = Pyro4.util.excepthook library = Pyro4.Proxy("PYRONAME:example.library") employee = Employee() f = open('./tasks.txt', 'r') try: reader = csv.reader(f) for row in reader: print(row) if(row[0] == 'a'): employee.add_book(row, library) #add book elif(row[0] == 'sy'): employee.select_year(row[1], row[2], library) #select book by year elif(row[0] == 'd'): employee.display(library) #display all the book elif(row[0] == 'si'): employee.select_ISBN(row[1],library) #select book by ISBN elif(row[0] == 'ol'): employee.on_loan(row[1],library) #set book on loan by ISBN elif(row[0] == 'nol'):
def test_give_custom_raise(): """Test that a custom raise works correctly.""" joe = Employee("Joe", "Mama", 5000) joe.give_raise(10000) assert joe.salary == 15000
c.execute("""UPDATE employees SET pay = :pay WHERE first = :first AND last = :last""", {'first': emp.first, 'last': emp.last, 'pay': emp.pay}) def remove_emp(emp): with conn: 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('Kim', 'Doe', 50000) insert_emp(emp_1) insert_emp(emp_2) emps = get_emps_by_name('Doe') print(emps) print("Updating emp_2's pay") print("Current pay:", emp_2.pay) update_pay(emp_2, 55555) print("Pay after update:", emp_2.pay) remove_emp(emp_1) emps = get_emps_by_name('Doe')
import sqlite3 from employee import Employee conn = sqlite3.connect("employee.db") c = conn.cursor() #..............? #c.execute("""CREATE TABLE employees( # first text, # last text, # pay integer # )""") emp1 = Employee("john","Doe",80000) emp2 = Employee("Jane","Doe",90000) print(emp1.first) print(emp1.last) print(emp1.pay) #c.execute("INSERT INTO employees VALUES('{}','{}',{})".format(emp1.first,emp1.last,emp1.pay)) c.execute("INSERT INTO employees VALUES(?,?,?)",(emp1.first,emp1.last,emp1.pay)) conn.commit() c.execute("INSERT INTO employees VALUES(:first,:last,:pay)",{'first':emp2.first,'last':emp2.last,'pay':emp2.pay}) conn.commit() #c.execute("INSERT INTO employees VALUES('balaji','sai kumar',50000)") c.execute("SELECT * FROM employees WHERE last=?",("sai kumar",)) print(c.fetchone()) c.execute("SELECT * FROM employees WHERE last=:last",{"last":"Doe"}) print(c.fetchall())
""" Test File. Testing all 3 phases of the program in different parts. I've also imported each file and the relevant classes. """ from employee import Employee from manager import Manager # Phase I testing employee = Employee("Banana", "Thompson", 645348788, 1234123) print(employee) employee.giveRaise(0.1) print(employee) # Phase II testing manager = Manager("Super Manager", 4500) manager.giveRaise(0.3) print(manager) print("\n") # Phase III testing employee1 = Employee("Mexico", "Ferrari", "123Hey", 1234123) employee2 = Employee("Max", "Power", 123098222, "meow") manager1 = Manager("Mega Manager", 7000) manager2 = Manager("Meh Manager", 2000) employeeList = [employee1, employee2, manager1, manager2] for employee in employeeList: print(employee)
def setUp(self): """Creates employee object for testing""" self.employee = Employee('Jose', 'Rivera', 23000)
def __init__(self, name, salary): Employee.__init__(self, name, salary)
def setUp(self): """Make an employee to use in tests.""" self.eric = Employee('eric', 'metthes', 65000)
def test_email(self): emp_1 = Employee('Corey', 'Schafer', 50000) emp_2 = Employee('Sue', 'Smith', 60000) self.assertEqual(emp_1.email, '*****@*****.**') self.assertEqual(emp_2.email, '*****@*****.**')
def setUp( self ): #Python doesn't usually camel case fucntion names but this is carried over from some legacy code. self.emp_1 = Employee('Corey', 'Schafer', 50000) self.emp_2 = Employee('Sue', 'Smith', 60000)
def setUp(self): print('setUp') # need to be instance attributes! self.emp_1 = Employee('Corey', 'Schafer', 50000) self.emp_2 = Employee('Sue', 'Smith', 60000)
def setUp(self): self.myEmployee = Employee('Vincent', 'Hu', 50000)
def setUp(self): print('\nsetUp') self.emp_1 = Employee('Corey', 'Schafer', 50000) self.emp_2 = Employee('Sue', 'Smith', 60000)
def setUp(self): print('setUp') self.emp_1 = Employee('Brock', 'Lesnar', 50000) self.emp_2 = Employee('John', 'Cena', 60000)
""" Tests the Employee and Manager classes """ """ Imports Employee and Manager """ from employee import Employee from manager import Manager if __name__ == "__main__": """ Defines Employees and Managers """ e1 = Employee("Jim", "Wellington III", "123-45-6789", 10000) e2 = Employee("Bob", "Connogherty", "132-42-5343", 25000) e3 = Employee("William", "Williamson", "098-76-5432", 40000) m1 = Manager("Dirk", "Dangerous", "675-01-1234", 140000000, "Executive Assistant to the CEO", 500000) m2 = Manager("John", "McCEO", "896-45-8293", 15000000000, "CEO", 8000000) company = [e1, e2, e3, m1, m2] """ Gives raises to Employees and Managers, checks if raise ratio remains the same for each after giving the raise """ for person in company: raiseAmt = .25 print("Pre-Raise > " + str(person)) preSal = person.salary person.giveRaise(raiseAmt) print("Post-Raise > " + str(person)) postSal = person.salary print( f" (Post-Raise Salary - Pre-Raise Salary) / Pre-Raise Salary == {(postSal - preSal)/preSal}" ) """ Test Run:
def setUp(self): print 'setUp' self.emp_1 = Employee('first', 'last', 50000) self.emp_2 = Employee('shayam', 'gupta', 60000)
def setUp(self): self.employee = Employee("John", "Doe", 5000)
def setUp(self): print('setUp') # runs its code before every single test self.emp_1 = Employee('Georgii', 'Ivannikov', 50000) self.emp_2 = Employee('Sange', 'Andyasha', 60000)
def add_employee(emp): conn = sqlite3.connect('employee.db') cur = conn.cursor() cur.execute("insert into employees values (?,?,?)", (emp.first, emp.last, emp.pay)) cur.execute("insert into employees values (:first,:last,:pay)", { 'first': emp_2.first, 'last': emp_2.last, 'pay': emp_2.pay }) conn.commit() conn.close() def view_table(): conn = sqlite3.connect('employee.db') cur = conn.cursor() cur.execute("select *from employees where last=?", ('mohd', )) #cur.execute("select *from employees where last=:last",{'last':'mohd'}) print(cur.fetchall()) conn.commit() conn.close() #create_table() emp_1 = Employee('Sam', 'Smith', 90000) emp_2 = Employee('Jane', 'Smith', 80000) add_employee(emp_1) view_table()
def setUp(self): self.test_emp = Employee("Dan", "Gaylord", 60000) self.amount = 10000
from employee import Employee emp_list=list() crob=Employee() prob=Employee() upob=Employee() while (True): print(''' .............................. >_ Please select the options : 1) Create Employee 2) Update Employee 3) Print All Employee 4) Exit the program ..............................\n ''') option=int(input()) if(option==1): ce=crob.createEmployee() emp_list.append(ce) elif(option==2): print(">_ Enter Employee ID to update information") emp_id=int(input()) ue=upob.updateEmployee(emp_id) for dic in emp_list: if(dic.keys() == ue.keys()): emp_list.remove(dic) emp_list.append(ue) print("\n>_UPDATED LIST :\n",emp_list) elif(option==3): prob.printEmployee(emp_list)
def __str__(self): #Converts a manager object into a string that lists out the Employee and Manager class attributes return (Employee.__str__(self)+ "\n** Manager Properties:\n** Title:.....%s\n** Bonus:.....%s" % (self.title,str(self.bonus)))
def test_giveRaiseE(self): e1 = Employee("Adam", "Smith", "123-456-7890", 80000) e1.giveRaise(5) self.assertEqual(84000, e1.salary, "Failed")
from employee import Employee print("Invoke using object") emp1 = Employee("Prasanna", "Mohanasundaram",21870,30) emp1.getInfo() emp2 = Employee("FIRSTNAME","LASTNAME",11223,99) emp2.getInfo() emp2.setInfo(55) emp2.getInfo()
#!/usr/bin/python from employee import Employee emp1 = Employee("Bob", 50000); emp2 = Employee("Mary", 60000); print emp1; print emp2; emp1.displayEmployee(); emp2.displayEmployee(); emp1.displayCount(); # Because python is dynamic and all you can add attributes to an # existing instance emp1.age = 25;
class TestEmployee(unittest.TestCase): @classmethod def setUpClass(cls): print('setupClass') @classmethod def tearDownClass(cls): print('teardownClass') def setUp(self): print('setUp') self.emp_1 = Employee('Corey', 'Schafer', 50000) self.emp_2 = Employee('Sue', 'Smith', 60000) def tearDown(self): print('tearDown\n') def test_email(self): print('test_email') self.assertEqual(self.emp_1.email, '*****@*****.**') self.assertEqual(self.emp_2.email, '*****@*****.**') self.emp_1.first = 'John' self.emp_2.first = 'Jane' self.assertEqual(self.emp_1.email, '*****@*****.**') self.assertEqual(self.emp_2.email, '*****@*****.**') def test_fullname(self): print('test_fullname') self.assertEqual(self.emp_1.fullname, 'Corey Schafer') self.assertEqual(self.emp_2.fullname, 'Sue Smith') self.emp_1.first = 'John' self.emp_2.first = 'Jane' self.assertEqual(self.emp_1.fullname, 'John Schafer') self.assertEqual(self.emp_2.fullname, 'Jane Smith') def test_apply_raise(self): print('test_apply_raise') self.emp_1.apply_raise() self.emp_2.apply_raise() self.assertEqual(self.emp_1.pay, 52500) self.assertEqual(self.emp_2.pay, 63000) def test_monthly_schedule(self): with patch('employee.requests.get') as mocked_get: mocked_get.return_value.ok = True mocked_get.return_value.text = 'Success' schedule = self.emp_1.monthly_schedule('May') mocked_get.assert_called_with('http://company.com/Schafer/May') self.assertEqual(schedule, 'Success') mocked_get.return_value.ok = False schedule = self.emp_2.monthly_schedule('June') mocked_get.assert_called_with('http://company.com/Smith/June') self.assertEqual(schedule, 'Bad Response!')
celsius = kelvin - 273.0 fahrenheit = celsius * 9 / 5 + 32 return celsius, fahrenheit c, f = calculate_temperature(340) print c, f me = Person('Tim', 'Reilly', '503 314 3771') fullname = me.full_name() print fullname from employee import Employee tim_employed = Employee('Tim', 'Reilly', '503 314 3771', 100000000) print tim_employed.salary tim_employed.give_raise(999) print tim_employed.salary print tim_employed #Files! f = open('test.txt', 'w') # w for overwrite f.write('This file is now at Galvanize') f.close()
def setUp(self): """Create default employee instance.""" self.employee = Employee('zheng hong', 'tan', 7000)
def __init__(self, name,ssn,salary,title, bonus): Employee.__init__(self, name,ssn,salary) self.title = title self.bonus = bonus
# Example retrieved from https://www.python-course.eu/python3_inheritance.php # Date retrieved: Nov 15, 2018 # Example slightly modified # More examples available here: https://pythonspot.com/polymorphism/ from person import Person from employee import Employee employees = [] employees[0] = Person("Marge", "Simpson", 36) employees[1] = Employee("Homer", "Simpson", 28, "1007") for item in employees: print(item)
def setUp(self): print('setUp') self.emp_1 = Employee('Corey', 'Schafer', 50000) self.emp_2 = Employee('Sue', 'Smith', 60000)
def is_valid_nric(nric): valid = False if len(nric) != 9: print('Length must be 9') elif nric[0] != 'S' and nric[0] != 'T': print('First character must be S or T') elif not nric[-1].isalpha(): print('Last character must be a alphabetic letter') else: valid = True return valid print(Employee('11', 'Eleven', 0)) print(Student('12', 'Twelve', 2)) empl_list = [] stud_list = [] option = 'Y' while option.upper() != 'N': valid_nric = False while not valid_nric: nric = input('Enter NRIC: ') valid_nric = is_valid_nric(nric) name = input('Enter Name: ')
def setUp(self): """ Create a set of employee record for use in all test methods. """ self.employee_survey = Employee('Saquib', 'Herman', 700000)
#!/usr/bin/python from employee import Employee emp1 = Employee("Zara", 2000) emp2 = Employee("Manni", 5000) emp1.displayEmployee() emp2.displayEmployee()
def __str__(self): """ Returns the object's data in a string. """ return Employee.__str__(self) + "Title: %s\nBonus: %s\n" %\ (self.title, self.bonus) """ Creates one employee and manager object. Calls methods on them for testing purposes. Creates list of employees and managers and sorts them in alphabetical order according to lastnames. """ if __name__ == "__main__": e1 = Employee("Jane", "Adams", "597-938-9202", 60000) print(e1) e1.giveRaise(5) print(e1) m1 = Manager("Joe", "Smith", "657-393-0191", 70000, "Supervisor", 700) print(m1) m1.giveRaise(10) print(m1) m2 = Manager("Joe", "Stuart", "697-808-978", 90766, "TL", 1000) print(m2 == m1) print(m1 < m2) print(m2 < e1)
conn = sqlite3.connect( 'employee.db' ) # If you want a fresh DB done for each run that purely lives in RAM, use ":memory: instead of 'employee.db" c = conn.cursor() # You only need to run this the first time you run the script. # c.execute("""CREATE TABLE employees ( # first text, # last text, # pay interget # )""") # 3 quotes is a docstring. # Build Python Objects emp_1 = Employee('Steve', 'asdf', 46789) emp_2 = Employee('Ben', ';lkjlka;lsk', 32123) # Inserts a data set into DB # c.execute("INSERT INTO employees VALUES(?, ?, ?)", (emp_1.first, emp_1.last, emp_1.pay)) # Note: Don't use string formatting when pushing data into your table in python # conn.commit() # Alternate Method to Insert Data # c.execute("INSERT INTO employees VALUES (:first, :last, :pay)", {'first':emp_2.first, 'last':emp_2.last, 'pay':emp_2.pay}) # conn.commit() # Hardcoded SQL Query c.execute("SELECT * FROM employees") # print(c.fetchall()) data = c.fetchall() for datum in data:
def __str__(self): """ Returns the object's data in a string. """ return Employee.__str__(self) + "Title: %s\nBonus: %s\n" %\ (self.title, self.bonus)
def setUp(self): self.emp_1 = Employee('Amaka', 'Ohiku', 150000) self.emp_2 = Employee('Sue', 'Smith', 60000)