/// <summary>
/// Draws the LSN map page.
/// </summary>
/// <param name="g">The graphics object.</param>
/// <param name="rect">The page Rectange.</param>
/// <param name="lsn">The LSN.</param>
/// <param name="maxLsn">The max LSN.</param>
/// <param name="minLsn">The min LSN.</param>
internal static void DrawLsnMapPage(Graphics g, Rectangle rect, decimal lsn, decimal maxLsn, decimal minLsn)
{
var h = 140;
var step = 230F / ((float)(maxLsn - minLsn));
var value = (int)(step / 1.175F * (float)lsn);
var pageColour = HsvColour.HsvToColor(h, (255 - value) % 255, value);
g.FillRectangle(new SolidBrush(pageColour), rect);
g.DrawRectangle(Pens.White, rect);
}
/// <summary>
/// Generates map layers by loading object's allocation structures
/// </summary>
/// <param name="database">The database.</param>
/// <param name="worker">The backgroundWorker object.</param>
/// <returns></returns>
public static List <AllocationLayer> GenerateLayers(Database database, BackgroundWorker worker, bool separateIndexes, bool separateSystemObjects)
{
var layers = new List <AllocationLayer>();
AllocationLayer layer = null;
var colourIndex = 0;
var count = 0;
var systemColourIndex = 0;
var previousObjectName = string.Empty;
var allocationUnits = database.AllocationUnits();
string filter;
if (separateIndexes)
{
filter = "allocation_unit_type=1 AND index_id < 2";
}
else
{
filter = string.Empty;
}
var userObjectCount = (int)allocationUnits.Compute("COUNT(table_name)", filter + " AND system=0"); // "allocation_unit_type=1 AND system=0 AND index_id < 2");
var systemObjectCount = (int)allocationUnits.Compute("COUNT(table_name)", filter + " AND system=1"); //, "allocation_unit_type=1 AND system=1 AND index_id < 2");
foreach (DataRow row in allocationUnits.Rows)
{
if (worker.CancellationPending)
{
return(null);
}
count++;
string currentObjectName;
if ((bool)row["system"] && !separateSystemObjects)
{
currentObjectName = "(System object)";
}
else
{
if (separateIndexes && !string.IsNullOrEmpty(row["index_name"].ToString()))
{
currentObjectName = row["schema_name"] + "." + row["table_name"] + "." + row["index_name"];
}
else
{
currentObjectName = row["schema_name"] + "." + row["table_name"];
}
}
if (currentObjectName != previousObjectName)
{
layer = new AllocationLayer();
layer.Name = currentObjectName;
layer.ObjectName = row["schema_name"] + "." + row["table_name"];
if (!Convert.ToBoolean(row["system"]))
{
layer.IndexName = row["index_name"].ToString();
layer.UsedPages = Convert.ToInt32(row["used_pages"]);
layer.TotalPages = Convert.ToInt32(row["total_pages"]);
layer.IndexType = (IndexTypes)Convert.ToInt32(row["index_type"]);
}
layer.UseDefaultSinglePageColour = false;
if ((bool)row["system"])
{
if (layer.Name != previousObjectName)
{
systemColourIndex += (int)Math.Floor(ColourCount / (double)systemObjectCount);
if (colourIndex >= ColourCount)
{
colourIndex = 1;
}
}
layer.Colour = Color.FromArgb(255, 190, 190, 205);
}
else
{
if (layer.Name != previousObjectName)
{
if (userObjectCount > ColourCount)
{
colourIndex += 1;
}
else
{
colourIndex += (int)Math.Floor(ColourCount / (double)userObjectCount);
}
}
layer.Colour = HsvColour.HsvToColor(colourIndex, UserSaturation, UserValue);
}
layers.Add(layer);
}
var address = new PageAddress((byte[])row["first_iam_page"]);
if (address.PageId > 0)
{
if (layer != null)
{
layer.Allocations.Add(new IamAllocation(database, address));
}
}
if (layer != null)
{
previousObjectName = layer.Name;
}
worker.ReportProgress((int)(count / (float)allocationUnits.Rows.Count * 100), layer.Name);
}
return(layers);
}
