Firebird testing tools for Windows

View: New views
18 Messages — Rating Filter:   Alert me  

Parent Message unknown Firebird testing tools for Windows

by Philippe Makowski :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Jeff Jones  [08-03-14 19.13] :
>
> What are the tools you use for Q/A?  Are they free?  Do they run on
> Windows XP?
>
I will reply here, but please, I suggest that we follow this thread on the firebird-test list

All basic informations are here :
http://www.firebirdsql.org/index.php?op=devel&sub=qa&id=qmtest_howto
and others pages of the Firebird QA

So we are using QMtest and since it is a Python tool, we can use it under Linux, Windows,
MacOsX, Solaris, ...

What it is not said in the web pages, is that Pavel wrote a gui to create tests, and that
he created also a tool to generate html reports for tests results.

So the use of all this is not difficult.
For example, since January two french students that never used Firebird and Qmtest before,
created for us 71 new tests for Fb2.1
(I have to check them and commit them into our svn)

The way the tools are design, there is no problem to use them for your own test, on the
database you wanted.
And if more people use these tools, I hope that in return, they will give us some of their
tests sor we can improve our test suite.
The more tests we make, the more we have chance to give you a robust product.
So you're welcome.
And please come on the firebird-test AT lists.sourceforge.net, we will be pleased to help you.



-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Firebird-test mailing list
Firebird-test@...
https://lists.sourceforge.net/lists/listinfo/firebird-test

Parent Message unknown Firebird testing tools for Windows

by Jeff Jones - SHERIFFX :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Some parts of this message have been removed. Learn more about Nabble's security policy.

I have downloaded and installed all of the tools listed at http://www.firebirdsql.org/index.php?op=devel&sub=qa&id=qmtest_howto, as suggested by Philippe, but I have been unable to download the test suite (https://firebird.svn.sourceforge.net/svnroot/firebird/qa/trunk/testsuite) with Subversion using TortoiseSVN.  I get two error messages:

 

PROPFIND request failed on ‘/svnroot/firebird/qa/trunk/testsuite’

