計算機科学のブログ

ほしい物リスト

Python - SQLite - List Comprehensions: Database Integrations - parameterized function

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(595/682)の解答を求めてみる。

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

TryQueries.ipynb

import DBcm

db_details = 'CoachDB.sqlite3'

from queries import *

def get_swimmers_events_by_session(name:str, age:int, date:str):
    with DBcm.UseDatabase(db_details) as db:
            db.execute(SQL_SWIMMERS_EVENTS_BY_SESSION, (name, age, date,))
            results = db.fetchall()
    return results

get_swimmers_events_by_session('Darius', 13, '2023-01-13')

[]