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