Qt sqlite database example6/20/2023 Sqlite_db_file: path (including database name) where the sqlite database will be createdĬommits: list of commits that are already in the databaseĮxtraction_settings: settings for the extraction Git_repo_dir: path to the git repository that is mined """ Processes all commits in a given git repository in a parallel manner. # Just be sure any changes have been committed or they will be lost.ĭef _process_repo_parallel(git_repo_dir, sqlite_db_file, commits, extraction_settings): ![]() # We can also close the connection if we are done with it. Str(userId), str(userName), str(tags), str(urls))) Sql = "INSERT INTO ILLUST_DATA(ID,TITLE,TYPE,USER_ID,USER_NAME,TAGS,IMG_SRC)VALUES(?,?,?,?,?,?,?)"Ĭ.execute(sql, (str(illustID), str(illustTitle), str(illustType), If len(c.execute("SELECT ID FROM ILLUST_DATA WHERE ID = ?", (str(illustID),)).fetchall()) = 0: ![]() ![]() (ID INT PRIMARY KEY NOT NULL, TITLE TEXT NOT NULL, TYPE INT NOT NULL, USER_ID INT NOT NULL,USER_NAME TEXT NOT NULL,TAGS TEXT NOT NULL,IMG_SRC TEXT NOT NULL)''') If len(c.execute("SELECT name FROM sqlite_master WHERE type='table' AND name='ILLUST_DATA'").fetchall()) = 0: Def update_database(illustID, illustTitle, illustType, userId, userName, tags, urls):
0 Comments
Leave a Reply. |