result.go

// Copyright 2026 Dolthub, Inc.
//
// Licensed under the Apache License, Version 2.0 (the "License");
// you may not use this file except in compliance with the License.
// You may obtain a copy of the License at
//
//     http://www.apache.org/licenses/LICENSE-2.0
//
// Unless required by applicable law or agreed to in writing, software
// distributed under the License is distributed on an "AS IS" BASIS,
// WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
// See the License for the specific language governing permissions and
// limitations under the License.

package embedded

import (
	"database/sql/driver"
	"io"

	gms "github.com/dolthub/go-mysql-server/sql"
	"github.com/dolthub/go-mysql-server/sql/types"
)

var _ driver.Result = (*doltResult)(nil)

type doltResult struct {
	affected int64
	last     int64
}

func newResult(gmsCtx *gms.Context, sch gms.Schema, itr gms.RowIter) (*doltResult, error) {
	var affected int64
	var last int64

	for {
		r, err := itr.Next(gmsCtx)
		if err != nil {
			if err != io.EOF {
				_ = itr.Close(gmsCtx)
				return nil, translateError(err)
			}
			break
		}

		for i := range r {
			if res, ok := r[i].(types.OkResult); ok {
				affected += int64(res.RowsAffected)
				last = int64(res.InsertID)
			}
		}
	}

	if err := itr.Close(gmsCtx); err != nil {
		return nil, translateError(err)
	}

	return &doltResult{
		affected: affected,
		last:     last,
	}, nil
}

// LastInsertId returns the database's auto-generated ID after, for example, an INSERT into a table with primary key.
func (result *doltResult) LastInsertId() (int64, error) {
	return result.last, nil
}

// RowsAffected returns the number of rows affected by the query.
func (result *doltResult) RowsAffected() (int64, error) {
	return result.affected, nil
}