competition.py 文件源码

def __init__(self):
        self.conn = conn
        self.cursor = cursor
        sql = '''
            CREATE TABLE IF NOT EXISTS Competition(
              id INT PRIMARY KEY AUTO_INCREMENT,
              title VARCHAR(100),
              publishdate datetime,
              detail TEXT
        )ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;'''
        self.cursor.execute(sql)
        self.conn.commit()

        for match in competition_list:
            splitword = jieba.lcut_for_search(match) #????
            onesplit = []
            for word in splitword:
                if re.match('??|??|??|???|??|??|??|?|??|??|??'.decode('utf8'), word) == None:
                    onesplit.append(word)
            competition_split.append(onesplit)