Máté Szendrő szemate

Fetch exercise

Create a dictionary page that shows word definitions from the Free Dictionary API. The API documentation can be found at https://dictionaryapi.dev/.

Open the developer tools in your browser and try the API with different words. Figure out how to get a definition from the returned JSON object.
Check what the response is when no definition is found.
Copy-paste index.html and script.js below into VSCode and open index.html with live server.
Complete script.js to show the first definition of the word from the input field when the user clicks the submit button. Don't forget to handle the case when no definition is found.
Stretch goal: include all definitions of the word and the example sentences.

Create a tokens table in the database with two columns:
- token text field, primary key
- user_id foreign key to the users table
In the POST /login request handler, after checking the user name and the password, generate a new token. It can be done using the uuid Node module (https://github.com/uuidjs/uuid). The token will look something like 1b9d6bcd-bbfd-4b2d-9b5d-ab8dfbbd4bed.
Insert the new token into the tokens table.

This exercise requires a working Postgres DB server with the homework database from https://github.com/CodeYourFuture/SQL-Coursework-Week1/tree/main/2-classes-db.

Initialise a new Node/Express web server.
Set up a connection pool to the homework database with node-posgtres.
Create a GET /spends endpoint that returns the list of all spends as a JSON array of objects. Each object should contain the date, description and amount properties.
Create a GET /suppliers endpoint that returns the list of the names of all suppliers as a JSON array of strings. Make sure the response is an array of strings and not an array of objects!
Extend the GET /spends endpont to return a more compete list of spends. Each object should contain the expense_area, expense_type, supplier, date, description and amount properties. The objects should not include any IDs, that is, the tables should be joined together.

Extract the contents of the zip file into a new directory and open the folder in VSCode.
Initialise a new Node app in the directory. The entry point should be the existing server.js.
Install Express.
Create an Express app in server.js that listens on port 3000.
Create a new request in Postman to make sure that the server is working.

Open the Network tab in the browser's Developer Tools, copy-paste http://httpbin.org/get?org=CodeYourFuture&class=ldn7 into the browser's address bar and inspect the following:

	/*
	STORE ACCOUNTING
	We are writing a program module for an online shop that processes purchases.
	The program receives the sold items as an array of objects; each object
	contains the name of the item, its price and its category (see below).
	*/
	const items = [
	{ product: "Premier Housewives Stainless Steel Toolset", price: 19.97, category: "homeware" },
	{ product: "iChinchin Women's Long Sleeve T Shirt", price: 15.99, category: "clothing" },
	{ product: "U-Design Toothbrush Holder Set", price: 10.55, category: "homeware" },

	/*
	TEST RESULT GRADING
	We are writing a program for teachers that helps them grade test results. The
	program receives the test results as an array of objects; each object contains
	the name of a student and their test score (see below).
	*/
	const results = [
	{ student: "Gytha Wheatley", score: 44 },
	{ student: "Alishia Thorpe", score: 83 },
	{ student: "Zack Vernon", score: 59 },

	/*
	STORE ACCOUNTING

	We are writing a program module for an online shop that processes purchases.
	The program receives the sold items as an array of objects; each object
	contains the name of the item, its price and its category (see below).

	1. Print the names and the number (the count) of all sold homeware accessories.
	2. Print the total revenue (the sum of the prices of all sold items).
	3. Print the average price of the items. Make sure that the price is rounded to 2 decimal points.

	/*
	TEST RESULT GRADING

	We are writing a program for teachers that helps them grade test results.
	The program receives the test results as an array of objects; each object
	contains the name of a student and their test score (see below).

	1. Print the names and the number (the count) of the students who passed the test (had at least 40 points).
	2. Print the average score.
	3. Print the name of the student who had the highest score.

	/**
	Exercise 1

	Rewrite the code below to use array destructuring instead of assigning each value to a variable.
	*/
	{
	console.log("EXERCISE 1");

	let item = ["Egg", 0.25, 12];