import re
import uuid

import docx
import pymysql

dbParams = {
    "host" : "",
    "user":"root",
    "password":"",
    "db":"webpage_dev",
    "port":,
    "charset":"utf8"
}




conn = pymysql.Connect(**dbParams)
cursor = conn.cursor()
insert_num = 0
xiu_num= 0

db_key = 1
key = 3
path = "/tmp/pycharm_project_683/task_1/" + "重点实验室_docx" + '/'
filename = "30.docx"



doc = docx.Document(path + filename)
my_type = "重点实验室"



def to_mysql(basename):
    basename = basename
    baseid = uuid.uuid1()
    print(basename)
    global db_key
    if db_key:
        try:
            sql = "insert into sd_company(baseid,basename,type) value('{}','{}','{}')".format(baseid,
                                                                                              basename,
                                                                                              my_type)
            res = cursor.execute(sql)
            global insert_num
            insert_num += 1
            print(res)

        except Exception as e:
            print(e)
            conn.rollback()
        finally:
            conn.commit()


def chuli(basename):
    basename_copy = basename
    if "（" in basename:
        basename = basename.replace('（','(')
    if "）" in basename:
        basename = basename.replace('）',')')

    if "(" in basename:
        s_index = basename.index("(")
        e_index = basename.index(")")
        rm_str = basename[s_index:e_index+1]
        basename = basename.replace(rm_str,"")


    basename_new = re.sub("[A-Za-z0-9\!\%\[\]\,\，\.\。\n\、\\\\；]", "", basename)

    if basename_copy != basename_new:
        global xiu_num
        xiu_num += 1
        print('修改数据')
    basename = basename_new


    if basename:
        to_mysql(basename)

for table in doc.tables:
    print(len(table.rows))
    for row in table.rows:
        print('++++++++++++++++++++++++++++++++++')
        if len(row.cells) >= key:
            print(row.cells[key].text)
            chuli(row.cells[key].text)

print('共入库{}条数据'.format(insert_num))
print('共修改{}条数据'.format(xiu_num))