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