[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
RE: [qftestJUI] Open terminal window.
Hi Amit, why don't you use the "psql" script from PostgreSQL for database manipulation? Using this tool enables you, doing database manipulation steps from command line. Sample Call: "psql -d <database> -c <sqlcommand>" or "psql -d <database> -f <file with sql statements>" I suppose using this tool would be rather easier and faster than starting up the UI of PostgreSQL. The integration of this command into qftestJUI as ExecuteShellCommand-Node is easy, as Karl-Heinz has mentioned already. Regards, Martin -----Original Message----- From: qftestjui-list-bounces@?.de [mailto:qftestjui-list-bounces@?.de] On Behalf Of Karlheinz Kellerer Sent: Monday, January 09, 2006 2:48 PM To: qftestJUI-list@?.de Cc: Tora, Amit (GE Healthcare, consultant) Subject: Re: [qftestJUI] Open terminal window. Hi Amit, > HI, > > I am working on a database application. I want to empty the database and for > taht i need to open a Linux terminal and had to login to postgress and then > empty the tables. Is it possible to open a terminal and automate this using > the qftest. How can we do that. Yes, that should be possible. If you create a shell script for login to postgress and empty the table, this script e.g. can be executed via a "Execute Shell Command" node. Please see manual chapter "15.6 Processes" further details. > Also in my application the data is presented > in form of rows and columns and so I need help to validate the number of > rows and colums. As we can get the row and column index how can I validate > the numbers of indexes. Can you please help me. There are different features in qftest to support you in working with data tables. - A "Check Items" node (15.4.2 Check items) may help to check an entire data row. - A "Fetch Index" node (15.5.2 Fetch index) helps to resolve the index of row containing certain data. - Row and Column count can be retrieved be using an SUT script node using the Java table methods getRowCount() and getColumnCount(). Best regards, Karl -- Karlheinz Kellerer Karlheinz.Kellerer@?.de Quality First Software GmbH http://www.qfs.de Tulpenstr. 41 Tel: +49 8171 919877 DE-82538 Geretsried Fax: +49 8171 919876 _______________________________________________ qftestJUI-list mailing list qftestJUI-list@?.de http://www.qfs.de/mailman/listinfo/qftestjui-list