steven-wagner / adattivorestserver Goto Github PK

endpoint should be {baseUrl}/new-employee/

request body should contain:

• FirstName varchar(50) not null,
  

• MiddleInitial char(1), (optional)
  

• LastName varchar(50) not null,
  

• DateOfBirth date, (optional) format for date is mm/dd/yyyy
  

• DateOfEmployment date not null, format for date is mm/dd/yyyy
  

• Status default is set to 'ACTIVE', options are 'ACTIVE' or 'INACTIVE' (optional)
  

Should return id of new employee if successful

Endpoint should be {baseUrl}/api/employee/{employee_id}

The employee_id is the id of the employee to be deleted.

Must include a valid Authorization header. For the purpose of this project the test content for the auth header will be 'password'

If validated, employee's Status column should be updated to 'INACTIVE'

Successful posts should return 201

• required fields are:

• firstName,

• LastName,

• DateOfEmployment

• FirstName and LastName can not be longer than 50 characters.

• DateOfEmployment and DateOfBirth must be in mm/dd/yyyy format.

• MiddleInital can only be 1 character and must be a letter.

• employee_id must exist
• FirstName and LastName can not be longer than 50 characters.
• DateOfEmployment and DateOfBirth must be in mm/dd/yyyy format.
• MiddleInital can only be 1 character and must be a letter.

employee_id param should correspond to an actual employee ID

employees who have their status set to 'INACTIVE' should not be gettable.

When new employee is posted validate that someone with the same exact name is not already in the list.

Perhaps send a message indicating that a person with this exact name exists and that it may be a duplicate. Give the user an option to set checkDuplicate to false;

Endpoint should be {baseUrl}/api/employee/employee_id

employee_id is the id of the user to be updated.

Request body fields (i.e anyone may update these columns) may include:

• FirstName
  

• MiddleInitial
  

• LastName
  

• DateOfBirth
  

• DateOfEmployment
  

• Status - options are 'ACTIVE' or 'INACTIVE'
  

returns 200 if success.

endpoint should be {baseUrl}/all-employees/

Should return all columns of all employees in the employees table.

endpoint should be {baseUrl}/employee/{employee_id} where the user_id is the id of the employee to be queried.

Should return all columns where employees.id = employee_id

• employee_id must exist
• employee must not already have Status: 'INACTIVE'
• Authorization header must be correct password