admindb

package
v0.0.0-...-182d01c Latest Latest
Warning

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

Go to latest
Published: Sep 22, 2016 License: Apache-2.0 Imports: 9 Imported by: 0

Documentation

Overview

Package admindb is the implementation of most of the database access code that CPM uses to control and get metadata out of the CPM administrative database. This database is implement in a Postgresql database.

Index

Constants

View Source
const CPMTEST_DB = "cpmtest"
View Source
const CPMTEST_USER = "cpmtest"

Variables

This section is empty.

Functions

func AddContainerUser

func AddContainerUser(dbConn *sql.DB, s types.ContainerUser) (int, error)

AddContainerUser inserts a new database user for a given container and returns the new ID

func DeleteCluster

func DeleteCluster(dbConn *sql.DB, id string) error

DeleteCluster deletes a given cluster from the database

func DeleteContainer

func DeleteContainer(dbConn *sql.DB, id string) error

DeleteContainer deleles a given container

func DeleteContainerUser

func DeleteContainerUser(dbConn *sql.DB, containername string, rolname string) error

DeleteContainerUser deletes a container database user

func DeleteHealthCheck

func DeleteHealthCheck(dbConn *sql.DB) error

DeleteHealthCheck deleles the entire set of health check metrics that are persisted

func DeleteProject

func DeleteProject(dbConn *sql.DB, id string) error

DeleteProject deletes a given project

func GetAllClustersForProject

func GetAllClustersForProject(dbConn *sql.DB, projectId string) ([]types.Cluster, error)

GetAllClustersForProject returns a list of cluster objects from the database for a given project

func GetAllContainers

func GetAllContainers(dbConn *sql.DB) ([]types.Container, error)

GetAllContainers returns a list of all containers

func GetAllContainersForCluster

func GetAllContainersForCluster(dbConn *sql.DB, clusterID string) ([]types.Container, error)

GetAllContainersForCluster returns a list of container objects for a given cluster

func GetAllContainersForProject

func GetAllContainersForProject(dbConn *sql.DB, projectID string) ([]types.Container, error)

GetAllContainersForProject returns a list of container objects for a given project

func GetAllContainersForServer

func GetAllContainersForServer(dbConn *sql.DB, serverID string) ([]types.Container, error)

GetAllContainersForServer returns a list of container objects for a given server

func GetAllContainersNotInCluster

func GetAllContainersNotInCluster(dbConn *sql.DB) ([]types.Container, error)

GetAllContainersNotInCluster is used to fetch all nodes that are eligible to be added into a cluster

func GetAllGeneralSettings

func GetAllGeneralSettings(dbConn *sql.DB) ([]types.Setting, error)

GetAllGeneralSettings returns a list of all settings of 'general' types

func GetAllProjects

func GetAllProjects(dbConn *sql.DB) ([]types.Project, error)

GetAllProjects returns a list of all project objects

func GetAllProxiesForProject

func GetAllProxiesForProject(dbConn *sql.DB, projectID string) ([]types.Proxy, error)

GetAllProxiesForProject returns a list of proxy objects for a given project

func GetAllSettings

func GetAllSettings(dbConn *sql.DB) ([]types.Setting, error)

GetAllSettings returns a list of all settings

func GetAllSettingsMap

func GetAllSettingsMap(dbConn *sql.DB) (map[string]string, error)

GetAllSettingsMap returns a map of all settings

func GetAllStandbyContainers

func GetAllStandbyContainers(dbConn *sql.DB, clusterid string) ([]types.Container, error)

GetAllStandbyContainers returns a list of container standby objects for a given cluster TODO combine with GetMaster into a GetContainersByRole func

func GetCluster

func GetCluster(dbConn *sql.DB, id string) (types.Cluster, error)

GetCluster returns a cluster object from the database for a given cluster ID

func GetClusterName

func GetClusterName(dbConn *sql.DB, id string) (string, error)

GetClusterName returns the name of a cluster based for a given cluster ID

func GetContainer

func GetContainer(dbConn *sql.DB, id string) (types.Container, error)

GetContainer returns a container object based on a container ID

func GetContainerByName

func GetContainerByName(dbConn *sql.DB, name string) (types.Container, error)

GetContainerByName returns a container object based on a container name

func GetContainerMaster

func GetContainerMaster(dbConn *sql.DB, clusterid string) (types.Container, error)

GetContainerMaster find the master container in a cluster

func GetContainerOldestInCluster

func GetContainerOldestInCluster(dbConn *sql.DB, clusterid string) (types.Container, error)

GetContainerOldestInCluster find the oldest container in a cluster

func GetContainerPgpool

func GetContainerPgpool(dbConn *sql.DB, clusterid string) (types.Container, error)

GetContainerPgpool find the pgpool container in a cluster

func GetContainerUser

func GetContainerUser(dbConn *sql.DB, containername string, usename string) (types.ContainerUser, error)

GetContainerUser returns a container user for a given container and user name

func GetDatabaseStatus

func GetDatabaseStatus(proxy types.Proxy, containerid string) (string, error)

GetDatabaseStatus returns a simple status of a container database

func GetHealthCheck

func GetHealthCheck(dbConn *sql.DB) ([]types.HealthCheck, error)

GetHealthCheck return the current set of healthcheck metrics that are persisted

func GetProject

func GetProject(dbConn *sql.DB, id string) (types.Project, error)

GetProject returns a given project object

func GetProxy

func GetProxy(dbConn *sql.DB, containername string) (types.Proxy, error)

GetProxy returns a given proxy object by container name

func GetProxyByContainerID

func GetProxyByContainerID(dbConn *sql.DB, containerID string) (types.Proxy, error)

GetProxyByContainerID returns a proxy object by container ID

func GetSetting

func GetSetting(dbConn *sql.DB, key string) (types.Setting, error)

GetSetting returns a particular setting based on it's key

func GetUserCredentials

func GetUserCredentials(dbConn *sql.DB, node *types.Container) (types.Credential, error)

GetUserCredentials return the set of database credentials stored for a given container

func InsertCluster

func InsertCluster(dbConn *sql.DB, cluster types.Cluster) (int, error)

InsertCluster inserts a new cluster object into the database

func InsertContainer

func InsertContainer(dbConn *sql.DB, container types.Container) (int, error)

InsertContainer inserts a new container object and returns the container id

func InsertHealthCheck

func InsertHealthCheck(dbConn *sql.DB, hc types.HealthCheck) (int, error)

InsertHealthCheck insert a health check metric into the database, return the key

func InsertProject

func InsertProject(dbConn *sql.DB, project types.Project) (int, error)

InsertProject inserts a new project object

func InsertSetting

func InsertSetting(dbConn *sql.DB, setting types.Setting) error

func UpdateCluster

func UpdateCluster(dbConn *sql.DB, cluster types.Cluster) error

UpdateCluster updates a given cluster object in the database

func UpdateContainer

func UpdateContainer(dbConn *sql.DB, container types.Container) error

UpdateContainer updates a given container

func UpdateContainerUser

func UpdateContainerUser(dbConn *sql.DB, user types.ContainerUser) error

UpdateContainerUser updates a given container database user

func UpdateProject

func UpdateProject(dbConn *sql.DB, project types.Project) error

UpdateProject updates a given project object

func UpdateSetting

func UpdateSetting(dbConn *sql.DB, setting types.Setting) error

UpdateSetting updates a given setting value

Types

This section is empty.

Jump to

Keyboard shortcuts

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