// +build ignore
package main

import (
    "database/sql"
    "fmt"

    _ "github.com/mattn/go-sqlite3"
)

func main() {
    db, err := sql.Open("sqlite3", "file:dummy.db?mode=memory&cache=shared")
    if err != nil {
        panic(err)
    }
    defer db.Close()

    _, err = db.Exec(`CREATE TABLE test (id INTEGER PRIMARY KEY NOT NULL, name TEXT);
                        INSERT INTO test (name) VALUES ('Bart'), ('Lisa');`)
    if err != nil {
        panic(err)
    }

    // A prepared statement that have a long lifetime...
        stmt, err := db.Prepare("SELECT * FROM test")
    if err != nil {
        panic(err)
    }
    defer stmt.Close()

    rows, err := stmt.Query()
    if err != nil {
        panic(err)
    }
    defer rows.Close()

    // An Alter, may be done by another connection/process (if the db is not in memory)...
    _, err = db.Exec("ALTER TABLE test ADD COLUMN data DEFAULT 'missing'")
    if err != nil {
        panic(err)
    }

    var id int
    var name string
    var data string
    // The native sqlite3_stmt is recompiled when the first sqlite3_step is called:
    // http://sqlite.org/c3ref/prepare.html
    // but not the Go wrappers...
    for rows.Next() {
        err = rows.Scan(&id, &name, &data)
        if err != nil {
            panic(err)
        }
        fmt.Println(id, name, data)
    }
}