0f4df23290
Some checks failed
kotlin / test (push) Has been skipped
python / test (push) Has been skipped
typescript / test (push) Has been skipped
go / build darwin/amd64 (push) Has been cancelled
go / build linux/amd64 (push) Has been cancelled
go / build windows/amd64 (push) Has been cancelled
go / build darwin/arm64 (push) Has been cancelled
go / build linux/arm64 (push) Has been cancelled
go / build windows/arm64 (push) Has been cancelled
go / test (push) Has been cancelled
go / vuln_check (push) Has been cancelled
54 lines
1007 B
Go
54 lines
1007 B
Go
//go:build examples
|
|
|
|
package authors
|
|
|
|
import (
|
|
"context"
|
|
"database/sql"
|
|
"testing"
|
|
|
|
_ "github.com/go-sql-driver/mysql"
|
|
|
|
"github.com/sqlc-dev/sqlc/internal/sqltest/local"
|
|
)
|
|
|
|
func TestAuthors(t *testing.T) {
|
|
ctx := context.Background()
|
|
uri := local.MySQL(t, []string{"schema.sql"})
|
|
sdb, err := sql.Open("mysql", uri)
|
|
if err != nil {
|
|
t.Fatal(err)
|
|
}
|
|
defer sdb.Close()
|
|
|
|
db := New(sdb)
|
|
|
|
// list all authors
|
|
authors, err := db.ListAuthors(ctx)
|
|
if err != nil {
|
|
t.Fatal(err)
|
|
}
|
|
t.Log(authors)
|
|
|
|
// create an author
|
|
result, err := db.CreateAuthor(ctx, CreateAuthorParams{
|
|
Name: "Brian Kernighan",
|
|
Bio: sql.NullString{String: "Co-author of The C Programming Language and The Go Programming Language", Valid: true},
|
|
})
|
|
if err != nil {
|
|
t.Fatal(err)
|
|
}
|
|
authorID, err := result.LastInsertId()
|
|
if err != nil {
|
|
t.Fatal(err)
|
|
}
|
|
t.Log(authorID)
|
|
|
|
// get the author we just inserted
|
|
fetchedAuthor, err := db.GetAuthor(ctx, authorID)
|
|
if err != nil {
|
|
t.Fatal(err)
|
|
}
|
|
t.Log(fetchedAuthor)
|
|
}
|