pythonでのデータベースの操作(1)
1458 ワード
#!/usr/bin/env python3
import sqlite3
import csv
con=sqlite3.connect('C:\\Users\\Administrator\\Desktop\\Suppliers.db')
c=con.cursor()
create_table="""CREATE TABLE IF NOT EXISTS Suppliers
(Supplier_Name VARCHAR(20),
Invoice_Number VARCHAR(20),
Part_Number VARCHART(20),
Cost FLOAT,
Purchase_Date DATE);"""
c.execute(create_table)
con.commit()
#
file_reader=csv.reader(open('E:\\ \\python \\ \\CSV \\Suppliers_base.csv','r',encoding='utf-8'),delimiter=',')
header=next(file_reader,None)
for row in file_reader:
# data=[]
# for column_index in range(len(header)):
# data.append(row[column_index])
# print(data)
# c.execute("INSERT INTO Suppliers VALUES (?,?,?,?,?)",data)
print(row)
c.execute("INSERT INTO Suppliers VALUES (?,?,?,?,?)",row)
con.commit()
print('')
# Suppliers
output=c.execute("SELECT * FROM Suppliers")
rows=output.fetchall()
row_count=0
for row in rows:
row_count+=1
result=[]
for col_index in range(len(row)):
result.append(str(row[col_index]))
print(result)
print(row_count)
, ,data Suppliers , , , , Suppliers data 。