dialect

type Column struct {
	Name      string
	Nullable  bool
	DataType  string
	TableName string
	Position  int64
}

type Columns []Column

type Dialect interface {
	Close(context.Context) error
	ReferenceKeys(context.Context, string) (ReferenceKeys, error)
	ForeignKeys(context.Context, string) (ForeignKeys, error)
	PrimaryKeyConstraint(context.Context, string) (string, error)
	Tables(context.Context) (Tables, error)
	Table(context.Context, string) (Table, error)
	Columns(context.Context, string) ([]Column, error)
	BulkInsert(context.Context, Table, []map[string]interface{}) error
	ResultSet(context.Context, string, ...interface{}) ([]map[string]interface{}, error)
}

type ForeignKey struct {
	Name                 string
	Definition           string
	ColumnName           string
	ReferencedTableName  string
	ReferencedTable      Table
	ReferencedColumnName string
}

type ForeignKeys []ForeignKey

type PrimaryKey struct {
	Name      string
	DataType  string
	TableName string
}

type ReferenceKey struct {
	Name       string
	Table      Table
	TableName  string
	ColumnName string
}

type ReferenceKeys []ReferenceKey

type Table struct {
	Name          string
	PrimaryKeys   []PrimaryKey
	Columns       Columns
	ForeignKeys   ForeignKeys
	ReferenceKeys ReferenceKeys
}

type Tables []Table