package pgxmock

import (
	"context"
	"errors"
	"fmt"
	"reflect"
	"strings"
	"sync"
	"time"

	pgx "github.com/jackc/pgx/v5"
	pgconn "github.com/jackc/pgx/v5/pgconn"
)

// an expectation interface
type expectation interface {
	error() error
	required() bool
	fulfilled() bool
	fulfill()
	sync.Locker
	fmt.Stringer
}

// CallModifier interface represents common interface for all expectations supported
type CallModifier interface {
	// Maybe allows the expected method call to be optional.
	// Not calling an optional method will not cause an error while asserting expectations
	Maybe() CallModifier
	// Times indicates that that the expected method should only fire the indicated number of times.
	// Zero value is ignored and means the same as one.
	Times(n uint) CallModifier
	// WillDelayFor allows to specify duration for which it will delay
	// result. May be used together with Context
	WillDelayFor(duration time.Duration) CallModifier
	// WillReturnError allows to set an error for the expected method
	WillReturnError(err error)
	// WillPanic allows to force the expected method to panic
	WillPanic(v any)
}

// common expectation struct
// satisfies the expectation interface
type commonExpectation struct {
	sync.Mutex
	triggered     uint          // how many times method was called
	err           error         // should method return error
	optional      bool          // can method be skipped
	panicArgument any           // panic value to return for recovery
	plannedDelay  time.Duration // should method delay before return
	plannedCalls  uint          // how many sequentional calls should be made
}

func (e *commonExpectation) error() error {
	return e.err
}

func (e *commonExpectation) fulfill() {
	e.triggered++
}

func (e *commonExpectation) fulfilled() bool {
	return e.triggered >= max(e.plannedCalls, 1)
}

func (e *commonExpectation) required() bool {
	return !e.optional
}

func (e *commonExpectation) waitForDelay(ctx context.Context) (err error) {
	select {
	case <-time.After(e.plannedDelay):
		err = e.error()
	case <-ctx.Done():
		err = ctx.Err()
	}
	if e.panicArgument != nil {
		panic(e.panicArgument)
	}
	return err
}

func (e *commonExpectation) Maybe() CallModifier {
	e.optional = true
	return e
}

func (e *commonExpectation) Times(n uint) CallModifier {
	e.plannedCalls = n
	return e
}

func (e *commonExpectation) WillDelayFor(duration time.Duration) CallModifier {
	e.plannedDelay = duration
	return e
}

func (e *commonExpectation) WillReturnError(err error) {
	e.err = err
}

var errPanic = errors.New("pgxmock panic")

func (e *commonExpectation) WillPanic(v any) {
	e.err = errPanic
	e.panicArgument = v
}

// String returns string representation
func (e *commonExpectation) String() string {
	w := new(strings.Builder)
	if e.err != nil {
		if e.err != errPanic {
			fmt.Fprintf(w, "\t- returns error: %v\n", e.err)
		} else {
			fmt.Fprintf(w, "\t- panics with: %v\n", e.panicArgument)
		}
	}
	if e.plannedDelay > 0 {
		fmt.Fprintf(w, "\t- delayed execution for: %v\n", e.plannedDelay)
	}
	if e.optional {
		fmt.Fprint(w, "\t- execution is optional\n")
	}
	if e.plannedCalls > 0 {
		fmt.Fprintf(w, "\t- execution calls awaited: %d\n", e.plannedCalls)
	}
	return w.String()
}

// queryBasedExpectation is a base class that adds a query matching logic
type queryBasedExpectation struct {
	expectSQL          string
	expectRewrittenSQL string
	args               []interface{}
}

func (e *queryBasedExpectation) argsMatches(sql string, args []interface{}) (rewrittenSQL string, err error) {
	eargs := e.args
	// check for any QueryRewriter arguments: only supported as the first argument
	if len(args) == 1 {
		if qrw, ok := args[0].(pgx.QueryRewriter); ok {
			// note: pgx.Conn is not currently used by the query rewriter
			if rewrittenSQL, args, err = qrw.RewriteQuery(context.Background(), nil, sql, args); err != nil {
				return rewrittenSQL, fmt.Errorf("error rewriting query: %w", err)
			}
		}
		// also do rewriting on the expected args if a QueryRewriter is present
		if len(eargs) == 1 {
			if qrw, ok := eargs[0].(pgx.QueryRewriter); ok {
				if _, eargs, err = qrw.RewriteQuery(context.Background(), nil, sql, eargs); err != nil {
					return "", fmt.Errorf("error rewriting query expectation: %w", err)
				}
			}
		}
	}
	if len(args) != len(eargs) {
		return rewrittenSQL, fmt.Errorf("expected %d, but got %d arguments", len(eargs), len(args))
	}
	for k, v := range args {
		// custom argument matcher
		if matcher, ok := eargs[k].(Argument); ok {
			if !matcher.Match(v) {
				return rewrittenSQL, fmt.Errorf("matcher %T could not match %d argument %T - %+v", matcher, k, args[k], args[k])
			}
			continue
		}
		if darg := eargs[k]; !reflect.DeepEqual(darg, v) {
			return rewrittenSQL, fmt.Errorf("argument %d expected [%T - %+v] does not match actual [%T - %+v]", k, darg, darg, v, v)
		}
	}
	return
}

