dbconfig

Documentation

Index

• func AddDBconfig(upd Dbconfigs) error
• func ChangeDBconfigStatus(id int, status int) error
• func CheckDbExists(upd Dbconfigs) int
• func CheckMysqlConnect(host string, port string, db_name string, username string, password string) error
• func CheckOracleConnect(host string, port string, inst_name string, username string, password string) error
• func CheckSqlserverConnect(host string, port string, inst_name string, db_name string, username string, ...) error
• func CountDBconfig(condArr map[string]string) int64
• func DeleteDBconfig(ids string) error
• func GetDBAlias(id int) string
• func GetDBDesc(id int) string
• func GetDBtype(id int) string
• func GetDBtypeByDBId(id int) int
• func UpdateDBconfig(id int, upd Dbconfigs) error
• type Dbconfigs
  • func GetDBconfig(id int) (Dbconfigs, error)
  • func ListAllDBconfig() (dbconf []Dbconfigs)
  • func ListDBconfig(condArr map[string]string, page int, offset int) (num int64, err error, dbconf []Dbconfigs)
  • func ListPrimaryDBconfig() (dbconf []Dbconfigs)
  • func ListScreenDBconfig() (dbconf []Dbconfigs)
  • func ListStandbyDBconfig() (dbconf []Dbconfigs)
  • func (this *Dbconfigs) TableName() string

Functions

func AddDBconfig

func AddDBconfig(upd Dbconfigs) error

添加数据库

func ChangeDBconfigStatus

func ChangeDBconfigStatus(id int, status int) error

更改资产状态

func CheckDbExists

func CheckDbExists(upd Dbconfigs) int

func CheckMysqlConnect

func CheckMysqlConnect(host string, port string, db_name string, username string, password string) error

func CheckOracleConnect

func CheckOracleConnect(host string, port string, inst_name string, username string, password string) error

func CheckSqlserverConnect

func CheckSqlserverConnect(host string, port string, inst_name string, db_name string, username string, password string) error

func CountDBconfig

func CountDBconfig(condArr map[string]string) int64

统计数量

func DeleteDBconfig

func DeleteDBconfig(ids string) error

func GetDBAlias

func GetDBAlias(id int) string

根据资产ID获取资产别名

func GetDBDesc

func GetDBDesc(id int) string

根据资产ID获取资产描述

func GetDBtype

func GetDBtype(id int) string

根据类型ID获取数据库类型

func GetDBtypeByDBId

func GetDBtypeByDBId(id int) int

根据ID获取数据库类型

func UpdateDBconfig

func UpdateDBconfig(id int, upd Dbconfigs) error

修改数据库配置信息

Types

type Dbconfigs

type Dbconfigs struct {
	Id             int    `orm:"pk;column(id);"`
	Dbtype         int    `orm:"column(asset_type);"`
	Host           string `orm:"column(host);"`
	Protocol       string `orm:"column(protocol);"`
	Port           int    `orm:"column(port);"`
	Alias          string `orm:"column(alias);"`
	InstanceName   string `orm:"column(instance_name);"`
	Dbname         string `orm:"column(db_name);"`
	Username       string `orm:"column(username);"`
	Password       string `orm:"column(password);"`
	Role           int    `orm:"column(role);"`
	Ostype         int    `orm:"column(os_type);"`
	OsProtocol     string `orm:"column(os_protocol);"`
	OsPort         int    `orm:"column(os_port);"`
	OsUsername     string `orm:"column(os_username);"`
	OsPassword     string `orm:"column(os_password);"`
	Status         int    `orm:"column(status);"`
	Display_Order  int    `orm:"column(display_order);"`
	IsDelete       int    `orm:"column(is_delete);"`
	Show_On_Screen int    `orm:"column(show_on_screen);"`
	Retention      int    `orm:"column(retention);"`
	Is_Alert       int    `orm:"column(is_alert);"`
	Alert_Mail     int    `orm:"column(alert_mail);"`
	Alert_WeChat   int    `orm:"column(alert_wechat);"`
	Alert_SMS      int    `orm:"column(alert_sms);"`
	Created        int64  `orm:"column(created);"`
	Updated        int64  `orm:"column(updated);"`
}

func GetDBconfig

func GetDBconfig(id int) (Dbconfigs, error)

得到数据库配置信息

func ListAllDBconfig

func ListAllDBconfig() (dbconf []Dbconfigs)

func ListDBconfig

func ListDBconfig(condArr map[string]string, page int, offset int) (num int64, err error, dbconf []Dbconfigs)

获取数据库配置列表

func ListPrimaryDBconfig

func ListPrimaryDBconfig() (dbconf []Dbconfigs)

func ListScreenDBconfig

func ListScreenDBconfig() (dbconf []Dbconfigs)

func ListStandbyDBconfig

func ListStandbyDBconfig() (dbconf []Dbconfigs)

func (*Dbconfigs) TableName

func (this *Dbconfigs) TableName() string