Bogdan Alexandru Militaru boobo94

Hi,

We have a simple exercise for you. You have to create few endpoints for a project manager tool. Firstly we have two types of users: regular users and admins.

What a regular user can do:

register (username, email, password, first name, last name)
login (username, password)
see details about his profile (username, email, first name, last name), just if he it's logged in, and he must only be able to view HIS profile

2. Design Pattern Questions

1.1. Answer: https://en.wikipedia.org/wiki/Model%E2%80%93view%E2%80%93controller#Components - The model is the central component of the pattern. It is the application's dynamic data structure, independent of the user interface. It directly manages the data, logic and rules of the application. - A view can be any output representation of information, such as a chart or a diagram. Multiple views of the same information are possible, such as a bar chart for management and a tabular view for accountants. - The controller, accepts input and converts it to commands for the model or view.

Answer: https://en.wikipedia.org/wiki/Object-relational_mapping

Useful commands

Show all databases \l+

Show all roles \du+

Show all tables \dt

Installing on Linux

Install Mysql on Ubuntu

$ sudo apt-get update
$ sudo apt-get install mysql-server Mysql will ask for root password

Use mysql

$ mysql -u root -p Will ask for root password

=====[Redirect if no https or www in a single redirect]=====

	RewriteCond %{HTTPS} off [OR]
	RewriteCond %{HTTP_HOST} !^www\.
	RewriteCond %{HTTP_HOST} ^(?:www\.)?(.+)$
	RewriteRule .* https://www.%1%{REQUEST_URI} [L,NE,R=301]

	## Display all extensions used

	```bash
	$ code --list-extensions \| xargs -L 1 echo code --install-extension
	```

	## List

	```
	code --install-extension aeschli.vscode-css-formatter

	{
	// See https://go.microsoft.com/fwlink/?LinkId=733558
	// for the documentation about the tasks.json format
	"version": "2.0.0",
	"tasks": [
	{
	"label": "Git Prune",
	"type": "shell",
	"command": "git fetch --prune && git branch -r \| awk '{print $1}' \| egrep -v -f /dev/fd/0 <(git branch -vv \| grep origin) \| awk '{print $1}' \| xargs git branch -d",
	"problemMatcher": []

	<VirtualHost *:80>
	# without http or https
	ServerName URL_ADDRESS

	RewriteEngine on
	RewriteCond %{HTTP_HOST} ^(.+)\.DOMAIN\.com$
	RewriteRule ^/(.*)$ https://%1.DOMAIN.com/$1 [R=301,L]

	</VirtualHost>

	RewriteEngine on
	RewriteBase /
	# Check if this is the noredirect query string
	RewriteCond %{QUERY_STRING} (^\|&)m=0(&\|$)
	# Set a cookie, and skip the next rule
	RewriteRule ^ - [CO=mredir:0:www.website.com]

	# Check if this looks like a mobile device
	# (You could add another [OR] to the second one and add in what you
	# had to check, but I believe most mobile devices should send at