table

type ColumnFilter struct {
	Index         int
	Operator      string
	Value, Escape interface{}
}

type ColumnOrder struct {
	Index int
	Desc  bool
}

type ErrCode int

type InsertableTable interface {
	Table

	TablePrepareInsert(ti *TableInsert) (TableInsertStmt, error)
}

type ModifyResult [2]*int64

type ScanError struct {
	ErrCode
	Operator    string
	FieldIndex  int
	FieldString string
}

type Table interface {
	Columns() []string

	// 'cols' must be specified, an the same array must be used in
	// any .Next() call onto the returned TableIterator object.
	// Otherwise the behavoir is undefined.
	//
	// If the *TableScan object is not acceptible, return an error,
	// preferribly a ScanError{}
	TableScan(cols []int, meta *TableScan) (TableIterator, error)
}

type TableInsert struct {
	AllCols bool
	Cols    []int

	Values [][]interface{}
	Op     TableOp

	OndupCols []int
	OndupVals []interface{}
}

type TableInsertStmt interface {
	Close() error
	Abort() error

	TableInsert(ti *TableInsert) (*ModifyResult, error)
}

type TableIterator interface {
	Close() error
	// Scan the next row. Return nil on success, io.EOF on end-of-table
	// and any other error if there is a true error.
	Next(cols []int, vals []interface{}) error
}

type TableOp int

type TableScan struct {
	Filter []ColumnFilter
	Order  []ColumnOrder
}

type TableUpdate struct {
	Op   TableOp
	Scan *TableScan

	UpdCols []int
	UpdVals []interface{}
}

type TableUpdateStmt interface {
	Close() error
	Abort() error

	TableUpdate(tu *TableUpdate) (*ModifyResult, error)
}

type UpdateableTable interface {
	Table

	TablePrepareUpdate(tu *TableUpdate) (TableUpdateStmt, error)
}