Python - SQL - SQLite - Databases: Getting Organized - select, insert, fetchone method - 計算機科学のブログ

Head First Python: A Learner’s Guide to the Fundamentals of Python Programming, A Brain-Friendly Guide、 Paul Barry(著)、 O’Reilly Mediaの Chapter 12.(Databases: Getting Organized)、EXERCISE(564/682)の解答を求めてみる。 Jupyter(コード、入出力結果) webapp/PopulateTables.ipynb with DBcm.UseDatabase(db_details) as db: for file in files: name, age, distance, stroke = file.removesuffix('.txt').split('-') db.execute(sql_get_sw