当python代码报错很诡异的错误时，可能是成对的符号丢失了一个-CSDN博客

今天写代码时，编译不过去，最后发现，配对符写丢了一个：

import sys
import re
import codecs


class TestCls(object):
    def __init__(self):
        return None

    def ReadSqlFile(self, filename, encoding):
        with codecs.open(filename=filename, mode='r', encoding=encoding) as f:
            content = f.read()
        # sql文件,以"--"作为注释符(暂不支持其他注释符),解析文件之前,先把注释替换掉,否则影响解析
        # 正则表达式,零宽断言,零宽度正预测先行断言
        content = re.sub(r"--.*(?=[\r\n]+?)", "", content)
        # 以"CREATE TABLE IF NOT EXISTS"作为建表的开始标志,以");"作为结束标志
        patternTable = "(" + """CREATE TABLE IF NOT EXISTS[ \t]+""" + """(?P<tableName>[a-zA-Z0-9_]+)""" + """[ \t\r\n]*\(""" + """(?P<allFieldContent>[^;]+)""" + """\);""" + ")"
        # 定义字段时必须要带"NULL"或"NOT NULL",否则解析不出来,例:
        # [colName] [colType] [NULL 或 NOT NULL] [后续字段(PRIMARY KEY等)]
        patternField = """([ \t]*(?P<colName>[a-zA-Z0-9_]+)[ \t]+(?P<colType>[a-zA-Z0-9\(\)]+)[ \t]+((NULL)|(NOT NULL))(?P<otherStr>.*))"""
        tableContentList = re.findall(patternTable, content)
        for tableContent in list(zip(*tableContentList))[0]:
            sreMatch = re.match(patternTable, tableContent)
            tableName = sreMatch.groupdict()["tableName"]
            allFieldContent  = sreMatch.groupdict(["allFieldContent"]
            #allFieldContent = sreMatch.groupdict()["allFieldContent"]
            # 如果"()"等符号丢失了一个的话,会报错出来很诡异的错误,此时应当意识到,可能丢失了配对符等.
            # 此时,建议使用排除法,一点一点的注释掉代码,找到出错的代码块,然后仔细查找原因.
            fieldContentList = re.findall(patternField, allFieldContent)
            for fieldContent in list(zip(*fieldContentList))[0]:
                sreMatch = re.match(patternField, fieldContent)
                colName = sreMatch.groupdict()["colName"]
                colType = sreMatch.groupdict()["colType"]
                otherStr = sreMatch.groupdict()["otherStr"]
                print(colName)
                print(colType)
                print(otherStr)
        return None


if __name__ == "__main__":
    sqlStr = """
DROP TABLE IF EXISTS nnnnnn_etf_list;
CREATE TABLE IF NOT EXISTS nnnnnn_etf_list(
  date     INTEGER     NOT NULL,--日期
  code     VARCHAR(32) NOT NULL,--code
  field1   VARCHAR(64) NOT NULL,--字段1
  field2   VARCHAR(64)     NULL,--字段2
  field3   VARCHAR(64)     NULL,--字段3
  field4   VARCHAR(64)     NULL,--字段4
  field5   VARCHAR(64)     NULL,--字段5
  field6   VARCHAR(64)     NULL,--字段6
  PRIMARY KEY(date,code,field1)
);"""
    obj = TestCls()
    fileName = r"D:\sql.sql"
    obj.ReadSqlFile(fileName, 'utf8')
    sys.exit(0)

完。