From 6f5290871cda909d3ab50d499ddc84481d61c5de Mon Sep 17 00:00:00 2001
From: Jan Vales <jan@jvales.net>
Date: Tue, 26 Mar 2019 16:31:50 +0100
Subject: [PATCH] Submission template

---
 ex1/.gitignore     | 13 ++++++
 ex1/build.sh       | 12 ++++++
 ex1/gitinfohook.sh | 28 +++++++++++++
 ex1/main.tex       | 98 ++++++++++++++++++++++++++++++++++++++++++++++
 4 files changed, 151 insertions(+)
 create mode 100644 ex1/.gitignore
 create mode 100755 ex1/build.sh
 create mode 100755 ex1/gitinfohook.sh
 create mode 100644 ex1/main.tex

diff --git a/ex1/.gitignore b/ex1/.gitignore
new file mode 100644
index 0000000..41707dd
--- /dev/null
+++ b/ex1/.gitignore
@@ -0,0 +1,13 @@
+##### .gitignore default file. #####
+*.dep
+*.dep.tmp
+*.dep.unused
+*.swp
+*.pdf
+*.aux
+*.log
+*.toc
+*.out
+*.dvi
+*.gz
+gitHeadInfo.gin
diff --git a/ex1/build.sh b/ex1/build.sh
new file mode 100755
index 0000000..8978be5
--- /dev/null
+++ b/ex1/build.sh
@@ -0,0 +1,12 @@
+#!/bin/bash
+./gitinfohook.sh
+pdflatex main.tex
+
+grep '*{file}' main.dep | cut -d'{' -f3 | sed -e 's/}//g' -e 's#^#./#g' | sort | uniq > main.dep.tmp
+#(find ./images ./articles ./fillers -type f; cat main.dep.tmp main.dep.tmp) | sort | uniq -u > main.dep.unused
+#rm main.dep.tmp
+
+echo -e "\n\n\n*** DONE ***\n"
+#echo "unused ./images ./articles ./fillers:"
+#cat main.dep.unused
+echo ""
diff --git a/ex1/gitinfohook.sh b/ex1/gitinfohook.sh
new file mode 100755
index 0000000..e085f4e
--- /dev/null
+++ b/ex1/gitinfohook.sh
@@ -0,0 +1,28 @@
+#!/bin/sh
+# Copyright 2011 Brent Longborough
+# Please read gitinfo.pdf for licencing and other details
+# -----------------------------------------------------
+# cp gitinfohook.sh .git/hooks/post-update
+# chmod +x .git/hooks/post-update
+#
+#prefixes=". test docs"    # Example for multiple gitHeadInfo.tex files
+prefixes="."              # Default --- in the working copy root
+for pref in $prefixes
+	do
+	git log -1 --date=short \
+	--pretty=format:"\usepackage[%
+		shash={%h},
+		lhash={%H},
+		authname={%an},
+		authemail={%ae},
+		authsdate={%ad},
+		authidate={%ai},
+		authudate={%at},
+		commname={%an},
+		commemail={%ae},
+		commsdate={%ad},
+		commidate={%ai},
+		commudate={%at},
+		refnames={%d}
+	]{gitsetinfo}" HEAD > $pref/gitHeadInfo.gin
+	done
diff --git a/ex1/main.tex b/ex1/main.tex
new file mode 100644
index 0000000..81d00cc
--- /dev/null
+++ b/ex1/main.tex
@@ -0,0 +1,98 @@
+%\RequirePackage{snapshot} % stats of included files: $filename.dep
+
+\documentclass[a4paper]{scrartcl}
+\usepackage[utf8]{inputenc}
+\usepackage[naustrian]{babel}
+\usepackage[T1]{fontenc}
+\usepackage{amsmath,enumerate}
+\usepackage{amsfonts}
+\usepackage{graphicx}
+\usepackage{multicol}
+\usepackage{subfig}
+\usepackage{float}
+\usepackage{listings}
+\lstset{language=sql,basicstyle=\small,keywordstyle=\ttfamily,morekeywords={REFERENCES,DEFERRED}}
+\usepackage{tabularx}
+\PassOptionsToPackage{hyphens}{url}\usepackage{hyperref}
+\usepackage{enumitem}
+
+\usepackage{scrpage2}
+\pagestyle{scrheadings}
+
+% includable git commit info
+\usepackage[missing=run\ build.sh\ or\ gitinfohook.sh]{gitinfo}
+
+\newcommand{\ul}[1]{\underline{#1}}
+\newcommand{\ra}{\rightarrow}
+\newcommand{\R}{\ensuremath{\mathcal{R}}}
+
+\newtheorem{ex}{Aufgabe}
+\newenvironment{exercise}[2]%
+{\def\tmp{}%
+	\ifx\points\tmp
+	\begin{ex}
+		\else
+		\def\tmp{1}%
+		\begin{ex}[#1][#2 Punkt\ifx\points\tmp\else e\fi]
+			\fi
+			\normalfont
+		}%
+		{\end{ex} %
+}
+
+%% HINWEIS!
+%% 
+%% Die vorgegebene Formatierung der Loesung ist nur als
+%% Beispiel bzw. Hilfe gedacht und kann gerne geaendert
+%% werden.
+
+
+\title{Exercise Sheet 1, 2019}
+\subtitle{6.0 VU Advanced Database Systems}
+\author{David Kaufmann (00700719)\\Jan VALES (00726236)}
+
+\automark{section}
+\ohead{\pagemark}
+\makeatletter
+\chead{@author}
+\makeatother
+\cfoot{}
+
+\begin{document}
+\maketitle
+\vspace{\fill}
+\subsubsection*{Version}
+\begin{footnotesize}
+\url{https://git.somenet.org/priv/jan/adbs.git}\\
+This is revision: \textbf{\gitAbbrevHash} Document (.tex) compiled on: \textbf{\today}
+\end{footnotesize}\newpage
+
+
+\begin{exercise}{I/O}{1}
+\begin{enumerate}[label=(\alph*)]
+\item Difficult Calculations.
+\item Average time.
+\item Many other tasks.
+\end{enumerate}
+\end{exercise}
+
+
+\begin{exercise}{I/O in Query Plans}{2}
+
+\end{exercise}
+
+
+\begin{exercise}{Selectivity}{3}
+
+\end{exercise}
+
+
+\begin{exercise}{The Query Planner and You}{4}
+
+\end{exercise}
+
+
+\begin{exercise}{Optimizing Queries}{5}
+
+\end{exercise}
+\end{document}
-- 
2.47.3