240 likes | 351 Views
Final Presentation. SoftServe IT Academy. Yemel’yanenko Tatiana DP-024.AQC Oct 25.2012. Personal information. Some information about the presenter. Yemel’yanenko Tatiana. Date of birth:. 12 July 1981. Education :. Doctor of Philosophy, Master of Science in
E N D
Final Presentation SoftServe IT Academy Yemel’yanenko Tatiana DP-024.AQC Oct 25.2012
Personal information Some information about the presenter Yemel’yanenko Tatiana Date of birth: 12 July 1981 Education: Doctor of Philosophy, Master of Science in Applied Mathematics, Associate Professor at Oles Gonchar Dnepropetrovsk National University Hobbies: learning English, reading, scrapbooking
Agenda • Elementary tasks • Selenium • Simple testing GUI components on www.gorod.dp.ua • Page Object Pattern • Testing GUI components on www.emarket.ua • SQL queries • SQL-Ex.ru • Query to hierarchy database • TestComplete • JMeter • Simple PT Scenario • PT Scenario with JMeter variables and functions • Using regular expressions, logical and loop controllers in Jmeter • BSF post processor in JMeter • Watir • Summary • Questions
Elementary Tasks Task. Display all the most frequently found element in list on C# public List<int> Frequently() { List<int> Maxelement = new List<int>(); int CurCount, MaxelementCount; Maxelement.Add(ListInt[0]); MaxelementCount = ListInt.Count(p => p == ListInt[0]); foreach (var el in ListInt) { CurCount = ListInt.Count(p => p == el); if (CurCount > MaxelementCount) { Maxelement.Clear(); Maxelement.Add(el); MaxelementCount = CurCount; } if ((CurCount == MaxelementCount) && (!Maxelement.Contains(el))) { Maxelement.Add(el); } } return Maxelement; }
Elementary Tasks Task. Display all the most frequently found element in array on ruby module Frequently ar = [2,3,5,2,7,8,9,7,2,3,8,3,9,8,15] puts "Array: #{ar}" max_element = [ar[0]] max_element_count = ar.count(max_element) ar.each{|el| cur_count = ar.count(el) if cur_count > max_element_count max_element_count = cur_count max_element = [el] end if (cur_count == max_element_count) && (!max_element.include?(el)) max_element<<el end } puts "Frequently found elements in array: #{max_element}" end
Selenium. Simple testing GUI components on gorod.dp.ua Task. Checking value of properties GUI components on page ‘Afisha’on www.gorod.dp.ua
Selenium. Simple testing GUI components on gorod.dp.ua Task. Checking value of properties GUI components on page ‘Afisha’on www.gorod.dp.ua Результаты тестирования в Nunit, что тестировалось, код?
Selenium. Page Object Pattern Task. Apply Page Object Pattern for checking functionality of adding and deleting advert on www.gorod.dp.ua Диаграмма классов
Selenium. Page Object Pattern Результаты тестированияв Nunit, удаление объявления, кусок кода?
Selenium. Testing GUI components on www.emarket.ua Task.Testing GUI components on www.emarket.ua [Test] public void testCheckColors() { AddAdvertPage ap = new AddAdvertPage(driver); ap.CheckColors(); foreach (var col in ap.ColorsList) { Assert.True(CheckFieldBackGroundColor(col.FieldBackGroundColor)); Assert.True(CheckColor(col.Color)); Assert.True(CheckBackGroundColor(col.BackGroundColor)); } } [Test] public void testCheckMessages() { AddAdvertPage ap = new AddAdvertPage(driver); ap.CheckMessages(); for (int i = 0; i < ap.MessagesList.Count; i++) { Assert.True(ap.MessagesList[i].Equals(ap.ValidMessagesList[i])); } }
SQL-ex.ru Results from www.sql-ex.ru Result: 39 exercises of learning stage
SQL. Query to hierarchy database Task. Find father’s last name which is more frequently used SELECT [LastName] FROM [Demo].[dbo].[Persons] WHERE [ID] IN (SELECT [fk_fatherID] FROM [Demo].[dbo].[Persons] WHERE [fk_fatherID] IS NOT NULL) GROUP BY [LastName] HAVING COUNT([LastName]) = (SELECT MAX(C) FROM (SELECT COUNT([LastName]) AS C FROM [Demo].[dbo].[Persons] WHERE ID IN (SELECT [fk_fatherID] FROM [Demo].[dbo].[Persons] WHERE [fk_fatherID] IS NOT NULL) GROUP BY [LastName] ) Res)
JMeter. Simple PT Scenario Task. Create PT Scenario for user’s login. Run scenario with 30, 60 and 120 threads (users). Save graph results.
JMeter. PT Scenario with JMeter variables and functions Task. Create PT Scenario, that will add Address Book entry. FirstName and LastName should contain current Thread number in the prefix. Birthday should contain random numbers. Scenario should contain parameters (server, port, protocol etc.)
JMeter. Using regular expr., logical and loop controllers Task. Create PT Scenario, that will remove all groups with your name Before After
JMeter. BSF post processor in JMeter Task. Analyze responses on /testlink/ of POST at “Add/Remove Test Cases” menu and create PT Scenario, that will parse this POST responses for receiving value of variable ‘href’.
Summary Tools: • ArgoUML • Selenium • MS SQL Server • MS Visual Studio • TestComplete • JMeter • Watir Skills: • UML • C# • SQL • Ruby • SCRUM
Questions Any questions ?
Contacts Yemel’yanenko Tatiana 49099, Dniepropetrovsk L.Stal, 7 Cell: 067-780-75-06 E-mail: t.yemelyanenko@gmail.com Skype: etg_eas Thank you for attention!