DAY 43

WORKING WITH PDF FILES: -

PDF STANDS FOR PORTABLE DOCUMENT. THESE FILES ARE OCCUPYING LESS MEMORY AND EASY TO TRANSPORT. THESE FILES WILL BE OPENING BY USING ABOBE ACROBAT READER.

IN GENERAL PDF FILES ARE ALLOWING READ OPERATION, BUT THEY ARE NOT ALLOWING RIGHT OPERATION.

TO ACCESS PDF FILES IN QTP, VB SCRIPT AND QTP DID’NT PROVIDE ANY COMPONENT. DUE TO THIS REASON TEST AUTOMATORS ARE USING EXTERNAL COMPONENT TO INTIGRATE QTP AND PDF FILES.

EX: - learnquicktest.manipulatepdf

BEFORE USING EXTERNAL COMPONENTS IN QTP SCRIPTS. FIRST WE WANT TO INSTALL THAT COMPONENT IN THE SYSTEM.

EX1: - Write QTP script in QTP to find no of pages in given pdf file.

Option Explicit

‘Pdfo pdf object

‘Nop no of pages

Dim pdfo, nop

Set pdfo =Createobject(“LearnquickTest.manipulatepdf”)

Nop=pdfo.Getnumberofpage(“c:\fw4.pdf”)

Print(“No: of pages is” &nop)

Set pdfo=nothing

EX2: - Write QTP script in QTP to get content of specified page in specified file.

Option Explicit

Dim pdfo, x

Set pdfo=Createobject(“LearnquickTest.manipulatepdf”)

X=pdfo=getpdftext(“c:\fw4.pdf”,2,2)

Print(“page content is “ &x)

Set pdfo =Createobject(“LearnquickTest.manipulatepdf”)

X=pdfo=getpdftext(“c:\fw4.pdf”,2,2)

Print(“page content is “ &x)

Set pdf0=nothing

EX3: - Write QTP script in QTP to get only numeric’s in every page of specified pdf file.

Option Explicit

Dim pdfo, x,y,nop,r,I,z

Set pdfo=Createobject(“LearnquickTest.manipulatepdf”)

Nop=pdf.getnumbersofpages(“c:\fw4.pdf”)

For i=1 to nop step 1

                X=pdfo=getpdftext(“c:\fw4.pdf”,i,i)

                Set r=newregexp

                r.pattern=”^[0-9]+$”

                r.global=true

                Set y=r.execute(x)

For each z in y

                Print(z.value)

Next

Set y=nothing

Set r=nothing

Next

Set pdfo=nothing

WORKING WITH DATABASE

DATA MEANS THAT COLLECTION OF DATA. EVERY DATABASE IS HAVING DATA IN TABLE FORMAT. IN GENERAL DATABASES ARE WORKING AS BACKEND OF SOFTWARE.

 

TO VERIFY THOSE DATABASES USING QTP TOOL, WE CAN FOLLOW ABOVE APPROACH.

TO VERIFY DATABASE OF A SOFTWARE QTP CAN ALLOWS YOU TO WRITE PROGRAMES IN VB SCRIPT ALONG WITH SQL (STRUCTURED QUERY LANGUAGE) COMMANDS.

EX: - IN FIGHT RESERVATION SOFTWARE, DATABASE IS DEVELOPED IN MS-ACCESS. THIS DATABASE NAME IS FLIDHT32.

DEVELOPERS PROVIDED A DSN (DATA SOURCE NAME) TO CONNECT TO THIS DATABASE, CALLED AS “DT_FLIGHT32”. IN THIS DATABASE, “ORDERS” IS TABLE NAME. THIS TABLE CONSISTS OF BELOW COLUMNS                                             

ORDER_NUMBER,           CUSTOMER_NAME,        DEPARTURE_DATE,                         FLIGHT_NUMBER

TICKETS_ORDERED,         CLASS AGENTS_NAME                  SEND_SIGNATURE_WITH_ORDER

NOTE: - THE REQUIRED INFORMATION REGARDING DATABASE WILL BE PROVIDED BY DEVELOPERS VIA A DOCUMENT, CALLED AS DDD (Database Design Document). 

 Please Join & Comment....Thank u