PROPFIND of ‘/svnroot/firebird/qa/trunk/testsuite’: could not connect to server (https://firebird.svn.sourceforge.net)

 

Can you help me?

 

Thanks!

 

Jeff Jones

 


-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Firebird-test mailing list
Firebird-test@...
https://lists.sourceforge.net/lists/listinfo/firebird-test

Parent Message unknown Firebird testing tools for Windows

by Jeff Jones - SHERIFFX :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Some parts of this message have been removed. Learn more about Nabble's security policy.

I have downloaded and installed all of the tools listed at http://www.firebirdsql.org/index.php?op=devel&sub=qa&id=qmtest_howto, as suggested by Philippe, but I have been unable to download the test suite (https://firebird.svn.sourceforge.net/svnroot/firebird/qa/trunk/testsuite) with Subversion using TortoiseSVN.  I get two error messages:

 

PROPFIND request failed on ‘/svnroot/firebird/qa/trunk/testsuite’

PROPFIND of ‘/svnroot/firebird/qa/trunk/testsuite’: could not connect to server (https://firebird.svn.sourceforge.net)

 

Can you help me?

 

Thanks!

 

Jeff Jones

 


-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Firebird-test mailing list
Firebird-test@...
https://lists.sourceforge.net/lists/listinfo/firebird-test

Re: Firebird testing tools for Windows

by Philippe Makowski :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Jeff Jones - SHERIFFX  [08-03-14 19.58] :
> I have downloaded and installed all of the tools listed at
> http://www.firebirdsql.org/index.php?op=devel&sub=qa&id=qmtest_howto, as
> suggested by Philippe, but I have been unable to download the test suite
> PROPFIND request failed on '/svnroot/firebird/qa/trunk/testsuite'
>
perhaps it was a problem at SF
now it seems to work

> Can you help me?
>
use :
https://firebird.svn.sourceforge.net/svnroot/firebird/qa/trunk/

with this you will get all tools


-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Firebird-test mailing list
Firebird-test@...
https://lists.sourceforge.net/lists/listinfo/firebird-test

Re: Firebird testing tools for Windows

by Jeff Jones - SHERIFFX :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Okay, the problem was a proxy setting at my end, nothing was wrong at
SourceForge.  I am downloading the files right now.

Thanks!
 
Jeff
 
-----Original Message-----
From: firebird-test-bounces@...
[mailto:firebird-test-bounces@...] On Behalf Of
Philippe Makowski
Sent: Friday, March 14, 2008 12:48 PM
To: firebird-test@...
Subject: Re: [Firebird-test] Firebird testing tools for Windows

Jeff Jones - SHERIFFX  [08-03-14 19.58] :
> I have downloaded and installed all of the tools listed at
> http://www.firebirdsql.org/index.php?op=devel&sub=qa&id=qmtest_howto,
as
> suggested by Philippe, but I have been unable to download the test
suite
> PROPFIND request failed on '/svnroot/firebird/qa/trunk/testsuite'
>
perhaps it was a problem at SF
now it seems to work

> Can you help me?
>
use :
https://firebird.svn.sourceforge.net/svnroot/firebird/qa/trunk/

with this you will get all tools


------------------------------------------------------------------------
-
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Firebird-test mailing list
Firebird-test@...
https://lists.sourceforge.net/lists/listinfo/firebird-test

-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Firebird-test mailing list
Firebird-test@...
https://lists.sourceforge.net/lists/listinfo/firebird-test

Parent Message unknown Re: Firebird testing tools for Windows

by Jeff Jones - SHERIFFX :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Some parts of this message have been removed. Learn more about Nabble's security policy.

Dear all,

 

I have tried to get QMTest up and running on my Windows XP machine, with no success.  It seems like the instructions at http://www.firebirdsql.org/index.php?op=devel&sub=qa make a lot of assumptions about the level of knowledge of the user, assumptions which are proven invalid in my case.  I am a SQL programmer and database developer, not a Python programmer.  While Python looks cool, my goal is not to learn how to install and run Python, or to develop Python programs.  My goal is to build a testing system for some Firebird databases.

 

If there is someone who can give me some guidance as to how to set up QMTest in a Windows XP environment so that I can run it relatively easily, I would appreciate hearing from you.  If you want to go offline, that is fine with me, too, although there may be someone else out there who could benefit from your knowledge.

 

Another alternative is to point me toward a different database testing package (preferably free or very inexpensive) that will work with Firebird on a Windows XP platform.  If you have any suggestions, please let me know.

 

Thanks!

 

Jeff Jones

J_jones@...

MCSO Technology Bureau

602-876-4048

 

data < information < knowledge < understanding < wisdom

 

 


-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Firebird-test mailing list
Firebird-test@...
https://lists.sourceforge.net/lists/listinfo/firebird-test

Re: Firebird testing tools for Windows

by Philippe Makowski :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Jeff Jones - SHERIFFX  [08-03-17 19.38] :
>
> I have tried to get QMTest up and running on my Windows XP machine, with
> no success.  
>
What problem do you have ?


--
Philippe Makowski
http://www.ibphoenix.com
Supporting users of Firebird
Tel +33 (0) 561058813



-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Firebird-test mailing list
Firebird-test@...
https://lists.sourceforge.net/lists/listinfo/firebird-test

Re: Firebird testing tools for Windows

by Jeff Jones - SHERIFFX :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Well, let's start at the beginning.

I have downloaded and/or installed all the applications listed.  I did
get Python 2.5, so I hope that is not a problem.

I downloaded the test suite from Subversion to a directory on my hard
drive named SVNRepository.

I added the Python directory to my PATH, and I can run Python in a
command window.

I am able to run the qadbm utility and create a "runnable" test suite
using the instructions given, but nothing is copied into any of the
directories.  I don't know if that is correct or not.

Although I can create a context file with all the variables listed,
there is no indication of where the file should be placed.

I would try to run a test, but (as far as I know) I haven't created any.

When I try to run the qmtest gui command from the Python prompt (">>>"),
I always get a syntax error.  Since there are no examples to mimic, it
is hard to know what the command should look like.

So, that is as far as I have gotten.  My frustration tolerance is rather
low after attempting to get this going all of Friday afternoon and
Monday morning, but if you have some suggestions on how to proceed,
please let me know.  I haven't given up yet, but that time may be coming
soon.

Thanks!
 
Jeff Jones
MCSO Technology Bureau
602-876-4048
 
-----Original Message-----
From: firebird-test-bounces@...
[mailto:firebird-test-bounces@...] On Behalf Of
Philippe Makowski
Sent: Monday, March 17, 2008 12:30 PM
To: firebird-test@...
Subject: Re: [Firebird-test] Firebird testing tools for Windows

Jeff Jones - SHERIFFX  [08-03-17 19.38] :
>
> I have tried to get QMTest up and running on my Windows XP machine,
with
> no success.  
>
What problem do you have ?


--
Philippe Makowski
http://www.ibphoenix.com
Supporting users of Firebird
Tel +33 (0) 561058813



------------------------------------------------------------------------
-
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Firebird-test mailing list
Firebird-test@...
https://lists.sourceforge.net/lists/listinfo/firebird-test

-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Firebird-test mailing list
Firebird-test@...
https://lists.sourceforge.net/lists/listinfo/firebird-test

Re: Firebird testing tools for Windows

by Philippe Makowski :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Jeff Jones - SHERIFFX  [08-03-17 21.15] :
> Well, let's start at the beginning.
>
> I have downloaded and/or installed all the applications listed.  I did
> get Python 2.5, so I hope that is not a problem.
>
and you set up qmtest and kinterbasdb

> I downloaded the test suite from Subversion to a directory on my hard
> drive named SVNRepository.
>
> I added the Python directory to my PATH, and I can run Python in a
> command window.
>
> I am able to run the qadbm utility and create a "runnable" test suite
> using the instructions given, but nothing is copied into any of the
> directories.  I don't know if that is correct or not.
>
no you should get something

here an example :
go to the directory where all tests are

cd /home/test/firebird/firebird/qa/trunk/testsuite

python qadbm.py

QADBM>platform linux
QADBM>target 2.0
QADBM> create /home/test/firebird/test2.1
QADBM> copy /home/test/firebird/test2.1


> Although I can create a context file with all the variables listed,
> there is no indication of where the file should be placed.
>
where you wanted

> I would try to run a test, but (as far as I know) I haven't created any.
>
not yet yes

> When I try to run the qmtest gui command from the Python prompt (">>>"),
> I always get a syntax error.  Since there are no examples to mimic, it
> is hard to know what the command should look like.
>
no to run test you should do the following (example continuing)
cd /home/test/firebird/test2.1
to run all tests :
qmtest run -C /mypath/context.txt

to launch gui
qmtest gui

and if you wanted to create tests, you can use qmedit
you have to launch it from the directory where you have your tests
(you can put if you wanted all the files that are into the qmedit directory from svn into
the directory where you have you tests)
and then launch qmedit
python qmedit.py

or under windows, I think you can double click on qmedit.py to launch it

now you can see how we wrote tests, and you can get inspiration from that

-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Firebird-test mailing list
Firebird-test@...
https://lists.sourceforge.net/lists/listinfo/firebird-test

Re: Firebird testing tools for Windows

by Pavel Cisar :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Philippe Makowski napsal(a):
> and you set up qmtest and kinterbasdb

There should be executable Windows installers for both, so installation
should be quite easy.

>> When I try to run the qmtest gui command from the Python prompt (">>>"),
>> I always get a syntax error.  Since there are no examples to mimic, it
>> is hard to know what the command should look like.

Don't run it from Python prompt, it has it's own script runnable from
shell. If you don't have c:\Python25\Scripts directory already in your
path, do so. It would make the life easier. If you have installed
ActivePython from ActiveState, you should have associations to directly
run .py and .pyw files. Or you can create a .bat file if you like.

> and if you wanted to create tests, you can use qmedit

Tests could be created, edited, inspected and run in qmtest gui (qmtest
web interface) just fine, but qmedit makes development of
Firebird-related tests more easy (our qmtest extension has a lot of
built-in functionality parametrized by test options. They're harder to
navigate using a web page, so qmedit is specialized editor with more
concise interface). However, it requires wxPython installed (easy and
straightforward using windows installer
(http://www.wxpython.org/download.php, install the unicode version, not
ansi).

best regards
Pavel Cisar
IBPhoenix

-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Firebird-test mailing list
Firebird-test@...
https://lists.sourceforge.net/lists/listinfo/firebird-test

Re: Firebird testing tools for Windows

by Jeff Jones - SHERIFFX :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Pavel,

Thank you very much for your assistance.  It has gotten me closer to my
goal (I think).

However, I still am unable to successfully run the qmtest gui.  I will
try to describe all that I have done.

I have installed ActivePython, the PyWin32 extensions, wxPython
(Unicode), KinterbasDB, QMTest, and the Subversion client.

The /Python25/ and /Python25/scripts/ directories are both in the PATH.

I used qadbm to create my test database at c:/fbtest/, and it
successfully copied the tests from your test suite.

In the test directory is a context file (context.txt).  Here are the
contents of this file:

---
temp_directory=c:/fbtest/temp/
server_location=localhost/3040:
database_location=c:/fbtest/temp/
suite_database_location=c:/fbtest/fdb/
backup_location=c:/fbtest/fbk/
files_location=c:/fbtest/files/
isc4_path="C:/Program Files/Firebird/Firebird_1_5/security.fdb"
user_name=SYSDBA
user_password=masterkey
isql_path="C:/Program Files/Firebird/Firebird_1_5/bin/isql"
gsec_path="C:/Program Files/Firebird/Firebird_1_5/bin/gsec"
gstat_path="C:/Program Files/Firebird/Firebird_1_5/bin/gstat"
gbak_path="C:/Program Files/Firebird/Firebird_1_5/bin/gbak"
#nbackup_path="C:/Program Files/Firebird/Firebird_1_5/bin/nbackup"
gfix_path="C:/Program Files/Firebird/Firebird_1_5/bin/gfix"
gpre_path="C:/Program Files/Firebird/Firebird_1_5/bin/gpre"
---

Does this look okay?  (I do have Firebird running on port 3040, because
Interbase is running on port 3050.  Also, I don't know if the values for
the paths need to have the double quotes around them, even though they
have a space embedded in them.  What do you think?)

Also in the c:/fbtest/ directory is a .bat file with which I want to run
the GUI.  Here are its contents:

---
cd..
cd /fbtest
qmtest.py gui -C context.txt
---

When I double-click this file, a command window opens, then my browser
(Mozilla Firefox) opens, it waits for a few seconds, then displays the
"Page cannot be displayed" message.  The address in the browser's
address line is:

http://127.0.0.1:1330/test/dir

It seems like I'm getting close, but still no success.  Any suggestions?

Thanks!
 
Jeff
 
-----Original Message-----
From: firebird-test-bounces@...
[mailto:firebird-test-bounces@...] On Behalf Of Pavel
Cisar
Sent: Tuesday, March 18, 2008 12:41 AM
To: firebird-test@...
Subject: Re: [Firebird-test] Firebird testing tools for Windows

Philippe Makowski napsal(a):
> and you set up qmtest and kinterbasdb

There should be executable Windows installers for both, so installation
should be quite easy.

>> When I try to run the qmtest gui command from the Python prompt
(">>>"),
>> I always get a syntax error.  Since there are no examples to mimic,
it
>> is hard to know what the command should look like.

Don't run it from Python prompt, it has it's own script runnable from
shell. If you don't have c:\Python25\Scripts directory already in your
path, do so. It would make the life easier. If you have installed
ActivePython from ActiveState, you should have associations to directly
run .py and .pyw files. Or you can create a .bat file if you like.

> and if you wanted to create tests, you can use qmedit

Tests could be created, edited, inspected and run in qmtest gui (qmtest
web interface) just fine, but qmedit makes development of
Firebird-related tests more easy (our qmtest extension has a lot of
built-in functionality parametrized by test options. They're harder to
navigate using a web page, so qmedit is specialized editor with more
concise interface). However, it requires wxPython installed (easy and
straightforward using windows installer
(http://www.wxpython.org/download.php, install the unicode version, not
ansi).

best regards
Pavel Cisar
IBPhoenix

------------------------------------------------------------------------
-
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Firebird-test mailing list
Firebird-test@...
https://lists.sourceforge.net/lists/listinfo/firebird-test

-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Firebird-test mailing list
Firebird-test@...
https://lists.sourceforge.net/lists/listinfo/firebird-test

Re: Firebird testing tools for Windows

by Pavel Cisar :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Jeff,

Jeff Jones - SHERIFFX napsal(a):

>
> Thank you very much for your assistance.  It has gotten me closer to my
> goal (I think).
>
> However, I still am unable to successfully run the qmtest gui.  I will
> try to describe all that I have done.
>
> I have installed ActivePython, the PyWin32 extensions, wxPython
> (Unicode), KinterbasDB, QMTest, and the Subversion client.
>
> The /Python25/ and /Python25/scripts/ directories are both in the PATH.

So far so good.

> I used qadbm to create my test database at c:/fbtest/, and it
> successfully copied the tests from your test suite.

Just to be sure, you did CREATE and then COPY, right? The qadbm.py tools
is very old (one from my first Python tools) and haven't very intuitive
interface (guess I'll rewrite it soon). The CREATE command creates the
destination directory and copies the QMTest subdirectory there. This
subdirectory in fact makes it a test database for QMTest. It contains
some configuration files and our extension classes for QMTest. The COPY
command just copies test files around.

> In the test directory is a context file (context.txt).  Here are the
> contents of this file:
>
> ---
> temp_directory=c:/fbtest/temp/
> server_location=localhost/3040:
> database_location=c:/fbtest/temp/
> suite_database_location=c:/fbtest/fdb/
> backup_location=c:/fbtest/fbk/
> files_location=c:/fbtest/files/
> isc4_path="C:/Program Files/Firebird/Firebird_1_5/security.fdb"
> user_name=SYSDBA
> user_password=masterkey
> isql_path="C:/Program Files/Firebird/Firebird_1_5/bin/isql"
> gsec_path="C:/Program Files/Firebird/Firebird_1_5/bin/gsec"
> gstat_path="C:/Program Files/Firebird/Firebird_1_5/bin/gstat"
> gbak_path="C:/Program Files/Firebird/Firebird_1_5/bin/gbak"
> #nbackup_path="C:/Program Files/Firebird/Firebird_1_5/bin/nbackup"
> gfix_path="C:/Program Files/Firebird/Firebird_1_5/bin/gfix"
> gpre_path="C:/Program Files/Firebird/Firebird_1_5/bin/gpre"
> ---
>
> Does this look okay?  (I do have Firebird running on port 3040, because
> Interbase is running on port 3050.  Also, I don't know if the values for
> the paths need to have the double quotes around them, even though they
> have a space embedded in them.  What do you think?)

Paths with spaces doesn't need to be escaped / enclosed in double
quotes. I'm not sure now whether they can hurt or not, but it should
definitely work without them. The server_location is correct.

Important thing: The qadbm tool doesn't copies support files like
databases or backup files when you create a working test database! It
somehow makes sense as they're shared. So you should point your context
entries for suite_database_location, backup_location and files_location
to directories where they really reside (in your SVN repository checkout).

> Also in the c:/fbtest/ directory is a .bat file with which I want to run
> the GUI.  Here are its contents:
>
> ---
> cd..
> cd /fbtest
> qmtest.py gui -C context.txt
> ---
>
> When I double-click this file, a command window opens, then my browser
> (Mozilla Firefox) opens, it waits for a few seconds, then displays the
> "Page cannot be displayed" message.  The address in the browser's
> address line is:
>
> http://127.0.0.1:1330/test/dir
>
> It seems like I'm getting close, but still no success.  Any suggestions?

Well, something went wrong half-way through QMTest initialization. The
best way to find out what's wrong is to run this bat file from command
prompt. Just open the new console window, switch to your test database
directory and run the bat file from there. QMTest will prints all
messages to console, and this way it wouldn't close on you.

best regards
Pavel Cisar
IBPhoenix

-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Firebird-test mailing list
Firebird-test@...
https://lists.sourceforge.net/lists/listinfo/firebird-test

Re: Firebird testing tools for Windows

by Jeff Jones - SHERIFFX :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Pavel,

I tried running the .bat file from the command window, and the behavior
is the same.  The only thing that shows up in the command window is:

QMTest running at http://127.0.0.1:1421/test/dir

It seems like there ought to be more output, but nothing appears.  The
browser stays open, and the command window does not close, and does not
return to the C: prompt.

Thanks for staying with me, I really appreciate it.

Jeff
 

-----Original Message-----
From: firebird-test-bounces@...
[mailto:firebird-test-bounces@...] On Behalf Of Pavel
Cisar
Sent: Wednesday, March 19, 2008 01:10 PM
To: firebird-test@...
Subject: Re: [Firebird-test] Firebird testing tools for Windows

Jeff,

Jeff Jones - SHERIFFX napsal(a):
>
> Thank you very much for your assistance.  It has gotten me closer to
my
> goal (I think).
>
> However, I still am unable to successfully run the qmtest gui.  I will
> try to describe all that I have done.
>
> I have installed ActivePython, the PyWin32 extensions, wxPython
> (Unicode), KinterbasDB, QMTest, and the Subversion client.
>
> The /Python25/ and /Python25/scripts/ directories are both in the
PATH.

So far so good.

> I used qadbm to create my test database at c:/fbtest/, and it
> successfully copied the tests from your test suite.

Just to be sure, you did CREATE and then COPY, right? The qadbm.py tools
is very old (one from my first Python tools) and haven't very intuitive
interface (guess I'll rewrite it soon). The CREATE command creates the
destination directory and copies the QMTest subdirectory there. This
subdirectory in fact makes it a test database for QMTest. It contains
some configuration files and our extension classes for QMTest. The COPY
command just copies test files around.

> In the test directory is a context file (context.txt).  Here are the
> contents of this file:
>
> ---
> temp_directory=c:/fbtest/temp/
> server_location=localhost/3040:
> database_location=c:/fbtest/temp/
> suite_database_location=c:/fbtest/fdb/
> backup_location=c:/fbtest/fbk/
> files_location=c:/fbtest/files/
> isc4_path="C:/Program Files/Firebird/Firebird_1_5/security.fdb"
> user_name=SYSDBA
> user_password=masterkey
> isql_path="C:/Program Files/Firebird/Firebird_1_5/bin/isql"
> gsec_path="C:/Program Files/Firebird/Firebird_1_5/bin/gsec"
> gstat_path="C:/Program Files/Firebird/Firebird_1_5/bin/gstat"
> gbak_path="C:/Program Files/Firebird/Firebird_1_5/bin/gbak"
> #nbackup_path="C:/Program Files/Firebird/Firebird_1_5/bin/nbackup"
> gfix_path="C:/Program Files/Firebird/Firebird_1_5/bin/gfix"
> gpre_path="C:/Program Files/Firebird/Firebird_1_5/bin/gpre"
> ---
>
> Does this look okay?  (I do have Firebird running on port 3040,
because
> Interbase is running on port 3050.  Also, I don't know if the values
for
> the paths need to have the double quotes around them, even though they
> have a space embedded in them.  What do you think?)

Paths with spaces doesn't need to be escaped / enclosed in double
quotes. I'm not sure now whether they can hurt or not, but it should
definitely work without them. The server_location is correct.

Important thing: The qadbm tool doesn't copies support files like
databases or backup files when you create a working test database! It
somehow makes sense as they're shared. So you should point your context
entries for suite_database_location, backup_location and files_location
to directories where they really reside (in your SVN repository
checkout).

> Also in the c:/fbtest/ directory is a .bat file with which I want to
run

> the GUI.  Here are its contents:
>
> ---
> cd..
> cd /fbtest
> qmtest.py gui -C context.txt
> ---
>
> When I double-click this file, a command window opens, then my browser
> (Mozilla Firefox) opens, it waits for a few seconds, then displays the
> "Page cannot be displayed" message.  The address in the browser's
> address line is:
>
> http://127.0.0.1:1330/test/dir
>
> It seems like I'm getting close, but still no success.  Any
suggestions?

Well, something went wrong half-way through QMTest initialization. The
best way to find out what's wrong is to run this bat file from command
prompt. Just open the new console window, switch to your test database
directory and run the bat file from there. QMTest will prints all
messages to console, and this way it wouldn't close on you.

best regards
Pavel Cisar
IBPhoenix

------------------------------------------------------------------------
-
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Firebird-test mailing list
Firebird-test@...
https://lists.sourceforge.net/lists/listinfo/firebird-test

-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Firebird-test mailing list
Firebird-test@...
https://lists.sourceforge.net/lists/listinfo/firebird-test

Re: Firebird testing tools for Windows

by Jeff Jones - SHERIFFX :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Hey!  I just tried this with Internet Explorer 7 and it worked!

Why would it not work with Mozilla Firefox?  Is there a setting I need
to check?  I would rather use Firefox...

Thanks!
 
Jeff
 

-----Original Message-----
From: firebird-test-bounces@...
[mailto:firebird-test-bounces@...] On Behalf Of Pavel
Cisar
Sent: Wednesday, March 19, 2008 01:10 PM
To: firebird-test@...
Subject: Re: [Firebird-test] Firebird testing tools for Windows

Jeff,

Jeff Jones - SHERIFFX napsal(a):
>
> Thank you very much for your assistance.  It has gotten me closer to
my
> goal (I think).
>
> However, I still am unable to successfully run the qmtest gui.  I will
> try to describe all that I have done.
>
> I have installed ActivePython, the PyWin32 extensions, wxPython
> (Unicode), KinterbasDB, QMTest, and the Subversion client.
>
> The /Python25/ and /Python25/scripts/ directories are both in the
PATH.

So far so good.

> I used qadbm to create my test database at c:/fbtest/, and it
> successfully copied the tests from your test suite.

Just to be sure, you did CREATE and then COPY, right? The qadbm.py tools
is very old (one from my first Python tools) and haven't very intuitive
interface (guess I'll rewrite it soon). The CREATE command creates the
destination directory and copies the QMTest subdirectory there. This
subdirectory in fact makes it a test database for QMTest. It contains
some configuration files and our extension classes for QMTest. The COPY
command just copies test files around.

> In the test directory is a context file (context.txt).  Here are the
> contents of this file:
>
> ---
> temp_directory=c:/fbtest/temp/
> server_location=localhost/3040:
> database_location=c:/fbtest/temp/
> suite_database_location=c:/fbtest/fdb/
> backup_location=c:/fbtest/fbk/
> files_location=c:/fbtest/files/
> isc4_path="C:/Program Files/Firebird/Firebird_1_5/security.fdb"
> user_name=SYSDBA
> user_password=masterkey
> isql_path="C:/Program Files/Firebird/Firebird_1_5/bin/isql"
> gsec_path="C:/Program Files/Firebird/Firebird_1_5/bin/gsec"
> gstat_path="C:/Program Files/Firebird/Firebird_1_5/bin/gstat"
> gbak_path="C:/Program Files/Firebird/Firebird_1_5/bin/gbak"
> #nbackup_path="C:/Program Files/Firebird/Firebird_1_5/bin/nbackup"
> gfix_path="C:/Program Files/Firebird/Firebird_1_5/bin/gfix"
> gpre_path="C:/Program Files/Firebird/Firebird_1_5/bin/gpre"
> ---
>
> Does this look okay?  (I do have Firebird running on port 3040,
because
> Interbase is running on port 3050.  Also, I don't know if the values
for
> the paths need to have the double quotes around them, even though they
> have a space embedded in them.  What do you think?)

Paths with spaces doesn't need to be escaped / enclosed in double
quotes. I'm not sure now whether they can hurt or not, but it should
definitely work without them. The server_location is correct.

Important thing: The qadbm tool doesn't copies support files like
databases or backup files when you create a working test database! It
somehow makes sense as they're shared. So you should point your context
entries for suite_database_location, backup_location and files_location
to directories where they really reside (in your SVN repository
checkout).

> Also in the c:/fbtest/ directory is a .bat file with which I want to
run

> the GUI.  Here are its contents:
>
> ---
> cd..
> cd /fbtest
> qmtest.py gui -C context.txt
> ---
>
> When I double-click this file, a command window opens, then my browser
> (Mozilla Firefox) opens, it waits for a few seconds, then displays the
> "Page cannot be displayed" message.  The address in the browser's
> address line is:
>
> http://127.0.0.1:1330/test/dir
>
> It seems like I'm getting close, but still no success.  Any
suggestions?

Well, something went wrong half-way through QMTest initialization. The
best way to find out what's wrong is to run this bat file from command
prompt. Just open the new console window, switch to your test database
directory and run the bat file from there. QMTest will prints all
messages to console, and this way it wouldn't close on you.

best regards
Pavel Cisar
IBPhoenix

------------------------------------------------------------------------
-
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Firebird-test mailing list
Firebird-test@...
https://lists.sourceforge.net/lists/listinfo/firebird-test

-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Firebird-test mailing list
Firebird-test@...
https://lists.sourceforge.net/lists/listinfo/firebird-test

Re: Firebird testing tools for Windows

by Pavel Cisar :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Jeff Jones - SHERIFFX napsal(a):
> Hey!  I just tried this with Internet Explorer 7 and it worked!
>
> Why would it not work with Mozilla Firefox?  Is there a setting I need
> to check?  I would rather use Firefox...

It works with Firefox for me (and always was). Maybe some FF plugin you
have installed? Or you have JavaScript disabled in FF?

best regards
Pavel Cisar
IBPhoenix

-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Firebird-test mailing list
Firebird-test@...
https://lists.sourceforge.net/lists/listinfo/firebird-test

Re: Firebird testing tools for Windows

by Jeff Jones - SHERIFFX :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

I checked the setup for Firefox and JavaScript is enabled, but this
still will not work.  It does work with IE 7, so I will just use that
for now.

Next problem:  I cannot get qmedit to run for me.  I tried running it
from a command window, and here are the results:

---
C:\fbtest>qmedit.py
Traceback (most recent call last):
  File "c:\SVNRepository\qmedit\qmedit.py", line 51, in <module>
    app = qmEditApp(False)
  File "C:\Python25\Lib\site-packages\wx-2.8-msw-unicode\wx\_core.py",
line 7936
, in __init__
    wx.App.__init__(self, redirect, filename, useBestVisual,
clearSigInt)
  File "C:\Python25\Lib\site-packages\wx-2.8-msw-unicode\wx\_core.py",
line 7836
, in __init__
    self._BootstrapApp()
  File "C:\Python25\Lib\site-packages\wx-2.8-msw-unicode\wx\_core.py",
line 7433
, in _BootstrapApp
    return _core_.PyApp__BootstrapApp(*args, **kwargs)
  File "c:\SVNRepository\qmedit\qmedit.py", line 38, in OnInit
    self.model = qmedit_model.qmDatabaseWrapper()
  File "C:\SVNRepository\qmedit\qmedit_model.py", line 59, in __init__
    self._setDatabase(databasePath)
  File "C:\SVNRepository\qmedit\qmedit_model.py", line 70, in
_setDatabase
 
self.testmap.setdefault(self.db.GetItem('test',t).GetArguments()['test_i
d'],
[]).append(t)
  File "C:\Python25\Lib\site-packages\qm\test\database.py", line 941, in
GetItem

    Database.SUITE : self.GetSuite } [kind] (item_id)
  File "C:\Python25\Lib\site-packages\qm\test\file_database.py", line
58, in Get
Test
    return self._GetTestFromPath(test_id, os.path.normpath(path))
  File "C:\Python25\Lib\site-packages\qm\test\classes\xml_database.py",
line 69,
 in _GetTestFromPath
    raise TestFileError, message
qm.test.classes.xml_database.TestFileError: A problem occurred while
loading the
 XML test file "functional.arno.indexes.lower_bound_asc_02_segments_01":
Exception '<type 'exceptions.ImportError'>' : 'No module named
kinterbasdb'

  File "C:\Python25\Lib\site-packages\qm\test\base.py", line 230, in
get_extensi
on_class_from_directory
    path + sys.path)

  File "C:\Python25\Lib\site-packages\qm\common.py", line 363, in
load_class
    module = load_module(module_name, search_path, load_path)

  File "C:\Python25\Lib\site-packages\qm\common.py", line 309, in
load_module
    module = imp.load_module(name, file, file_name, description)

  File "C:\fbtest\QMTest\fbqa.py", line 38, in <module>
    import sys, os, string, re, difflib, kinterbasdb as kdb, struct,
cgi, types


The "fbqa.FirebirdTest" extension class could not be loaded.

C:\fbtest>
---

Any ideas on why this is not working?

Your help has been very valuable to me.  I appreciate the time you have
taken.

Thanks!
 
Jeff
 

-----Original Message-----
From: firebird-test-bounces@...
[mailto:firebird-test-bounces@...] On Behalf Of Pavel
Cisar
Sent: Wednesday, March 19, 2008 02:41 PM
To: firebird-test@...
Subject: Re: [Firebird-test] Firebird testing tools for Windows

Jeff Jones - SHERIFFX napsal(a):
> Hey!  I just tried this with Internet Explorer 7 and it worked!
>
> Why would it not work with Mozilla Firefox?  Is there a setting I need
> to check?  I would rather use Firefox...

It works with Firefox for me (and always was). Maybe some FF plugin you
have installed? Or you have JavaScript disabled in FF?

best regards
Pavel Cisar
IBPhoenix

------------------------------------------------------------------------
-
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Firebird-test mailing list
Firebird-test@...
https://lists.sourceforge.net/lists/listinfo/firebird-test

-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Firebird-test mailing list
Firebird-test@...
https://lists.sourceforge.net/lists/listinfo/firebird-test

Re: Firebird testing tools for Windows

by Jeff Jones - SHERIFFX :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Okay, now I feel silly!

I thought I had KinterbasDB installed, but it turns out that I did not.
When that is installed, qmedit works much better!

Again, thank you, Pavel, for your assistance.

Jeff
 
-----Original Message-----
From: firebird-test-bounces@...
[mailto:firebird-test-bounces@...] On Behalf Of Pavel
Cisar
Sent: Wednesday, March 19, 2008 02:41 PM
To: firebird-test@...
Subject: Re: [Firebird-test] Firebird testing tools for Windows

Jeff Jones - SHERIFFX napsal(a):
> Hey!  I just tried this with Internet Explorer 7 and it worked!
>
> Why would it not work with Mozilla Firefox?  Is there a setting I need
> to check?  I would rather use Firefox...

It works with Firefox for me (and always was). Maybe some FF plugin you
have installed? Or you have JavaScript disabled in FF?

best regards
Pavel Cisar
IBPhoenix

------------------------------------------------------------------------
-
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Firebird-test mailing list
Firebird-test@...
https://lists.sourceforge.net/lists/listinfo/firebird-test

-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Firebird-test mailing list
Firebird-test@...
https://lists.sourceforge.net/lists/listinfo/firebird-test

Re: Firebird testing tools for Windows

by Pavel Cisar :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Jeff,

Jeff Jones - SHERIFFX napsal(a):
>
> I thought I had KinterbasDB installed, but it turns out that I did not.
> When that is installed, qmedit works much better!
>
> Again, thank you, Pavel, for your assistance.

You are welcome. You'll probably find out that qmedit (and other tools
like qareport as well) is a little bit crude tool. It was developed to
satisfy our specific needs and support our QA process (like test naming
convention, test versioning etc.), and may not fit well to your specific
needs. However, it doesn't mean we're not interested to develop it
beyond that. In fact, we would be more than happy if it would outgrow
our QA sandbox and become generally usable tool set for Firebird. We
just haven't the incentive to do so yet (you're the first one from
outside the project who seriously considers to use this tool chain). So,
feel free to give us feedback on usability of these tools, or even
better, you can cooperate with us to improve or extend them or just send
us patches.

best regards
Pavel Cisar
IBPhoenix

-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Firebird-test mailing list
Firebird-test@...
https://lists.sourceforge.net/lists/listinfo/firebird-test