Developed by Rennan Ribas.
The following tools were used in the construction of the project:
- React Router Dom
- React Icons
- Axios
- Bootstrap
- Express
- Sequelize
- PostgreSQL
- Nodemon
- Dotenv
- Axios
And
Preview Rest API server (try get /todo)
Pre-requisits:
- Node.js
If you do not have, follow the instructions on this link.
Then, clone this repository
git clone https://github.com/rennanrr/api-kaffa-qualification-test.git
You have to compile and install node modules of this project into your machine:
npm install
Finally, to run in your machine:
npm start
- Validate CNPJ format (Mask) Given a string, check if it looks like a CNPJ, considering two formats: Formatted: "00.000.000/0000-00" Number only: "00000000000000"
The first exercise use a simple conditional if and regex to verify if the mask ("00.000.000/0000-00" or "00000000000000") is correct.
- Validate CNPJ digits Given a string validate if it’s a well-formed CNPJ, considering the “check digits” as defined by Receita Federal. Important: Don’t use a library. You should write the validation code.
The seccond exercise use a simple logic provided by Receita Federal, and coded by me. I had a logical support too on this classical Macoratti Example.
- Test if two rectangles intersect Considering two rectangles in a discrete grid (like pixels in a display), each defined by two points, return true if they intersect, false otherwise. Note: the points are included in the rectangle and have a dimension of 1 unit; the rectangle (0, 0; 1, 1) have an area of 4 units. A=(3,5;11,11) B=(7,2;13,7) C=(11,11;15,13) intersects(A,B)=>true intersects(A,C)=>true intersects(B,C)=>false
The Third exercise has the core on function intersects(), that basicaly take the 2 rectangles axes X and Y, sort and compare if the extreme points of retangles match, kowing in this way, if intersect or not.
Note that: In this exercise, the algorithm is enable to compare not only 2 asked intersect rectangle in the exercise, but many rectangles the user input on the list.
- Compute area of intersection between two rectangles Considering two rectangles in a discrete grid (like pixels in a display), each defined by two points, compute the area of intersection between the two. Note: the points are included in the rectangle and have a dimension of 1 unit; the rectangle (0, 0; 1, 1) have an area of 4 units. A=(3,5;11,11) B=(7,2;13,7) C=(11,11;15,13) areaOfIntersection(A,B)=15 areaOfIntersection(A,C)=1
The Fourth exercise is based on function areaOfIntersection(), that basicaly gets the rectangles sorted by axes X and Y, and with a sum and multiplication, gets the area.
Note that: in this exercise, the algorith can calculate the intersection area of many rectangles user want.
- Simple Todo List Todo list application that permits the creation and deletion of tasks (texts). The application must persist the tasks between executions; Use any storage you want: database, files, PaaS backends (Firebase, etc.);
The Fifth exercise has a half in the backend, that is a CRUD with NodeJS, Express, ORM Sequelize and PostgreSQL. With design pattern Route->Controler->Repositorie(DAO)->Model->Database.
And another half of this exercise is in the screen Todo List, that has a table with one input to delete and one input and one button to add item.
Note that: You can edit the items too, and in the same time, will save changes in the server.
- Rest Client - World Clock Application that queries a server and displays the current date/time hour in local and UTC timezones.
The Sixth exercise uses a web REST API to get information DateTime in UTC and LOCAL. This exercise is in the screen World Clock, where update time each 1 minute.
- Rest Server - World Clock REST server returning a JSON like: { "currentDateTime":"20190812T14:40Z" }
The Seventh exercise is on the backend project and you can test in this link that get the local server DateTime on UTC format, or you can use this path to get the datetime that queries the same REST API of exercise sixth, but, in this time, give back with a json by backend.
Local server time: /api/v1/date/localserver and UTC time: /api/v1/date/externalapi
- Entity Relationship Diagram - Simple Order Manager Design the model of a simple Order Manager System. The system consists of: Clients Products Orders You can draw, describe, or list the tables as SQL. Extras: SQL: list ORDERS with number of items Which indexes should be created in this model?
The Eighth exercise is a database made and tested in MySql database. The SQL query is here and in the screen Entity Relationship Diagram. Is a simple database, has some insert examples in the SQL and the solution to list ORDERS with number of items using inner join is on the page screen and on the SQL Query.
To test, you have to run MySql Server on your computer and just paste this SQL Query.