private static TargetQueryInfo GetTargetQueryFolderId(WorkItemQuery sourceQuery, QueryReplacementParameters replacementParameters)
{
TargetQueryInfo targetQueryFolder = new TargetQueryInfo();
targetQueryFolder.FolderPath = sourceQuery.path;
if (!string.IsNullOrEmpty(replacementParameters.PathFind) && !string.IsNullOrEmpty(replacementParameters.PathReplace) &&
!replacementParameters.PathFind.Equals(replacementParameters.PathReplace, StringComparison.InvariantCultureIgnoreCase))
{
var findIndex = targetQueryFolder.FolderPath.IndexOf(replacementParameters.PathFind, StringComparison.InvariantCultureIgnoreCase);
while (findIndex > -1)
{
targetQueryFolder.FolderPath = targetQueryFolder.FolderPath.Remove(findIndex, replacementParameters.PathFind.Length);
targetQueryFolder.FolderPath = targetQueryFolder.FolderPath.Insert(findIndex, replacementParameters.PathReplace);
findIndex = targetQueryFolder.FolderPath.IndexOf(replacementParameters.PathFind, findIndex + replacementParameters.PathReplace.Length, StringComparison.InvariantCultureIgnoreCase);
}
}
targetQueryFolder.QueryName = targetQueryFolder.FolderPath.Remove(0, targetQueryFolder.FolderPath.LastIndexOf('/') + 1);
targetQueryFolder.FolderPath = targetQueryFolder.FolderPath.Remove(targetQueryFolder.FolderPath.LastIndexOf('/'));
try
{
targetQueryFolder.FolderId = TfsStatic.GetWorkItemQuery(false, targetQueryFolder.FolderPath, QueryExpand.minimal, 0).id;
}
catch
{
string pathLeft = targetQueryFolder.FolderPath;
do
{
pathLeft = pathLeft.Remove(pathLeft.LastIndexOf('/'));
try
{
targetQueryFolder.FolderId = TfsStatic.GetWorkItemQuery(false, pathLeft, QueryExpand.minimal, 0).id;
break;
}
catch { }
}while (string.IsNullOrEmpty(targetQueryFolder.FolderId));
do
{
var nextFolder = targetQueryFolder.FolderPath.Remove(0, pathLeft.Length + 1);
if (nextFolder.IndexOf('/') > -1)
{
nextFolder = nextFolder.Remove(nextFolder.IndexOf('/'));
}
targetQueryFolder.FolderId = TfsStatic.CreateWorkItemQueryFolder(false, pathLeft, nextFolder).id;
pathLeft = $"{pathLeft}/{nextFolder}";
}while (targetQueryFolder.FolderPath.Length != pathLeft.Length);
}
return(targetQueryFolder);
}
private static WorkItemQuery TryWriteQuery(WorkItemQuery sourceQuery, TargetQueryInfo targetQueryInfo)
{
WorkItemQuery targetQuery;
var queryExistsAlready = false;
try
{
var targetFolder = TfsStatic.GetWorkItemQuery(true, targetQueryInfo.FolderId, QueryExpand.minimal, 1);
if (targetFolder.hasChildren)
{
targetQuery = targetFolder.children.FirstOrDefault(o => o.name.Equals(targetQueryInfo.QueryName, StringComparison.InvariantCultureIgnoreCase));
if (targetQuery != null)
{
queryExistsAlready = true;
sourceQuery.id = targetQuery.id;
targetQuery = TfsStatic.UpdateWorkItemQuery(false, sourceQuery);
}
else
{
targetQuery = TfsStatic.CreateWorkItemQuery(false, targetQueryInfo.FolderId, sourceQuery);
}
}
else
{
targetQuery = TfsStatic.CreateWorkItemQuery(false, targetQueryInfo.FolderId, sourceQuery);
}
}
catch
{
if (queryExistsAlready)
{
throw;
}
targetQuery = TfsStatic.CreateWorkItemQuery(false, targetQueryInfo.FolderId, sourceQuery);
}
return(targetQuery);
}
public static WorkItemQuery CopyQuery(CopyQueryParameters parameters,
string sourceProjectName, string sourceTeamName,
string targetProjectName, string targetTeamName)
{
var sourceQuery = TfsStatic.GetWorkItemQuery(true, parameters.QueryId, QueryExpand.minimal, 0);
var targetQueryInfo = GetTargetQueryFolderId(sourceQuery, parameters.QueryReplacements);
if (TfsStatic.SourceTeamProjectBaseUri.Equals(TfsStatic.TargetTeamProjectBaseUri, StringComparison.InvariantCultureIgnoreCase) &&
sourceQuery.path.Equals($"{targetQueryInfo.FolderPath}/{targetQueryInfo.QueryName}", StringComparison.InvariantCultureIgnoreCase))
{
Console.ForegroundColor = ConsoleColor.DarkYellow;
Console.WriteLine($"Skipped: Target query path matches source query ({targetQueryInfo.FolderPath}/{targetQueryInfo.QueryName})");
Console.ForegroundColor = ConsoleColor.White;
return(sourceQuery);
}
sourceQuery.name = targetQueryInfo.QueryName;
sourceQuery.path = targetQueryInfo.FolderPath;
RemoveTeamAreaId(sourceQuery);
if (!string.IsNullOrEmpty(sourceProjectName) || !string.IsNullOrEmpty(sourceTeamName) ||
!string.IsNullOrEmpty(targetProjectName) || !string.IsNullOrEmpty(targetTeamName))
{
if (parameters.QueryReplacements == null)
{
parameters.QueryReplacements = new QueryReplacementParameters();
}
if (parameters.QueryReplacements.QueryFindAndReplace == null)
{
parameters.QueryReplacements.QueryFindAndReplace = new();
}
if (!parameters.QueryReplacements.QueryFindAndReplace.Any(o => o.Find.Equals($"[{sourceProjectName}]\\{sourceTeamName}")))
{
parameters.QueryReplacements.QueryFindAndReplace.Add(new FindAndReplace
{
Find = $"[{sourceProjectName}]\\{sourceTeamName}",
Replace = $"[{targetProjectName}]\\{targetTeamName}",
});
}
if (!parameters.QueryReplacements.QueryFindAndReplace.Any(o => o.Find.Equals($"[{sourceProjectName}]")))
{
parameters.QueryReplacements.QueryFindAndReplace.Add(new FindAndReplace
{
Find = $"[{sourceProjectName}]",
Replace = $"[{targetProjectName}]",
});
}
}
FindAndReplaceInWiql(parameters, sourceQuery);
WorkItemQuery result;
int tryCount = 0;
while (true)
{
try
{
result = TryWriteQuery(sourceQuery, targetQueryInfo);
break;
}
catch
{
tryCount++;
if (tryCount >= 5)
{
Program.WriteFileProgress($"Query creation failed from source query {sourceQuery.path}");
throw;
}
}
Thread.Sleep(2500);
}
return(result);
}
