計算機科学のブログ

ほしい物リスト

Python - SQL - SQLite - List Comprehensions: Database Integrations - select

Head First Python: A Learner’s Guide to the Fundamentals of Python Programming, A Brain-Friendly Guide、 Paul Barry(著)、 O’Reilly Mediaの Chapter 13.(List Comprehensions: Database Integrations)、EXERCISE(583/682)の解答を求めてみる。

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

webapp/TryQueries.ipynb

import DBcm
from queries import SQL_SESSIONS
print(SQL_SESSIONS)

    select distinct ts from times

db_details = 'CoachDB.sqlit3'
with DBcm.UseDatabase(db_details) as db:
    db.execute(SQL_SESSIONS)
    results = db.fetchall()

results

[('2025-05-15 04:30:50',)]