Fragenkatalog

git init

git checkout <Commit-Hash>

git checkout HEAD~1

git pull

git switch main
git cherry-pick -x <Commit-Hash>

❯ git switch log

commit cb6a74f7c7b49499c9b5087a6d43ae2b67ab60b1 (HEAD -> main)
Author: htl-leonding <t.stuetz@htl-leonding.ac.at>
Date:   Sun Feb 15 12:15:30 2026 +0100

    restructured dependencies

    (cherry picked from commit 587a53a23ac5e1b689c8a9e170a227eae0b1afb8)

git config list

credential.helper=osxkeychain
user.name=maxmustermann
user.email=m.mustermann@students.htl-leonding.ac.at
core.autocrlf=input
init.defaultbranch=main
(END)

git config user.name
git config user.email

mmustermann
m.mustermann@private-mail.at

git config --global user.name
git config --global user.email

maxmustermann
m.mustermann@students.htl-leonding.ac.at

git config --local user.name "Dein Name"
git config --local user.email "deine.email@beispiel.com"

git config --global user.name "Dein Name"
git config --global user.email "deine.email@beispiel.com"

git config --global --unset-all user.name
git config --global --unset-all user.email

docker container ls -a (1)
docker ps -a (2)

docker image ls
docker images (1)

docker run [optionen] image-name (1)
docker start container-name-or-id (2)

docker stop <container-name-or-id>

docker stop a1b2c3d4e5f6

docker rm <container-name-or-id>

docker rm -f <container-name-or-id> (1)

docker volume rm <volume-name>

docker volume rm mein-volume

#!/usr/bin/env bash

docker compose down
docker container prune -f
docker image prune -f
docker volume prune -f
docker builder prune --all --force #build cache löschen
IMAGES=$(docker images -q)

for image in $IMAGES
do
    docker image rm -f $image
done
VOLUMES=$(docker volume ls -q)
for volume in $VOLUMES
do
    docker volume rm $volume
done
docker container ls
docker volume ls
docker image ls

# Dockerfile
FROM node:18 (1)
WORKDIR /app (2)
COPY . . (3)
RUN npm install (4)
CMD ["node", "index.js"] (5)

docker build -t mein-node-image . (1)

docker tag <image_name> ghcr.io/<user>/<repo>:<tag>
docker push ghcr.io/<user>/<repo>:<tag>

docker tag my-image ghcr.io/htl-leonding-college/my-image:latest
docker push ghcr.io/htl-leonding-college/my-image:latest

docker exec -it <container_id> /bin/bash

docker compose -f my-docker-compose-file.yaml up

docker compose -f my-docker-compose-file.yaml up -d

docker compose -f my-docker-compose-file.yaml stop

docker compose -f my-docker-compose-file.yaml down

docker compose -f my-docker-compose-file.yaml logs -f

docker compose --file=docker-compose.yaml exec -it postgres pg_dump --username=app db | gzip > sql.gz

docker exec -t <container_id> pg_dumpall -c -U <user> > dump_`date +%Y-%m-%d"_"%H_%M_%S`.sql

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
#!/bin/bash

# Configuration
BACKUP_DIR="$(dirname "$0")/backups"
CONTAINER_NAME="my-container"
DB_USER="my-user"
DB_NAME="db"
DATE=$(date +%Y%m%d_%H%M%S)
BACKUP_FILE="${BACKUP_DIR}/myapp_backup_${DATE}.sql"
RETENTION_DAYS=7

# Ensure backup directory exists
mkdir -p "${BACKUP_DIR}"

echo "Starting database backup for ${DB_NAME}..."

# Execute pg_dump inside the container
# We use -it or just docker exec. For scripts, no -t is better.
if docker exec ${CONTAINER_NAME} pg_dump -U ${DB_USER} ${DB_NAME} > "${BACKUP_FILE}"; then
    echo "Backup successful: ${BACKUP_FILE}"

    # Compress the backup to save space
    gzip "${BACKUP_FILE}"
    echo "Backup compressed: ${BACKUP_FILE}.gz"

    # Cleanup old backups (older than RETENTION_DAYS)
    echo "Cleaning up backups older than ${RETENTION_DAYS} days..."
    find "${BACKUP_DIR}" -name "payments_backup_*.sql.gz" -mtime +${RETENTION_DAYS} -exec rm {} \;
    echo "Cleanup finished."
