gin使用gorm操作数据库

1、查询

row := db.Table("users").Where("name = ?", "jinzhu").Select("name, age").Row() // (*sql.Row)
row.Scan(&name, &age)

db.Exec("DROP TABLE users;")
db.Exec("UPDATE orders SET shipped_at=? WHERE id IN (?)", time.Now, []int64{11,22,33})

var list []model.WbOnhandCost
configs.Db.Exec("select * from wb_onhand_cost where id>?", 1).Find(&list)
fmt.Println(list)

var list []model.WbOnhandCost
db.Table("wb_onhand_cost").Where("id>=?", 1).Find(&list)
db.Where("id>=?", 1).Find(&list)
db.Table("users").Select("name, age").Where("name = ?", 3).Scan(&list)
fmt.Println(list)

db.Table("deleted_users").Count(&count)

查法
var data []model.Databasesource
db.Raw("select datasource_id,`sql` from databasesource where databasetype=? and status=?", "mysql", "3").Find(&data)

2、插入

data := &model.WbOnhand{
	Goodsid: it.Goodsid,
	Storeid: it.Storeid,
}
if err := configs.Db.Create(data).Error; err != nil {
	fmt.Println("插入失败")
}

3、修改

db.Table("users").Where("id IN (?)", []int{10, 11}).Updates(map[string]interface{}{"name": "hello", "age": 18})

db.Table("wb_onhand").Where("storeid=?", *it.Storeid).
				Where("goodsid=?", it.Goodsid).
				Updates(map[string]interface{}{"quantity": 0, "price": 0, "amount": 0})

//原生
db.Exec("update wb_onhand set quantity=quantity-?,price=?,amount=? where storeid=? and goodsid=?", data["costQuantity"], wbBillflow.Price, 0, *it.Storeid, *it.Goodsid)

4、删除

db.Table("deleted_users").Where("name = ?", "jinzhu").Delete()