Python - Data Has to Go Somewhere(SQL, ORDER BY)

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.8.を解いてみる。

Things to Do 8.8.

コード(Eacs, BBEdit)

sample8.py

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

import sqlite3

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

cur.execute('SELECT title FROM books ORDER BY title')
for row in cur.fetchall():
    print(row[0])        

connection.commit()

cur.close()
connection.close()

入出力結果(Terminal, IPython)

$ ./sample8.py
Perdido Street Station
Small Gods
The Spellman Files
The Weirdstone of Brisingamen
Thud!
$ cat books.csv 
title,author,year
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
$