Python - Data Has to Go Somewhere(SQL, SELECT)

Introducing Python
Modern Computing in Simple Packages
(O'Reilly Media)
Bill Lubanovic (著)

開発環境

• OS X Yosemite - Apple (OS)
• Emacs (CUI)、BBEdit - Bare Bones Software, Inc. (GUI) (Text Editor)
• Python 3.4 (プログラミング言語)

Introducing Python: Modern Computing in Simple Packages(Bill Lubanovic (著)、 O'Reilly Media)のChapter 8(Data Has to Go Somewhere)、Things to Do 8.9.を解いてみる。

Things to Do 8.9.

コード(Eacs, BBEdit)

sample9.py

#!/usr/bin/env python3
# -*- coding: utf-8 -*-

import sqlite3

connection = sqlite3.connect('books.db')
cur = connection.cursor()

cur.execute('SELECT * FROM books')

for row in cur.fetchall():
    print(row)

cur.close()
connection.close()

入出力結果(Terminal, IPython)

$ ./sample9.py
('The Weirdstone of Brisingamen', 'Alan Garner', 1960)
('Perdido Street Station', 'China Miéville', 2000)
('Thud!', 'Terry Pratchett', 2005)
('The Spellman Files', 'Lisa Lutz', 2007)
('Small Gods', 'Terry Pratchett', 1992)
$