goconditions := make([]*entity.Condition,0)conditions = append(conditions, &entity.Condition{Key:"id > ?", Val: 10})conditions = append(conditions, &entity.Condition{Key:"and user_name = ?", Val: "bee"})conditions = append(conditions, &entity.Condition{Key: "order by create_time desc", Val: entity.NotWhere})resultMap, err := operation.GetDBTemplate("Data source name").Select("table name", conditions)
根据条件修改数据goconditions := make([]*entity.Condition,0)conditions = append(conditions, &entity.Condition{Key:"id = ?", Val: 1})data := ResultStruct{UserName: "TestNoSqlUpdate"}operation.GetDBTemplate("Data source name").Update("table name", dbutil.StructToMapIgnore(&data, data, true), conditions)
根据条件删除数据goconditions := make([]*entity.Condition,0)conditions = append(conditions, &entity.Condition{Key:"id = ?", Val: 2})_, err := operation.GetDBTemplate("Data source name").Delete("table name", conditions)
插入一条数据godata := ResultStruct{UserName: "TestNoSqlInsert",UserEmail: "xxxxx@163.com",UpdateTime: "2021-12-09 13:50:00",}result, err := operation.GetDBTemplate("Data source name").Insert("table name", dbutil.StructToMapIgnore(&data, data, true))
### 复杂操作可以写sql完成有兴趣的可以翻阅文档:https://beeruscc.com