dbconfig

package
v0.0.0-...-1489327 Latest Latest
Warning

This package is not in the latest version of its module.

Go to latest
Published: Apr 9, 2022 License: GPL-2.0 Imports: 11 Imported by: 0

Documentation

Index

Constants

This section is empty.

Variables

This section is empty.

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

Jump to

Keyboard shortcuts

? : This menu
/ : Search site
f or F : Jump to
y or Y : Canonical URL