import sqlite3

conn = sqlite3.connect("datafile.db")

#conn = sqlite3.connect(":memory:")
cursor = conn.cursor()
cursor.execute("""create table people (id integer primary key, name text, count integer)""")
#cursor.execute("""insert into people (name, count) values ('Bob', 15)""")
cursor.execute("""insert into people (name, count) values (?, ?)""", ('Bob', 25))
cursor.execute("""insert into people (name, count) values (:username, :usercount)""", {"username": "Grace", "usercount": 27})

conn.commit() #儲存這些改變
conn.close()

import sqlite3

conn = sqlite3.connect("datafile.db")
cursor = conn.cursor()
result = cursor.execute("select * from people")
print(result.fetchall())

conn.commit() #儲存這些改變
conn.close()

# [(1, 'Bob', 25), (2, 'Grace', 27)]

import sqlite3

conn = sqlite3.connect("datafile.db")
cursor = conn.cursor()
result = cursor.execute("select * from people")
print(result.fetchone())
print(result.fetchmany(2))

conn.commit() #儲存這些改變
conn.close()

# (1, 'Bob', 25)
# [(1, 'Bob', 25), (2, 'Grace', 27)]

import sqlite3

conn = sqlite3.connect("datafile.db")
cursor = conn.cursor()
result = cursor.execute("select * from people where name=:username", {"username": "Grace"})
print(result.fetchall())

conn.commit() #儲存這些改變
conn.close()

# [(2, 'Grace', 27)]

SQLite3 - CRUD

1. Create new data rows in the database.