2、gorm 的 CURD

// Create
db.Create(&table1{Name: "小明", Age: 80}) 
// INSERT INTO `table1` (`created_at`,`updated_at`,`deleted_at`,`name`,`age`) VALUES ('2022-01-09 22:01:03.982','2022-01-09 22:01:03.982',NULL,'小明',80)

// Read
var person table1
db.First(&person, 1) // 根据整形主键查找 
// SELECT * FROM `table1` WHERE `table1`.`id` = 1 AND `table1`.`deleted_at` IS NULL ORDER BY `table1`.`id` LIMIT 1
db.First(&person, "name = ?", "小明") 
// 查找 name 字段值为 小明 的记录 // SELECT * FROM `table1` WHERE name = '小明' AND `table1`.`deleted_at` IS NULL ORDER BY `table1`.`id` LIMIT 1

// Update - 将 person 的 Name 更新为 小东
db.Model(&person).Update("Name", "小东") 
//UPDATE `table1` SET `name`='小东',`updated_at`='2022-01-09 21:57:35.378'

// Update - 更新多个字段
db.Model(&person).Updates(table1{Name: "小明", Age: 80}) // 仅更新非零值字段 
//UPDATE `table1` SET `updated_at`='2022-01-09 21:59:08.109',`name`='小明',`age`=80
db.Model(&person).Updates(map[string]interface{}{"Name": "小明一号", "Age": 80}) 
//UPDATE `table1` SET `age`=80,`name`='小明一号',`updated_at`='2022-01-09 21:59:52.966'

// Delete - 删除 person
db.Delete(&person, 1) 
//UPDATE `table1` SET `deleted_at`='2022-01-09 22:00:32.07' WHERE `table1`.`id` = 1 AND `table1`.`deleted_at` IS NULL