mssql

Documentation

Index

• func GetColumnColidAndRemark(db *sql.DB, id string, m map[string]string) map[string]string
• func GetColumnNameAndColid(db *sql.DB, id string) map[string]string
• func GetObjectID(db *sql.DB, tableName string) string
• func SearchKey(db *sql.DB, tableName string) map[string]bool
• func SearchRemark(db *sql.DB, tableName string) map[string]string
• type FlagMsSqlDbGen
  • func NewMsSqlDbGen(flag model.FlagModel) *FlagMsSqlDbGen
  • func (f *FlagMsSqlDbGen) AllTableData() (model.TableMataDataList, error)
  • func (f *FlagMsSqlDbGen) ConnectionDB() (err error)
  • func (f *FlagMsSqlDbGen) GetTableColumns(tableName string) (cols model.ColumnMetaDataList, err error)
  • func (f *FlagMsSqlDbGen) TableDataForSelect(flagModel model.FlagModel) (model.TableMataDataList, error)
• type MsSqlDBGen

Functions

func GetColumnColidAndRemark

func GetColumnColidAndRemark(db *sql.DB, id string, m map[string]string) map[string]string

GetColumnColidAndRemark 获取colid ID + 备注

func GetColumnNameAndColid

func GetColumnNameAndColid(db *sql.DB, id string) map[string]string

GetColumnNameAndColid 获取列的名称+colid ID

func GetObjectID

func GetObjectID(db *sql.DB, tableName string) string

GetObjectID 获取系统 objects 表中的id

func SearchKey

func SearchKey(db *sql.DB, tableName string) map[string]bool

SearchKey 查找主键

func SearchRemark

func SearchRemark(db *sql.DB, tableName string) map[string]string

SearchRemark 查找备注

Types

type FlagMsSqlDbGen

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

func NewMsSqlDbGen

func NewMsSqlDbGen(flag model.FlagModel) *FlagMsSqlDbGen

NewMsSqlDbGen 创建sqlserver生成器

func (*FlagMsSqlDbGen) AllTableData

func (f *FlagMsSqlDbGen) AllTableData() (model.TableMataDataList, error)

AllTableData 所有表的数据

func (*FlagMsSqlDbGen) ConnectionDB

func (f *FlagMsSqlDbGen) ConnectionDB() (err error)

ConnectionDB 测试连接数据库

func (*FlagMsSqlDbGen) GetTableColumns

func (f *FlagMsSqlDbGen) GetTableColumns(tableName string) (cols model.ColumnMetaDataList, err error)

GetTableColumns 根据表名称查询列元数据集

func (*FlagMsSqlDbGen) TableDataForSelect

func (f *FlagMsSqlDbGen) TableDataForSelect(flagModel model.FlagModel) (model.TableMataDataList, error)

type MsSqlDBGen

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