resultset

type Column interface {
	// Name returns the column name.
	Name() string
	// DataType returns the data type.
	DataType() DataType
	// Constraint returns the column constraint.
	Constraint() Constraint
}

type ColumnOption func(*column)

type Constraint = query.Constraint

type DataType = query.DataType

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() uint64
	// Close closes the resultset.
	Close() error
}

type ResultSetOption func(*resultset)

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 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)