Your goal is to implement backend JSON API for an internal tool for getting an overview on the most active users. Activity is a measure of total count of listings applied to.
The tool consists of 2 views:
This shows a list of most active users in the past week, orders them by activity and has pagination support.
Shows info for user by id:
- user details
- applied listings
- connected companies
- created listings
Info for connected resources does not need to be paginated in this view, but needs to be limited to a maximum of 5 entries.
See the assumed structure for both of the service endpoints in spec.md.
Base database structure is fixed - you may not alter the underlying table structure. See definitions in structure.sql.
There is some starting dummy data in data.sql but feel free to add more. You don't need to have your testing data in your submission. The assumption is that the service stays performant with hundreds of thousands users, companies, listings and applications.
- Before(!) coding, send us a notice of the date you estimate the task to be completed as well as how many working hours it will take. We expect this information within 24 hours after receiving the assignment;
- Show us your best code - even though it's a hypothetical scenario, build the service to be ready for production;
- Implement it as a HTTP service in NodeJS, PostgreSQL database;
- Implement both endpoints to take the arguments and return JSON with structure specified in
spec.md; - Use git and Github or Bitbucket. Share your repository URL as early as possible - we do not expect any work do be done yet upon receiving the URL;
- Include a Dockerfile;
- Test and document your work.
In case of any questions or comments send us an email.