db

type Column struct {
	OrdinalPosition        int            `json:"ordinal_position" gorm:"column:ordinal_position"`
	Name                   string         `json:"column_name" gorm:"column:column_name"`
	DataType               string         `json:"data_type" gorm:"column:data_type"`
	DefaultValue           sql.NullString `json:"column_default" gorm:"column:column_default"`
	IsNullable             string         `json:"is_nullable" gorm:"column:is_nullable"`
	CharacterMaximumLength sql.NullInt64  `json:"character_maximum_length" gorm:"column:character_maximum_length"`
	NumericPrecision       sql.NullInt64  `json:"numeric_precision" gorm:"column:numeric_precision"`
	ColumnKey              string         `json:"column_key" gorm:"column:column_key"`           // mysql specific
	Extra                  string         `json:"extra" gorm:"column:extra"`                     // mysql specific
	ConstraintName         sql.NullString `json:"constraint_name" gorm:"column:constraint_name"` // pg specific
	ConstraintType         sql.NullString `json:"constraint_type" gorm:"column:constraint_type"` // pg specific
}

type Conn struct {
	// contains filtered or unexported fields
}

type DBType string

type Database interface {
	GetTables() (tables []*Table, err error)
	// PrepareGetColumnsOfTableStmt() (err error)
	GetColumnsOfTable(table *Table) (err error)

	IsPrimaryKey(column Column) bool
	IsAutoIncrement(column Column) bool
	IsNullable(column Column) bool

	GetStringDatatypes() []string
	IsString(column Column) bool

	GetTextDatatypes() []string
	IsText(column Column) bool

	GetIntegerDatatypes() []string
	IsInteger(column Column) bool

	GetFloatDatatypes() []string
	IsFloat(column Column) bool

	GetTemporalDatatypes() []string
	IsTemporal(column Column) bool
}

type GeneralDatabase struct {
	// contains filtered or unexported fields
}

type NetworkDB struct {
	Database string
	User     string
	Password string
	Host     string
	Port     uint16
	Debug    bool

	ConnectionTimeout int // Seconds

	// database/sql tunables, see
	// https://golang.org/pkg/database/sql/#DB.SetConnMaxLifetime and below
	// Note: defaults will be set if these are 0
	MaxOpenConns    int `json:"maxOpenConns"`    // default: 5
	MaxIdleConns    int `json:"maxIdleConns"`    // default: 5
	ConnMaxLifetime int `json:"connMaxLifetime"` // Seconds, default: not set
}

type SSL struct {
	Mode   string
	CAFile string `json:"cAFile"`
	// Files for client auth.
	KeyFile  string `json:"keyFile"`
	CertFile string `json:"certFile"`
}

type Storage interface {
	Open(logger *log.Logger) (*Conn, error)
}

type Table struct {
	Name    string   `json:"table_name" gorm:"column:table_name"`
	Columns []Column `json:"columns" gorm:"-"`
}