Python - Databases(SELECT, FROM, sqlite3 module, connect method, cursormethod, execute method, fetchall method)

Practical Programming
An Introduction to Computer Science
Using Python 3
(Pragmatic Programmers)
(Pragmatic Bookshelf)
Paul Gries (著)Jennifer Campbell (著)
Jason Montojo (著)Lynn Beighley (編集)

開発環境

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

Practical Programming: An Introduction to Computer Science Using Python 3 (Pragmatic Programmers)(Paul Gries (著)、Jennifer Campbell (著)、Jason Montojo (著)、Lynn Beighley (編集)、Pragmatic Bookshelf)のChapter 17(Databases)、17.10(Exercises) 2-b.を解いてみる。

17.10(Exercises) 2-b.

コード(BBEdit)

sample2_a.py

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

import sqlite3

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

cur.execute('''
SELECT province_territory, population, capital, population FROM Capitals
''')

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


connection.commit()
connection.close()

入出力結果(Terminal, IPython)

$ ./sample2_b.py
('Newfoundland and Labrador', 172918, 'St. John’s', 172918)
('Prince Edward Island', 58358, 'Charlottetown', 58358)
('Nova Scotia', 359183, 'Halifax', 359183)
('New Brunswick', 81346, 'Fredericton', 81346)
('Quebec', 682757, 'Quebec City', 682757)
('Ontario', 4682897, 'Toronto', 4682897)
('Manitoba', 671274, 'Winnipeg', 671274)
('Saskatchewan', 192800, 'Regina', 192800)
('Alberta', 311902, 'Victoria', 311902)
('British Columbia', 937845, 'Edmonton', 937845)
('Yukon Territory', 21405, 'Whitehorse', 21405)
('Northwest Territories', 16541, 'Yellowknife', 16541)
('Nunavut', 5236, 'Iqaluit', 5236)
$