pipelines.py 文件源码

def create_table(self):
        conn = sqlite3.connect(get_project_settings()['DATABASE_POSITION'])
        conn.text_factory = str
        try:
            conn.execute(
                """CREATE TABLE pixiv_item(
                       id INTEGER PRIMARY KEY,
                       title TEXT, link TEXT,
                       star INTEGER, multi INTEGER,
                       keyword TEXT, publish TIMESTAMP)""")
            conn.commit()
        except:
            pass
        return conn