You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
25 lines
674 B
25 lines
674 B
import sqlite3
|
|
con = sqlite3.connect('bannerList.sqlite3')
|
|
|
|
import csv
|
|
|
|
with open('Banner.csv') as csv_file:
|
|
csv_reader = csv.reader(csv_file, delimiter=',')
|
|
|
|
cnt = 0
|
|
row = 2
|
|
for item in csv_reader:
|
|
if cnt != 0:
|
|
cur = con.cursor()
|
|
|
|
banner_id = int(item[0])
|
|
banner_name = item[1]
|
|
banner_row = f"{row}"
|
|
# Insert a row of data
|
|
sql_query = f"INSERT INTO banner VALUES ({banner_id}, \"{banner_name}\", \"{banner_row}\")"
|
|
cur.execute(sql_query)
|
|
con.commit()
|
|
row += 1
|
|
cnt +=1
|
|
|
|
# for row in cur.execute('SELECT * FROM stocks ORDER BY price'): |