Tag Info

Hot answers tagged

9

For the most part, I've gotten by with running simple SELECT queries with various WHERE filters. With my current position, though, I'm finding that adding more complex JOINs are necessary to really get what I need out of the database. I think you are answering your own question here. Basically - "it depends". Sometimes the position requires just a ...


7

Ideally I would like to write the test based on a file that approximates what my script would be actually processing, rather a much much smaller sample size. If it were me, I would test functional correctness and scale independently. Fault isolation is easier that way. Your code/test/debug cycle can go more quickly too. The thinking here is that ...


3

I have found value from testing date time issues at all layers of an application. Which layer is determined by what I am trying to test. For instance: Testing Functional Logic: Assuming for a second that you don't have core logic built into your UI code (Model View Separation or something similar). It is often easier to test the core logic layer by ...


3

This is really less of an SQA question, and more about "how to I use web site analytics"? You can search for "website analytics" to learn more. And this might help: http://analytics.blogspot.com/


3

Proficiency in SQL is just a start, there is something more that just being competent with the SQL syntax: Select, From, Join, Where, Order by, etc. A good Software tester in a job requiring DB skills needs to be willing to learn from the Developers and DBAs in the shop. The tester should want to refine and improve their DB data mining skill continuously. ...


3

If I am looking for a tester for either a database or for a heavily data driven application then the stronger they are with SQL the better. I think not only should they be comfortable with writing queries including JOINS, UNIONS etc, but they need to have a good understanding of what some of the different performance implications are around inserts and ...


2

If you work in a company using intensively with SQL databases, like in enterprise systems or online shops, you will very likely need at least basic skills in SQL, at least to create some test data in the database, to check results and so on. At least some DML knowledge, SELECT, INSERT, UPDATE, DELETE, will come handy sooner or later. But keep in mind it's ...


2

There are lots of ways to do this; some of the data points I have used in the past are: Build breakage: is the automated build compilation/test failure rate going up or down? Assuming an Agile development model, are the user stories complete and have they been reviewed by QA + stakeholders Has the code freeze been effective? Are developers still checking ...


2

using your favorite script language would probably be the best solution, Peter suggested Perl and I'll add Python to the list, both have excellent modules to parse and analyze CSVs and XMLs and a lot of capabilities to help you in your tasks.


1

Instead of testing with csv / xml level. You can load the data into a database and run queries and obtain accurate results Create a Results DB with Run_Id (ex-ResultMMDDYYY_1) Load the source and destination data into the DB Run Queries for each source / destination tables and create a results table Fetch the data from results table and publish results You ...


1

[Disclaimer: This product is created by my company] We have a product call QuerySurge that allows you to fully compare data in the source tables with the data loaded into the data warehouse. Compared to other approaches, this seems to be the best automated method for validation.


1

There are a few different solutions off the top of my head. There are several proxies that others have already mentioned that have APIs that can be made to listen on whatever port you need. They may not get granular enough though for what you need. If I were looking in this area I'd maybe take a look at Python's socket module.: ...


1

I know that it is doable, one of my previous employers integrated Wireshark (Ethereal then) analysis into its VoIP automation, using Perl AFAIK. I did some hacks by grepping on tcpdump and a filter, catching a packet or event I was looking for.


1

You might want to take a look at Fiddler


1

I assume for the purposes of your question you are not concerned about testing anything upstream from the JMS queue. You may want to check whether the values in the XML are consistent with any constraints in the databases, e.g. uniqueness or maximum length. Depending on your circumstances, you may also want to test what happens when the values are not ...


1

I don't think that there can be such a concept as an "acceptable" defect arrival rate, in the sense of a target number as you typically want to discover them as fast as possible. So, in english, you want to find as many bugs as you can. The key way to read that metric is that you want a consistent arrival rate over time, i.e. you want the defect arrival ...



Only top voted, non community-wiki answers of a minimum length are eligible