protected virtual IActiveOperation <TInternal> PrepareNonQueryOperationWithParameter <TContext, TMySqlOperation, TOperation, TResult, TInternal>(TMySqlOperation operation, IReadOnlyCollection <IColumnValuePair <byte[]> > dataEntryList, Func <TOperation, IAsyncResult, TInternal> createResultHandler, Func <MySqlCommand, TInternal, string> finalizer)
where TContext : IModifyContext, IDataContext
where TMySqlOperation : IMySqlModifyOperation <TContext, TInternal>, TOperation
where TOperation : IModifyOperation, IOperation <TContext, TResult>
where TResult : IModifyResult, IDataResult
where TInternal : IModifyResultInternal, IDataResultInternal, TResult
{
TInternal OperationResult;
MySqlActiveOperation <TInternal> ActiveOperation;
try
{
string CommandText = operation.GetCommandText();
MySqlCommand Command = new MySqlCommand(CommandText, Connection);
int i = 0;
foreach (IColumnValuePair <byte[]> DataEntry in dataEntryList)
{
MySqlParameter DataParameter = Command.CreateParameter();
DataParameter.ParameterName = $"data{i}";
DataParameter.Value = DataEntry.Value;
Command.Parameters.Add(DataParameter);
i++;
}
TraceCommand(Command);
IAsyncResult Result = Command.BeginExecuteNonQuery();
OperationResult = createResultHandler(operation, Result);
ActiveOperation = new MySqlActiveOperation <TInternal>(OperationResult, finalizer);
ActiveOperationTable.Add(ActiveOperation, Command);
}
#if TRACE
catch (ApplicationException)
{
throw;
}
#endif
catch (MySqlException e)
{
TraceMySqlException(e);
OperationResult = createResultHandler(operation, null);
ActiveOperation = new MySqlActiveOperation <TInternal>(OperationResult);
}
catch (Exception e)
{
TraceException(e);
OperationResult = createResultHandler(operation, null);
ActiveOperation = new MySqlActiveOperation <TInternal>(OperationResult);
}
return(ActiveOperation);
}
private void ExecuteOperation()
{
WaitHandle[] ThreadHandles = new WaitHandle[] { NewOperationEvent, ShutdownEvent };
bool Exit = false;
while (!Exit)
{
int ThreadWaitResult = WaitHandle.WaitAny(ThreadHandles, Timeout.InfiniteTimeSpan);
if (ThreadWaitResult == 0)
{
IActiveOperation[] ActiveOperations = new IActiveOperation[ActiveOperationTable.Count];
WaitHandle[] OperationHandles = new WaitHandle[ActiveOperationTable.Count + 1];
OperationHandles[0] = ShutdownEvent;
int n = 0;
foreach (IActiveOperation ActiveOperation in ActiveOperationTable)
{
ActiveOperations[n] = ActiveOperation;
OperationHandles[n + 1] = ActiveOperation.ResultBase.AsyncResult.AsyncWaitHandle;
n++;
}
int OperationWaitResult = WaitHandle.WaitAny(OperationHandles, TimeSpan.FromSeconds(1.0));
if (OperationWaitResult == WaitHandle.WaitTimeout)
{
NewOperationEvent.Set();
}
else if (OperationWaitResult > 0 && OperationWaitResult <= OperationHandles.Length)
{
IActiveOperation ActiveOperation = ActiveOperations[OperationWaitResult - 1];
ActiveOperationTable.Remove(ActiveOperation);
Connector.NotifyOperationCompleted(ActiveOperation, out Exception CompletionException);
if (LastCompletionException == null && CompletionException != null)
{
LastCompletionException = CompletionException;
}
}
else
{
Exit = true;
}
}
else
{
Exit = true;
}
}
}
protected virtual IActiveOperation <TInternal> PrepareNonQueryOperation <TContext, TMySqlOperation, TOperation, TResult, TInternal>(TMySqlOperation operation, Func <TOperation, IAsyncResult, TInternal> createResultHandler, Func <MySqlCommand, TInternal, string> finalizer)
where TContext : IModifyContext
where TMySqlOperation : IMySqlModifyOperation <TContext, TInternal>, TOperation
where TOperation : IModifyOperation, IOperation <TContext, TResult>
where TResult : IModifyResult
where TInternal : IModifyResultInternal, TResult
{
TInternal OperationResult;
MySqlActiveOperation <TInternal> ActiveOperation;
try
{
string CommandText = operation.GetCommandText();
MySqlCommand Command = new MySqlCommand(CommandText, Connection);
TraceCommand(Command);
IAsyncResult Result = Command.BeginExecuteNonQuery();
OperationResult = createResultHandler(operation, Result);
ActiveOperation = new MySqlActiveOperation <TInternal>(OperationResult, finalizer);
ActiveOperationTable.Add(ActiveOperation, Command);
}
#if TRACE
catch (ApplicationException)
{
throw;
}
#endif
catch (MySqlException e)
{
TraceMySqlException(e);
OperationResult = createResultHandler(operation, null);
ActiveOperation = new MySqlActiveOperation <TInternal>(OperationResult);
}
catch (Exception e)
{
TraceException(e);
OperationResult = createResultHandler(operation, null);
ActiveOperation = new MySqlActiveOperation <TInternal>(OperationResult);
}
return(ActiveOperation);
}
private void FinalizeOrQueue(IActiveOperation activeOperation)
{
IResultInternal Result = activeOperation.ResultBase;
if (Result.IsStarted)
{
Result.CheckIfCompletedSynchronously(out bool IsCompletedSynchronously);
if (IsCompletedSynchronously)
{
Connector.NotifyOperationCompleted(activeOperation, out Exception CompletionException);
if (CompletionException != null)
{
throw CompletionException;
}
}
else
{
ActiveOperationTable.Add(activeOperation);
NewOperationEvent.Set();
Result.WaitCompleted();
}
}
}
private void NotifyOperationCompleted(IMySqlActiveOperation activeOperation, out Exception completionException)
{
completionException = null;
try
{
using (MySqlCommand Command = ActiveOperationTable[activeOperation])
{
ActiveOperationTable.Remove(activeOperation);
IResultInternal Result = activeOperation.ResultBase;
string Diagnostic = activeOperation.MySqlFinalizerBase(Command, Result);
if (Result.IsCompletedSynchronously)
{
Diagnostic += " [SYNCHRONOUS]";
}
TraceCommandEnd(Command, Diagnostic);
}
}
#if TRACE
catch (ApplicationException)
{
throw;
}
#endif
catch (MySqlException e)
{
TraceMySqlException(e);
}
catch (Exception e)
{
completionException = e;
TraceException(e);
}
}
