#!/bin/bash

#variables of honor

counter_kunde_nr="1"
counter_kunde_address="1"
counter_kunde_name="1"
counter_auftrag_nr="101"
year=""
month=""
day=""
counter_aufpos_auftrag="100"
counter_artikel_nr="1023"
description="tool"
counter_tool="1"
menge=""
first_number=""
second_number=""

#the file where balrog shall not pass

echo -n "" > you_shall_not_pass.sql

#the tables in order to bring glory

echo "create table kunde (nr integer primary key, name char(50), adresse char(80) );" >> you_shall_not_pass.sql
echo "create table auftrag (nr integer primary key, kunde integer, datum date );" >> you_shall_not_pass.sql
echo "create table artikel (nr integer primary key, bez char(30), preis numeric(8,2), bestand integer);" >> you_shall_not_pass.sql
echo "create table aufpos (auftrag integer, artikel integer, menge integer);" >> you_shall_not_pass.sql

#the loop in order to bring glory

while [ $counter_kunde_nr -lt 1001 ]
do
	echo "insert into kunde (nr, name, adresse) values ($counter_kunde_nr, 'name$counter_kunde_name', 'strasse$counter_kunde_address');" >> you_shall_not_pass.sql
	counter_kunde_name=$((counter_kunde_name+1))
	counter_kunde_address=$((counter_kunde_address+1))
		
	year=$((1998+RANDOM%16))
	month=$((RANDOM%12+1))
	day=$((RANDOM%27+1))
	echo "insert into auftrag (nr, kunde, datum) values ($counter_auftrag_nr, $counter_kunde_nr, '$year-$month-$day');" >> you_shall_not_pass.sql
	counter_kunde_nr=$((counter_kunde_nr+1))
	
	first_number=$((RANDOM%200+1))
	second_number=$((RANDOM%99))
	bestand=$((RANDOM%500+10))	
	echo "insert into artikel (nr, bez, preis, bestand) values ($counter_artikel_nr, '$description$counter_tool', '$first_number.$second_number', $bestand);" >> you_shall_not_pass.sql
	counter_tool=$((counter_tool+1))
	
	menge=$((RANDOM%10+1))
	echo "insert into aufpos (auftrag, artikel, menge) values ($counter_auftrag_nr, $counter_artikel_nr, $menge );" >> you_shall_not_pass.sql 	
	counter_auftrag_nr=$((counter_auftrag_nr+1))
	counter_artikel_nr=$((counter_artikel_nr+1))
done