info

Documentation

Index

• type ColumnInfo
  • func GetColumnInfo(table, column string, db *sqlx.DB) *ColumnInfo
  • func (ci *ColumnInfo) GetUniqueKey() *IndexInfo
  • func (ci *ColumnInfo) HasDefault() (bool, string)
  • func (ci *ColumnInfo) IsPrimary() bool
  • func (ci *ColumnInfo) IsUnique() bool
  • func (ci *ColumnInfo) Nullable() bool
• type IndexInfo
  • func GetIndexInfoByColumn(table, column string, db *sqlx.DB) []*IndexInfo
  • func GetIndexInfoByTable(table string, db *sqlx.DB) []*IndexInfo
  • func (ii *IndexInfo) IsForeign() bool
  • func (ii *IndexInfo) IsPrimary() bool
  • func (ii *IndexInfo) IsUnique() bool
• type KeyInfo
  • func GetKeyInfo(name string, db *sqlx.DB) *KeyInfo

Types

type ColumnInfo

type ColumnInfo struct {
	ColumnDefault  sql.NullString `db:"COLUMN_DEFAULT"`
	IsNullable     string         `db:"IS_NULLABLE"`
	ColumnType     string         `db:"COLUMN_TYPE"`
	ColumnKey      string         `db:"COLUMN_KEY"`
	ColumnKeysInfo []*IndexInfo
}

func GetColumnInfo

func GetColumnInfo(table, column string, db *sqlx.DB) *ColumnInfo

func (*ColumnInfo) GetUniqueKey

func (ci *ColumnInfo) GetUniqueKey() *IndexInfo

func (*ColumnInfo) HasDefault

func (ci *ColumnInfo) HasDefault() (bool, string)

func (*ColumnInfo) IsPrimary

func (ci *ColumnInfo) IsPrimary() bool

func (*ColumnInfo) IsUnique

func (ci *ColumnInfo) IsUnique() bool

func (*ColumnInfo) Nullable

func (ci *ColumnInfo) Nullable() bool

type IndexInfo

type IndexInfo struct {
	NonUnique int    `db:"Non_unique"`
	KeyName   string `db:"Key_name"`
}

func GetIndexInfoByColumn

func GetIndexInfoByColumn(table, column string, db *sqlx.DB) []*IndexInfo

func GetIndexInfoByTable

func GetIndexInfoByTable(table string, db *sqlx.DB) []*IndexInfo

func (*IndexInfo) IsForeign

func (ii *IndexInfo) IsForeign() bool

func (*IndexInfo) IsPrimary

func (ii *IndexInfo) IsPrimary() bool

func (*IndexInfo) IsUnique

func (ii *IndexInfo) IsUnique() bool

type KeyInfo

type KeyInfo struct {
	ConstraintName       string `db:"CONSTRAINT_NAME"`
	TableName            string `db:"TABLE_NAME"`
	ColumnName           string `db:"COLUMN_NAME"`
	ReferencedTableName  string `db:"REFERENCED_TABLE_NAME"`
	ReferencedColumnName string `db:"REFERENCED_COLUMN_NAME"`
}

func GetKeyInfo

func GetKeyInfo(name string, db *sqlx.DB) *KeyInfo