software-engineer-test

Overview:

1. This test is owned by Swirge and is solely used to facilitate Swirge interview process only.
2. This test covers the basics of working with NodeJS working environment, which includes a) Basic git operations b) NodeJS environment setup d) CRUD with mysql DB d) Unit test with jest
3. This test is intented to solve real life scenario with open book concepts.

Test objectives:

1. Ability to setup and run nodejs application
2. Understanding of how API works, through routing in expressjs
3. Understanding of basic error handling
4. Understanding of basic CRUD operations with mysql
5. Know how to write unit test and/or integration test

Prerequisite:

1. Have git, npm installed and running in local machine
2. Have mysql installed in local machine
3. Use node version > v14.17.2

Goals:

1. Get a list of 5 cat facts from public API
2. Assuming mysql is installed at localhost:3306, save the list to the database and get it on next load i.e. when you hit up the route, if it doesn't have any data in the database, hit up the API, else fetch from the database
3. Add the functionality to get a single record, update and delete saved record
4. Write unit test and/or integrated test for all functionalities

Steps:

1. Clone this repo
2. Fill in the blanks in code and get server up and running in local
3. Create basic implementation of CRUD operations for predefined data
4. Write test to cover server functionalities, especially API
5. Do proper error handling to tackle network issues (4xx, 5xx errors)
6. Upload the code to a repo and share the link

Bonus Tips:

1. Showcase your ability to write clean code
2. Showcase your understanding on object-oriented programming concepts using javascript
3. You may change the structure of the files to achieve the same goals
4. Using standard library will be a plus
5. Commenting your thinking flow and add function definition will be a big plus