resultset

type Arguments = query.Arguments

type Column interface {
	// Name returns the column name.
	Name() string
	// DataType returns the data type.
	DataType() DataType
	// Constraint returns the column constraint.
	Constraint() Constraint
	// IsFunction returns true whether the column is a function.
	IsFunction() bool
	// Function returns the function if the column is a function.
	Function() (Function, bool)
	// Arguments returns the executor arguments.
	Arguments() Arguments
	// DefinitionString returns the definition string representation.
	DefinitionString() string
	// String returns the string representation of the column.
	String() string
	// ColumnHelper provides additional methods for columns in a query.
	ColumnHelper
}

type ColumnHelper interface {
	// IsAsterisk returns true if the column is an asterisk.
	IsAsterisk() bool
	// IsFunction returns true if the column is a function.
	IsFunction() bool
}

type ColumnOption func(*column)

type Constraint = query.Constraint

type DataType = query.DataType

type Function = query.Function

type MapRow = map[string]any

type MapRows = []map[string]any

type ResultSet interface {
	// Schema returns the schema.
	Schema() Schema
	// Next returns the next row.
	Next() bool
	// Row returns the current row.
	Row() (Row, error)
	// RowsAffected returns the number of rows affected.
	RowsAffected() uint
	// Close closes the resultset.
	Close() error
}

type ResultSetOption func(*resultset) error

type Row interface {
	// Object returns the row object.
	Object() map[string]any
	// Values returns the row values.
	Values() []any
	// ValueAt returns the row value at the specified index.
	ValueAt(int) (any, error)
	// ValueBy returns the row value by the specified name.
	ValueBy(string) (any, error)
	// Scan scans the values.
	Scan(...any) error
	// ScanAt scans the value at the specified index.
	ScanAt(int, any) error
	// ScanBy scans the value by the specified name.
	ScanBy(string, any) error
}

type RowOption func(*row)

type RowsOption func(*rows) error

type Schema interface {
	// DatabaseName returns the database name.
	DatabaseName() string
	// TableName returns the table name.
	TableName() string
	// Selectows returns the selectors.
	Selectors() query.Selectors
	// Columns returns the columns.
	Columns() []Column
	// LookupColumn returns the column by the specified name.
	LookupColumn(name string) (Column, error)
}

type SchemaOption func(*schema) error