// ExpectedClose is used to manage pgx.Close expectation
// returned by pgxmock.ExpectClose
type ExpectedClose struct {
	commonExpectation
}

// String returns string representation
func (e *ExpectedClose) String() string {
	return "ExpectedClose => expecting call to Close()\n" + e.commonExpectation.String()
}

// ExpectedBegin is used to manage *pgx.Begin expectation
// returned by pgxmock.ExpectBegin.
type ExpectedBegin struct {
	commonExpectation
	opts pgx.TxOptions
}

// String returns string representation
func (e *ExpectedBegin) String() string {
	msg := "ExpectedBegin => expecting call to Begin() or to BeginTx()\n"
	if e.opts != (pgx.TxOptions{}) {
		msg += fmt.Sprintf("\t- transaction options awaited: %+v\n", e.opts)
	}
	return msg + e.commonExpectation.String()
}

// ExpectedCommit is used to manage pgx.Tx.Commit expectation
// returned by pgxmock.ExpectCommit.
type ExpectedCommit struct {
	commonExpectation
}

// String returns string representation
func (e *ExpectedCommit) String() string {
	return "ExpectedCommit => expecting call to Tx.Commit()\n" + e.commonExpectation.String()
}

// ExpectedExec is used to manage pgx.Exec, pgx.Tx.Exec or pgx.Stmt.Exec expectations.
// Returned by pgxmock.ExpectExec.
type ExpectedExec struct {
	commonExpectation
	queryBasedExpectation
	result pgconn.CommandTag
}

// WithArgs will match given expected args to actual database exec operation arguments.
// if at least one argument does not match, it will return an error. For specific
// arguments an pgxmock.Argument interface can be used to match an argument.
func (e *ExpectedExec) WithArgs(args ...interface{}) *ExpectedExec {
	e.args = args
	return e
}

// WithRewrittenSQL will match given expected expression to a rewritten SQL statement by
// an pgx.QueryRewriter argument
func (e *ExpectedExec) WithRewrittenSQL(sql string) *ExpectedExec {
	e.expectRewrittenSQL = sql
	return e
}

// String returns string representation
func (e *ExpectedExec) String() string {
	msg := "ExpectedExec => expecting call to Exec():\n"
	msg += fmt.Sprintf("\t- matches sql: '%s'\n", e.expectSQL)

	if len(e.args) == 0 {
		msg += "\t- is without arguments\n"
	} else {
		msg += "\t- is with arguments:\n"
		for i, arg := range e.args {
			msg += fmt.Sprintf("\t\t%d - %+v\n", i, arg)
		}
	}
	if e.result.String() != "" {
		msg += fmt.Sprintf("\t- returns result: %s\n", e.result)
	}

	return msg + e.commonExpectation.String()
}

// WillReturnResult arranges for an expected Exec() to return a particular
// result, there is pgxmock.NewResult(op string, rowsAffected int64) method
// to build a corresponding result.
func (e *ExpectedExec) WillReturnResult(result pgconn.CommandTag) *ExpectedExec {
	e.result = result
	return e
}

// ExpectedPrepare is used to manage pgx.Prepare or pgx.Tx.Prepare expectations.
// Returned by pgxmock.ExpectPrepare.
type ExpectedPrepare struct {
	commonExpectation
	mock           *pgxmock
	expectStmtName string
	expectSQL      string
	deallocateErr  error
	mustBeClosed   bool
	deallocated    bool
}

// WillReturnCloseError allows to set an error for this prepared statement Close action
func (e *ExpectedPrepare) WillReturnCloseError(err error) *ExpectedPrepare {
	e.deallocateErr = err
	return e
}

// WillBeClosed is for backward compatibility only and will be removed soon.
//
// Deprecated: One should use WillBeDeallocated() instead.
func (e *ExpectedPrepare) WillBeClosed() *ExpectedPrepare {
	return e.WillBeDeallocated()
}

// WillBeDeallocated expects this prepared statement to be deallocated
func (e *ExpectedPrepare) WillBeDeallocated() *ExpectedPrepare {
	e.mustBeClosed = true
	return e
}

// ExpectQuery allows to expect Query() or QueryRow() on this prepared statement.
// This method is convenient in order to prevent duplicating sql query string matching.
func (e *ExpectedPrepare) ExpectQuery() *ExpectedQuery {
	eq := &ExpectedQuery{}
	eq.expectSQL = e.expectStmtName
	e.mock.expectations = append(e.mock.expectations, eq)
	return eq
}

