Импорт из csv в SQLite3 Python

Введение

В этом примере я импортирую в базу данных sqlite3 товары из онлайн магазина OLDI

Пример

import csv, sqlite3 con = sqlite3.connect('db/oldi.db') cur = con.cursor() cur.execute("CREATE TABLE goods (\ available,\ categoryId,\ currencyId,\ description,\ id,\ model,\ modified_time,\ name,\ oldprice,\ param,\ picture,\ price,\ type,\ typePrefix,\ uri,\ url,\ vendor,\ vendorCode\ )") with open('csv/current.csv', 'r', encoding="utf8") as f: dr = csv.DictReader(f, delimiter=";") to_db = [(i['available'], i['categoryId'], i['currencyId'], i['description'], i['id'], i['model'], i['modified_time'], i['name'], i['oldprice'], i['param'], i['picture'], i['price'], i['type'], i['typePrefix'], i['uri'], i['url'], i['vendor'], i['vendorCode']) for i in dr] cur.executemany("INSERT INTO goods (available,\ categoryId,\ currencyId,\ description,\ id,\ model,\ modified_time,\ name,\ oldprice,\ param,\ picture,\ price,\ type,\ typePrefix,\ uri,\ url,\ vendor,\ vendorCode) VALUES " "(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);", to_db) con.commit() con.close()

Article author: Andrei Olegovich