diff options
Diffstat (limited to 'dependencies/pkg/mod/github.com/mattn/go-sqlite3@v1.14.16/_example/simple')
-rw-r--r-- | dependencies/pkg/mod/github.com/mattn/go-sqlite3@v1.14.16/_example/simple/Dockerfile | 45 | ||||
-rw-r--r-- | dependencies/pkg/mod/github.com/mattn/go-sqlite3@v1.14.16/_example/simple/simple.go | 109 |
2 files changed, 154 insertions, 0 deletions
diff --git a/dependencies/pkg/mod/github.com/mattn/go-sqlite3@v1.14.16/_example/simple/Dockerfile b/dependencies/pkg/mod/github.com/mattn/go-sqlite3@v1.14.16/_example/simple/Dockerfile new file mode 100644 index 0000000..c19f6e6 --- /dev/null +++ b/dependencies/pkg/mod/github.com/mattn/go-sqlite3@v1.14.16/_example/simple/Dockerfile @@ -0,0 +1,45 @@ +# ============================================================================= +# Multi-stage Dockerfile Example +# ============================================================================= +# This is a simple Dockerfile that will build an image of scratch-base image. +# Usage: +# docker build -t simple:local . && docker run --rm simple:local +# ============================================================================= + +# ----------------------------------------------------------------------------- +# Build Stage +# ----------------------------------------------------------------------------- +FROM golang:alpine AS build + +# Important: +# Because this is a CGO enabled package, you are required to set it as 1. +ENV CGO_ENABLED=1 + +RUN apk add --no-cache \ + # Important: required for go-sqlite3 + gcc \ + # Required for Alpine + musl-dev + +WORKDIR /workspace + +COPY . /workspace/ + +RUN \ + go mod init github.com/mattn/sample && \ + go mod tidy && \ + go install -ldflags='-s -w -extldflags "-static"' ./simple.go + +RUN \ + # Smoke test + set -o pipefail; \ + /go/bin/simple | grep 99\ こんにちは世界099 + +# ----------------------------------------------------------------------------- +# Main Stage +# ----------------------------------------------------------------------------- +FROM scratch + +COPY --from=build /go/bin/simple /usr/local/bin/simple + +ENTRYPOINT [ "/usr/local/bin/simple" ] diff --git a/dependencies/pkg/mod/github.com/mattn/go-sqlite3@v1.14.16/_example/simple/simple.go b/dependencies/pkg/mod/github.com/mattn/go-sqlite3@v1.14.16/_example/simple/simple.go new file mode 100644 index 0000000..0c34791 --- /dev/null +++ b/dependencies/pkg/mod/github.com/mattn/go-sqlite3@v1.14.16/_example/simple/simple.go @@ -0,0 +1,109 @@ +package main + +import ( + "database/sql" + "fmt" + _ "github.com/mattn/go-sqlite3" + "log" + "os" +) + +func main() { + os.Remove("./foo.db") + + db, err := sql.Open("sqlite3", "./foo.db") + if err != nil { + log.Fatal(err) + } + defer db.Close() + + sqlStmt := ` + create table foo (id integer not null primary key, name text); + delete from foo; + ` + _, err = db.Exec(sqlStmt) + if err != nil { + log.Printf("%q: %s\n", err, sqlStmt) + return + } + + tx, err := db.Begin() + if err != nil { + log.Fatal(err) + } + stmt, err := tx.Prepare("insert into foo(id, name) values(?, ?)") + if err != nil { + log.Fatal(err) + } + defer stmt.Close() + for i := 0; i < 100; i++ { + _, err = stmt.Exec(i, fmt.Sprintf("こんにちは世界%03d", i)) + if err != nil { + log.Fatal(err) + } + } + err = tx.Commit() + if err != nil { + log.Fatal(err) + } + + rows, err := db.Query("select id, name from foo") + if err != nil { + log.Fatal(err) + } + defer rows.Close() + for rows.Next() { + var id int + var name string + err = rows.Scan(&id, &name) + if err != nil { + log.Fatal(err) + } + fmt.Println(id, name) + } + err = rows.Err() + if err != nil { + log.Fatal(err) + } + + stmt, err = db.Prepare("select name from foo where id = ?") + if err != nil { + log.Fatal(err) + } + defer stmt.Close() + var name string + err = stmt.QueryRow("3").Scan(&name) + if err != nil { + log.Fatal(err) + } + fmt.Println(name) + + _, err = db.Exec("delete from foo") + if err != nil { + log.Fatal(err) + } + + _, err = db.Exec("insert into foo(id, name) values(1, 'foo'), (2, 'bar'), (3, 'baz')") + if err != nil { + log.Fatal(err) + } + + rows, err = db.Query("select id, name from foo") + if err != nil { + log.Fatal(err) + } + defer rows.Close() + for rows.Next() { + var id int + var name string + err = rows.Scan(&id, &name) + if err != nil { + log.Fatal(err) + } + fmt.Println(id, name) + } + err = rows.Err() + if err != nil { + log.Fatal(err) + } +} |