数据库

Python内置的sqlite3模块

import sqlite3

创建sqlite3内存数据库

创建带有4个属性的sales表

con = sqlite3.connect(':memory:')
query = """CREATE TABLE sales
(customer VARCHAR(20),
product VARCHAR(40),
amount FLOAT,
date DATE);"""
con.execute(query)
con.commit()

在表中插入几行数据

data = [('Richard Lucas', 'Notepad', 2.50, '2014-01-02'),
('Jenny Kim', 'Binder', 4.15, '2014-01-15'),
('Svetlana Crow', 'Printer', 155.75, '2014-02-03'),
('Stephen Randolph', 'Computer', 679.40, '2014-02-20')]
statement = "INSERT INTO sales VALUES(?, ?, ?, ?)"
con.executemany(statement, data)
con.commit()

查询sakes表

cursor = con.execute("SELECT * FROM sales")
rows = cursor.fetchall()

查询结果中行的数量

row_counter = 0
for row in rows:
print(row)
row_counter += 1
print('Number of rows: {}'.format(row_counter))

🔚
前几天在学python的函数和类，所以就没有更新。