ip=$(grep -m1 "^url=" FRINGE_build_test.ini | cut -d= -f2-)
port=$(grep -m1 "^port=" FRINGE_build_test.ini | cut -d= -f2-)
count=0
cp $test_data_dir/annotation.ath.manual.csv .
if grep -q $'\t' annotation.ath.manual.csv; then 
	fields_t="\t" 
 else
	fields_t=";" 
 fi 
sh wait_mysql.sh && mysqlimport --fields-terminated-by=$fields_t --fields-optionally-enclosed-by='"' --verbose -h $ip -P $port --local -uFRINGE_user_test -pf1b9735665df93783272f6a2485bc3d784c99789562c23a2e6910d0c931d4688 FRINGE_instance_test annotation.ath.manual.csv
if [ $? == 1 ];then
	exit 1
fi

count=$(($count + $(wc -l annotation.ath.manual.csv | awk '{print $1}')))

cp $test_data_dir/annotation.bra.manual.csv .
if grep -q $'\t' annotation.bra.manual.csv; then 
	fields_t="\t" 
 else
	fields_t=";" 
 fi 
sh wait_mysql.sh && mysqlimport --fields-terminated-by=$fields_t --fields-optionally-enclosed-by='"' --verbose -h $ip -P $port --local -uFRINGE_user_test -pf1b9735665df93783272f6a2485bc3d784c99789562c23a2e6910d0c931d4688 FRINGE_instance_test annotation.bra.manual.csv
if [ $? == 1 ];then
	exit 1
fi

count=$(($count + $(wc -l annotation.bra.manual.csv | awk '{print $1}')))

cp $test_data_dir/annotation.osa.manual.csv .
if grep -q $'\t' annotation.osa.manual.csv; then 
	fields_t="\t" 
 else
	fields_t=";" 
 fi 
sh wait_mysql.sh && mysqlimport --fields-terminated-by=$fields_t --fields-optionally-enclosed-by='"' --verbose -h $ip -P $port --local -uFRINGE_user_test -pf1b9735665df93783272f6a2485bc3d784c99789562c23a2e6910d0c931d4688 FRINGE_instance_test annotation.osa.manual.csv
if [ $? == 1 ];then
	exit 1
fi

count=$(($count + $(wc -l annotation.osa.manual.csv | awk '{print $1}')))


cp $test_data_dir/annot_sources.ath.csv .
if grep -q $'\t' annot_sources.ath.csv; then 
	fields_t="\t" 
 else
	fields_t=";" 
 fi 
sh wait_mysql.sh && mysqlimport --fields-terminated-by=$fields_t --fields-optionally-enclosed-by='"' --verbose -h $ip -P $port --local -uFRINGE_user_test -pf1b9735665df93783272f6a2485bc3d784c99789562c23a2e6910d0c931d4688 FRINGE_instance_test annot_sources.ath.csv
if [ $? == 1 ];then
	exit 1
fi


cp $test_data_dir/annot_sources.bra.csv .
if grep -q $'\t' annot_sources.bra.csv; then 
	fields_t="\t" 
 else
	fields_t=";" 
 fi 
sh wait_mysql.sh && mysqlimport --fields-terminated-by=$fields_t --fields-optionally-enclosed-by='"' --verbose -h $ip -P $port --local -uFRINGE_user_test -pf1b9735665df93783272f6a2485bc3d784c99789562c23a2e6910d0c931d4688 FRINGE_instance_test annot_sources.bra.csv
if [ $? == 1 ];then
	exit 1
fi


cp $test_data_dir/annot_sources.osa.csv .
if grep -q $'\t' annot_sources.osa.csv; then 
	fields_t="\t" 
 else
	fields_t=";" 
 fi 
sh wait_mysql.sh && mysqlimport --fields-terminated-by=$fields_t --fields-optionally-enclosed-by='"' --verbose -h $ip -P $port --local -uFRINGE_user_test -pf1b9735665df93783272f6a2485bc3d784c99789562c23a2e6910d0c931d4688 FRINGE_instance_test annot_sources.osa.csv
if [ $? == 1 ];then
	exit 1
fi


cp $test_data_dir/gene_protein_motif.ath.manual.csv .
sh wait_mysql.sh && mysqlimport --fields-terminated-by="\t" --fields-optionally-enclosed-by='"' --verbose -h $ip -P $port --local -uFRINGE_user_test -pf1b9735665df93783272f6a2485bc3d784c99789562c23a2e6910d0c931d4688 FRINGE_instance_test gene_protein_motif.ath.manual.csv
if [ $? == 1 ];then
	exit 1
