How to interact with database using Golang ORM tools?

Using GORM ORM tools to interact with the database can be easily achieved through the following steps: installation and initialization (1), defining model (2), establishing mapping (3), creating records (4), reading records (5), Update records (6), delete records (7), and transaction processing (8) ORM (Object-Relational Mapping) نام GORM است که کار با پایگاه داده های رابطه ای را در Go آسان می کند.

#Interact with the database using Golang ORM tools

Introduction

ORM (Object Relational Mapping) tools simplify the interaction between Golang applications and relational databases. It enables developers to easily create, read, update and delete database records by establishing a mapping between objects and database tables.

GORM ORM

GORM is a popular ORM tool in Golang that provides rich functionality and intuitive API. Here's how to use GORM to interact with a database:

Installation and Initialization

import (
    "github.com/jinzhu/gorm"
    _ "github.com/jinzhu/gorm/dialects/mysql"
)

// 创建一个数据库连接
db, err := gorm.Open("mysql", "user:password@/database_name")

if err != nil {
    // 处理错误
}

Define the model

Create a database table Corresponding structure:

type Product struct {
    ID    int    `gorm:"primary_key"`
    Name  string
    Price float64
}

Establish mapping

Use

gorm.Model to mark the model structure and establish mapping with the database table:

func init() {
    db.AutoMigrate(&Product{})
}

Create record

p := Product{
    Name:  "Apple iPhone 13",
    Price: 999.99,
}

db.Create(&p)

Read record

// 读取所有记录
products := []Product{}
db.Find(&products)

// 根据主键查找记录
var p Product
db.First(&p, 1)

Update record

p.Price = 1099.99
db.Save(&p)

Delete records

db.Delete(&p)

Transaction processing

Using transactions can ensure that multiple database operations succeed or fail at the same time:

// 开启一个事务
tx := db.Begin()

// 执行多个操作
p.Price = 1199.99
if err := db.Save(&p).Error; err != nil {
    // 出错时回滚事务
    tx.Rollback()
    return err
}

// 提交事务
if err := tx.Commit().Error; err != nil {
    // 出错时回滚事务
    tx.Rollback()
    return err
}

Practical case

Create a simple CRUD (create, read, update, delete) application:

package main

func main() {
    // 初始化数据库连接
    db, _ := gorm.Open("mysql", "user:password@/database_name")

    // 创建一个产品结构体
    type Product struct {
        ID    int    `gorm:"primary_key"`
        Name  string
        Price float64
    }

    // 迁移数据库表
    db.AutoMigrate(&Product{})

    // 创建一个产品
    p := Product{
        Name:  "iPhone 14",
        Price: 999.99,
    }
    db.Create(&p)

    // 读取所有产品
    products := []Product{}
    db.Find(&products)

    // 更新产品价格
    p.Price = 1099.99
    db.Save(&p)

    // 删除产品
    db.Delete(&Product{}, p.ID)
}

Using GORM can simplify the interaction with the database, Demonstrates the power of Golang ORM tools.

The above is the detailed content of How to interact with database using Golang ORM tools?. For more information, please follow other related articles on the PHP Chinese website!