Python 爬取数据入库mysql

# -*- enconding:etf-8 -*-
import pymysql
import os
import time
import re
serveraddr="localhost"
user="root"
password="123456"
databaseName="test"
filename="./data/UNCL.csv"

def create_table():
    # sep=os.sep
    # tableName=raw_input('please input the table name which will be created:')
    # classpath=raw_input('请输入需要遍历的路径：')

    db=pymysql.connect(serveraddr,user,password,databaseName)
    cursor=db.cursor()
    cursor.execute("drop table if exists `tncl`")
    sql="""    create table `tncl`(
            `tncl_id` varchar(25) not null,
            `tncl_tag` varchar(25) not null,
            `tncl_desc` varchar(255) not null,
            `tncl_note` varchar(1200) not null,
            primary key(`tncl_id`)
            ) engine=InnoDB default charset=utf8;"""
            
    cursor.execute(sql)
    db.close()
def test():
    p1=r"^\s{13}\w.+|\n$"
    pattern=re.compile(p1)
    fr=open(filename)
    w2=open('./data/e.csv','a')
    for line in fr.readlines():
        # print(line)
        matcher=re.findall(pattern,line)
        # print(matcher)
        # print(type(matcher))
        for i in matcher:
            w2.write(i)
            # w2.write("\n")
    fr.close()
    w2.close()

    
if __name__=='__main__':
    test()