fi

cp $test_data_dir/gene_protein_motif.bra.manual.csv .
sh wait_mysql.sh && mysqlimport --fields-terminated-by="\t" --fields-optionally-enclosed-by='"' --verbose -h $ip -P $port --local -uFRINGE_user_test -pf1b9735665df93783272f6a2485bc3d784c99789562c23a2e6910d0c931d4688 FRINGE_instance_test gene_protein_motif.bra.manual.csv
if [ $? == 1 ];then
	exit 1
fi


cp $test_data_dir/gene_protein_motif.osa.manual.csv .
sh wait_mysql.sh && mysqlimport --fields-terminated-by="\t" --fields-optionally-enclosed-by='"' --verbose -h $ip -P $port --local -uFRINGE_user_test -pf1b9735665df93783272f6a2485bc3d784c99789562c23a2e6910d0c931d4688 FRINGE_instance_test gene_protein_motif.osa.manual.csv
if [ $? == 1 ];then
	exit 1
fi


cp $test_data_dir/gene_go.ath.manual.csv .
sh wait_mysql.sh && mysqlimport --fields-terminated-by="\t" --fields-optionally-enclosed-by='"' --verbose -h $ip -P $port --local -uFRINGE_user_test -pf1b9735665df93783272f6a2485bc3d784c99789562c23a2e6910d0c931d4688 FRINGE_instance_test gene_go.ath.manual.csv
if [ $? == 1 ];then
	exit 1
fi


cp $test_data_dir/gene_go.bra.manual.csv .
sh wait_mysql.sh && mysqlimport --fields-terminated-by="\t" --fields-optionally-enclosed-by='"' --verbose -h $ip -P $port --local -uFRINGE_user_test -pf1b9735665df93783272f6a2485bc3d784c99789562c23a2e6910d0c931d4688 FRINGE_instance_test gene_go.bra.manual.csv
if [ $? == 1 ];then
	exit 1
fi


cp $test_data_dir/gene_go.osa.manual.csv .
sh wait_mysql.sh && mysqlimport --fields-terminated-by="\t" --fields-optionally-enclosed-by='"' --verbose -h $ip -P $port --local -uFRINGE_user_test -pf1b9735665df93783272f6a2485bc3d784c99789562c23a2e6910d0c931d4688 FRINGE_instance_test gene_go.osa.manual.csv
if [ $? == 1 ];then
	exit 1
fi

cp $test_data_dir/configuration.1237.species_tree.tsv .
if grep -q $'\t' configuration.1237.species_tree.tsv; then 
	fields_t="\t" 
 else
	fields_t=";" 
 fi 
sh wait_mysql.sh && mysqlimport --fields-terminated-by=$fields_t  --fields-optionally-enclosed-by='"' --verbose -h $ip -P $port --local -uFRINGE_user_test -pf1b9735665df93783272f6a2485bc3d784c99789562c23a2e6910d0c931d4688 FRINGE_instance_test configuration.1237.species_tree.tsv
if [ $? == 1 ];then
	exit 1
fi

cp $test_data_dir/configuration.1237.species.tsv .
if grep -q $'\t' configuration.1237.species.tsv; then 
	fields_t="\t" 
 else
	fields_t=";" 
 fi 
sh wait_mysql.sh && mysqlimport --fields-terminated-by=$fields_t  --fields-optionally-enclosed-by='"' --verbose -h $ip -P $port --local -uFRINGE_user_test -pf1b9735665df93783272f6a2485bc3d784c99789562c23a2e6910d0c931d4688 FRINGE_instance_test configuration.1237.species.tsv
if [ $? == 1 ];then
	exit 1
fi

cp $test_data_dir/configuration.1237.workbench_settings.tsv .
if grep -q $'\t' configuration.1237.workbench_settings.tsv; then 
	fields_t="\t" 
 else
	fields_t=";" 
 fi 
sh wait_mysql.sh && mysqlimport --fields-terminated-by=$fields_t  --fields-optionally-enclosed-by='"' --verbose -h $ip -P $port --local -uFRINGE_user_test -pf1b9735665df93783272f6a2485bc3d784c99789562c23a2e6910d0c931d4688 FRINGE_instance_test configuration.1237.workbench_settings.tsv
if [ $? == 1 ];then
	exit 1
fi

cp $test_data_dir/configuration.1237.website_settings.tsv .
if grep -q $'\t' configuration.1237.website_settings.tsv; then 
	fields_t="\t" 
 else
	fields_t=";" 
 fi 
