public void Prepare()
{
_resultPanel.Clear();
PrepareForExecute();
var result = new StringBuilder();
var errors = new ErrorList();
try
{
using (var statusForm = new StatusForm(Strings.ProcessingQuery))
{
bool attemptExecute = true;
try
{
DateTime startTime = DateTime.Now;
try
{
IServerScript script;
IServerProcess process =
DataSession.ServerSession.StartProcess(
new ProcessInfo(DataSession.ServerSession.SessionInfo));
try
{
script = process.PrepareScript(GetTextToExecute());
try
{
if (ScriptExecutionUtility.ConvertParserErrors(script.Messages, errors))
{
foreach (IServerBatch batch in script.Batches)
{
if (batch.IsExpression())
{
IServerExpressionPlan plan = batch.PrepareExpression(null);
try
{
attemptExecute &=
ScriptExecutionUtility.ConvertCompilerErrors(plan.Messages,
errors);
if (attemptExecute)
{
result.AppendFormat
(
Strings.PrepareSuccessful,
new object[]
{
plan.PlanStatistics.PrepareTime.ToString(),
plan.PlanStatistics.CompileTime.ToString(),
plan.PlanStatistics.OptimizeTime.ToString(),
plan.PlanStatistics.BindingTime.ToString()
}
);
result.Append("\r\n");
}
}
finally
{
batch.UnprepareExpression(plan);
}
}
else
{
IServerStatementPlan plan = batch.PrepareStatement(null);
try
{
attemptExecute &=
ScriptExecutionUtility.ConvertCompilerErrors(plan.Messages,
errors);
if (attemptExecute)
{
result.AppendFormat
(
Strings.PrepareSuccessful,
new object[]
{
plan.PlanStatistics.PrepareTime.ToString(),
plan.PlanStatistics.CompileTime.ToString(),
plan.PlanStatistics.OptimizeTime.ToString(),
plan.PlanStatistics.BindingTime.ToString()
}
);
result.Append("\r\n");
}
}
finally
{
batch.UnprepareStatement(plan);
}
}
AppendResultPanel(result.ToString());
result.Length = 0;
}
}
}
finally
{
process.UnprepareScript(script);
}
}
finally
{
DataSession.ServerSession.StopProcess(process);
}
}
finally
{
TimeSpan elapsed = DateTime.Now - startTime;
_executionTimeStatus.Text = elapsed.ToString();
}
if (attemptExecute)
{
SetStatus(Strings.ScriptPrepareSuccessful);
}
else
{
SetStatus(Strings.ScriptPrepareFailed);
}
}
catch (Exception exception)
{
SetStatus(Strings.ScriptFailed);
errors.Add(exception);
}
}
}
finally
{
ProcessErrors(errors);
}
}
