Python - Data Has to Go Somewhere(sqlalchemy module, sqlite3)

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

Things to Do 8.10.

コード(Eacs, BBEdit)

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

import csv
import sqlalchemy as sa

conn = sa.create_engine('sqlite:///books.db')

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

入出力結果(Terminal, IPython)

$ ./sample10.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
$