mattn/go-sqlite3 — pull request #12 by jgallagher (2012-04-07 04:42:15+00:00)
Title: Minor tweaks, plus add support for "timestamp" columns.

Two of these commits are small (a typo, and an increase to the default busy_timeout).

The middle commit adds support for time.Time types for driver.Values. Because SQLite doesn't have a true date/time type, I stole the way the Python sqlite3 module does it. When inserting a time, it uses a "YYYY-MM-DD HH:MM:SS" text string (which SQLite's date/time functions understand). When querying, it uses sqlite3_column_decltype() to find columns declared as "timestamp", and expects the corresponding driver.Values to be time.Times. The code as written allows the timestamp text strings as above as well as integers, assuming they are Unix timestamps (also supported by SQLite's date/time functions).