// ExpectExec allows to expect Exec() on this prepared statement.
// This method is convenient in order to prevent duplicating sql query string matching.
func (e *ExpectedPrepare) ExpectExec() *ExpectedExec {
	eq := &ExpectedExec{}
	eq.expectSQL = e.expectStmtName
	e.mock.expectations = append(e.mock.expectations, eq)
	return eq
}

// String returns string representation
func (e *ExpectedPrepare) String() string {
	msg := "ExpectedPrepare => expecting call to Prepare():"
	msg += fmt.Sprintf("\t- matches statement name: '%s'", e.expectStmtName)
	msg += fmt.Sprintf("\t- matches sql: '%s'\n", e.expectSQL)
	if e.deallocateErr != nil {
		msg += fmt.Sprintf("\t- returns error on Close: %s", e.deallocateErr)
	}
	return msg + e.commonExpectation.String()
}

// ExpectedPing is used to manage Ping() expectations
type ExpectedPing struct {
	commonExpectation
}

// String returns string representation
func (e *ExpectedPing) String() string {
	msg := "ExpectedPing => expecting call to Ping()\n"
	return msg + e.commonExpectation.String()
}

// ExpectedQuery is used to manage *pgx.Conn.Query, *pgx.Conn.QueryRow, *pgx.Tx.Query,
// *pgx.Tx.QueryRow, *pgx.Stmt.Query or *pgx.Stmt.QueryRow expectations
type ExpectedQuery struct {
	commonExpectation
	queryBasedExpectation
	rows             pgx.Rows
	rowsMustBeClosed bool
	rowsWereClosed   bool
}

// WithArgs will match given expected args to actual database query arguments.
// if at least one argument does not match, it will return an error. For specific
// arguments an pgxmock.Argument interface can be used to match an argument.
func (e *ExpectedQuery) WithArgs(args ...interface{}) *ExpectedQuery {
	e.args = args
	return e
}

// WithRewrittenSQL will match given expected expression to a rewritten SQL statement by
// an pgx.QueryRewriter argument
func (e *ExpectedQuery) WithRewrittenSQL(sql string) *ExpectedQuery {
	e.expectRewrittenSQL = sql
	return e
}

// RowsWillBeClosed expects this query rows to be closed.
func (e *ExpectedQuery) RowsWillBeClosed() *ExpectedQuery {
	e.rowsMustBeClosed = true
	return e
}

// String returns string representation
func (e *ExpectedQuery) String() string {
	msg := "ExpectedQuery => expecting call to Query() or to QueryRow():\n"
	msg += fmt.Sprintf("\t- matches sql: '%s'\n", e.expectSQL)

	if len(e.args) == 0 {
		msg += "\t- is without arguments\n"
	} else {
		msg += "\t- is with arguments:\n"
		for i, arg := range e.args {
			msg += fmt.Sprintf("\t\t%d - %+v\n", i, arg)
		}
	}
	if e.rows != nil {
		msg += fmt.Sprintf("%s\n", e.rows)
	}
	return msg + e.commonExpectation.String()
}

// WillReturnRows specifies the set of resulting rows that will be returned
// by the triggered query
func (e *ExpectedQuery) WillReturnRows(rows ...*Rows) *ExpectedQuery {
	e.rows = &rowSets{sets: rows, ex: e}
	return e
}

// ExpectedCopyFrom is used to manage *pgx.Conn.CopyFrom expectations.
// Returned by *Pgxmock.ExpectCopyFrom.
type ExpectedCopyFrom struct {
	commonExpectation
	expectedTableName pgx.Identifier
	expectedColumns   []string
	rowsAffected      int64
}

// String returns string representation
func (e *ExpectedCopyFrom) String() string {
	msg := "ExpectedCopyFrom => expecting CopyFrom which:"
	msg += "\n  - matches table name: '" + e.expectedTableName.Sanitize() + "'"
	msg += fmt.Sprintf("\n  - matches column names: '%+v'", e.expectedColumns)

	if e.err != nil {
		msg += fmt.Sprintf("\n  - should returns error: %s", e.err)
	}

	return msg
}

// WillReturnResult arranges for an expected CopyFrom() to return a number of rows affected
func (e *ExpectedCopyFrom) WillReturnResult(result int64) *ExpectedCopyFrom {
	e.rowsAffected = result
	return e
}

// ExpectedReset is used to manage pgx.Reset expectation
type ExpectedReset struct {
	commonExpectation
}

func (e *ExpectedReset) String() string {
	return "ExpectedReset => expecting database Reset"
}

// ExpectedRollback is used to manage pgx.Tx.Rollback expectation
// returned by pgxmock.ExpectRollback.
type ExpectedRollback struct {
	commonExpectation
}

// String returns string representation
func (e *ExpectedRollback) String() string {
	msg := "ExpectedRollback => expecting transaction Rollback"
	if e.err != nil {
		msg += fmt.Sprintf(", which should return error: %s", e.err)
	}
	return msg
}