แนะนำ GORM

package main

import (
  "fmt"
  "gorm.io/gorm"
  "log"
)

type Book struct {
  gorm.Model
  Name        string
  Author      string
  Description string
}

func CreateBook(db *gorm.DB, book *Book) {
  result := db.Create(book)
  if result.Error != nil {
    log.Fatalf("Error creating book: %v", result.Error)
  }
  fmt.Println("Book created successfully")
}

func GetBook(db *gorm.DB, id uint) *Book {
  var book Book
  result := db.First(&book, id)
  if result.Error != nil {
    log.Fatalf("Error finding book: %v", result.Error)
  }
  return &book
}

func UpdateBook(db *gorm.DB, book *Book) {
  result := db.Save(book)
  if result.Error != nil {
    log.Fatalf("Error updating book: %v", result.Error)
  }
  fmt.Println("Book updated successfully")
}

func DeleteBook(db *gorm.DB, id uint) {
  var book Book
  result := db.Delete(&book, id)
  if result.Error != nil {
    log.Fatalf("Error deleting book: %v", result.Error)
  }
  fmt.Println("Book deleted successfully")
}

func main() {
  // Config Gorm เหมือนเดิม

  // Create a new book
  newBook := Book{Name: "The Go Programming Language", Author: "Alan A. A. Donovan", Description: "Comprehensive guide to Go"}
  CreateBook(db, &newBook)

  // // Get a book
  book := GetBook(db, 1) // Assuming the ID of the book is 1
  // fmt.Println("Book Retrieved:", book)

  // // Update a book
  book.Name = "The Go Programming Language, Updated Edition"
  UpdateBook(db, book)

  // Delete a book
  DeleteBook(db, book.ID)
}

func HardDeleteBook(db *gorm.DB, id uint) error {
  var book Book
  result := db.Unscoped().Delete(&book, id)
  if result.Error != nil {
    return result.Error
  }
  fmt.Println("Book hard deleted successfully")
  return nil
}

func getBooksSortedByCreatedAt(db *gorm.DB) ([]Book, error) {
  var books []Book
  result := db.Order("created_at desc").Find(&books)
  if result.Error != nil {
    return nil, result.Error
  }
  return books, nil
}

func getBooksByAuthorName(db *gorm.DB, authorName string) ([]Book, error) {
  var books []Book
  result := db.Where("author = ?", authorName).Find(&books)
  if result.Error != nil {
    return nil, result.Error
  }
  return books, nil
}