#!/bin/csh -f

if($1 == "-h" || $#argv != 1) then
	echo " "
	echo "Usage:   "
	echo  "  >> go_bank <bank_database>"
	echo  "     creates the banks from the .bank files into the bank_database"
	echo " "
	echo "Possible databases: user_banks, clas12_banks."
	echo " "
	exit 0
endif


set database = $1

set files = (`\ls bankdefs/*.bank`)
set banks = (`\ls bankdefs/*.bank | awk -F".bank" '{print $1}' | awk -F\/ '{print $2}'` )

rm -rf                  bank_table_commands;
echo use $database\;  > bank_table_commands

set i = 1
foreach b ($banks)
	echo                                                                     >> bank_table_commands
	echo drop table if exists $database.$b\;                                 >> bank_table_commands
	echo create table $database.$b\(           name     VARCHAR\(40\)\)\;    >> bank_table_commands
	echo alter table $b add column           id         int\;                >> bank_table_commands
	echo alter table $b add column         type         int\;                >> bank_table_commands
	echo alter table $b add column    activated         int\;                >> bank_table_commands
	echo alter table $b add column  description     VARCHAR\(100\)\;         >> bank_table_commands
	echo LOAD DATA LOCAL INFILE \'$files[$i]\' into TABLE $b\;               >> bank_table_commands
	echo                                                                     >> bank_table_commands
	@ i += 1
end
	
mysql -h $GEMC_HOST -u $GEMC_USER < bank_table_commands
rm bank_table_commands