else
    echo "ERROR: Backup failed! Check if container ${CONTAINER_NAME} is running."
    exit 1
fi

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
#!/bin/bash

# Configuration
BACKUP_DIR="$(dirname "$0")/backups"
CONTAINER_NAME="my-db"
DB_USER="my-user"
DB_NAME="db"

# Check if a backup file was provided
if [ -z "$1" ]; then
    echo "Usage: ./restore.sh <backup_file.sql.gz>"
    echo "Available backups in ${BACKUP_DIR}:"
    ls -1 "${BACKUP_DIR}"
    exit 1
fi

BACKUP_FILE=$1

# Ensure the container is running
if ! docker ps | grep -q "${CONTAINER_NAME}"; then
    echo "ERROR: Container ${CONTAINER_NAME} is not running! Please start it first with ./start-db.sh"
    exit 1
fi

echo "Restoring database ${DB_NAME} from ${BACKUP_FILE}..."

# Decompress and restore
# We use 'cat' and pipe to 'docker exec' to avoid needing to copy the file into the container
gunzip -c "${BACKUP_FILE}" | docker exec -i ${CONTAINER_NAME} psql -U ${DB_USER} -d ${DB_NAME}

if [ $? -eq 0 ]; then
    echo "------------------------------------------------------------"
    echo "SUCCESS: Database has been restored."
    echo "------------------------------------------------------------"
else
    echo "ERROR: Restore failed!"
    exit 1
fi

scp -i ~/.ssh/id_ed25519 <file> <user>@<remote-server>:<path>

ssh -L 5432:localhost:5432 <user>@<remote-server>

MY_ENV_VAR=1234 ./my_script.sh

PGPASSWORD=app pg_dump --username=app db

netstat -tulpn | grep 8080

lsof -i :8080

sudo apt install net-tools

= Fragenkatalog
Thomas W. Stütz
1.0.0, {docdate}: Basiswissen für Programmieren und Projektentwicklung
:icons: font
:experimental:
:sectnums:
:source-highlighter: rouge
:docinfo: shared
:toc:
// https://fontawesome.com/v4.7.0/icons/
icon:file-text-o[link=https://github.com/2324-4bhif-wmc/2324-4bhif-wmc-lecture-notes/main/asciidocs/{docname}.adoc] ‏ ‏ ‎
icon:github-square[link=https://github.com/htl-leonding-college/fragenkatalog] ‏ ‏ ‎
icon:home[link=http://edufs.edu.htl-leonding.ac.at/~t.stuetz/hugo/2021/01/lecture-notes/]

:toc:

:icons: font

docker compose -f docker-compose.yaml up #<.>

docker compose -f docker-compose.yaml up (1)

    ifdef::env-github[]
    :tip-caption: :bulb:
    :note-caption: :information_source:
    :important-caption: :heavy_exclamation_mark:
    :caution-caption: :fire:
    :warning-caption: :warning:
    endif::[]

[discrete]
== Überschrift

:sectnums:

Link[Text^]

:experimental:

Drücken Sie die kbd:[RETURN]-Taste

|===
|Spalte 1 |Spalte 2 |Spalte 3

|Wert 1 - Spalte 1
|Wert 2 - Spalte 2
|Wert 3 - Spalte 3


|Wert 4 - Spalte 1
|Wert 5 - Spalte 2
|Wert 6 - Spalte 3
|===

[cols="3,3,3", options="header"]
|===
|Spalte 1 |Spalte 2 |Spalte 3
|Wert 1   |Wert 2   |Wert 3
|Wert 4   |Wert 5   |Wert 6
|===

 .Lösung
 [%collapsible]
 ====

 ...

 ====