Description

Exec() now provides access to the last inserted ID and number of affected rows for all statements, not just the last one. This is useful to execute batches of statements such as UPDATE with minimal roundtrips. Fixes #1261.

The approach taken is to track last insert id and affected rows using []int64 instead of a int64. Both are set in mysqlResult, and a new mysql.Result interface makes them accessible to callers calling Exec() via sql.Conn.Raw. For example:

conn.Raw(func(conn interface{}) error {
        ex := conn.(driver.Execer)
        res, err := ex.Exec(`
        UPDATE point SET x = 1 WHERE y = 2;
        UPDATE point SET x = 2 WHERE y = 3;
        `, nil)
        // Both slices have 2 elements.
        log.Print(res.(mysql.Result).AllRowsAffected())
        log.Print(res.(mysql.Result).AllLastInsertIds())
      })

Checklist

• Code compiles correctly
• Created tests which fail without the change (if possible)
• All tests passing
• Extended the README / documentation, if necessary
• Added myself / the copyright holder to the AUTHORS file