ptable

type Column interface {
	Owner() Table
	TableName() string
	ColumnName() string
}

type ColumnBool interface {
	Column
	Get(row Row) bool
	Set(row Row, value bool)
}

type ColumnFloat32 interface {
	Column
	Get(row Row) float32
	Set(row Row, value float32)
}

type ColumnFloat64 interface {
	Column
	Get(row Row) float64
	Set(row Row, value float64)
}

type ColumnInt interface {
	Column
	Get(row Row) int
	Set(row Row, value int)
}

type ColumnInt16 interface {
	Column
	Get(row Row) int16
	Set(row Row, value int16)
}

type ColumnInt32 interface {
	Column
	Get(row Row) int32
	Set(row Row, value int32)
}

type ColumnInt64 interface {
	Column
	Get(row Row) int64
	Set(row Row, value int64)
}

type ColumnInt8 interface {
	Column
	Get(row Row) int8
	Set(row Row, value int8)
}

type ColumnString interface {
	Column
	Get(row Row) string
	Set(row Row, value string)
}

type ColumnTime interface {
	Column
	Get(row Row) time.Time
	Set(row Row, value time.Time)
}

type ColumnUint interface {
	Column
	Get(row Row) uint
	Set(row Row, value uint)
}

type ColumnUint16 interface {
	Column
	Get(row Row) uint16
	Set(row Row, value uint16)
}

type ColumnUint32 interface {
	Column
	Get(row Row) uint32
	Set(row Row, value uint32)
}

type ColumnUint64 interface {
	Column
	Get(row Row) uint64
	Set(row Row, value uint64)
}

type ColumnUint8 interface {
	Column
	Get(row Row) uint8
	Set(row Row, value uint8)
}

type ColumnX interface {
	Column
}

type DataDir interface {
	Path() fs.Path
	OpenDatabase(name string, init bool) (Database, error)
}

type DataDirFactory interface {
	// Init(dir fs.Path) (DataDir, error)
	Open(dir fs.Path, init bool) (DataDir, error)
}

type DataSource interface {
	GetSession() Session
	GetDatabase() Database
}

type Database interface {
	Name() string
	Path() fs.Path
	Owner() DataDir
	OpenTable(p *TableOpen) (Table, error)
	OpenSession() (Session, error)
}

type DatabaseFactory interface {
	Open(name string, dir fs.Path, owner DataDir, init bool) (Database, error)
}

type Repository interface {
	Init(ds DataSource) error
}

type Row interface {
	Owner() Table
	Key() string
	Delete() error
	SetValue(field string, value string) error
	GetValue(field string) (string, error)
	Exists() bool
}

type Session interface {
	io.Closer
	BeginTransaction() Transaction
	DB() Database
	GetProperties(table Table) collection.Properties
	ListIDs(table Table) []string
	GetRow(table Table, key string) Row
	GetRowRequired(table Table, key string) (Row, error)
}

type SessionFactory interface {
	OpenSession(db Database) (Session, error)
}

type SessionManager interface {
	GetSession(db Database, create bool) (Session, error)
}

type Table interface {
	Owner() Database
	Path() fs.Path
	Name() string
	PrimaryKey() string

	GetColumnString(name string) ColumnString
	GetColumnBool(name string) ColumnBool
	GetColumnTime(name string) ColumnTime

	GetColumnFloat32(name string) ColumnFloat32
	GetColumnFloat64(name string) ColumnFloat64

	GetColumnInt(name string) ColumnInt
	GetColumnInt8(name string) ColumnInt8
	GetColumnInt16(name string) ColumnInt16
	GetColumnInt32(name string) ColumnInt32
	GetColumnInt64(name string) ColumnInt64

	GetColumnUint(name string) ColumnUint
	GetColumnUint8(name string) ColumnUint8
	GetColumnUint16(name string) ColumnUint16
	GetColumnUint32(name string) ColumnUint32
	GetColumnUint64(name string) ColumnUint64
}

type TableFactory interface {
	Open(p *TableOpen) (Table, error)
}

type TableOpen struct {
	TableName  string
	PrimaryKey string // default is 'id'
	File       fs.Path
	OwnerDB    Database
	DoInit     bool
}

type Transaction interface {
	io.Closer
	Commit()
	Rollback()
}