gendry

What's Changed

• fix bug: manager settings set blank value option missing by @twz915 in https://github.com/didi/gendry/pull/145
• builder where & update support Raw SQL by @twz915 in https://github.com/didi/gendry/pull/147
• feat: build delete support limit by @twz915 in https://github.com/didi/gendry/pull/148

Full Changelog: https://github.com/didi/gendry/compare/v1.8.1...v1.8.2

What's Changed

• feat: support empty tag by @nlimpid in https://github.com/didi/gendry/pull/136
• 支持对scan后rows.Err()检查 by @winston-ke in https://github.com/didi/gendry/pull/144

New Contributors

• @winston-ke made their first contribution in https://github.com/didi/gendry/pull/144

Full Changelog: https://github.com/didi/gendry/compare/v1.8.0...v1.8.1

New Features

• support multiple _or condition, #130 (@zhanghongnian )
• Fix typo in readme, #132 (@jxba016050 )

Add

• when value is a slice, in keyword is omitable

map[string]interface{}{
  "foo in": []int{1,2,3},
}

// equals to
map[string]interface{}{
  "foo": []int{1,2,3},
}

Fix

• if an object implements sql.Scanner, it'll take over the Scan job

• support _limit in BuildUpdate
• optimize unnecessary map copy, which makes gendry run much faster

• support build insert on duplicate
• update doc
• support _lockMode
• Fix bug of wrongly trimed quota field

bump version to 1.3.2

Fix bug of _orderby&_groupby.

in mysql manual:

Parameter markers can be used only where data values should appear, not for SQL keywords, identifiers, and so forth.

see also: issue mysql manual

• Fix potential sql injection bug caused by _orderby, _groupby and _limit
• Using strings.Builder to concat sql, which makes BuildSelectnearly 10% faster

support not like

add support for between and not between:

	where := map[string]interface{}{
		"age not between": []int{10, 30},
		"name":            "caibirdme",
		"score between":   []float64{3.5, 7.2},
	}

make regexp non-greedy

support scan boolean type(in mysql tinyint(1))

• support replace into
• support insert ignore into

Thx for @guangxuewu 's contribution

the library is stable and can be used in production with confidence