Q: Designer, forms testing, automation

Malcolm Dew-Jones · *nix forums Guru Joined: 04 Mar 2005 Posts: 418

Oracle Designer 9i 9.0.4.5.6

I'm not too familiar with all the capabilities of Designer yet. I am
wondering if I should be looking for things in Designer that help to test
the forms that are generated. The Designer generated forms obviously
works as designed, but the question is whether the details of the design
produce forms that interact the way the user expects, and then whether the
form still works that way after making various changes.

Along the same line, if anyone has suggestions for the best way to
automate the testing of an Oracle .fmb/.fmx then I would appreciate
hearing about it.

Links to anything useful would also be appreciated.

Thanks.

psoug · *nix forums Guru Joined: 15 May 2005 Posts: 3492

Malcolm Dew-Jones wrote:

frank.van.bortel@gmail.co · *nix forums Guru Joined: 11 Sep 2005 Posts: 832

DA Morgan schreef:

Malcolm Dew-Jones · *nix forums Guru Joined: 04 Mar 2005 Posts: 418

Frank van Bortel (frank.van.bortel@gmail.com) wrote:
: DA Morgan schreef:
: >
: > I personally think of Designer as one of the worst places to build and
: > test forms.

: I will disagree with you on the builing part. Personally
: speaking, of course :)

There are lots of forms, they all work reliably relative to the
definitions of what's in each form, so Designer seems "good enough" for
all I care here.

And no, the user in this case doesn't get much say in whether a box is
mauve or not (suitably amused) - if a field is on the form, has the right
length, etc etc, then it's good enough for the user to be able to do their
job, that's all that counts here.

The data has lots of constraints on what is allowed and who can do what to
it, often depending on the values of the various fields. For example,
which details can be modified about an item might depend on the contract
with the facility that is storing the item, and what roles the user has,
and what time of day it is.

The code for that is all in designer as a series of constraints.
Designer copies it all into the various forms, all is well, but are the
correct rules then in the correct place in all the forms? and do the rules
all interact correctly?

It ought to be feasible to pull out all the code into a format that could
be tested in some kind of batch mode, and then have reams of test cases
that call the constraint code just like it would be called in the form, or
maybe create a routine in the form to push values into the fields and then
fire the triggers, or something. I will likely come up with that
something over time, but first I thought I'd check for what existed.

frank.van.bortel@gmail.co · *nix forums Guru Joined: 11 Sep 2005 Posts: 832

Malcolm Dew-Jones schreef:

Sybrand Bakker · *nix forums Guru Joined: 03 Apr 2005 Posts: 1766

On Mon, 26 Jun 2006 19:52:19 +0200, Frank van Bortel
<frank.van.bortel@gmail.com> wrote:

Google