public Guid RegisterTransaction(TransactionLocksInfo transactionInfo)
{
lock (_addingLocker)
{
foreach (var tableLock in transactionInfo.TablesLocks)
{
if (!_tablesLockInfo.TryGetValue(tableLock.TableName, out var queue))
{
_tablesLockInfo.Add(tableLock.TableName, queue = new LockQueueType());
}
queue.AddLock(tableLock);
}
}
var guid = Guid.NewGuid();
_transactions.Add(guid, transactionInfo);
return(guid);
}
public OperationResult <SqlSequenceResult> ExecuteSqlSequence(string sqlSequence)
{
var result = new SqlSequenceResult();
#region Sequence Parsing
_parsersSemaphore.WaitOne();
_sqlParsers.TryDequeue(out var parser);
var parseTree = parser.BuildTree(sqlSequence);
_sqlParsers.Enqueue(parser);
_parsersSemaphore.Release();
#endregion
//Is parsing failed
if (parseTree.Root == null)
{
var message = parseTree.ParserMessages[0];
var error = new ParsingRequestError(message.Message, message.Location.ToString());
return(new OperationResult <SqlSequenceResult>(ExecutionState.parserError, null, error));
}
#region Sequence Executing
var transactionListNode = (TransactionListNode)parseTree.Root.AstNode;
foreach (var transactionNode in transactionListNode.TransactionNodes)
{
var transactionTableLocks = new List <TableLock>();
var uniqueTableLocks = new Dictionary <string, TableLock>();
foreach (var command in transactionNode.CommnadsForNode)
{
var tableLocks = command.GetTableLocks();
foreach (var tableLock in tableLocks)
{
if (!uniqueTableLocks.TryGetValue(tableLock.TableName, out var uniqueLock))
{
uniqueTableLocks.Add(tableLock.TableName, tableLock);
}
else
{
if (uniqueLock.LockType == LockType.Non)
{
uniqueLock.LockType = tableLock.LockType;
}
else
{
if (uniqueLock.LockType != tableLock.LockType)
{
uniqueLock.LockType = LockType.Update;
}
}
}
}
}
foreach (var tableLock in uniqueTableLocks.Values)
{
transactionTableLocks.Add(tableLock);
}
var transactionLocksInfo = new TransactionLocksInfo(transactionTableLocks);
var trGuid = _transactionScheduler.RegisterTransaction(transactionLocksInfo);
var transaction = new TransactionInfo()
{
Name = transactionNode.TransactionBeginOptNode?.TransactionName ?? new Id(new List <string>()
{
trGuid.ToString()
}),
Guid = trGuid
};
_transactionScheduler.WaitTransactionResourceLock(transaction.Guid);
transaction.StartTime = DateTime.Now;
_engineCommander.StartTransaction(transaction.Guid);
var(state, exception) = _engineCommander.ExecuteCommands(transaction.Guid, transactionNode.CommnadsForNode);
if (state == ExecutionState.performed)
{
if (transactionNode.StmtListNode != null)
{
foreach (var stmt in transactionNode.StmtListNode.StmtList)
{
var table = _engineCommander.GetTableByName(transaction.Guid, stmt.ReturnedTableName);
transaction.OperationsResults.Add(table);
}
}
else
{
var table = _engineCommander.GetTableByName(transaction.Guid, transactionNode.SqlCommandNode.ReturnedTableName);
transaction.OperationsResults.Add(table);
}
var transactionEndNode = (transactionNode as TransactionNode).TransactionEndOptNode;
switch (transactionEndNode.TransactionEndType)
{
case TransactionEndType.Commit:
_engineCommander.CommitTransaction(transaction.Guid);
break;
case TransactionEndType.Rollback:
_engineCommander.RollBackTransaction(transaction.Guid);
break;
}
}
else
{
_engineCommander.RollBackTransaction(transaction.Guid);
transaction.OperationsResults.Add(new OperationResult <Table>(state, null, exception));
}
transaction.EndTime = DateTime.Now;
_transactionScheduler.RemoveTransactionResourcesLocks(transaction.Guid);
result.Answer.Add(transaction);
}
#endregion
return(new OperationResult <SqlSequenceResult>(ExecutionState.performed, result, null));
}
