gorm拼接大于like等sql

最新推荐文章于 2024-01-31 17:52:21 发布

IT_ziliang

最新推荐文章于 2024-01-31 17:52:21 发布

阅读量537

点赞数

CC 4.0 BY-SA版权

文章标签： golang 数据库 gorm

本文链接：https://blog.youkuaiyun.com/IT_ziliang/article/details/129842359

该函数用于从键值对的map中构建SQL查询的WHERE条件，支持等于、大于、小于等比较操作符以及IN、LIKE等复杂条件。当输入格式不正确时，函数会返回错误。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

//BuildCondition
func BuildCondition(where map[string]interface{}) (whereSql string, values []interface{}, err error) {
	for key, value := range where {
		conditionKey := strings.Split(key, " ")
		if len(conditionKey) > 2 {
			return "", nil, fmt.Errorf("" +
				"map构建的条件格式不对，类似于'age >'")
		}
		if whereSql != "" {
			whereSql += " AND "
		}
		switch len(conditionKey) {
		case 1:
			whereSql += fmt.Sprint(conditionKey[0], " = ?")
			values = append(values, value)
			break
		case 2:
			field := conditionKey[0]
			switch conditionKey[1] {
			case "=":
				whereSql += fmt.Sprint(field, " = ?")
				values = append(values, value)
				break
			case ">":
				whereSql += fmt.Sprint(field, " > ?")
				values = append(values, value)
				break
			case ">=":
				whereSql += fmt.Sprint(field, " >= ?")
				values = append(values, value)
				break
			case "<":
				whereSql += fmt.Sprint(field, " < ?")
				values = append(values, value)
				break
			case "<=":
				whereSql += fmt.Sprint(field, " <= ?")
				values = append(values, value)
				break
			case "in":
				whereSql += fmt.Sprint(field, " in (?)")
				values = append(values, value)
				break
			case "like":
				whereSql += fmt.Sprint(field, " like ?")
				values = append(values, value)
				break
			case "<>":
				whereSql += fmt.Sprint(field, " != ?")
				values = append(values, value)
				break
			case "!=":
				whereSql += fmt.Sprint(field, " != ?")
				values = append(values, value)
				break
			}
			break
		}
	}
	return
}