https://github.com/mattn/go-sqlite3

    1. package main
    3. import (
    4.     "database/sql"
    5.     "fmt"
    6.     _ "github.com/mattn/go-sqlite3"
    7.     "log"
    8.     "os"
    9. )
    11. func main() {
    12.     os.Remove("./foo.db")
    14.     db, err := sql.Open("sqlite3", "./foo.db")
    15.     if err != nil {
    16.         log.Fatal(err)
    17.     }
    18.     defer db.Close()
    20.     sqlStmt := `
    21.     create table foo (id integer not null primary key, name text);
    22.     delete from foo;
    23.     `
    24.     _, err = db.Exec(sqlStmt)
    25.     if err != nil {
    26.         log.Printf("%q: %s\n", err, sqlStmt)
    27.         return
    28.     }
    30.     tx, err := db.Begin()
    31.     if err != nil {
    32.         log.Fatal(err)
    33.     }
    34.     stmt, err := tx.Prepare("insert into foo(id, name) values(?, ?)")
    35.     if err != nil {
    36.         log.Fatal(err)
    37.     }
    38.     defer stmt.Close()
    39.     for i := 0; i < 100; i++ {
    40.         _, err = stmt.Exec(i, fmt.Sprintf("こんにちわ世界%03d", i))
    41.         if err != nil {
    42.             log.Fatal(err)
    43.         }
    44.     }
    45.     err = tx.Commit()
    46.     if err != nil {
    47.         log.Fatal(err)
    48.     }
    50.     rows, err := db.Query("select id, name from foo")
    51.     if err != nil {
    52.         log.Fatal(err)
    53.     }
    54.     defer rows.Close()
    55.     for rows.Next() {
    56.         var id int
    57.         var name string
    58.         err = rows.Scan(&id, &name)
    59.         if err != nil {
    60.             log.Fatal(err)
    61.         }
    62.         fmt.Println(id, name)
    63.     }
    64.     err = rows.Err()
    65.     if err != nil {
    66.         log.Fatal(err)
    67.     }
    69.     stmt, err = db.Prepare("select name from foo where id = ?")
    70.     if err != nil {
    71.         log.Fatal(err)
    72.     }
    73.     defer stmt.Close()
    74.     var name string
    75.     err = stmt.QueryRow("3").Scan(&name)
    76.     if err != nil {
    77.         log.Fatal(err)
    78.     }
    79.     fmt.Println(name)
    81.     _, err = db.Exec("delete from foo")
    82.     if err != nil {
    83.         log.Fatal(err)
    84.     }
    86.     _, err = db.Exec("insert into foo(id, name) values(1, 'foo'), (2, 'bar'), (3, 'baz')")
    87.     if err != nil {
    88.         log.Fatal(err)
    89.     }
    91.     rows, err = db.Query("select id, name from foo")
    92.     if err != nil {
    93.         log.Fatal(err)
    94.     }
    95.     defer rows.Close()
    96.     for rows.Next() {
    97.         var id int
    98.         var name string
    99.         err = rows.Scan(&id, &name)
    100.         if err != nil {
    101.             log.Fatal(err)
    102.         }
    103.         fmt.Println(id, name)
    104.     }
    105.     err = rows.Err()
    106.     if err != nil {
    107.         log.Fatal(err)
    108.     }
    109. }