insert bulk values into table in sqlite
# connect to db
database = sqlite3.connect('database.db')
cursor = database.cursor()
# using INSERT INTO in bulk (where each line represents a new entry)
cursor.execute('''INSERT INTO tablename (column1,column2) VALUES
(data1,data2),
(data3,data4),
(data5,data6),
(data7,data8)''')
# disconnect from db :)
database.commit()
cursor.close()