public ContextAction(string name, CommandExecutionHandler executionHandler, ActionExecutionContext executionContext, bool isLongOperation = false)
{
Name = name;
ExecutionHandler = executionHandler;
ExecutionContext = executionContext;
IsLongOperation = isLongOperation;
}
public OracleStatementFormatter()
{
ExecutionHandler =
new CommandExecutionHandler
{
Name = "FormatStatement",
DefaultGestures = GenericCommands.FormatStatement.InputGestures,
ExecutionHandler = c => new StandardStatementFormatter(c).FormatStatements()
};
SingleLineExecutionHandler =
new CommandExecutionHandler
{
Name = "FormatStatementAsSingleLine",
DefaultGestures = GenericCommands.FormatStatementAsSingleLine.InputGestures,
ExecutionHandler = c => new SingleLineStatementFormatter(c).FormatStatements()
};
NormalizeHandler =
new CommandExecutionHandler
{
Name = "NormalizeStatement",
DefaultGestures = GenericCommands.NormalizeStatement.InputGestures,
ExecutionHandler = c => new StatementNormalizer(c).FormatStatements()
};
}
public static ICollection <CommandExecutionHandler> ResolveCommandHandlers(OracleStatementSemanticModel semanticModel, StatementGrammarNode currentTerminal)
{
CheckParametersNotNull(semanticModel, currentTerminal);
var commands = new List <CommandExecutionHandler>();
if (!CanConvertCurrentTerminal(currentTerminal))
{
return(EmptyHandlerCollection);
}
var requiredPrecedingTerminalId = GetRequiredPrecedingTerminalId(currentTerminal);
var literalTerminals = FindUsagesCommand.GetEqualValueLiteralTerminals(semanticModel.Statement, currentTerminal)
.Where(t => requiredPrecedingTerminalId == t.PrecedingTerminal.Id || (requiredPrecedingTerminalId == null && !t.PrecedingTerminal.Id.In(Terminals.Date, Terminals.Timestamp)))
.ToArray();
var singleOccurenceConvertAction =
new CommandExecutionHandler
{
Name = "Convert to bind variable",
ExecutionHandler =
c => new LiteralBindVariableConversionCommand(c, new[] { currentTerminal }, requiredPrecedingTerminalId).Execute(),
CanExecuteHandler = c => true
};
commands.Add(singleOccurenceConvertAction);
if (literalTerminals.Length > 1)
{
var allOccurencesConvertAction =
new CommandExecutionHandler
{
Name = "Convert all occurences to bind variable",
ExecutionHandler =
c => new LiteralBindVariableConversionCommand(c, literalTerminals, requiredPrecedingTerminalId).Execute(),
CanExecuteHandler = c => true
};
commands.Add(allOccurencesConvertAction);
}
return(commands.AsReadOnly());
}
public IEnumerable <ContextAction> GetSessionContextActions(DatabaseSession databaseSession)
{
var sessionValues = (OracleSessionValues)databaseSession.ProviderValues;
var executionHandler = new CommandExecutionHandler();
string actionName;
if (String.Equals(sessionValues.SqlTrace, "Disabled"))
{
actionName = "Enable trace";
executionHandler.ExecutionHandlerAsync = (context, cancellationToken) => EnableSessionTracing(sessionValues, sessionValues.TraceId, true, true, cancellationToken);
}
else
{
actionName = "Disable trace";
executionHandler.ExecutionHandlerAsync = (context, cancellationToken) => DisableSessionTracing(sessionValues, cancellationToken);
}
yield return(new ContextAction(actionName, executionHandler, null, true));
var remoteTraceDirectory = OracleConfiguration.Configuration.GetRemoteTraceDirectory(_connectionString.Name);
var traceFileName = String.IsNullOrWhiteSpace(remoteTraceDirectory)
? sessionValues.TraceFile
: Path.Combine(remoteTraceDirectory, new FileInfo(sessionValues.TraceFile).Name);
executionHandler =
new CommandExecutionHandler
{
ExecutionHandler = context => OracleTraceViewer.NavigateToTraceFile(traceFileName)
};
yield return(new ContextAction("Navigate to trace file", executionHandler, null));
executionHandler =
new CommandExecutionHandler
{
ExecutionHandlerAsync = (context, cancellationToken) => KillSession(sessionValues, cancellationToken)
};
yield return(new ContextAction("Kill", executionHandler, null, true));
}
public static ICollection <CommandExecutionHandler> ResolveCommandHandlers(OracleStatementSemanticModel semanticModel, StatementGrammarNode currentTerminal)
{
CheckParametersNotNull(semanticModel, currentTerminal);
if (!String.Equals(currentTerminal.Id, Terminals.BindVariableIdentifier))
{
return(EmptyHandlerCollection);
}
var bindVariable = FindUsagesCommand.GetBindVariable(semanticModel, currentTerminal.Token.Value);
var singleOccurenceConvertAction =
new CommandExecutionHandler
{
Name = "Convert to literal",
ExecutionHandler = c => new BindVariableLiteralConversionCommand(c, bindVariable, false)
.Execute(),
CanExecuteHandler = c => true
};
var commands = new List <CommandExecutionHandler> {
singleOccurenceConvertAction
};
if (bindVariable.Nodes.Count > 1)
{
var allOccurencesConvertAction =
new CommandExecutionHandler
{
Name = "Convert all accurences to literal",
ExecutionHandler = c => new BindVariableLiteralConversionCommand(c, bindVariable, true)
.Execute(),
CanExecuteHandler = c => true
};
commands.Add(allOccurencesConvertAction);
}
return(commands.AsReadOnly());
}
