]>
Commit | Line | Data |
---|---|---|
6fb7536b | 1 | # $Source$ |
2 | # $Header$ | |
3 | # | |
4 | # This converts the file used to originally create the database | |
5 | # into a program to back it up. | |
6 | # This is not guaranteed to work for all data types; it may | |
7 | # need to be extended. | |
8 | ||
3d058c8a | 9 | BEGIN { |
10 | print "/* This file automatically generated */"; | |
11 | print "/* Do not edit */\n"; | |
6fb7536b | 12 | print "#include <stdio.h>"; |
3388d7f8 | 13 | print "EXEC SQL INCLUDE sqlca;"; |
d55654f4 | 14 | print "#include \"dump_db.h\""; |
3d058c8a | 15 | print "#define dump_date dump_str\n"; |
16 | ||
b11ddcdf | 17 | print "/* This file automatically generated */" > "bkup1.pc"; |
18 | print "/* Do not edit */\n" >> "bkup1.pc"; | |
19 | print "#include <stdio.h>" >> "bkup1.pc"; | |
20 | print "FILE *open_file();" >> "bkup1.pc"; | |
21 | print "do_backups(prefix)\n\tchar *prefix;\n{" >> "bkup1.pc"; | |
6fb7536b | 22 | } |
23 | ||
3388d7f8 | 24 | $1=="#" { next; } |
25 | ||
3d058c8a | 26 | /^create/ { |
27 | printf "dump_%s(f)\nFILE *f;\n{\n\tEXEC SQL BEGIN DECLARE SECTION;\n", $3; | |
b11ddcdf | 28 | printf "\tdump_%s(open_file(prefix, \"%s\"));\n", $3, $3 >> "bkup1.pc"; |
3d058c8a | 29 | |
3388d7f8 | 30 | tablename = $3; |
6fb7536b | 31 | rangename = substr(tablename, 1, 1); |
3388d7f8 | 32 | count = 0; |
3d058c8a | 33 | next; |
34 | } | |
6fb7536b | 35 | |
3388d7f8 | 36 | NF>=2 { |
6fb7536b | 37 | vname[count] = $1; |
3d058c8a | 38 | printf "/* %s */\n", $0; |
3388d7f8 | 39 | if ($2 ~ /INTEGER/ || $2 ~ /SMALLINT/ || $2 ~ /INTEGER1/) { |
3d058c8a | 40 | printf "\tint\tt_%s;\n", vname[count]; |
41 | vtype[count]="int"; | |
3388d7f8 | 42 | } else if ($2 ~ /CHAR\([0-9]*\)/) { |
3d058c8a | 43 | t = split($2, temp, "("); |
3388d7f8 | 44 | if (t != 2) printf "Can't parse %s\n", $2; |
3d058c8a | 45 | t = split(temp[2], temp2, ")"); |
6fb7536b | 46 | if (t != 2) printf "Can't parse %s\n", temp[2]; |
3388d7f8 | 47 | printf "\tchar\tt_%s[%d];\n", vname[count], temp2[1]+1; |
639a8de3 | 48 | if ($1 == "signature") { |
3d058c8a | 49 | vtype[count]="bin"; |
639a8de3 | 50 | } else { |
3d058c8a | 51 | vtype[count]="str"; |
639a8de3 | 52 | } |
3d058c8a | 53 | vsize[count] = temp2[1]+1; |
3388d7f8 | 54 | } else if ($2 ~ /DATE/) { |
3d058c8a | 55 | printf "\tchar\tt_%s[26];\n", vname[count]; |
56 | vtype[count]="date"; | |
3388d7f8 | 57 | } else printf "Unknown data type %s\n", $2; |
6fb7536b | 58 | count++; |
59 | } | |
60 | ||
3388d7f8 | 61 | /^\);$/ { |
62 | printf "\tEXEC SQL END DECLARE SECTION;\n"; | |
63 | printf "\tEXEC SQL DECLARE c_%s CURSOR FOR\n", tablename; | |
3d058c8a | 64 | printf "\t\tSELECT\n"; |
65 | for (i = 0; i < count; i++) { | |
66 | if (i != 0) { | |
67 | print ","; | |
68 | } | |
69 | if(vtype[i] ~ /date/) { | |
70 | printf "\t\t\tTO_CHAR(%s, 'DD-mon-YYYY HH24:MI:SS')", vname[i]; | |
71 | } else printf "\t\t\t%s", vname[i]; | |
72 | } | |
73 | printf " FROM %s;\n", tablename; | |
74 | ||
3388d7f8 | 75 | printf "\tEXEC SQL OPEN c_%s;\n", tablename; |
3d058c8a | 76 | printf "\twhile(1) {\n\t\tEXEC SQL FETCH c_%s INTO\n", tablename; |
6fb7536b | 77 | for (i = 0; i < count; i++) { |
78 | if (i != 0) printf ",\n"; | |
3d058c8a | 79 | printf "\t\t\t:t_%s", vname[i]; |
6fb7536b | 80 | } |
3388d7f8 | 81 | printf ";\n"; |
3d058c8a | 82 | printf "\t\tif(sqlca.sqlcode != 0) break;\n"; |
6fb7536b | 83 | for (i = 0; i < count; i++) { |
3d058c8a | 84 | if (i != 0) print "\t\tdump_sep(f);"; |
85 | if (vtype[i] ~ /str/) { | |
86 | printf "\t\tdump_str(f, strtrim(t_%s));\n", vname[i]; | |
87 | } else { | |
88 | printf "\t\tdump_%s(f, t_%s);\n", vtype[i], vname[i]; | |
89 | } | |
6fb7536b | 90 | } |
3388d7f8 | 91 | printf "\t\tdump_nl(f);\n"; |
92 | printf "\t}\n"; | |
93 | printf "\tEXEC SQL CLOSE c_%s;\n", tablename; | |
94 | printf "\tsafe_close(f);\n"; | |
3d058c8a | 95 | printf "}\n\n"; |
6fb7536b | 96 | } |
3d058c8a | 97 | |
98 | END { | |
99 | print "/* All done */"; | |
b11ddcdf | 100 | print "}" >> "bkup1.pc"; |
6fb7536b | 101 | } |