Backend Engineer Interview Project

High level spec

Your task is to build a REST API using TypeScript with Node.js that returns data from sqlite database.

The database.sqli file is a database that includes 3 tables:

• users - each row represnts a single user
• albums - albums of a user
• images - images of an album

The entities_sample.txt file includes the structure of the tables and sample data of each table.

The API should have the following endpoints:

• Get User by user Id
• Get User and Albums by user Id
• Get Albums and Images by user Id
  • Endpoint should include support for pagination
  • Endpoint should include support for sorting by album title

---

How to share your results?

• Clone this repository to your private account.
• .... develop .....
• Once you are ready, create a pull request from your private repo and branch to the original repository.

Evaluation:

• There should be at least one test written and the README file should include instructions on how to execute it.
• You should provide clear documentation of the API, you can use Swagger or any other format.
• The app should build without errors (typically using npm run build). If there are necessary steps required to get it to compile, those should be covered in the README.md.
• No crashes or bugs.
• Code is easily understood and communicative (eg. comments, variable names, etc).
• Everything that you decide to not do due to the limitation of time should be documented in the README.
• GitHub commit history is consistent, easy to follow and understand.

To run application:

• npm install
• npm start