public void Execute(TeamFoundationWorkspace ws)
{
if (ws == null)
{
AppOutput.ConsoleWriteLine("---- Invalide ws config");
}
var files = GetLocalFiles();
AppOutput.ConsoleWriteLine("Tfs inclider: filesFound: " + files.Count());
var paddingChanges = ws.GetPendingChanges().Select(p => p.LocalItem);
foreach (var file in files)
{
var serverPath = ws.TryGetServerItemForLocalItem(file);
var serverItemExists = ws.VersionControlServer.ServerItemExists(serverPath, ItemType.File);
if (!serverItemExists && !paddingChanges.Contains(file))
{
ws.PendAdd(file);
AppOutput.ConsoleWriteLine(" Exluded file: " + file);
}
}
AppOutput.ConsoleWriteLine("Finished");
}
public int ExecuteString(string sqlScript, IEnumerable <DatabaseConnectionString> connectionStrings = null)
{
ThreadHelper.ThrowIfNotOnUIThread();
if (string.IsNullOrWhiteSpace(sqlScript))
{
return(0);
}
var errorCount = -1;
foreach (var connectionString in connectionStrings ?? Settings.Databases.ConnectionStrings)
{
errorCount = 0;
System.Data.SqlClient.SqlConnection sqlConnection = new System.Data.SqlClient.SqlConnection(connectionString.ConnectionString);
ServerConnection svrConnection = new ServerConnection(sqlConnection);
Server server = new Server(svrConnection);
AppOutput.ConsoleWriteLine("------ Database: " + sqlConnection.Database + " -------");
try
{
var a = server.ConnectionContext.ExecuteNonQuery(sqlScript) > -1;
AppOutput.ConsoleWriteLine("Executed script: " + sqlScript);
}
catch (Exception e)
{
AppOutput.ConsoleWriteException(e, "Error script at: " + sqlScript);
throw;
}
sqlConnection.Close();
}
return(errorCount);
}
public void DataAcess_DatabaseMessage(object sender, string message)
{
AppOutput.Text += message + "\n\r\n\r";
while (AppOutput.Text.Length > 10000)
{
AppOutput.Text = AppOutput.Text.Substring(AppOutput.Text.IndexOf("\n\r") + 4);
}
AppOutput.SelectionStart = AppOutput.Text.Length;
AppOutput.ScrollToCaret();
}
//[Test]
public void TestUFGVisualViewport_UnitTest()
{
JsonSerializer serializer = JsonUtils.CreateSerializer();
IWebDriver driver = SeleniumUtils.CreateChromeDriver();
EyesRunner runner = new VisualGridRunner(10);
Eyes eyes = new Eyes(runner);
TestUtils.SetupLogging(eyes);
eyes.visualGridEyes_.EyesConnectorFactory = new Mock.MockEyesConnectorFactory();
Configuration config = eyes.GetConfiguration();
IosDeviceInfo iosDeviceInfo = new IosDeviceInfo(IosDeviceName.iPhone_11_Pro);
config.AddBrowser(iosDeviceInfo);
eyes.SetConfiguration(config);
try
{
eyes.Open(driver, "Eyes Selenium SDK", "Eyes Selenium SDK - UFG Visual Viewport Test");
Mock.MockEyesConnector mockEyesConnector = (Mock.MockEyesConnector)eyes.visualGridEyes_.eyesConnector_;
Mock.MockServerConnector mockServerConnector = new Mock.MockServerConnector(eyes.Logger, new Uri(eyes.ServerUrl));
EyesConnector eyesConnector = new EyesConnector(eyes.Logger, new RenderBrowserInfo(iosDeviceInfo), config)
{
runningSession_ = new RunningSession(),
ServerConnector = mockServerConnector
};
mockEyesConnector.WrappedConnector = eyesConnector;
string inputJson = CommonUtils.ReadResourceFile("Test.Eyes.Selenium.DotNet.Resources.Misc.TestUFGVisualViewport_Input.json");
RenderStatusResults renderStatusResults = serializer.Deserialize <RenderStatusResults>(inputJson);
mockEyesConnector.SetRenderStatusResultsList(renderStatusResults);
driver.Url = "https://applitools.github.io/demo/TestPages/DynamicResolution/desktop.html";
eyes.Check(Target.Window().Fully());
eyes.Close();
runner.GetAllTestResults();
Assert.AreEqual(1, mockServerConnector.MatchWindowCalls.Count);
MatchWindowData matchWindowData = mockServerConnector.MatchWindowCalls[0];
AppOutput appOutput = matchWindowData.AppOutput;
Assert.AreEqual(980, appOutput.Viewport.Width);
Assert.AreEqual(1659, appOutput.Viewport.Height);
Assert.IsNotNull(mockEyesConnector.DeviceSize);
Assert.AreEqual(375, mockEyesConnector.DeviceSize.Width);
Assert.AreEqual(812, mockEyesConnector.DeviceSize.Height);
}
finally
{
eyes.AbortIfNotClosed();
driver.Quit();
}
}
public int Execute()
{
Microsoft.VisualStudio.Shell.ThreadHelper.ThrowIfNotOnUIThread();
EnvDTE.OutputWindowPanes panes = Dte.ToolWindows.OutputWindow.OutputWindowPanes;
var result = string.Empty;
foreach (OutputWindowPane pane in panes)
{
if (Settings.Databases.Panes.Contains(pane.Name))
{
try
{
pane.Activate();
var sel = pane.TextDocument.Selection;
sel.StartOfDocument(false);
sel.EndOfDocument(true);
var text = sel.Text;
if (Settings.Databases.SetDelimiterOnPanesAfterRead)
{
var indexOfDelimiter = text.LastIndexOf(AppConstants.DelimiterOnPanesAfterRead);
if (indexOfDelimiter > 0)
{
text = text.Substring(indexOfDelimiter);
}
pane.OutputString(Environment.NewLine + AppConstants.DelimiterOnPanesAfterRead + Environment.NewLine);
}
result += Environment.NewLine + text + Environment.NewLine;
}
catch (Exception e)
{
AppOutput.ConsoleWriteException(e);
throw;
}
}
}
var rows = result.Split(new string[] { Environment.NewLine }, StringSplitOptions.RemoveEmptyEntries);
return(ExecuteFiles(rows));
}
public bool IncludeFiles(IDictionary <Project, IEnumerable <FileInfo> > filesToInclude)
{
ThreadHelper.ThrowIfNotOnUIThread();
try
{
foreach (var project in filesToInclude)
{
foreach (var file in project.Value)
{
AppOutput.ConsoleWriteLine($"including file: {file.Name} in {project.Key.Name}");
project.Key.ProjectItems.AddFromFile(file.FullName);
AppOutput.ConsoleWriteLine("File included");
}
}
}
catch (Exception e)
{
AppOutput.ConsoleWriteException(e);
throw;
}
return(true);
}
public int ExecuteFiles(string[] files, IEnumerable <DatabaseConnectionString> connectionStrings = null)
{
ThreadHelper.ThrowIfNotOnUIThread();
var havFilesToExecute = false;
var errorCount = 0;
foreach (var connectionString in connectionStrings ?? Settings.Databases.ConnectionStrings)
{
System.Data.SqlClient.SqlConnection sqlConnection = new System.Data.SqlClient.SqlConnection(connectionString.ConnectionString);
ServerConnection svrConnection = new ServerConnection(sqlConnection);
Server server = new Server(svrConnection);
AppOutput.ConsoleWriteLine(Environment.NewLine, "------ Database: " + sqlConnection.Database + " -------");
foreach (var row in files)
{
if (!string.IsNullOrWhiteSpace(connectionString.FilterPattern) && !Regex.IsMatch(row, connectionString.FilterPattern))
{
continue;
}
if (!string.IsNullOrWhiteSpace(connectionString.IgnorePattern) && Regex.IsMatch(row, connectionString.IgnorePattern))
{
continue;
}
havFilesToExecute = true;
var filePath = string.IsNullOrWhiteSpace(connectionString.ReplasePattern)
? connectionString.ReplasePattern
: Regex.Replace(row, connectionString.ReplasePattern, string.Empty);
if (!string.IsNullOrWhiteSpace(connectionString.SqlCmdPattern) && Regex.IsMatch(row, connectionString.SqlCmdPattern))
{
System.Diagnostics.Process proc = new System.Diagnostics.Process();
try
{
var args = $" -S \"{sqlConnection.DataSource}\" -E -d \"{sqlConnection.Database}\" -i \"{filePath}\"";
ProcessStartInfo info = new ProcessStartInfo("sqlcmd", args);
info.UseShellExecute = false;
info.CreateNoWindow = true;
info.WindowStyle = ProcessWindowStyle.Hidden;
info.RedirectStandardOutput = true;
info.RedirectStandardError = true;
proc.StartInfo = info;
var output = new StringBuilder();
var error = new StringBuilder();
using (AutoResetEvent outputWaitHandle = new AutoResetEvent(false))
using (AutoResetEvent errorWaitHandle = new AutoResetEvent(false))
{
proc.ErrorDataReceived += (sender, e) =>
{
if (e.Data == null)
{
errorWaitHandle.Set();
}
else
{
error.AppendLine(e.Data);
}
};
proc.OutputDataReceived += (sender, e) =>
{
if (e.Data == null)
{
outputWaitHandle.Set();
}
else
{
output.AppendLine(e.Data);
}
};
proc.Start();
proc.BeginErrorReadLine();
proc.BeginOutputReadLine();
proc.WaitForExit();
}
var errorString = error.ToString();
var outputString = output.ToString()?.ToLower();
var isSuccess = string.IsNullOrEmpty(errorString) &&
(string.IsNullOrEmpty(outputString) || outputString.Contains("commands completed successfully") || Regex.IsMatch(outputString, "[(][0-9]+ row[s]* affected[)]", RegexOptions.Multiline));
if (isSuccess)
{
AppOutput.ConsoleWriteLine("Executed sqlcmd: " + filePath);
}
else
{
errorCount++;
AppOutput.ConsoleWriteLine("-----------", "----- Error sqlcmd: " + filePath, $"{error.ToString()}{Environment.NewLine}{output.ToString()}", "-------------");
}
}
catch (Exception e)
{
AppOutput.ConsoleWriteException(e, "Error at: " + filePath);
throw;
}
finally
{
proc.Close();
}
continue;
}
if (File.Exists(filePath))
{
var sqlScript = File.ReadAllText(filePath);
try
{
var a = server.ConnectionContext.ExecuteNonQuery(sqlScript) > -1;
AppOutput.ConsoleWriteLine("Executed: " + filePath);
}
catch (Exception e)
{
AppOutput.ConsoleWriteException(e, "Error at: " + filePath);
throw;
}
}
else
{
AppOutput.ConsoleWriteLine("File dont exists: " + filePath);
}
}
sqlConnection.Close();
}
return(havFilesToExecute ? errorCount : -1);
}
