python 生成sql语句

#coding=utf8
import re
import sys
def flushoutput(fh,msg):
    print >>fh,msg
    fh.flush()
a = 0
phoneprefixs = [这次是运营商手机号码的前三位
                ]
try :
    with open(sys.argv[1],'rb') as f1:
            with  open('%s.log' %(sys.argv[1],),'wb') as f2:
                 with open(("%s.sql") %(sys.argv[1]),'wb') as f3:
                    # print f1.readlines()
                    for i  in f1.readlines():
                        a +=1
                        num = i.strip().split(',')[0]
                        three =re.search(r'^(\d{3})(\d{8})$',num)
                        if three:
                            four = three.group(1)
                            if four in phoneprefixs:
                                new_num = "INSERT INTO  test VALUES(id ,name)"
                                second_num = "INSERT INTO  test VALUES(%s ,name)"  %a
                                # with open(("%s.%s") %(sys.argv[1],a),'wb') as f3:
                                flushoutput(f3,new_num + '\n' +second_num)
                            else :
                                flushoutput(f2,num)
                        else :
                            flushoutput(f2,num)
                    print  u'全部执行成功，数据在.sql文件里。 错误日志在.log里 ！！'
except :
    print "哥们，看看是不是漏什么东西了？，这么操作是不对的"