WhereHolder key with trailing spaces is incorrectly translated

[Hao-Wu]

1. What version of Go and system type/arch are you using?

go version go1.17.3 darwin/amd64

2. What version of GoFrame are you using?

v2.0.4

3. Can this issue be re-produced with the latest release?

Yes

4. What did you do?

Query ORM,
Note, there is a space before and after id

r, _ := g.Model("testTableName").Where(" id ", 1000).One()

5. What did you expect to see?

Correct Mysql query should be translated and executed

SELECT * FROM `testTableName` WHERE  id = '1000'  LIMIT 1

6. What did you see instead?

Wrong SQL is translated, the condition value is missing

2022-06-24 12:49:32.654 [ERRO] {3098224b3875fb16cd5b61186100e7ea} [ 27 ms] [default] [rows:0  ] SELECT * FROM `testTableName` WHERE  id  LIMIT 1
Error: sql: expected 0 arguments, got 1 

Summary:

It is very common for developers to add(or mistakenly add) spaces to the WhereHolder, could we do some improvements to make it be compatible with this scenario?

I made a debug of gdb, maybe Trim leading and trailing spaces on WhereHolder in formatWhereHolder() is an easy resolution.

[Hao-Wu]

If it is necessary, I'd like to make a PR to resolve this issue.

[gqcn]

@Hao-Wu Good suggestion, let me handle this.

[Hao-Wu]

verified,
cool, thanks