Tag: Software Testing

There is no one or absolute way for building test automation. I use the following approach to choose the technology or tool I use to build my test automation framework:

• Open source
• Most popular in the community
• Regular maintenance by community
• Able to solve my problem

Scenario: Kicking off PageUp Exporter

    Given I delete the output file

When I log into Feature Manager

And I kick off an Exporter process with query “SELECT * from dbo.applicant where semail like ‘%test%’ and linstid = ‘543’”

Then I verify that the file is exported

And we verify that the file has “60” rows

And we verify that the file has “100” delimiters

And we verify that the email address contains “test”

And we verify that the file size is “19484”

The step definitions for the 1st step consists of C# code that calls the batch file:

 [Given(@”I delete the output file”)]

        public void GivenIDeleteTheOutputFile()

        {

            string fileName = @”c:PageUpOutexporterTest..txt”;

            File.Delete(fileName);

            Process p = new Process();

            p.StartInfo.UseShellExecute = false;

            p.StartInfo.RedirectStandardOutput = true;

            p.StartInfo.FileName = “C:\exporter_delete.bat”;

            p.Start();

        }

The batch file calls a text file which WinSCP needs:

@ECHO OFF

cd c:Program Files (x86)WinSCP

start WinSCP.exe /console /script=c:exporter_delete.txt

:END

The text file consists of more MS DOS commands to perform the operation on the FTP server:

# Automatically abort script on errors

option batch abort

# Disable overwrite confirmations that conflict with the previous

option confirm off

# Connect using a password

# open sftp://user:password@example.com -hostkey=”ssh-rsa 1024 xx:xx:xx:xx:xx:xx:xx:xx:xx:xx:xx:xx:xx:xx:xx:xx”

# Connect

open sftp://tuneup:iScWxPjvi7Oal6m@securestorage.pageuppeople.com -hostkey=”ssh-dss 1024 9e:bd:6f:c8:f9:68:18:81:f0:50:ce:71:dd:d6:53:2e”

cd /

# Download file to the local directory d:

rm *.txt

# Disconnect

close

# Exit WinSCP

exit