package main
import (
"fmt"
"gorm.io/driver/sqlite"
"gorm.io/gorm"
)
type Product struct {
ID uint
Code string
Price float64
}
func main() {
// Connect to SQLite database
db, err := gorm.Open(sqlite.Open("gorm.db"), &gorm.Config{})
if err != nil {
panic("Failed to connect to database")
}
// Auto Migrate the Product model
db.AutoMigrate(&Product{})
// Create a new product
newProduct := Product{Code: "P1", Price: 19.99}
db.Create(&newProduct)
// Read the product from the database
var retrievedProduct Product
db.First(&retrievedProduct, 1)
// Update the product's price
db.Model(&retrievedProduct).Update("Price", 29.99)
// Delete the product
db.Delete(&retrievedProduct)
// Query all products
var products []Product
db.Find(&products)
// Print the products
fmt.Println("All Products:", products)
}