database

Documentation

Index

• func AddAgent(database *sql.DB, agentId string, path string) error
• func AgentIDExists(database *sql.DB, agentId string) bool
• func CreateDB(dbName string) (*sql.DB, error)
• func GetAgents(database *sql.DB) []string
• func GetCustomMetricNames(database *sql.DB) []string
• func GetDBPathForAgent(database *sql.DB, agentId string) string
• func GetLogFromDB(database *sql.DB, logType string, from int64, to int64, time int64) []string
• func GetLogFromDBCount(database *sql.DB, logType string, count int64) []string
• func OpenDB(db *sql.DB, path string) (*sql.DB, error)
• func RemoveAgent(database *sql.DB, agentId string) error
• func SaveLogToDB(database *sql.DB, unixTime string, jsonStr string, logType string) error
• type MySql
  • func (mysql *MySql) AddAgent(agentId string, timezone string) error
  • func (mysql *MySql) AgentIDExists(agentId string) bool
  • func (mysql *MySql) Close()
  • func (mysql *MySql) Connect(user string, password string, host string, database string, ...)
  • func (mysql *MySql) GetAgents() []string
  • func (mysql *MySql) GetCustomMetricNames(serverName string) []string
  • func (mysql *MySql) GetLogFromDB(serverName string, logType string, from int64, to int64, time int64) []string
  • func (mysql *MySql) GetLogFromDBCount(serverId string, logType string, count int64) []string
  • func (mysql *MySql) Init() error
  • func (mysql *MySql) RemoveAgent(agentId string) error
  • func (mysql *MySql) SaveLogToDB(serverName string, unixTime string, jsonStr string, logType string) error
  • func (mysql *MySql) Select(query string, args ...interface{}) (Table, error)
• type Table

Functions

func AddAgent

func AddAgent(database *sql.DB, agentId string, path string) error

AddAgent adds the agent to the given DB

func AgentIDExists

func AgentIDExists(database *sql.DB, agentId string) bool

AgenIDExists checks if agent is added to the db

func CreateDB

func CreateDB(dbName string) (*sql.DB, error)

CreateDB create and return SQLite DB

func GetAgents

func GetAgents(database *sql.DB) []string

func GetCustomMetricNames

func GetCustomMetricNames(database *sql.DB) []string

func GetDBPathForAgent

func GetDBPathForAgent(database *sql.DB, agentId string) string

GetDBPathForAgent returns the db path of the given agent

func GetLogFromDB

func GetLogFromDB(database *sql.DB, logType string, from int64, to int64, time int64) []string

GetLogFromDB returns log records of the given log type in the given time/range

func GetLogFromDBCount

func GetLogFromDBCount(database *sql.DB, logType string, count int64) []string

GetLogFromDBCount returns log records of the given log type

func OpenDB

func OpenDB(db *sql.DB, path string) (*sql.DB, error)

OpenDB opens a SQLite DB file

func RemoveAgent

func RemoveAgent(database *sql.DB, agentId string) error

RemoveAgent removes agent info

func SaveLogToDB

func SaveLogToDB(database *sql.DB, unixTime string, jsonStr string, logType string) error

SaveLogToDB saves given monitor log to the sqlite DB

Types

type MySql

type MySql struct {
	DB        *sql.DB
	SqlErr    error
	Connected bool
	User      string
	Host      string
	Database  string
}

func (*MySql) AddAgent

func (mysql *MySql) AddAgent(agentId string, timezone string) error

func (*MySql) AgentIDExists

func (mysql *MySql) AgentIDExists(agentId string) bool

func (*MySql) Close

func (mysql *MySql) Close()

func (*MySql) Connect

func (mysql *MySql) Connect(user string, password string, host string, database string, isMultiStatement bool)

func (*MySql) GetAgents

func (mysql *MySql) GetAgents() []string

func (*MySql) GetCustomMetricNames

func (mysql *MySql) GetCustomMetricNames(serverName string) []string

func (*MySql) GetLogFromDB

func (mysql *MySql) GetLogFromDB(serverName string, logType string, from int64, to int64, time int64) []string

func (*MySql) GetLogFromDBCount

func (mysql *MySql) GetLogFromDBCount(serverId string, logType string, count int64) []string

func (*MySql) Init

func (mysql *MySql) Init() error

func (*MySql) RemoveAgent

func (mysql *MySql) RemoveAgent(agentId string) error

func (*MySql) SaveLogToDB

func (mysql *MySql) SaveLogToDB(serverName string, unixTime string, jsonStr string, logType string) error

func (*MySql) Select

func (mysql *MySql) Select(query string, args ...interface{}) (Table, error)

type Table

type Table struct {
	Name    string
	Headers []string
	Data    [][]string
}