sh wait_mysql.sh && mysqlimport --fields-terminated-by=$fields_t  --fields-optionally-enclosed-by='"' --verbose -h $ip -P $port --local -uFRINGE_user_test -pf1b9735665df93783272f6a2485bc3d784c99789562c23a2e6910d0c931d4688 FRINGE_instance_test configuration.1237.website_settings.tsv
if [ $? == 1 ];then
	exit 1
fi

cp $test_data_dir/configuration.1237.tool_settings.tsv .
if grep -q $'\t' configuration.1237.tool_settings.tsv; then 
	fields_t="\t" 
 else
	fields_t=";" 
 fi 
sh wait_mysql.sh && mysqlimport --fields-terminated-by=$fields_t  --fields-optionally-enclosed-by='"' --verbose -h $ip -P $port --local -uFRINGE_user_test -pf1b9735665df93783272f6a2485bc3d784c99789562c23a2e6910d0c931d4688 FRINGE_instance_test configuration.1237.tool_settings.tsv
if [ $? == 1 ];then
	exit 1
fi

cp $test_data_dir/configuration.1237.toolbox_settings.tsv .
if grep -q $'\t' configuration.1237.toolbox_settings.tsv; then 
	fields_t="\t" 
 else
	fields_t=";" 
 fi 
sh wait_mysql.sh && mysqlimport --fields-terminated-by=$fields_t  --fields-optionally-enclosed-by='"' --verbose -h $ip -P $port --local -uFRINGE_user_test -pf1b9735665df93783272f6a2485bc3d784c99789562c23a2e6910d0c931d4688 FRINGE_instance_test configuration.1237.toolbox_settings.tsv
if [ $? == 1 ];then
	exit 1
fi

cp $test_data_dir/configuration.1237.program_settings.tsv .
if grep -q $'\t' configuration.1237.program_settings.tsv; then 
	fields_t="\t" 
 else
	fields_t=";" 
 fi 
sh wait_mysql.sh && mysqlimport --fields-terminated-by=$fields_t  --fields-optionally-enclosed-by='"' --verbose -h $ip -P $port --local -uFRINGE_user_test -pf1b9735665df93783272f6a2485bc3d784c99789562c23a2e6910d0c931d4688 FRINGE_instance_test configuration.1237.program_settings.tsv
if [ $? == 1 ];then
	exit 1
fi

cp $test_data_dir/configuration.1237.go_provider_settings.tsv .
if grep -q $'\t' configuration.1237.go_provider_settings.tsv; then 
	fields_t="\t" 
 else
	fields_t=";" 
 fi 
sh wait_mysql.sh && mysqlimport --fields-terminated-by=$fields_t  --fields-optionally-enclosed-by='"' --verbose -h $ip -P $port --local -uFRINGE_user_test -pf1b9735665df93783272f6a2485bc3d784c99789562c23a2e6910d0c931d4688 FRINGE_instance_test configuration.1237.go_provider_settings.tsv
if [ $? == 1 ];then
	exit 1
fi

cp $test_data_dir/configuration.1237.go_linkout_settings.tsv .
if grep -q $'\t' configuration.1237.go_linkout_settings.tsv; then 
	fields_t="\t" 
 else
	fields_t=";" 
 fi 
sh wait_mysql.sh && mysqlimport --fields-terminated-by=$fields_t  --fields-optionally-enclosed-by='"' --verbose -h $ip -P $port --local -uFRINGE_user_test -pf1b9735665df93783272f6a2485bc3d784c99789562c23a2e6910d0c931d4688 FRINGE_instance_test configuration.1237.go_linkout_settings.tsv
if [ $? == 1 ];then
	exit 1
fi

cp $test_data_dir/configuration.1237.gene_type_settings.tsv .
if grep -q $'\t' configuration.1237.gene_type_settings.tsv; then 
	fields_t="\t" 
 else
	fields_t=";" 
 fi 
sh wait_mysql.sh && mysqlimport --fields-terminated-by=$fields_t  --fields-optionally-enclosed-by='"' --verbose -h $ip -P $port --local -uFRINGE_user_test -pf1b9735665df93783272f6a2485bc3d784c99789562c23a2e6910d0c931d4688 FRINGE_instance_test configuration.1237.gene_type_settings.tsv
if [ $? == 1 ];then
	exit 1
fi

