Backend Developer Test

The Business of Fashion uses various tests to assess whether a candidate is best suited to the expectations of the role advertised and the offer given.

This test aims to demonstrate your technical skills in practice: that you can deliver a solution which implements a scalable backend architecture, that produces the right results, and that pays attention to the requirement details.

Instructions & Deliverables

Fork this repository to your account (https://help.github.com/articles/fork-a-repo/)
Read these instructions carefully first before continuing with the practical test
Read the Requirements / Story Definition and Conditions of Acceptance
Identify and write at least 5 test cases (no code necessary; Gherkin or a written list will suffice)
- Demonstrate your understanding of the Conditions of Acceptance
- Identify any appropriate edge cases
Implement the Story's functionality using the ReportYearlyCommand.php file
- Develop a solution which demonstrates your skills and strengths
- You may add/change/modify any files in the project
- You may use any tool to review/modify the associated database
- You may use any google or other references for mysql/php syntax queries
Describe how you can build a better "Product" for this coding task in SOLUTION.md and include your estimates
Create a pull request to origin repository when you are satisfied with your solution (https://help.github.com/articles/about-pull-requests/)

Other Notes

You may modify the database accordingly, however, please mention what you have done
This is not a full Symfony framework app so some components are missing - you can add any components you might need
Please remember to demonstrate your skills and how you would normally approach development tasks regardless of this smaller task size.
I must ask that you time yourself so that you balance Quality and Delivery. I will not prescribe a deadline of X hours, instead, I would like you estimate the task, complete the task, and measure your elapsed time. Please submit your estimate and actual time with your code solution.

Requirements / Story Definitions

So that I can have visibility on profile performance, as a Business Analyst, I want to report the monthly views for each profile. CONDITIONS OF ACCEPTANCE (COA's)

GIVEN that there is historical data available
WHEN I execute the Yearly Views report
THEN I expect to see a monthly breakdown of the total views per profiles

GIVEN that there is historical data available
WHEN I view the Yearly Views report
THEN I expect to have the profiles names listed in alphabetical order

GIVEN that there is historical data available
WHEN I view the Yearly Views report
THEN I expect to see "n/a" when data is not available

Technical Setup

On the command prompt, run:

$> cd /path/to/the/test/folder

$> mysql -uroot -p < setup.sql

This can be used to reset the entire database if required.

$> composer install
Ensure the database schema and user is setup as per setup.sql
Execute the test:data:reset command to add the required data for the test:

$> bin/console test:data:reset
Execute the report:profiles:yearly command to see a sample output and test the environment:

$> bin/console report:profiles:yearly

You should see a list of items in the databases

Example Output