You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
 
 
 
 
Markus Pesch 6686bd8266
fix: README
2 months ago
img fix: schema and er-diagramm 1 year ago
referenzen add: bibtex pkg 2 years ago
sh fix: bash environment variables 1 year ago
sql fix: exercise 7, task 1-5 1 year ago
titel fix: titlepage - latex sourcecode link 1 year ago
uebungen fix: exercise 7, task 1-5 1 year ago
.drone.yml fix: drone ci, split into different pipelines 2 months ago
.editorconfig fix: repo 2 years ago
.gitattributes fix: repo 2 years ago
.gitignore add: git-url 3 years ago
.latexmkrc fix: latexmk, glossaries, travis 2 years ago
Makefile fix: README, Makefile 1 year ago
README.md fix: README 2 months ago
docker-compose.yml add: docker-compose for oracle xe 1 year ago
git-info.sh fix: git-info 1 year ago
index.tex fix: linenos 1 year ago

README.md

Tutorium Grundlagen Datenbanken WS1819

Build Status

This document contains all tasks for the tutorial basics databases winter semester 2018/2019 of the University of Applied Sciences Trier.

Discussions and questions can be posted via the Telegram group tgdb_ws1819. Announcements of changes to the document are also published there.

Build

The outcoming document is a pdf file. The pdf file can be compiled with latex. Latex is available for multiple operation systems. Instead to download and install all required libraries to compile the document, it is easier to use the provided container image which is also used to compile the pdf document inside the CI/CD pipeline. Therefore can be used two different commands to compile the pdf document.

Compile the pdf document inside a container image. A container runtime such as docker must be available.

The container runtime can be changed inside the Makefile

make container-run/index.pdf

Alternatively can also the local installed latex binaries used when all dependencies are fulfilled.

make index.pdf

SQL

The database scheme can be imported via the Makefile. The required database connection string will be concatenated from the environment variables DB_USER, DB_PASSWD and DB_HOST.

The command make db/import-model imports the complete scheme into the database. The solutions, defined in the separate files will be executed by make execute-solutions. The third command is make db delete-scheme to delete the complete scheme.

Sometimes you don't want to run all solutions, but only those from a directory. The FOLDER environment variable can be used to execute the directory with the solutions it contains, for example make execute-solutions FOLDER=uebung_05.