func main() {
var err error
// open database
db, err := sql.Open("postgres", "postgres://*****:*****@localhost/booktest")
if err != nil {
log.Fatal(err)
}
// create an author
a := models.Author{
Name: "Unknown Master",
}
// save author to database
err = a.Save(db)
if err != nil {
log.Fatal(err)
}
// create transaction
tx, err := db.Begin()
if err != nil {
log.Fatal(err)
}
// save first book
now := time.Now()
b0 := models.Book{
AuthorID: a.AuthorID,
Isbn: "1",
Title: "my book title",
Booktype: models.FictionBookType,
Year: 2016,
Available: &now,
}
err = b0.Save(db)
if err != nil {
log.Fatal(err)
}
// save second book
b1 := models.Book{
AuthorID: a.AuthorID,
Isbn: "2",
Title: "the second book",
Booktype: models.FictionBookType,
Year: 2016,
Available: &now,
Tags: models.StringSlice{"cool", "unique"},
}
err = b1.Save(db)
if err != nil {
log.Fatal(err)
}
// save third book
b2 := models.Book{
AuthorID: a.AuthorID,
Isbn: "3",
Title: "the third book",
Booktype: models.FictionBookType,
Year: 2001,
Available: &now,
Tags: models.StringSlice{"cool"},
}
err = b2.Save(db)
if err != nil {
log.Fatal(err)
}
// save fourth book
b3 := models.Book{
AuthorID: a.AuthorID,
Isbn: "4",
Title: "4th place finisher",
Booktype: models.NonfictionBookType,
Year: 2011,
Available: &now,
Tags: models.StringSlice{"other"},
}
err = b3.Save(db)
if err != nil {
log.Fatal(err)
}
// tx commit
err = tx.Commit()
if err != nil {
log.Fatal(err)
}
// upsert, changing ISBN and title
b4 := models.Book{
BookID: b3.BookID,
AuthorID: a.AuthorID,
Isbn: "NEW ISBN",
Booktype: b3.Booktype,
Title: "never ever gonna finish, a quatrain",
Year: b3.Year,
Available: b3.Available,
Tags: models.StringSlice{"someother"},
}
err = b4.Upsert(db)
if err != nil {
log.Fatal(err)
}
// retrieve first book
books0, err := models.BooksByTitle(db, "my book title", 2016)
if err != nil {
log.Fatal(err)
}
for _, book := range books0 {
fmt.Printf("Book %d (%s): %s available: %s\n", book.BookID, book.Booktype, book.Title, book.Available.Format(time.RFC822Z))
author, err := book.Author(db)
if err != nil {
log.Fatal(err)
}
fmt.Printf("Book %d author: %s\n", book.BookID, author.Name)
}
// find a book with either "cool" or "other" tag
fmt.Printf("---------\nTag search results:\n")
res, err := models.AuthorBookResultsByTags(db, models.StringSlice{"cool", "other", "someother"})
if err != nil {
log.Fatal(err)
}
for _, ab := range res {
fmt.Printf("Book %d: '%s', Author: '%s', ISBN: '%s'\nTags: ", ab.BookID, ab.BookTitle, ab.AuthorName, ab.BookIsbn)
for _, s := range ab.BookTags {
fmt.Printf("'%s' ", s)
}
fmt.Println()
}
// call say_hello(varchar)
str, err := models.SayHello(db, "john")
if err != nil {
log.Fatal(err)
}
fmt.Printf("SayHello response: %s\n", str)
}
func main() {
var err error
db, err := sql.Open("postgres", "postgres://*****:*****@localhost/booktest")
if err != nil {
log.Fatal(err)
}
// create an author
a := models.Author{
Isbn: "some isbn",
Name: "Author Name",
Subject: "a subject",
}
// save author to database
err = a.Save(db)
if err != nil {
log.Fatal(err)
}
// create book in a transaction
tx, err := db.Begin()
if err != nil {
log.Fatal(err)
}
b := models.Book{
AuthorID: a.AuthorID,
Title: "my book title",
Booktype: models.FictionBookType,
Year: 2016,
}
err = b.Save(db)
if err != nil {
log.Fatal(err)
}
err = tx.Commit()
if err != nil {
log.Fatal(err)
}
// retrieve created book
books, err := models.BooksByTitle(db, "my book title", 2016)
if err != nil {
log.Fatal(err)
}
for _, book := range books {
fmt.Printf("Book %d (%s): %s\n", book.BookID, book.Booktype, book.Title)
author, err := book.Author(db)
if err != nil {
log.Fatal(err)
}
fmt.Printf("Book %d author: %s\n", book.BookID, author.Name)
}
// call say_hello(varchar)
str, err := models.SayHello(db, "john")
if err != nil {
log.Fatal(err)
}
fmt.Printf("SayHello response: %s\n", str)
}