dbsql2go

type Constraint struct {
	Type       ConstraintType // The key or constraint type
	Name       string         // Name of key
	Table      string         // the table to which this key belongs.
	Columns    []string       // the columns that this key/constraint are on, in order.
	Fields     []string       // the Go struct field names corresponding to the table's column names.
	RefTable   string         // Referred to table for Foreign Keys
	RefColumns []string       // Referred to columns, in order, for Foreign Keys
	RefFields  []string       // the Go struct field names corresponding to the table's column names.
}

type ConstraintType int

type DBType int

type DBer interface {
	Get() error
	GetTables() error
	Tables() []Tabler
	GetIndexes() error
	GetConstraints() error
	GetViews() error
	Views() []Viewer
	UpdateTableConstraints() error
	UpdateTableIndexes()
}

type Index struct {
	Type    string   // type of Index
	Primary bool     // if the Index is a primary key
	Name    string   // Name of Index
	Table   string   // Index's table
	Columns []string // Index Columns, in order.
}

type Indexer interface {
	Name() string // Just so that there's semething to fulfill until this gets fleshed out further.
}

type TableSQL struct {
	Table              string   // the table from which to SELECT
	Columns            []string // the columns that will be SELECTed
	WhereColumns       []string // the where column names
	WhereComparisonOps []string // the comparison operator for the corresponding column index
	WhereConditions    []string // The conditional operator for Column pairs.
}

type Tabler interface {
	//Columns() []Column
	Name() string
	Schema() string
	Collation() string
	Definition(io.Writer) error
	Go(io.Writer) error
	GoFmt(io.Writer) error
	ColumnNames() []string
	NonPKColumnNames() []string
	Indexes() []Index
	Constraints() []Constraint
	IsView() bool // If this is actually a view
	PK() *Constraint
	StructName() string
}

type UnknownConstraintErr struct {
	Value string
}

type UnsupportedDBErr struct {
	Value string
}

type Viewer interface {
	Name() string // Just so that there's semething to fulfill until this gets fleshed out further.
}