How to mock a simple insert statement?

[noahyao1024]

Thanks you, I want to proxy some query to my own HTTP server, But it does't work on 'INSERT' while 'SELECT' is maybe perfect.

I use this piece of snippet to response, But MySQL received as a Empty query.
if strings.HasPrefix(query, "insert") {
testResult.InsertID = 100
testResult.RowsAffected = 1
testResult.Rows = append(make([][]sqltypes.Value, 0), testResult.Rows[0])
testResult.Rows = make([][]sqltypes.Value, 0)
}

Thanks you very much

[noahyao1024]

@BohuTANG HELP!

[BohuTANG]

The codes are no longer maintained, but I'm sure they work.
I guess the issue is building the testResult, you can try to build it like this:

https://github.com/xelabs/go-mysqlstack/blob/master/driver/client_test.go#L24-L27