def run():
dbConn = services.getConnection()
# clear outs existing employees
services.deleteStaff(dbConn, "test1")
services.deleteStaff(dbConn, "test2")
# create a new employee
first = model.staff.StaffMember("test1", 1, True, "street", "city", "OR", "zip", "phone")
first.flush(dbConn)
# check if it is created
firstCheck = services.getStaff(dbConn, "test1")
print "created", first
print "found ", firstCheck
print "created and found ", first == firstCheck
# update employee
first.name = "test2"
first.roleId = 2
first.isActive = False
first.street = "newStreet"
first.city = "newCity"
first.state = "WA"
first.zip = "newZip"
first.phone = "newPhone"
first.flush(dbConn, "test1")
secondCheck = services.getStaff(dbConn, "test2")
print "updated", first
print "found ", secondCheck
print "updated and found ", first == secondCheck
# delete employee
services.deleteStaff(dbConn, "test2")
thirdCheck = services.getStaff(dbConn, "test2")
print "deleted and gone ", thirdCheck == None
dbConn.close()
def isNameConflict(name): """ Returns an html snipit saying whether or not there is a staff member with the same name """ result = "" connection = services.getConnection() #look for any conflict staff = services.getStaff(connection, name) #if there is a conflict return an error message if staff: result = "There is already a staff member named %s" % name return result
