Sahi Pro - Excel Framework

Sample Excel Sheet

For example, a simple test written as an Excel sheet looks like this:

TestCase	Key Word	Argument1	Argument2	Argument3
	loadSahi	"books_lib.sah"
Check shopping cart total	[Documentation]	Smoke test for add books
	login	"test"	"secret"
	addBooks	3	2	1
	verifyTotal	1640
	logout
Test login error message	[Documentation]	Checks Invalid login message
	login	"test"	"bad password"
	verifyNotLoggedIn
	verifyErrorMessage	"Invalid username or password"

These tests talk mostly in the language of the business (also called a Domain Specific Language or DSL for that business), and hide away all the implementation details of clicking buttons and populating textboxes.

Loading Sahi script libraries

The implementation details are moved into an included Sahi script, which is linked to this Excel sheet via the initial

loadSahi

"books_lib.sah"

statement.

The code in books_lib.sah is given below:

function login($username, $password){
    _setValue(_textbox("user"), $username);
    _setValue(_password("password"), $password);
    _click(_submit("Login"));
}

function addBooks($numJava, $numRuby, $numPython){
    _setValue(_textbox("q", _near(_cell("Core Java"))), $numJava);
    _setValue(_textbox("q", _near(_cell("Ruby for Rails"))), $numRuby);
    _setValue(_textbox("q", _near(_cell("Python Cookbook"))), $numPython);
    _click(_button("Add"));
}

function verifyTotal($total){
    _assertEqual($total, _textbox("total").value);
}

function logout(){
    _click(_button("Logout"));
}

function verifyNotLoggedIn(){
    _assertExists(_textbox("user"));
}

function verifyErrorMessage($msg){
    _assert(_isVisible(_div("errorMessage")));
    _assertEqual($msg, _getText(_div("errorMessage")));
}

Executing the Excel Sheet

Executing the Excel sheet is no different from executing a Sahi script.
Just copy the Excel sheet into sahi/userdata/scripts directory (or inside a sub-directory) and the xls file will be visible in the drop down in Controller Playback tab. Choose the file, Click "Set" and then "Play" to playback.

Play back reports/logs

On execution, Sahi generates logs showing success or failure. Logs are visible from the "Logs" link in Playback tab.
Logs can also be accessed via http://localhost:9999/logs

A sample log is shown below. Clicking any step expands to show the underlying Sahi steps. You can click on the log statements below.


Please refer to sahi/userdata/scripts/demo/framework folder for some examples.

Syntax

Test Case	Key word	Argument 1	Argument 2	Argument 3	Very first line of sheet
					Blank lines are ignored
	loadSahi	"custom_lib.sah"			Loads a Sahi script with required function definitions
Test Case One	Step One	Param1	Param2		New test case started.StepOne(Param1, Param2) is called.
	Step Two	Param3			StepTwo(Param3) is called
Test Case Two	Step One	25	"age"		New test case started.String values are quoted
	Step Two	Param5
Test Case Three	[Documentation]	Some description about the test case			[Documentation] is useful for, well, documentation
	Step One	25	"age"		New test case started.String values are quoted
//	Step Two	Param5			Commented step using //
	Step Two	Param6

Spaces will be removed from keywords and corresponding functions invoked.

The rules for writing the Excel sheet are as follows

The first line should be populated with
Test Case | Key word | Argument 1 | Argument 2 | Argument 3
The names of the columns are not important, but they should not be left blank

If the first column is populated, a new test case is started.

The second column holds keywords. Keywords are mapped to functions in the included Sahi script.
They can be user defined functions or Sahi APIs themselves

For example,

login

"test"

"secret"

in the excel sheet, maps to the javascript call

login("test", "secret");

_assertEqual

_getText(_cell("msg"))

"abcd"

becomes

_assertEqual(_getText(_cell("msg")), "abcd");

Variables

The Excel framework also supports variables, eg.

	$userId=createUserInGroup	"My name"	"My group"
	verifyUserCreated	$userId	"My name"	"My group"

or

	$msg=	_getText(_cell("msg"))
	_assertEqual	$msg	"abcd"

SetUp and TearDown

Different test cases may need the same steps to be executed before and after.
For example, one may need to login before and logout after each test case.
This can be accomplished through global SetUp and TearDown blocks.
TearDown will be called inspite of any errors or failures in the testcase.

[Global]	[SetUp]
	_log	"In Global Setup"
	login	"test"	"secret"
	[TearDown]
	_click	_button("Logout")
	_log	"In Global Teardown"
Verify books total	addBooks	3	2	1
	verifyTotal	1650
Verify books again	addBooks	3	2	2
	verifyTotal	2000

This will execute as:

	_log	"In Global Setup"
	login	"test"	"secret"
	addBooks	3	2	1
	verifyTotal	1650
	_click	_button("Logout")
	_log	"In Global Teardown"
	_log	"In Global Setup"
	login	"test"	"secret"
	addBooks	3	2	2
	verifyTotal	2000
	_click	_button("Logout")
	_log	"In Global Teardown"

Creating Keywords on the fly in Excel

Keywords are normally created as functions in the included Sahi scripts, so that the details are hidden away and one gets good programmatic control in the scripts.But sometimes it may be convenient to club together different steps and create a keyword in the Excel sheet itself.

Create AddBooksCheck Key Word	[CreateKeyword]	Add Books Check				[CreateKeyword] command creates a keyword called "Add Books Check"
	[Arguments]	$java	$ruby	$python	$total	These are the arguments or parameters that "Add Books Check" takes as input
	[Documentation]	Data drivable add books check
	addBooks	$java	$ruby	$python
	verifyTotal	$total

So now, a call to "Add Books Check" like this:

Add Books Check

3

2

1

1650

is equivalent to

	addBooks	3	2	1
	verifyTotal	1650

Data driven testing

Data Driven Example	[Keyword]	Add Books Check				Starts a testcase "Data Drivern Example" AddBooksCheck function will be called for the data set below.
	[SetUp]					This will be called BEFORE each row of data
	login	"test"	"secret"
	[TearDown]					This will be called AFTER each row of data
	_click	_button("Logout")
	[Documentation]	java	ruby	python	total	Ignored by Sahi. Makes test case more readable
	[Data]	3	2	1	1650	[Data] denotes start of data
		4	5	0	2100
		0	1	9	3350

This roughly translates to:

	login	"test"	"secret"
	Add Books Check	3	2	1	1650
	_click	_button("Logout")
	login	"test"	"secret"
	Add Books Check	4	5	0	2100
	_click	_button("Logout")
	login	"test"	"secret"
	Add Books Check	0	1	9	3350
	_click	_button("Logout")