1 # -*- enconding:etf-8 -*-
2 import pymysql
3 import os
4 import time
5 import re
6 serveraddr="localhost"
7 user="root"
8 password="123456"
9 databaseName="test"
10 filename="./data/UNCL.csv"
11
12 def create_table():
13 # sep=os.sep
14 # tableName=raw_input('please input the table name which will be created:')
15 # classpath=raw_input('请输入需要遍历的路径：')
16
17 db=pymysql.connect(serveraddr,user,password,databaseName)
18 cursor=db.cursor()
19 cursor.execute("drop table if exists `tncl`")
20 sql=""" create table `tncl`(
21 `tncl_id` varchar(25) not null,
22 `tncl_tag` varchar(25) not null,
23 `tncl_desc` varchar(255) not null,
24 `tncl_note` varchar(1200) not null,
25 primary key(`tncl_id`)
26 ) engine=InnoDB default charset=utf8;"""
27
28 cursor.execute(sql)
29 db.close()
30 def test():
31 p1=r"^\s{13}\w.+|\n$"
32 pattern=re.compile(p1)
33 fr=open(filename)
34 w2=open('./data/e.csv','a')
35 for line in fr.readlines():
36 # print(line)
37 matcher=re.findall(pattern,line)
38 # print(matcher)
39 # print(type(matcher))
40 for i in matcher:
41 w2.write(i)
42 # w2.write("\n")
43 fr.close()
44 w2.close()
45
46
47 if __name__=='__main__':
48 test()
