//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
}
gorm拼接大于like等sql
最新推荐文章于 2024-01-31 17:52:21 发布