cd /media/cdromsudo ./VBoxLinuxAdditions-x86.run sudo ./VBoxLinuxAdditions-amd64.run
require 'watir'
require 'watir/screen_capture'
include Watir::ScreenCapture
require 'win32ole'
def take_screenshot
randfname = Array.new(6) { (rand(122-97) + 97).chr }.join
begin
directory_name = File.dirname(__FILE__).gsub('/','\\') +
"\\screenshots\\#{$randdir}"
if FileTest::directory?(directory_name)
filename = "#{directory_name}\\#{randfname}.png"
screen_capture(filename,false, false)
else
Dir::mkdir(directory_name)
filename = "#{directory_name}\\#{randfname}.png"
screen_capture(filename,false, false)
end
end
end
' Adding sheet for Module
DataTable.AddSheet ("Module")
' Adding sheet for Testcase
DataTable.AddSheet ("Testcase")
' Adding sheet for Teststep
DataTable.AddSheet ("Teststep")
'-- Importing sheets from an external excel file
' Importing data of Module sheet from external excel file
DataTable.ImportSheet "Path of the excel file",1,"Module"
' Importing data of Testcase sheet from external excel file
DataTable.ImportSheet "Path of the excel file",2,"Testcase"
' Importing data of Teststep sheet from external excel file
DataTable.ImportSheet "Path of the excel file",3,"Teststep"
' Getting the total number of rows in the Module sheet
MrowCount=Datatable.GetSheet("Module").GetRowCount
' For loop is started here for Module data
For i=1 to Mrowcount
' Setting the first row in the Module sheet
DataTable.SetCurrentRow(i)
' Getting and Assigning the value of current row to Mflag
Mflag=DataTable.Value(3,"Module")
If Mflag ="Y" Then
' If Mflag = Y, assigning the current row value to ModuleId
ModuleId= DataTable.Value (1,"Module")
' Getting the total number of rows in the Testcase sheet
TcrowCount=DataTable.GetSheet ("Testcase").GetRowCount
' For loop is started here for Testcase data
For j=1 to TcrowCount
' Setting the first row in the Testcase sheet
Datatable.SetCurrentRow (j)
' Getting and Assigning the value of current row to ModuleId1
ModuleId1=DataTable.Value(4,"Testcase")
' Getting and Assigning the value of current row to Tcflag
Tcflag=DataTable.Value(3,"Testcase")
If ModuleId=ModuleId1 and Tcflag="Y" Then
' If ModuleId = ModuleId1 and Tcflag = Y, assigning the
current row value to TcId
TcId=DataTable.Value(1,"Testcase")
' Getting the total number of rows in the Teststep sheet
TsrowCount=DataTable.GetSheet("Teststep").GetRowCount
' For loop is started here for Teststep data
For k= 1 to TsrowCount
' Setting the first row in the Teststep sheet
Datatable.SetCurrentRow(k)
' Getting and Assigning the value of current row to Tcid1
Tcid1=DataTable.Value(5,"Teststep")
If TcId= TcId1 Then
' If TcId = TcId1, assigning the current row value to
keyword
keyword= DataTable.Value(3,"Teststep")
' Select Case statement is started here
Select Case keyword
Case "lN"
' If keyword = IN, execute Login function and assign the
value to res
res=Login()
' Write the value of res to Teststep in the runtime data
table
DataTable.Value(6,"Teststep")=res
Case "CA"
' If keyword = CA, execute Close_Appl function
Close_Appl()
Case "OP"
' If keyword = OP, execute OpenOrd function and
assign the value to res
res=OpenOrd()
' Write the value of res to Teststep in the runtime
data table
DataTable.Value(6,"Teststep")=res
' End of Select Case statement
End Select
' End of If statement for Test Step sheet
End If
' End of For loop for Teststep data
Next
' End of If statement for Testcase sheet
End If
' End of For loop for Testcase data
Next
' End of If statement for Module sheet
End If
' End of For loop for Module data
Next
'--- Exporting results
' Exporting the runtime data sheet of Teststep to external excel file
Datatable.ExportSheet "Path of the file where you want","Teststep"
' Need to define functions like Login, Close_app and Openord
'--- Login function
' function definition for Login
Function Login()
----
End Function
'--- Close application function
' function definition for Close_Appl
Function Close_Appl()
-----
End Function
'--- Openord function
' function definition for OpenOrd
Function OpenOrd()
----
End Function
What is Diaspora?
Diaspora is the social network that puts you in control of your information. You decide what you’d like to share, and with whom. You retain full ownership of all your information, including friend lists, messages, photos, and profile details.
Share what you want, with who you want.
[via joindiaspora]
$sudo apt-get update $sudo apt-get install alien$sudo alien -k name-of-rpm-file.rpm$sudo dpkg -i name-of-deb-file.debmkdir /home/MountFoldermount -t vboxsf SharedFolder /home/MountFolderphp go-pear.phpphp PEAR/go-pear.pharpear channel-discover pear.phpunit.depear install phpunit/PHPUnitpear install Testing_Selenium-0.4.3.tarphpunit --verbose GoogleTest C:/Tests/GoogleTest.php<?xml version="1.0" encoding="UTF-8"?>
<html xsl:version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
xmlns="http://www.w3.org/1999/xhtml">
<xsl:if test="system-property('xsl:vendor')='Transformiix'"></xsl:if>
<body style="font-family: Verdana, Arial, Helvetica,
sans-serif;font-size:11px;background-color:#EEEEEE">
<xsl:for-each select="testsuite">
<div style="background-color:blue;color:white;padding:4px">
<span style="font-weight:bold">
<xsl:value-of select="@name"/>
<xsl/> Overall Results
</span>
</div>
<div style="margin-left:20px;margin-bottom:1em;font-size:10pt">
<span>
<xsl/> tests:
</span>
<xsl:value-of select="@tests"/>
</div>
<div style="margin-left:20px;margin-bottom:1em;font-size:10pt">
<span>
<xsl/> assertions:
</span>
<xsl:value-of select="@assertions"/>
</div>
<div style="margin-left:20px;margin-bottom:1em;font-size:10pt">
<span>
<xsl/> failures:
</span>
<xsl:value-of select="@failures"/>
</div>
<div style="margin-left:20px;margin-bottom:1em;font-size:10pt">
<span>
<xsl/> errors:
</span>
<xsl:value-of select="@errors"/>
</div>
<div style="margin-left:20px;margin-bottom:1em;font-size:10pt">
<span>
<xsl/> time (seconds):
</span>
<xsl:value-of select="@time"/>
</div>
</xsl:for-each>
<xsl:for-each select="testsuite/testcase">
<div style="color:white;padding:4px">
<xsl:attribute name="style">
<xsl:choose>
<xsl:when test="failure">background-color:red;
color:white;padding:4px;font-weight:bold</xsl:when>
<xsl:when test="@time=0.0">background-color:gray;
color:white;padding:4px;font-weight:bold</xsl:when>
<xsl:otherwise>background-color:green;
color:white;padding:4px;font-weight:bold
</xsl:otherwise>
</xsl:choose>
</xsl:attribute>
<span><xsl:value-of select="@name"/></span>
</div>
<div style="margin-left:20px;margin-bottom:1em;font-size:10pt">
<span>
<xsl/> assertions:
</span>
<xsl:value-of select="@assertions"/>
</div>
<div style="margin-left:20px;margin-bottom:1em;font-size:10pt">
<span>
<xsl/> time (seconds):
</span>
<xsl:value-of select="@time"/>
</div>
<xsl:for-each select="failure">
<div style="margin-left:20px;margin-bottom:1em;font-size:10pt">
<span>
<xsl:value-of select="time"/> failure type:
</span>
<xsl:value-of select="@type"/>
</div>
<div style="margin-left:20px;margin-bottom:1em;font-size:10pt">
<span>
<xsl/> failure message:
</span>
<xsl:value-of select="@message"/>
</div>
</xsl:for-each>
</xsl:for-each>
<div style="background-color:black;color:white;padding:4px">
<span style="font-weight:bold">
<xsl/> Console Output
</span>
</div>
<xsl:value-of
select="."
disable-output-escaping="yes"/>
</body>
</html>
def write_report(suite)
File.open("#{@basename}-#{suite.name.gsub(/[^a-zA-Z0-9]+/, '-')}--
#{Time.now.strftime("%m-%d-%Y--%H-%m")}.xml", "w") do |f|
f << suite.to_xml
end
end
<?php
set_include_path(get_include_path() . PATH_SEPARATOR . './PEAR/');
require_once 'Testing/Selenium.php';
require_once 'PHPUnit/Framework/TestCase.php';
class check_links extends PHPUnit_Framework_TestCase {
private $sel;
function setUp() {
$this->sel = new Testing_Selenium("*firefox", "www.my-test-url.com/");
$this->sel->start();
$this->sel->setTimeOut(60000);
}
function tearDown() {
$this->sel->stop();
}
function testLinks() {
//delete screenshot files
foreach (glob("C:\\screenshot_repo\\*.png") as $filename) {
unlink($filename);
}
$this->sel->open("/");
$this->linkval = $this->sel->getAllLinks('id=links-div');
//write all the links found on a separate php file in an array form
$txtfile = fopen('dump.php', 'w+');
fwrite($txtfile, "<?php\n\$links_content = array(\n");
for($i = 0, $size = sizeof($this->linkval); $i < $size; $i++) {
$txt = $this->sel->getText("id=".$this->linkval[$i]);
fwrite($txtfile, "array(href=>".'"'.$this->sel->getAttribute(
'id='.$this->linkval[$i].'@href').'"'.','."text=>".'"'.$txt.'")
,'."\t\n");
}
fwrite($txtfile, ");\n?>");
//read the file and get file length
$txtfile = fopen('dump.php', 'r');
$count = 0;
while(fgets($txtfile)) {
$count++;
}
fclose($txtfile);
include 'dump.php';
for ($links=0;$links<=$count-5;$links++) {
$this->sel->open($links_content[$links]['href']);
$this->sel->waitForPageToLoad(30000);
//take a screenshot of the page
$this->sel->windowFocus();
$this->sel->windowMaximize();
$SSPath = 'C:\\screenshot_repo\\';
$this->sel->captureEntirePageScreenshot($SSPath.str_replace(
" ","_",(strtolower($links_content[$links]['text'])))
.".png","");
}
}
}
?>
<?php
$dbname="{database name}";
$cn=mysql_connect('{host}','{username}','{password}') or
die("I Couldn't connect");
$db=mysql_select_db($dbname,$cn) or die("I Couldn't select your database");
$app_table1="{table name}";
?>
java -versionjava -jar selenium-server.jarrequire 'fileutils'
require 'win32ole'
def check_for_popups(title="Message from webpage", button="OK")
popup=Thread.new {
autoit=WIN32OLE.new('AutoItX3.Control')
ret=autoit.WinWait(title,"",60)
if (ret==1)
autoit.WinActivate(title)
button.downcase!
if button.eql?("ok") || button.eql?("yes") || button.eql?("continue")
autoit.Send("{Enter}")
else
autoit.Send("{tab}")
autoit.Send("{Enter}")
end
elsif (ret==0)
puts "No popup, please check your code."
end
}
at_exit { Thread.kill(popup)
}
end and below for Internet Explorer authetication popupdef login(vusername,vpassword,vtest_site)
@user = vusername
@pass = vpassword
@url = vtest_site
a = Thread.new {
FileUtils.rm_rf vcookiedir
$ie = Watir::Browser.new
$ie.goto(@url)
sleep 15
}
sleep 15
autoit=WIN32OLE.new('AutoItX3.Control')
autoit.Send(@user)
autoit.Send('{TAB}')
autoit.Send(@pass)
autoit.Send('{ENTER}')
a.join
end
net use z: \\vboxsvr\SharedFolder -p
require ‘fileutils’
$cookieDir = “C:\\Documents and Settings\\#{ENV['USERNAME']}\\Cookies”
FileUtils.rm_rf $cookieDir
sudo gem install rufus-schedulerrequire 'filetorun'
require 'rufus/scheduler'
class Scheduler
def start
scheduler = Rufus::Scheduler.start_new
scheduler.every '20s', :blocking =>; true do
puts "running test"
`ruby filetorun.rb`
end
scheduler.join
end
end
Scheduler.new.start
sudo gem install ruportruby -rubygems -e "require 'ruport'; puts Ruport::VERSION"require 'ruport'
require 'ruport/util'
r = Ruport::Report.new
r.add_mailer :default,
:host => "mail.domain.com",
:address => "email@domain.com"
recipients = ["to1@domain.com","to2@domain.com"]
recipients.each do |recipient|
r.send_to(recipient) do |mail|
mail.subject = "Test Email"
mail.attach "test_file.txt"
mail.attach "stylesheet.xsl"
mail.text = "This is an email with attachments"
end
end