// GetAllProjects returns a list of all project objects
func GetAllProjects(dbConn *sql.DB) ([]types.Project, error) {
//logit.Info.Println("admindb:GetAllProjects: called")
var rows *sql.Rows
var err error
rows, err = dbConn.Query("select id, name, description, to_char(updatedt, 'MM-DD-YYYY HH24:MI:SS') from project order by name")
if err != nil {
return nil, err
}
defer rows.Close()
projects := make([]types.Project, 0)
var containers []types.Container
var clusters []types.Cluster
var proxies []types.Proxy
for rows.Next() {
project := types.Project{}
if err = rows.Scan(
&project.ID,
&project.Name,
&project.Desc,
&project.UpdateDate); err != nil {
return nil, err
}
project.Proxies = make(map[string]string)
proxies, err = GetAllProxiesForProject(dbConn, project.ID)
if err != nil {
logit.Info.Println("admindb:GetAllProjects:" + err.Error())
return projects, err
}
for i := range proxies {
project.Proxies[proxies[i].ContainerID] = proxies[i].ContainerName
}
project.Containers = make(map[string]string)
containers, err = GetAllContainersForProject(dbConn, project.ID)
if err != nil {
logit.Info.Println("admindb:GetAllProjects:" + err.Error())
return projects, err
}
for i := range containers {
project.Containers[containers[i].ID] = containers[i].Name
}
project.Clusters = make(map[string]string)
clusters, err = GetAllClustersForProject(dbConn, project.ID)
if err != nil {
logit.Info.Println("admindb:GetAllProjects:" + err.Error())
return projects, err
}
for i := range clusters {
project.Clusters[clusters[i].ID] = clusters[i].Name
}
projects = append(projects, project)
}
if err = rows.Err(); err != nil {
return nil, err
}
return projects, nil
}
