Python - SQLite - Databases: Getting Organized - insert, select, delete

開発環境

Jupyter(コード、入出力結果)

webapp/PopulateTables.ipynb

import DBcm

db_details = 'CoachDB.sqlite'

SQL_INSERT = """
insert into swimmers
(name, age)
values
(?, ?)
"""

with DBcm.UseDatabase(db_details) as db:
    db.execute(SQL_INSERT, ('Hannah', 13))

SQL = """select * from swimmers"""
with DBcm.UseDatabase(db_details) as db:
    db.execute(SQL)
    results = db.fetchall()
results

[(1, 'Hannah', 13)]

SQL = """delete from swimmers"""
with DBcm.UseDatabase(db_details) as db:
    db.execute(SQL)

SQL = """select * from swimmers"""
with DBcm.UseDatabase(db_details) as db:
    db.execute(SQL)
    results = db.fetchall()
results

[]

計算機科学のブログ