Markus Schneider MrSnyder

Architecture Cheatsheet

Web concepts

Tokens, sessions and cookies

Misc concepts

Polymorphism
Reflection

Reactive programming

Regex Cheatsheet

sed

# base structure
sed 's/FIND_STRING/REPLACE_STRING/OPTIONS'
# examples
sed 's/<proxyBaseUrl>.*<\/proxyBaseUrl>/<proxyBaseUrl>https:\/\/whatever.de<\/proxyBaseUrl>/'

Options

FOSSGIS Tools Cheatsheet

Imposm Cheatsheet

Imports OpenStreetMap data into PostgreSQL/PostGIS databases.
https://imposm.org/

imposm  import -config imposm_config/config.json -read imposm_data/detmold-regbez-latest.osm.pbf -write -overwritecache -deployproduction

GeoServer

Python Cheatsheet

Language

Object-Oriented Programming in Python vs Java

# list comprehension
names = ['Apple', 'Banana', 'wtf']
names_length = [len(v) for v in a]
name_to_length = {v:len(v) for v in a if len(v) < 4}

Dependency management

SQL Cheatsheet

MySQL

-- start via docker
docker run --name=mystuff-mysql -d -e MYSQL_ROOT_PASSWORD=trallalla -e MYSQL_DATABASE=my_stuff -e MYSQL_USER=my_stuff -e MYSQL_PASSWORD=my_stuff -p 3306:3306 mysql:8

-- create database + user
CREATE DATABASE IF NOT EXISTS my_stuff;

Challenge: Integration Tests mit Java Spring Boot für REST-basierte CRUD Anwendung

Aufgabe

Integration Tests für alle Endpoints bereitstellen
Bereitstellung des Codes in eigenem GitHub-Repo

Links

Übersicht zu Test-Varianten für Spring Controller

Spring Boot Testing Cheatsheet

[Übersicht über Test-Ansätzen für Spring Controller] https://thepracticaldeveloper.com/2017/07/30/guide-spring-boot-controller-tests/
[Live-Coding zu MVC-Tests (Februar)] https://www.youtube.com/watch?v=TGcE7lEqhN4&list=PLVBvhDBS_eGWm3_N3sx95lGhBWkxuv_Qn&index=17&t=3513s
[Testing OAuth] https://www.baeldung.com/oauth-api-testing-with-spring-mvc

Unit tests vs integration tests

Unit tests: MockMVC (standalone)

RESTful Cheatsheet

DISCLAIMER: This document is mostly not about pure REST (or "RESTful") APIs in the original sense intended by Roy Fielding. To my knowledge, most APIs found in the wild do not really qualify to be called RESTful, as they only use a subset of the ideas described by Roy Fielding.

Commonly found RESTful concepts

The following concepts are usually found in real-world web APIs that are described as RESTful:

Resource-orientation: A single base URI per resource type, e.g. /notes
Usage of HTTP verbs for CRUD operations (see table below)

	# Linux permissions exercise

	## Step 0: Create an example directory hierarchy

	```
	/srv
	└── telekom
	├── bin
	├── gigabit
	│ ├── bin

	FROM openjdk:8-jdk-alpine
	RUN addgroup -S spring && adduser -S spring -G spring
	USER spring:spring
	ARG JAR_FILE=target/*.jar
	COPY ${JAR_FILE} app.jar
	ENTRYPOINT ["java","-jar","/app.jar"]