]>
Commit | Line | Data |
---|---|---|
29738a81 | 1 | # $Id$ |
dec49b94 | 2 | # |
3 | # This converts the file used to originally create the database | |
4 | # into a program to restore it from a backup. | |
5 | # This is not guaranteed to work for all data types; it may | |
6 | # need to be extended. | |
7 | ||
3d058c8a | 8 | BEGIN { |
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();"; |
7ac48069 | 13 | print "#include <com_err.h>"; |
14 | print "#include \"dump_db.h\""; | |
15 | print "#include \"rest.h\""; | |
3d058c8a | 16 | |
b11ddcdf | 17 | print "/* This file automatically generated */" > "rest1.pc"; |
18 | print "/* Do not edit */\n" >> "rest1.pc"; | |
7ac48069 | 19 | print "#include \"dump_db.h\"" >> "rest1.pc"; |
20 | print "#include \"rest.h\"" >> "rest1.pc"; | |
21 | print "void do_restores(char *prefix)\n{" >> "rest1.pc"; | |
22 | ||
23 | print "/* This file automatically generated */" > "bkup.h"; | |
24 | print "/* Do not edit */\n" >> "bkup.h"; | |
dec49b94 | 25 | } |
26 | ||
3388d7f8 | 27 | $1=="#" { next; } |
28 | ||
3d058c8a | 29 | /^create/ { |
7ac48069 | 30 | printf "void restore_%s(FILE *f)\n", $3; |
5eaef520 | 31 | print "{\n EXEC SQL BEGIN DECLARE SECTION;"; |
32 | printf " restore_%s(open_file(prefix, \"%s\"));\n", $3, $3 >> "rest1.pc"; | |
7ac48069 | 33 | printf "void restore_%s(FILE *f);\n", $3 >> "rest.h"; |
3d058c8a | 34 | |
3388d7f8 | 35 | tablename = $3; |
dec49b94 | 36 | rangename = substr(tablename, 1, 1); |
3388d7f8 | 37 | count = 0; |
3d058c8a | 38 | next; |
39 | } | |
dec49b94 | 40 | |
3388d7f8 | 41 | NF >= 2 { |
5eaef520 | 42 | vname[count] = $1; |
43 | printf " /* %s */\n", $0; | |
3388d7f8 | 44 | if ($2 ~ /INTEGER/ || $2 ~ /SMALLINT/ || $2 ~ /INTEGER1/) { |
5eaef520 | 45 | printf " int\tt_%s;\n", vname[count]; |
3d058c8a | 46 | vtype[count]="int"; |
3388d7f8 | 47 | } else if ($2 ~ /CHAR\([0-9]*\)/) { |
3d058c8a | 48 | t = split($2, temp, "("); |
3388d7f8 | 49 | if (t != 2) printf "Can't parse %s\n", $2; |
3d058c8a | 50 | t = split(temp[2], temp2, ")"); |
dec49b94 | 51 | if (t != 2) printf "Can't parse %s\n", temp[2]; |
5eaef520 | 52 | printf " char\tt_%s[%d];\n", vname[count], temp2[1]+1; |
3d058c8a | 53 | if ($1 == "signature") { |
54 | vtype[count]="bin"; | |
5eaef520 | 55 | printf " EXEC SQL VAR t_signature IS STRING(%d);\n", temp2[1]+1; |
3d058c8a | 56 | } else vtype[count]="str"; |
dec49b94 | 57 | vsize[count] = temp2[1]+1; |
3388d7f8 | 58 | } else if ($2 ~ /DATE/) { |
5eaef520 | 59 | printf " char\tt_%s[26];\n", vname[count]; |
3d058c8a | 60 | vtype[count]="date"; |
3388d7f8 | 61 | } else printf "Unknown data type %s\n", $2; |
dec49b94 | 62 | count++; |
63 | } | |
64 | ||
5eaef520 | 65 | /^\);$/ { |
66 | printf " EXEC SQL END DECLARE SECTION;\n\n int count = 0;\n"; | |
3d058c8a | 67 | |
5eaef520 | 68 | print " while (!feof(f))\n {"; |
69 | print " if (!(++count % 100))\n EXEC SQL COMMIT;\n"; | |
3d058c8a | 70 | |
dec49b94 | 71 | for (i = 0; i < count; i++) { |
5eaef520 | 72 | if (i != 0) print " parse_sep(f);"; |
dec49b94 | 73 | if (vtype[i] ~ /int/) { |
5eaef520 | 74 | printf(" t_%s = parse_int(f);\n", vname[i]); |
3d058c8a | 75 | } else if (vtype[i] ~ /date/) { |
5eaef520 | 76 | printf " parse_str(f, t_%s, 26);\n", vname[i]; |
3d058c8a | 77 | } else { |
5eaef520 | 78 | printf " parse_str(f, t_%s, %d);\n", vname[i], vsize[i]; |
3d058c8a | 79 | } |
5eaef520 | 80 | if (i == 0) print " if (feof(f))\n break;"; |
dec49b94 | 81 | } |
5eaef520 | 82 | printf " parse_nl(f);\n" |
dec49b94 | 83 | |
5eaef520 | 84 | printf " EXEC SQL INSERT INTO %s (\n", tablename; |
3388d7f8 | 85 | for (i = 0; i < count; i++) { |
86 | if (i != 0) printf ",\n"; | |
5eaef520 | 87 | printf " %s", vname[i]; |
3388d7f8 | 88 | } |
5eaef520 | 89 | printf ")\n VALUES (\n"; |
dec49b94 | 90 | for (i = 0; i < count; i++) { |
91 | if (i != 0) printf ",\n"; | |
3d058c8a | 92 | if (vtype[i] ~ /date/) { |
5eaef520 | 93 | printf " TO_DATE(NVL(:t_%s,TO_CHAR(SYSDATE, 'DD_mon-YYYY HH24:MI:SS')), 'DD-mon-YYYY HH24:MI:SS')", vname[i]; |
3d058c8a | 94 | } else if(vtype[i] ~ /int/) { |
5eaef520 | 95 | printf " :t_%s", vname[i]; |
3d058c8a | 96 | } else { |
5eaef520 | 97 | printf " NVL(:t_%s,CHR(0))", vname[i]; |
3d058c8a | 98 | } |
dec49b94 | 99 | } |
5eaef520 | 100 | printf ");\n if (sqlca.sqlcode != 0)\n {\n"; |
101 | printf " sqlca.sqlerrm.sqlerrmc[sqlca.sqlerrm.sqlerrml] = 0;\n"; | |
102 | printf " printf(\"%%s\\n\", sqlca.sqlerrm.sqlerrmc);\n"; | |
103 | printf " com_err(\"restore\", 0, \"insert failed\");\n"; | |
104 | printf " exit(2);\n }\n }\n"; | |
105 | printf " fclose(f);\n"; | |
106 | printf " EXEC SQL COMMIT;\n"; | |
3d058c8a | 107 | printf "}\n\n"; |
dec49b94 | 108 | } |
3d058c8a | 109 | |
110 | ||
111 | END { | |
112 | print "/* All done */"; | |
b11ddcdf | 113 | print "}" >> "rest1.pc"; |
dec49b94 | 114 | } |