/// <summary> /// This method is designed to get the data about server from database /// </summary> /// <returns>The list of database objects</returns> public List <DbObject> GetDbData() { string getSizeRequest = "SELECT pg_database.datname AS database_name, pg_database_size(pg_database.datname) AS database_size FROM pg_database WHERE pg_database.datname NOT Like 'template_';"; NpgsqlConnection connection = new NpgsqlConnection(connectionParams); try { connection.Open(); Console.WriteLine($"Подключение к серверу \"{this.serverName}\""); } catch (Exception exp) { Console.WriteLine($"Ошибка подключения к серверу {this.serverName} \n {exp.ToString()}"); } NpgsqlCommand command = new NpgsqlCommand(getSizeRequest, connection); NpgsqlDataReader reader = command.ExecuteReader(); List <DbObject> dbObjects = new List <DbObject>(); while (reader.Read()) { double size = (double.Parse(reader.GetValue(1).ToString())) / 1024 / 1024 / 1024; size = Math.Round(size, 4); DbObject dbObject = new DbObject(this.serverName, reader.GetString(0), size); dbObjects.Add(dbObject); } connection.Close(); return(dbObjects); }
public List <DbObject> GetDbData() { List <DbObject> dbObjects = new List <DbObject>(); DbObject dbObject1 = new DbObject(serverName, "postgres", 0.00600641220808029); DbObject dbObject = new DbObject(serverName, "db", 0.00637262314558029); dbObjects.Add(dbObject1); dbObjects.Add(dbObject); return(dbObjects); }