How does the automated test parse the excel file?

foreword In automated testing, we store data nothing more than using files or databases, so the files can be csv, xlsx, xml, or even txt files. Usually, excel files are often our first choice. Whether it is writing test cases or storing test data, excel is Very convenient. So today, we will summarize the methods of processing excel files in dif ...

Posted by raven_web on Wed, 25 May 2022 15:58:56 +0300

appium---PO model design

We should all have heard of the PO model when we do automation, so what is the PO model? What is the role of PO model in automation? PO model PO is actually: Page Object Model, also known as POM Model. PO is actually a design pattern, which has become popular in automated testing to enhance test maintenance and reduce code duplication. Page obj ...

Posted by Gazan on Fri, 20 May 2022 09:27:22 +0300

Software testing environment -- install MySQL on Linux (detailed), fine sorting

1, Foreword Several common ways to install software on Linux: Source code compilationDecompress the compressed package (generally tar.gz)Compiled installation package (RPM, DPKG, etc.)Online installation (YUM, APT, etc.) The convenience of the above methods increases in turn, but the versatility decreases in turn Delete the development ...

Posted by parkej60 on Wed, 18 May 2022 02:16:56 +0300

Python+Selenium uses Page Object to automate page testing

Page Object mode is a test design mode in Selenium. It mainly designs each page as a Class, which contains the elements (buttons, input boxes, headers, etc.) that need to be tested in the page. In the Selenium test page, page elements can be obtained by calling page classes, which cleverly avoids changing the test page code when the page elemen ...

Posted by stef686 on Tue, 17 May 2022 19:14:09 +0300

The second Python selenium automated test project

preface The previous article said that I want to write an article on automatic combat. I'm busy during this period. I haven't updated my blog since I went home for 11. Today, I'll sort out the code of the actual combat project for everyone to learn. (Note: the project is a test of our company's internal system, which can only be accessed throu ...

Posted by ywickham on Mon, 09 May 2022 22:57:05 +0300

Shell learning variables

1, shell variable 1. Define variables Shell supports the following three ways to define variables xub$ name=value xub$ name='value' xub$ name="value" # Name is the variable name and value is the value assigned to the variable. difference If value does not contain any white space characters (such as spaces, Tab indents, etc.), quotation ma ...

Posted by dig412 on Wed, 04 May 2022 02:42:26 +0300

The three most common framework parsing | how to create JUnit parametric tests

Parametric testing is a good way to define and run multiple test cases. The only difference between them is data. Here, let's take a look at three different frameworks commonly used in JUnit testing. When writing a unit test, the method input parameters and expected results are usually initialized in the test method itself. In some cases, a ...

Posted by JustinK101 on Tue, 03 May 2022 18:13:47 +0300

"List" of Python 3 "zero foundation beginners from introduction to actual combat"

List List is the most frequently used data type in Python language. List is one of ordered and variable sequences. The data types of elements in the same list can be different. The list is a data set enclosed by []. Different data are separated by commas. Different data types can be in the list For example: songs = ["Thousands of miles away ...

Posted by lutzlutz896 on Tue, 03 May 2022 10:24:43 +0300

[automatic test learning notes] yaml file operation

What is yaml A markup language. yaml is a language specially used to write configuration files, which is very concise and powerful It is more intuitive and convenient, which is a little similar to json format Automated testing needs to separate code and data. We often need to put different data into different files for reading, such as puttin ...

Posted by resago on Sat, 30 Apr 2022 20:48:13 +0300

MySQL exercises ~ 45

Create tables and add data -- classic SQL Exercises CREATE TABLE STUDENT8 (SNO VARCHAR(3) NOT NULL, SNAME VARCHAR(4) NOT NULL, SSEX VARCHAR(2) NOT NULL, SBIRTHDAY DATETIME, CLASS VARCHAR(5)); CREATE TABLE COURSE (CNO VARCHAR(5) NOT NULL, CNAME VARCHAR(10) NOT NULL, TNO VARCHAR(10) NOT NULL); CREATE TABLE SCORE (SNO VARCHAR(3) NOT NULL, CNO ...

Posted by _confused_ on Wed, 13 Apr 2022 00:52:46 +0300