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  。