114 lines
2.1 KiB
Text
114 lines
2.1 KiB
Text
|
## Sources
|
||
|
|
to integrate typeorm and generate migrations
|
||
|
|
|
||
|
|
https://dev.to/amirfakour/using-typeorm-migration-in-nestjs-with-postgres-database-3c75
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
Technical
|
||
|
|
|
||
|
|
- Start from a boiler plate with simple database:
|
||
|
|
-postgre /Typeorm/express//jest
|
||
|
|
|
||
|
|
```js
|
||
|
|
const carbonEmissionFactors = [
|
||
|
|
{
|
||
|
|
Name: "ham",
|
||
|
|
unit: "kg",
|
||
|
|
valueInKgCO2: 0.12,
|
||
|
|
source: "Agrybalise",
|
||
|
|
},
|
||
|
|
{
|
||
|
|
name: cheese,
|
||
|
|
unit: "kg",
|
||
|
|
valueInKgCO2: 0.12,
|
||
|
|
source: "Agrybalise",
|
||
|
|
},
|
||
|
|
{
|
||
|
|
name: tomato,
|
||
|
|
unit: "kg",
|
||
|
|
valueInKgCO2: 0.12,
|
||
|
|
source: "Agrybalise",
|
||
|
|
},
|
||
|
|
{
|
||
|
|
name: oliveOil,
|
||
|
|
unit: l,
|
||
|
|
valueInKgCO2: 0.12,
|
||
|
|
source: "Agrybalise",
|
||
|
|
},
|
||
|
|
];
|
||
|
|
|
||
|
|
```
|
||
|
|
|
||
|
|
|
||
|
|
When working on the following exercise, give particular attention to the following points:
|
||
|
|
Readability of your code
|
||
|
|
Unit Testing
|
||
|
|
Architecture and organization of your functions
|
||
|
|
Handling of corner cases and errors
|
||
|
|
Overall performance of your code
|
||
|
|
|
||
|
|
1/ Create an endpoint to compute carbonFootprint of food and persist data in database.
|
||
|
|
```js
|
||
|
|
const hamCheesePizza = {
|
||
|
|
ingredients: [
|
||
|
|
{ name: "ham", value: "2", unit: "g" },
|
||
|
|
{ name: "cheese", value: "15", unit: "g" },
|
||
|
|
{ name: "tomato", value: "4", unit: "g" },
|
||
|
|
{ name: "floor", value: "7", unit: "g" },
|
||
|
|
{ name: "oliveOil", value: "0.7", unit: "l" },
|
||
|
|
],
|
||
|
|
};
|
||
|
|
```
|
||
|
|
2/Agrybalise has updated its coefficients and we want to update accordingly our knowledge base. In order to do that, we need to develop and endpoint allowing to update and/or insert new values in our referential of emission factors.
|
||
|
|
|
||
|
|
In particular, we want to add these values:
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
Test Criterion for technical test:
|
||
|
|
Problem solving solution: should solve efficiently the problem
|
||
|
|
Clean code aspects: readability (naming, architecture), test
|
||
|
|
Performance of code & algorithmic
|
||
|
|
Knowledge of database
|
||
|
|
Error handling & exceptions
|
||
|
|
|
||
|
|
Test Criterion for technical test:
|
||
|
|
Clarity of explanation of approach and database
|
||
|
|
General engineering culture
|
||
|
|
Reactivity on advices & inputs
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
Questions:
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
2/
|
||
|
|
|
||
|
|
Fonction buggé
|
||
|
|
|
||
|
|
|
||
|
|
Performance
|
||
|
|
|
||
|
|
Asynchronous feature
|
||
|
|
Utiliser un ORM
|
||
|
|
Rest API
|
||
|
|
Base de donnée
|
||
|
|
|
||
|
|
Bonus:
|
||
|
|
authentification
|