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