shawkC_sql_pagecreate.sh

#!/bin/bash
# ls -1 *.tif | awk 'BEGIN {count=0}{count++;}{printf "%d %s\n",count,$1}END{printf "end and total %d\n",count}'
rm -fr sql_write.c formtable.sql sql_write.run
printf "\057\052 create all pages for db menu and tables edit \052\057\n" >> sql_write.c
printf "\057\052 compile gcc sql_write.c -o sql_write.run -Wall \052\057\n" >> sql_write.c
printf "\043include <stdlib.h> \n" >> sql_write.c
printf "\043include <string.h> \n" >> sql_write.c
printf "\043include <stdio.h> \n"  >> sql_write.c
printf "int main \050\051\n" >> sql_write.c
printf "{\n" >> sql_write.c
printf "\n" >>  sql_write.c
awk 'BEGIN {FS=","}{printf "\057\052processing formtable %d of %d of %d\052\057\n",NR,NF,FNR}END{printf " int tablenummer = %d\073\n int i = 0\073\n",NR}' formtable.txt >> sql_write.c
printf "char ** dbsql_ptr = NULL\073\n" >> sql_write.c 
awk 'BEGIN {FS=","}{printf "char \052 dbsql_%d = \042%s\042\073\n",(NR-1),$1}' formtable.txt >> sql_write.c
printf "\n" >> sql_write.c
printf "dbsql_ptr = (char *) malloc (tablenummer * sizeof(char *))\073\n" >> sql_write.c
printf "\n" >> sql_write.c
awk 'BEGIN {FS=","}{printf "dbsql_ptr[%d] = dbsql_%d\073 \057\052 %s \052\057\n",(NR-1),(NR-1),$1} END {printf "\n"}' formtable.txt >> sql_write.c
printf "if (dbsql_ptr == NULL)\n" >> sql_write.c
printf "{\n" >> sql_write.c
printf " printf \050\042\134nMemory allocation is as successful at brexit - failed ending program.\134n\042\051\073\n" >> sql_write.c
printf " return 1\073\n" >> sql_write.c
printf "}\n" >> sql_write.c
printf "\n" >> sql_write.c
printf "char ** disply_ptr = NULL\073\n" >> sql_write.c 
awk 'BEGIN {FS="," }{printf "char \052 disply_%d = \042%s\042\073\n",(NR-1),$4}' formtable.txt >> sql_write.c
printf "\n" >> sql_write.c
printf "disply_ptr = (char *) malloc (tablenummer * sizeof(char *))\073\n" >> sql_write.c
printf "\n" >> sql_write.c
awk 'BEGIN {FS="," }{printf "disply_ptr[%d] = disply_%d\073 \057\052 %s \052\057\n",(NR-1),(NR-1),$4} END {printf "\n"}' formtable.txt >> sql_write.c
printf "\n" >> sql_write.c
printf "if (disply_ptr == NULL)\n" >> sql_write.c
printf "{\n" >> sql_write.c
printf " printf \050\042\134nMemory allocation is as successful at brexit - failed ending program.\134n\042\051\073\n" >> sql_write.c
printf " return 1\073\n" >> sql_write.c
printf "}\n" >> sql_write.c
printf "\n" >> sql_write.c
printf "\n" >> sql_write.c
printf "int wdtype\133\135 \075 \173" >> sql_write.c 
awk 'BEGIN {FS=","}{printf "%d\054",$3}END{printf "\175\073\n"}' formtable.txt >> sql_write.c
sed -i 's|,};|};|g' sql_write.c
printf "\n" >> sql_write.c
cat std_form_sql.c >> sql_write.c
gcc sql_write.c -o sql_write.run -Wall
./sql_write.run
echo 'stop..finished..sql file should be ready'