jhall68w
Contributor
Joined 9 years ago
User Profile
User Widgets
Contributions
Verifying on screen contents by comparing DB to UI
We have 4 different environments, with each environment having multiple databases. Each database could/will have different data, but all in the same structure What I am trying to do is find a way (no matter what environment/database) I am using that when I am verifying the UI contents, I can directly test that against the database to make sure the tables are populating correctly. Verifying single values has not been an issue, but verifying a complete table has become difficult as I am not looking at the same database each test. A SQL table example could be like this, and this is what I want to verify is against what is displaying on the UI. Item Abbreviation Count item1 IT1 23 Item2 IT2 11 Item3 IT3 31 I am not sure if I can use the Stores>DB Tables as it does not seem those can by dynamic, so I am stuck in 1 environment and 1 database. I am also not sure if I can create a new DB Table project variable that can store the query results in a format that I can compare either. Instead of recreating the wheel, I am looking for insight on if, and what others have found to be the best way to go about this. Below is an example of what I am doing for a Single value. function GetItemCount() { var Qry; Qry = ADO.CreateADOQuery(); Qry.ConnectionString = "my connection string" Qry.SQL = "SQL Count(*) Statement" Qry.Open(); Qry.First(); Project.Variables.Item_Total = Qry.FieldByName("Count").value; Log.Message('Current Item count is ' + Qry.FieldByName("Count").value); Qry.Close(); }Solved1.2KViews0likes2CommentsRe: Working from home? How is it?
I work remotely full time, but occassionaly I work in the office (maybe 1 or 2 days a couple times a year). What would take me 8 hours to complete in the office, I can usually complete in 5 hours when at home. So long story short I can complete a lot more now than I could when I worked in the office. When I am in the office there is so much side bar conversations or interruptions. When working remotely, I start the day with work that I know needs to be done and I can just work. No interruptions. Now with this COVID-19 and schools being closed, my first grader is now home with me. I am not sure what we would of done if both my wife and I had to be in the office. There are many forms of communication I use with the rest of the team that I am on, so talking to each other is never an issue. My wife and I have an understanding that I will not do any house work during my working hours, unless it is over my lunch. I work and treat the day just as I am in the office.2.2KViews1like4CommentsEdge v80 is not being recognized when I attempt to execute tests
TC : 14.30.3743.7 x64 Edge version: v80.0.361.69 Windows 10 Enterprise v1803 I followed the steps from here: https://support.smartbear.com/testcomplete/docs/app-testing/web/general/preparing-browsers/edge.html I have made sure that all settings are set as described in the above article. My experience so far is I can run Edge, but onceit is running it is no longer recognized by TestComplete. I am getting a Waiting for Sys.Browser("edge") message, and shortly after it fails. The log shows Unable to find the object Sys.Browser("edge"). See Details for additional information. The only thing in details is The object with the specified attributes does not exist. I am using keywords test. Under the Possible Issues With Web Testing , I found the below script and attempted to run that when I started my test. That did not work either. It could never close Edge, but all other browsers worked. var edgeBrowser = Sys.WaitBrowser("Edge"); if (edgeBrowser.Exists) edgeBrowser.Close(); I have also attempted to Object Spy in Edge, and that does not work either. Has anyone else ran into this same issue, or have a solution?Solved1.8KViews0likes4CommentsRe: When I attempt to use Postman from my TestedApps it does not recognize any objects, only uses XY
The last thing that was causing issues was this part of the script: (straight from TC documentation) // Create an XMLHTTP object for sending the SOAP request XmlHttpRequest = getActiveXObject("MSXML2.XMLHTTP.3.0"); We just needed to update it to: XmlHttpRequest = getActiveXObject("MSXML2.XMLHTTP"); We also removed the array information as that portion was not necessary for our request. And the last thing was not using the "code" generated from the web services screen (modified to false values): function Transaction() { var Result; var TypeFactory; //Get the type factory for the web service TypeFactory = WebServices.QA.TypeFactory; Result = TypeFactory.Transaction; //Result.item1 = ; //Result.item2 = ; return Result; } to RequestObj.item1 RequestObj.item2968Views0likes1CommentRe: When I attempt to use Postman from my TestedApps it does not recognize any objects, only uses XY
That is the scripted response from SB. And no, it does not work. I sent the XML that we are using, and even sent the javascript (using their template with our values) to them and it is still failing. I requested to do a screen share to show them what we are attempting to perform, hoping to help speed up a resolution but were denied. They stated that it would be to vast of a subject to discuss over call/webshare.2KViews0likes2CommentsRe: When I attempt to use Postman from my TestedApps it does not recognize any objects, only uses XY
I have, and SoapUI works. It is marketed that TestComplete can perform this without SoapUI, but our QA team and help of development we have not been successful. And I continue to get scripted responses from SB that say to look at the documentation which we have basically memorized at this point. We are now attempting to pass parameters and/or variable values from TestComplete to SoapUI.2KViews0likes4Comments