grim/devweb

Add Update and Delete methods to db.Book
draft
2020-07-15, Gary Kramlich
c829827e5266
Parents 9ca0046f67d5
Children c470b1ba24a1
Add Update and Delete methods to db.Book
1 files changed, 16 insertions(+), 0 deletions(-)
  • +16 -0
    db/book.go
    • --- a/db/book.go Wed Jul 15 02:17:05 2020 -0500
    +++ b/db/book.go Wed Jul 15 02:25:15 2020 -0500
    @@ -14,6 +14,22 @@
    return err
    }
    +func (b Book) Update() error {
    + query := `UPDATE book SET name= $1, default_version= $2 WHERE id = $3;`
    +
    + _, err := _db.Exec(query, b.Name, b.DefaultVersion, b.ID)
    +
    + return err
    +}
    +
    +func (b Book) Delete() error {
    + query := `DELETE FROM book WHERE id = $1;`
    +
    + _, err := _db.Exec(query, b.ID)
    +
    + return err
    +}
    +
    func ListBooks() ([]Book, error) {
    books := []Book{}