cp $test_data_dir/configuration.1237.gene_family_settings.tsv .
if grep -q $'\t' configuration.1237.gene_family_settings.tsv; then 
	fields_t="\t" 
 else
	fields_t=";" 
 fi 
sh wait_mysql.sh && mysqlimport --fields-terminated-by=$fields_t  --fields-optionally-enclosed-by='"' --verbose -h $ip -P $port --local -uFRINGE_user_test -pf1b9735665df93783272f6a2485bc3d784c99789562c23a2e6910d0c931d4688 FRINGE_instance_test configuration.1237.gene_family_settings.tsv
if [ $? == 1 ];then
	exit 1
fi

cp $test_data_dir/configuration.1237.orthology_settings.tsv .
if grep -q $'\t' configuration.1237.orthology_settings.tsv; then 
	fields_t="\t" 
 else
	fields_t=";" 
 fi 
sh wait_mysql.sh && mysqlimport --fields-terminated-by=$fields_t  --fields-optionally-enclosed-by='"' --verbose -h $ip -P $port --local -uFRINGE_user_test -pf1b9735665df93783272f6a2485bc3d784c99789562c23a2e6910d0c931d4688 FRINGE_instance_test configuration.1237.orthology_settings.tsv
if [ $? == 1 ];then
	exit 1
fi

cp $test_data_dir/configuration.1237.funding_settings.tsv .
if grep -q $'\t' configuration.1237.funding_settings.tsv; then 
	fields_t="\t" 
 else
	fields_t=";" 
 fi 
sh wait_mysql.sh && mysqlimport --fields-terminated-by=$fields_t  --fields-optionally-enclosed-by='"' --verbose -h $ip -P $port --local -uFRINGE_user_test -pf1b9735665df93783272f6a2485bc3d784c99789562c23a2e6910d0c931d4688 FRINGE_instance_test configuration.1237.funding_settings.tsv
if [ $? == 1 ];then
	exit 1
fi

cp $test_data_dir/configuration.1237.authentication_settings.tsv .
if grep -q $'\t' configuration.1237.authentication_settings.tsv; then 
	fields_t="\t" 
 else
	fields_t=";" 
 fi 
sh wait_mysql.sh && mysqlimport --fields-terminated-by=$fields_t  --fields-optionally-enclosed-by='"' --verbose -h $ip -P $port --local -uFRINGE_user_test -pf1b9735665df93783272f6a2485bc3d784c99789562c23a2e6910d0c931d4688 FRINGE_instance_test configuration.1237.authentication_settings.tsv
if [ $? == 1 ];then
	exit 1
fi

cp $test_data_dir/configuration.1237.api_settings.tsv .
if grep -q $'\t' configuration.1237.api_settings.tsv; then 
	fields_t="\t" 
 else
	fields_t=";" 
 fi 
sh wait_mysql.sh && mysqlimport --fields-terminated-by=$fields_t  --fields-optionally-enclosed-by='"' --verbose -h $ip -P $port --local -uFRINGE_user_test -pf1b9735665df93783272f6a2485bc3d784c99789562c23a2e6910d0c931d4688 FRINGE_instance_test configuration.1237.api_settings.tsv
if [ $? == 1 ];then
	exit 1
fi

cp $test_data_dir/configuration.1237.go_group_settings.tsv .
if grep -q $'\t' configuration.1237.go_group_settings.tsv; then 
	fields_t="\t" 
 else
	fields_t=";" 
 fi 
sh wait_mysql.sh && mysqlimport --fields-terminated-by=$fields_t  --fields-optionally-enclosed-by='"' --verbose -h $ip -P $port --local -uFRINGE_user_test -pf1b9735665df93783272f6a2485bc3d784c99789562c23a2e6910d0c931d4688 FRINGE_instance_test configuration.1237.go_group_settings.tsv
if [ $? == 1 ];then
	exit 1
fi

cp $test_data_dir/configuration.1237.go_settings.tsv .
if grep -q $'\t' configuration.1237.go_settings.tsv; then 
	fields_t="\t" 
 else
	fields_t=";" 
 fi 
sh wait_mysql.sh && mysqlimport --fields-terminated-by=$fields_t  --fields-optionally-enclosed-by='"' --verbose -h $ip -P $port --local -uFRINGE_user_test -pf1b9735665df93783272f6a2485bc3d784c99789562c23a2e6910d0c931d4688 FRINGE_instance_test configuration.1237.go_settings.tsv
if [ $? == 1 ];then
	exit 1
fi

echo "succes" > databaseImportSucces.txt 
echo $count > geneIDCount.txt