Skip to content

Instantly share code, notes, and snippets.

View colshag's full-sized avatar
🎯
Focusing

Chris Lewis colshag

🎯
Focusing
  • Edmonton, Alberta, Canada
View GitHub Profile
@garthk
garthk / dumpsqlite3tocsv.py
Created May 1, 2012 01:07
Unicode-safe Python script to dump sqlite3 tables to CSV for Trac data extraction
#!/usr/bin/env python
"""
Script to open a sqlite3 database and dump all user tables to CSV files.
Tested in Unicode-rich environment.
Usage:
dumpsqlite3tocsv foo.db
"""
import sqlite3, csv, codecs, cStringIO, os, os.path