Форум сайта python.su
Добрый день.
Пытаюсь добавить данные в SQLite через функцию executemany:
for i in phrases: lemma = str(phrases[id_phrase]).replace("('","").replace("',)", "").split() n_lemma = 0 lemma_collection = '' l_count = 0 for y in lemma: lemma_phrase = str(id_lemma) + "," + str(id_phrase) + ",'"+ lemma[l_count] +"'" lemma_collection += lemma_phrase if len(lemma) == l_count + 1: lemma_collection_list = lemma_collection.split("_") cursor.executemany("INSERT INTO lemmas VALUES (?, ?, ?)", lemma_collection_list) conn.commit() else: lemma_collection += '_' l_count += 1 id_lemma += 1 id_phrase += 1
Отредактировано Maksim156 (Сен. 11, 2018 16:44:53)
Офлайн