95 inpfile =
open(
"TILB-GEO-01",
"rt")
96 outfile =
open(
"TILB.sql",
"awt")
97 line = modname = comment = volline = cindx =
' '
99 n1 = n2 = n3 = n15 = n21 = n22 = n23 = n24 = n25 = n26 = 0
100 r4 = r5 = r6 = r7 = r8 = r9 = r10 = 0.0
101 r11 = r12 = r13 = r14 = r16 = r17 = r18 = r19 = r20 = r27 = 0.0
107 line = inpfile.readline()
113 name = string.split(line)
134 r11 =
float(name[10])
135 r12 =
float(name[11])
136 r13 =
float(name[12])
137 r14 =
float(name[13])
139 r16 =
float(name[15])
140 r17 =
float(name[16])
141 r18 =
float(name[17])
142 r19 =
float(name[18])
143 r20 =
float(name[19])
150 r27 =
float(name[26])
153 volline = volline+
","+
str(r7)+
","+
str(r8)+
","+
str(r9)+
","+
str(r10)+
","+
str(r11)+
","+
str(r12)
154 volline = volline+
","+
str(r13)+
","+
str(r14)+
","+
str(n15)+
","+
str(r16)+
","+
str(r17)+
","+
str(r18)
155 volline = volline+
","+
str(r19)+
","+
str(r20)+
","+
str(n21)+
","+
str(n22)+
","+
str(n23)+
","+
str(n24)
156 volline = volline+
","+
str(n25)+
","+
str(n26)+
","+
str(r27)
158 outfile.write(
"insert into TILB_data (TILB_data_id,SECTION,NPERIOD,NMODUL,RMIN,RMAX,RMINIMAL,RMAXIMAL,\n")
159 outfile.write(
"DZPERIO,DRFRONT,DZEND,FLANGEX,FLANGEY,ZOFFSET,PHIGAP,ISCI_ST,DZMODUL,DZMAST,DZSPAC,\n")
160 outfile.write(
"DZEND1,DZEND2,NGIRDER,NSCIN,FINGPATTERN,NPERCUTPOS,NPERCUTNEG,CURSCINT,DZGIR) values (\n")
161 outfile.write(volline)
162 outfile.write(
");\n")
163 outfile.write(
"insert into TILB_data2tag values ('TILB-GEO-01', ")
165 outfile.write(
");\n")
168 print ' IndexError : ',nmax,
' ',name