Database in Sequelize implemented

Closes #15

See merge request swp-ws21-fahrtenbuch/team-einhorn/fahrtenbuch!7

Implement Mail Sending & Template

- added sending mails via nodemailer  -> .env may need to be updated
- added template loading from server/src/assets
	* special email html for readability across multiple mail clients
	* expressions inside {{}} are replaced by the values of the replace argument in the sendMail function
	* templates are both in txt and html for mail clients that don't support html

Closes #18

See merge request swp-ws21-fahrtenbuch/team-einhorn/fahrtenbuch!10

some salt according to: https://git.imp.fu-berlin.de/swp-ws21-fahrtenbuch/team-einhorn/fahrtenbuch/-/merge_requests/7#note_79858

Fix for `Parameter 'res' implicitly has an 'any' type.` using QueryResult.  Quick (temporary) Fix for missing "pg"-module.

- removed process env check (already verified after transporter creation)

- added template loading from server/src/assets
	* special email html for readability across multiple mail clients
	* expressions inside {{}} are replaced by the values of the replace argument in the sendMail function
	* templates are both in txt and html for mail clients that don't support html

Resolve "Fix Pipeline"

Closes #16

See merge request swp-ws21-fahrtenbuch/team-einhorn/fahrtenbuch!8

alexander06 authored 3 years ago and fu1106jv committed 3 years ago

**What did I do?**

* change `.gitlab-ci.yml` to basically reproduce docker compose up and npm run jest
  1. Go into server and run `npm install`
  1. Go into client and run `npm install`
  1. Go into server and run `npm run build`
  1. Go into server, start the server and run all tests in `server/tests`
  1. Go into server, start the server, go into client, start the client and run all tests in `client/tests`
* Create Testing documentation under `doc/testing.md`
* install `jest` and `ts-jest` and all their dependencies as dev-dependencies
* Create config files for jest under `client/jest.config.js` and `server/jest.config.js`
* Create basic tests that also serve as examples under `server/tests/connection.test.ts` and `client/tests/connection.test.ts`
  * The server tests basically try some GET requests to some API Endpoints defined in `server/src/routes.ts` and expect 404 errors
  * The client just polls the index.html file of the frontend
* change the `tsconfig.json` files to lint(?) the test directories

Point (3) Leander-Comment: 1)config gathers env-vars. 2)seqConnection connect to db. 3)db_init initilizes tables

-tsconfig funktioniert wieder.

- added Error Handling for missing env Variables

Closes #6

See merge request swp-ws21-fahrtenbuch/team-einhorn/fahrtenbuch!6

dockerize application

See merge request swp-ws21-fahrtenbuch/team-einhorn/fahrtenbuch!4

- Split server and client into two separate packages.
- Update README with info on how to start dev server locally
- Client
	- Update react-router-dom to v6
	- Separate page components from UI components
	- Add "proxy" field to package.json for proxying api requests to the backend server
- Server
	- Update path of static file serving to new client directory
	- Update scripts