Differences between revisions 1 and 2
⇤ ← Revision 1 as of 2007-01-29 06:52:59 →
Size: 1000
Editor: ZoomQuiet
Comment:
← Revision 2 as of 2007-01-29 06:59:22 → ⇥
Size: 1045
Editor: ZoomQuiet
Comment:
Deletions are marked like this. Additions are marked like this.
Line 2: Line 2:
`stephen chan <[email protected]>`

07-01-29.非常非常初级的小程序--SQL分析

stephen chan <[email protected]>

  • 是这样的，我想用python把一段sql中的数据字段名还有字段类型长度等给抽取出来然后写在一个空的txt或者tex格式的文本里，可是程序有错误，感觉不是我想要的，首先我想把sql文本中没有含有括号"("和")"的整行去除，抽取出"("")"内的数据，然后进行数据处理，用limodou的ulipad不好调试，郁闷死我了，可否帮我看看这段程序错在哪？非常短 

   1 #Write DD Document from SQL,Small Script Just test.
   2 file1r=open("E:\JGGZ_Table_script.sql","r")   #读文件1内容
   3 file1w=open("E:\JGGZ_Table_script_dd.tex","w") #写入文件2，文件2是自己创建的，初为空
   4 i=0
   5 for line in file1r.readlines():
   6     if not(line.find("(") | line.find(")")):
   7         line=''
   8     else:
   9         pass
  10     i+=1
  11     print i,
  12     print ".",
  13     print line
  14 file1r.close()
  15 file1w.close()
  • attachment:JGGZ_Table_script.sql

MicroProj/2007-01-29 (last edited 2009-12-25 07:10:32 by localhost)