public void ExcelgetFormulaTest()
{
scripter.Text = ($@"excel.open {SpecialChars.Variable}xlsPath sheet Add
excel.getformula row 1 colindex 3");
scripter.Run();
Assert.AreEqual(formula, scripter.Variables.GetVariableValue <string>("result"));
}
public void XlsxGetValueDifferentTypesTest()
{
scripter.Text = $@"
xlsx.open {SpecialChars.Variable}xlsPath result {SpecialChars.Variable}id
xlsx.getvalue row 1 colindex 1 result {SpecialChars.Variable}result1
xlsx.getvalue row 1 colindex 2 result {SpecialChars.Variable}result2
xlsx.getvalue row 1 colindex 4 result {SpecialChars.Variable}result3
xlsx.getvalue row 2 colindex 7 result {SpecialChars.Variable}result4
xlsx.getvalue row 5 colindex 27 result {SpecialChars.Variable}result6
xlsx.getvalue row 5 colindex 52 result {SpecialChars.Variable}result7
xlsx.getvalue row 5 colindex 53 result {SpecialChars.Variable}result8
xlsx.getvalue row 5 colindex 728 result {SpecialChars.Variable}result9
xlsx.getvalue row 5 colindex 731 result {SpecialChars.Variable}result10
xlsx.getvalue row 5 colindex 26 result {SpecialChars.Variable}result11
xlsx.getvalue row 22 colindex 38 result {SpecialChars.Variable}result12
";
scripter.Run();
Assert.AreEqual("1234", scripter.Variables.GetVariable("result1").GetValue().Object);
Assert.AreEqual("abcd", scripter.Variables.GetVariable("result2").GetValue().Object);
Assert.AreEqual("150", scripter.Variables.GetVariable("result3").GetValue().Object);
Assert.AreEqual("AA", scripter.Variables.GetVariable("result6").GetValue().Object);
Assert.AreEqual("AZ", scripter.Variables.GetVariable("result7").GetValue().Object);
Assert.AreEqual("BA", scripter.Variables.GetVariable("result8").GetValue().Object);
Assert.AreEqual("AAZ", scripter.Variables.GetVariable("result9").GetValue().Object);
Assert.AreEqual("ABC", scripter.Variables.GetVariable("result10").GetValue().Object);
Assert.AreEqual("Z", scripter.Variables.GetVariable("result11").GetValue().Object);
Assert.IsTrue(string.IsNullOrEmpty(scripter.Variables.GetVariable("result12").GetValue().Object.ToString()));
}
public void ExcelActivateSheetTest()
{
scripter.Text = ($@"excel.open {SpecialChars.Variable}xlsPath
excel.activatesheet name {SpecialChars.Text}Macro{SpecialChars.Text}
excel.close");
scripter.Run();
}
public void WaitForValueSuccessTest()
{
scripter.Text = $@"
ie.open url {SpecialChars.Text}https://secure.tibia.com/community/?subtopic=characters{SpecialChars.Text}
ie.waitforvalue script {SpecialChars.Text}document.querySelectorAll('input[name=""name""]').length > 0{SpecialChars.Text} timeout 15000 expectedvalue true
ie.close";
scripter.Run();
}
public void FindAllTest()
{
int expectedRectanglesCount = 8;
string imageWithRectanglesPath = Assembly.GetExecutingAssembly().UnpackResourceToFile("Resources." + nameof(Resources.Rectangles8), "png");
scripter.Text = ($"image.findrectangles {SpecialChars.Text}{imageWithRectanglesPath}{SpecialChars.Text}");
scripter.Run();
Assert.AreEqual(expectedRectanglesCount, scripter.Variables.GetVariableValue <List <Object> >("result").Count);
}
public void ExcelDuplicateRowTest()
{
scripter.Text = ($@"excel.open ♥xlsPath sheet Add
excel.duplicaterow source 1 destination 2
excel.getvalue row 2 colindex 1
excel.close");
scripter.Run();
Assert.AreEqual(3, int.Parse(scripter.Variables.GetVariableValue <string>("result")));
}
public void ExcelExportTest()
{
scripter.Text = ($@"excel.open {SpecialChars.Variable}xlsPath
excel.export {SpecialChars.Variable}pdfPath
excel.export {SpecialChars.Variable}xpsPath");
scripter.Run();
Assert.IsTrue(File.Exists(xpsPath));
Assert.IsTrue(File.Exists(pdfPath));
}
public void XlsxSetSheetDefault()
{
scripter.Text = $@"
xlsx.open {SpecialChars.Variable}xlsPath result {SpecialChars.Variable}id
xlsx.setsheet result {SpecialChars.Variable}res
";
scripter.Run();
Assert.IsTrue(scripter.Variables.GetVariableValue <bool>("res"));
}
public void ExcelInsertRowFailTest()
{
scripter.Text = "excel.insertcolumn colindex 1 where haha";
Exception exception = Assert.Throws <ApplicationException>(delegate
{
scripter.Run();
});
Assert.IsInstanceOf <ArgumentException>(exception.GetBaseException());
}
public void IEOpenTestSuccessTest()
{
scripter.Text = $@"
ie.open
ie.open
ie.open
";
scripter.Run();
Assert.IsTrue(IETests.GetIeInstancesCount() == 3);
}
public void ExcelGetValueTest()
{
scripter.Text = ($@"excel.open {SpecialChars.Variable}xlsPath sheet Add
excel.getvalue row 1 colindex 1 result {SpecialChars.Variable}result1
excel.getvalue row 1 colindex 3 result {SpecialChars.Variable}result3
excel.getvalue row 1 colindex 2 result {SpecialChars.Variable}result2");
scripter.Run();
Assert.AreEqual(3, int.Parse(scripter.Variables.GetVariable("result1").GetValue().Object.ToString()));
Assert.AreEqual(4, int.Parse(scripter.Variables.GetVariable("result2").GetValue().Object.ToString()));
Assert.AreEqual(7, int.Parse(scripter.Variables.GetVariable("result3").GetValue().Object.ToString()));
}
public void GoogleSheetDownloadFileXLSX()
{
scripter.Text = ($@"googlesheet.open {SpecialChars.Variable}fileid isshared false
{SpecialChars.Variable}savePath = {SpecialChars.Variable}temp{SpecialChars.Text}\\SheetsTest.xlsx{SpecialChars.Text}
googlesheet.download path {SpecialChars.Variable}savePath type {SpecialChars.Text}xls{SpecialChars.Text}
delay 3
googlesheet.close");
scripter.Run();
var result = scripter.Variables.GetVariable("result");
Assert.AreEqual("Download complete.", result.GetValue().ToString());
}
public void IERunScriptSuccessTest()
{
scripter.Text = $@"
ie.open
ie.seturl {SpecialChars.Text}google.pl{SpecialChars.Text}
ie.runscript script {SpecialChars.Text}2 + 5{SpecialChars.Text}
";
scripter.Run();
string result = scripter.Variables.GetVariableValue <string>("result", string.Empty, true)?.ToLower();
Assert.AreEqual(result, 7.ToString());
}
public void CountRowsTest()
{
int rowCount;
scripter.InitVariables.Clear();
scripter.InitVariables.Add("xlsPath", new TextStructure(file));
scripter.Text = $@"xlsx.open {SpecialChars.Variable}xlsPath result {SpecialChars.Variable}id
xlsx.countrows result {SpecialChars.Variable}rowCunt";
scripter.Run();
rowCount = scripter.Variables.GetVariableValue <int>("rowCunt", -1, true);
Assert.AreEqual(5, rowCount);
}
public void ProcessFileTest()
{
scripter.Text = ($"ocrabbyy.processfile {SpecialChars.Variable}file language English");
scripter.Run();
int documentId = scripter.Variables.GetVariableValue <int>("result");
FineReaderDocument document = AbbyyManager.Instance.GetDocument(documentId);
Assert.IsNotNull(document);
string plainText = document.GetAllText();
Assert.AreEqual(Properties.Resources.documentText, plainText);
}
public void IEWaitForCompleteSuccessGoogleTests()
{
scripter.Text = $@"
ie.open
ie.seturl google.pl nowait true
ie.waitforcomplete timeout 20000
ie.gettitle result {SpecialChars.Variable}title
";
scripter.Run();
var title = scripter.Variables.GetVariableValue <string>("title").ToLower();
Assert.IsTrue(title.Contains("google"));
}
public void CloseTest()
{
scripter.RunLine($@"ocrabbyy.processfile {SpecialChars.Variable}file result {SpecialChars.Variable}result1
ocrabbyy.processfile {SpecialChars.Variable}file
ocrabbyy.close");
scripter.Run();
int documentId = scripter.Variables.GetVariableValue <int>("result1");
FineReaderDocument document = AbbyyManager.Instance.GetDocument(documentId);
long engineLoadedMemory = GetAllocatedMemory();
long engineUnloadedMemory = GetAllocatedMemory();
Assert.IsTrue(engineLoadedMemory - engineUnloadedMemory > 0x10000, $"Closing engine relesed less than 1MB of memory, relesed bytes = {engineLoadedMemory - engineUnloadedMemory}");
}
public void IEGetTitleSuccessTest()
{
scripter.Text = $@"
ie.open
ie.seturl {SpecialChars.Text}google.pl{SpecialChars.Text}
ie.waitforvalue script {SpecialChars.Text}document.querySelectorAll('#lst-ib').length > 0{SpecialChars.Text} timeout 15000 expectedvalue true
ie.gettitle result {SpecialChars.Variable}title
";
scripter.Run();
string title = scripter.Variables.GetVariableValue <string>("title", string.Empty, true)?.ToLower();
Assert.IsTrue(title.Contains("google"));
}
public void IEGetAttributeSuccessTest()
{
scripter.Text = $@"
ie.open timeout 20000
ie.seturl {SpecialChars.Text}google.pl{SpecialChars.Text} timeout 20000
ie.waitforvalue script {SpecialChars.Text}document.querySelectorAll('input[name=""q""]').length > 0{SpecialChars.Text} timeout 15000 expectedvalue true
ie.getattribute name {SpecialChars.Text}title{SpecialChars.Text} search {SpecialChars.Text}lst-ib{SpecialChars.Text} by id result {SpecialChars.Variable}title
";
scripter.Run();
string title = scripter.Variables.GetVariableValue <string>("title", string.Empty, true)?.ToLower();
Assert.IsTrue(title == "search" || title == "szukaj");
}
public void IEDetachSuccessTest()
{
scripter.Text = $@"
ie.open result {SpecialChars.Variable}result1
ie.open result {SpecialChars.Variable}result2
ie.switch {SpecialChars.Variable}result1
ie.detach
ie.switch {SpecialChars.Variable}result2
ie.detach";
scripter.Run();
Assert.IsTrue(IETests.GetIeInstancesCount() != 0);
}
public void IEClickTestsSuccessTest()
{
string titleVariable = "title";
string titleShouldContain = "gmail";
scripter.Text = $@"
ie.open {pageAddress}
ie.click search {SpecialChars.Text}a.gb_P[href='https://mail.google.com/mail/?tab=wm']{SpecialChars.Text} by query timeout 30000
ie.gettitle result {SpecialChars.Variable}{titleVariable}";
scripter.Run();
string title = scripter.Variables.GetVariableValue <string>(titleVariable, string.Empty, true)?.ToLower();
Assert.IsTrue(title.Contains(titleShouldContain));
}
public void XlsxFindDifferentTypesTest()
{
scripter.Text = $@"xlsx.open {SpecialChars.Variable}xlsPath result {SpecialChars.Variable}id
xlsx.find 1234 resultrow {SpecialChars.Variable}resrow resultcolumn {SpecialChars.Variable}resCol
xlsx.find {SpecialChars.Text}abcd{SpecialChars.Text} resultrow {SpecialChars.Variable}resrow2 resultcolumn {SpecialChars.Variable}resCol2
xlsx.find 150 resultrow {SpecialChars.Variable}resrow3 resultcolumn {SpecialChars.Variable}resCol3
-xlsx.find {SpecialChars.Text}160%{SpecialChars.Text} resultrow {SpecialChars.Variable}resrow4 resultcolumn {SpecialChars.Variable}resCol4
-xlsx.find {SpecialChars.Text}100%{SpecialChars.Text} resultrow {SpecialChars.Variable}resrow5 resultcolumn {SpecialChars.Variable}resCol5
xlsx.find {SpecialChars.Text}AA{SpecialChars.Text} resultrow {SpecialChars.Variable}resrow6 resultcolumn {SpecialChars.Variable}resCol6
xlsx.find {SpecialChars.Text}AZ{SpecialChars.Text} resultrow {SpecialChars.Variable}resrow7 resultcolumn {SpecialChars.Variable}resCol7
xlsx.find {SpecialChars.Text}BA{SpecialChars.Text} resultrow {SpecialChars.Variable}resrow8 resultcolumn {SpecialChars.Variable}resCol8
xlsx.find {SpecialChars.Text}AAZ{SpecialChars.Text} resultrow {SpecialChars.Variable}resrow9 resultcolumn {SpecialChars.Variable}resCol9
xlsx.find {SpecialChars.Text}ABC{SpecialChars.Text} resultrow {SpecialChars.Variable}resrow10 resultcolumn {SpecialChars.Variable}resCol10
xlsx.find {SpecialChars.Text}Z{SpecialChars.Text} resultrow {SpecialChars.Variable}resrow11 resultcolumn {SpecialChars.Variable}resCol11
";
scripter.Run();
Assert.AreEqual(1, scripter.Variables.GetVariable("resrow").GetValue().Object);
Assert.AreEqual(1, scripter.Variables.GetVariable("resCol").GetValue().Object);
Assert.AreEqual(1, scripter.Variables.GetVariable("resrow2").GetValue().Object);
Assert.AreEqual(2, scripter.Variables.GetVariable("resCol2").GetValue().Object);
Assert.AreEqual(1, scripter.Variables.GetVariable("resrow3").GetValue().Object);
Assert.AreEqual(4, scripter.Variables.GetVariable("resCol3").GetValue().Object);
//Assert.AreEqual(1, scripter.Variables.GetVariable("resrow4").GetValue().Object);
//Assert.AreEqual(5, scripter.Variables.GetVariable("resCol4").GetValue().Object);
//Assert.AreEqual(2, scripter.Variables.GetVariable("resrow5").GetValue().Object);
//Assert.AreEqual(5, scripter.Variables.GetVariable("resCol5").GetValue().Object);
Assert.AreEqual(5, scripter.Variables.GetVariable("resrow6").GetValue().Object);
Assert.AreEqual(27, scripter.Variables.GetVariable("resCol6").GetValue().Object);
Assert.AreEqual(5, scripter.Variables.GetVariable("resrow7").GetValue().Object);
Assert.AreEqual(52, scripter.Variables.GetVariable("resCol7").GetValue().Object);
Assert.AreEqual(5, scripter.Variables.GetVariable("resrow8").GetValue().Object);
Assert.AreEqual(53, scripter.Variables.GetVariable("resCol8").GetValue().Object);
Assert.AreEqual(5, scripter.Variables.GetVariable("resrow9").GetValue().Object);
Assert.AreEqual(728, scripter.Variables.GetVariable("resCol9").GetValue().Object);
Assert.AreEqual(5, scripter.Variables.GetVariable("resrow10").GetValue().Object);
Assert.AreEqual(731, scripter.Variables.GetVariable("resCol10").GetValue().Object);
Assert.AreEqual(5, scripter.Variables.GetVariable("resrow11").GetValue().Object);
Assert.AreEqual(26, scripter.Variables.GetVariable("resCol11").GetValue().Object);
}
public void IEFireEventTestsSuccessTest()
{
scripter.Text = $@"
ie.open
ie.seturl {SpecialChars.Text}google.pl{SpecialChars.Text}
ie.waitforvalue script {SpecialChars.Text}document.querySelectorAll('input[name=""q""]').length > 0{SpecialChars.Text} timeout 15000 expectedvalue true
ie.fireevent eventname {SpecialChars.Text}onclick{SpecialChars.Text} search {SpecialChars.Text}a.gb_P[href='https://mail.google.com/mail/?tab=wm']{SpecialChars.Text} by query timeout 15000
ie.gettitle result {SpecialChars.Variable}title
ie.close";
scripter.Run();
string title = scripter.Variables.GetVariableValue <string>("title", string.Empty, true)?.ToLower();
Assert.IsTrue(title.Contains("gmail"));
}
public void ReadTabletest()
{
Scripter scripter = new Scripter();
scripter.InitVariables.Clear();
scripter.Text = ($@"ocrabbyy.processfile {SpecialChars.Text}{path}{SpecialChars.Text}
ocrabbyy.readtables");
scripter.Run();
List <GStruct.Structure> cells = scripter.Variables.GetVariableValue <List <GStruct.Structure> >("result");
List <string> values = new List <string>()
{
"Egypt", "Nigeria"
};
for (int i = 0; i < cells.Count; i++)
{
for (int j = 0; j < values.Count; j++)
{
if (values[j] == ((GStruct.TextStructure)cells[i]).Value.Trim())
{
values.Remove(values[j]);
}
}
}
Assert.AreEqual(0, values.Count, $"Havent found values {values}");
}
public void WaitForExistingImageTest()
{
testerApp = SDK.Tester.RunFormTester("Title TestApp");
Color color = Color.Gainsboro;
string colorCode = "FFDCDCDC";
RobotWin32.ShowWindow(testerApp.MainWindowHandle, RobotWin32.ShowWindowEnum.ShowNormal);
Scripter scripter = new Scripter();
scripter.InitVariables.Clear();
scripter.RunLine("window TestApp");
scripter.InitVariables.Add(nameof(colorCode), new TextStructure(colorCode));
scripter.Text = $@"keyboard {TextChar}FocusOnControl tbColorRGB{TextChar}
keyboard {SpecialChars.KeyBegin}enter{SpecialChars.KeyEnd}
keyboard {TextChar}{SpecialChars.Variable}{nameof(colorCode)}{TextChar}
keyboard {SpecialChars.KeyBegin}enter{SpecialChars.KeyEnd}";
scripter.Run();
string path1 = Assembly.GetExecutingAssembly().UnpackResourceToFile("Resources." + nameof(Resources.littleGrayRectangle), "bmp");
scripter.RunLine($"waitfor.image image {SpecialChars.Text}{path1}{SpecialChars.Text}");
}
public void FilterTest()
{
List <string> boldedTexts = new List <string>()
{
"In 1929", "In 1949", "In 1950,", "In 1955,"
};
string path = Assembly.GetExecutingAssembly().UnpackResourceToFile("Resources." + nameof(Resources.document2), "jpg");
Scripter scripter = new Scripter();
scripter.InitVariables.Clear();
scripter.Text = ($@"ocrabbyy.processfile {SpecialChars.Text}{path}{SpecialChars.Text}
ocrabbyy.filter filter bold");
scripter.Run();
List <GStruct.Structure> res = scripter.Variables.GetVariableValue <List <GStruct.Structure> >("result");
foreach (GStruct.Structure value in res)
{
string text = ((GStruct.TextStructure)value).Value.Trim();
if (boldedTexts.Contains(text))
{
boldedTexts.Remove(text);
}
}
System.Text.StringBuilder notRecognizedBold = new System.Text.StringBuilder();
foreach (string s in boldedTexts)
{
notRecognizedBold.Append($" '{s}'");
}
Assert.AreEqual(0, boldedTexts.Count, $"Text not recognized as boold {notRecognizedBold}");
}
public void WordSaveTest()
{
string savePath = Environment.CurrentDirectory + @"\test.docx";
scripter.Text =
$@"word.open
window {SpecialChars.Text}{SpecialChars.Search}word{SpecialChars.Search}{SpecialChars.Text}
keyboard {SpecialChars.Text}{wordToBeTested}{SpecialChars.Text}
word.save {SpecialChars.Variable}savePath
word.close
delay 4
word.open {SpecialChars.Variable}savePath
window {SpecialChars.Text}{SpecialChars.Search}word{SpecialChars.Search}{SpecialChars.Text}
word.gettext
word.close";
scripter.InitVariables.Add("savePath", new TextStructure(savePath));
scripter.Run();
Assert.AreEqual(wordToBeTested, scripter.Variables.GetVariableValue <string>("result").Trim());
FileInfo f = new FileInfo(savePath);
Assert.IsTrue(f.Exists);
f.Delete();
}
public void ExcelRemovecolindexumnTest()
{
scripter.Text = ($@"excel.open
excel.setvalue aaa row 1 colindex 1
excel.setvalue bbb row 1 colindex 2
excel.insertcolumn colindex 1 where after
excel.removecolumn colindex 2
excel.getvalue row 1 colindex 2 result {SpecialChars.Variable}result1
excel.insertcolumn colindex 2 where before
excel.removecolumn colname b
excel.getvalue row 1 colindex 2
excel.close");
scripter.Run();
Assert.AreEqual("bbb", scripter.Variables.GetVariableValue <string>("result1"));
Assert.AreEqual("bbb", scripter.Variables.GetVariableValue <string>("result"));
}
public void ExpectImageOnScreenTest()
{
string colorCode = "FFF0F8FF";
testerApp = SDK.Tester.RunFormTester("Title TestApp");
Scripter scripter = new Scripter();
scripter.InitVariables.Clear();
string image1 = Assembly.GetExecutingAssembly().UnpackResourceToFile("Resources." + nameof(Resources.FFF0F8FF), "bmp");
scripter.InitVariables.Add(nameof(colorCode), new TextStructure(colorCode));
scripter.Text = $@"image.expected image1 {SpecialChars.Text}{image1}{SpecialChars.Text}
window TestApp
keyboard {TextChar}FocusOnControl tbColorRGB{TextChar}
keyboard {SpecialChars.KeyBegin}enter{SpecialChars.KeyEnd}
keyboard {TextChar}{SpecialChars.Variable}{nameof(colorCode)}{TextChar}
keyboard {SpecialChars.KeyBegin}enter{SpecialChars.KeyEnd}";
scripter.Run();
var result = scripter.Variables.GetVariableValue <bool>("result");
Assert.IsTrue(result);
}
public void WordExportTest()
{
string pdfPath = Environment.CurrentDirectory + @"\test.pdf";
string xpsPath = Environment.CurrentDirectory + @"\test.xps";
scripter.InitVariables.Add("pdfPath", new TextStructure(pdfPath));
scripter.InitVariables.Add("xpsPath", new TextStructure(xpsPath));
scripter.Text =
$@"word.open
word.export {SpecialChars.Variable}pdfPath
word.export {SpecialChars.Variable}xpsPath type xps
word.close";
scripter.Run();
FileInfo pdfFile = new FileInfo(pdfPath);
FileInfo xpsFile = new FileInfo(xpsPath);
Assert.IsTrue(pdfFile.Exists);
Assert.IsTrue(xpsFile.Exists);
pdfFile.Delete();
xpsFile.Delete();
}
