Win a copy of Functional Design and Architecture this week in the Functional programming forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Ron McLeod
  • Rob Spoor
  • Tim Cooke
  • Junilu Lacar
Sheriffs:
  • Henry Wong
  • Liutauras Vilda
  • Jeanne Boyarsky
Saloon Keepers:
  • Jesse Silverman
  • Tim Holloway
  • Stephan van Hulst
  • Tim Moores
  • Carey Brown
Bartenders:
  • Al Hobbs
  • Mikalai Zaikin
  • Piet Souris

How to validate error msgs for missing id's/names in 2 similar data tables stored in 2 different dbs

 
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator

I am testing two GUI applications. One is a new one and another is an old one. Both the application tables and data reside in tables in 2 different databases. I have to validate some exception errors. I tried in different ways and still not getting the error msgs. Any suggestions/Ideas in regards to this are appreciable. Below is the detailed explanation of my test scenarios.

I have to create orders in new application with filling the following mandatory fields like Order id, order name, Product id, product name, manufacture id, manufacture name, vendor id, vendor name etc. Once I start

creating a new order, the order id is auto populated and need to select the product id, product name etc which are in new app and also stored in the old app as well. Each product id is mapped to a product name,

manufacture id and name etc. while saving the order the new app confirms the above mapped information in old app and saves the order. if any of the information is not valid will get an invalid error message.The product table is one of the main table in both databases and consist of same information as the data flows between these 2 tables. Example - if the product table of new app have id's from 100 to 110, the old product table also have this information as well including all changes to these order id's i.e. order 108 might have 2 more additional records with all updates. I have to test 15 error messages related to above mentioned mandatory fields. For

example - one of the error message is the product id, product name, vendor id etc should exist in the new table if not an error message should be displayed. In order to get this error message I tried to delete a

record in the new table but got an integrity constraint error and same with the update as well.In order to see the product id number error text which includes order id, I have to create an order which also creates a record in both tables.In simple words how to get an error if a specific id exists in both tables and error will only be shown when the new/old tables does not have the specific id or name etc .

I hope I did not confuse by providing too detail explanation.
 
Bartender
Posts: 598
26
Oracle Notepad Linux
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Detail is always good when it is relevant to understand context. What i don;t understand though, is what you are asking. What is the issue exactly?
 
ravi nand
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Thanks for the response Brian. I thought I put too many details in the previous post. Basically, I am testing error messages as part of the new application functionality and trying to validate the below error messages.

"Check that the order id exist in the Order table. If does not exist, stop and give the following error message "invalid order id is sent"

"Check that the product id exist in the product table. If does not exist, stop and give the following error message "Invalid product id is sent".

I tried to test these using the following steps but was not able to generate the messages.

1. I tried to update/delete some of the product/order data in both these tables and when I tried this, got an integrity constraint error.
2. Tried to modify the product and order fields in the application with wrong values but was getting other error messages but not the above.

my question is in order to test the above messages what test data do I have to prepare or is there any other approach?

I am testing 2 product related interfaces(one is new and another is an existing one) containing the same product, order, manufacture data etc. For ex - If I create a product in new interface and once I save it, that product information will be available in existing interface as well. I mean data flows between these 2 interfaces.

I hope this gives some clarity !!!




 
Sheriff
Posts: 26765
82
Eclipse IDE Firefox Browser MySQL Database
  • Likes 1
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
But if you want to check whether some rows exist, you would normally just do a SELECT query and see if you get any records back. Doing an UPDATE or DELETE sounds like not a good idea to me; your results are actually good because you didn't modify the contents of the databases.
 
You showed up just in time for the waffles! And this tiny ad:
Building a Better World in your Backyard by Paul Wheaton and Shawn Klassen-Koop
https://coderanch.com/wiki/718759/books/Building-World-Backyard-Paul-Wheaton
reply
    Bookmark Topic Watch Topic
  • New Topic