Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [sql]

Structured Query Language (SQL) is a language for managing data in relational database management systems. This tag is for general SQL programming questions; it is not for Microsoft SQL Server, nor does it refer to specific dialects of SQL on its own.

0
votes
1answer
36 views

Selenium, data driven testing using NUnit and SQL queries.

I am developing a Selenium Test Automation Framework for the purpose of testing multiple websites. I have currently set up the Framework in Visual Studio using C# and implementing the Page Object ...
0
votes
2answers
107 views

Is there any way to validate sql data with cucumber feature file data?

I am using cucumber , Junit , Selenium Web driver and have JDBC connection I have a feature with below scenario Scenario Outline: Fill out the ATS Registration Form When Click on SignUp And ...
1
vote
1answer
194 views

What is Sql data conditioning?

This question was asked during QA interview. What is SQL data conditioning? Is it creating test data using SQL scripts to test different scenarios?
6
votes
2answers
75 views

Using a different database engine for testing

This was inspired by the Speeding up Django unit tests with SQLite, keepdb and /dev/shm article that demonstrates how switching from PostgreSQL to an in memory SQLite helps to speed up testing during ...
1
vote
1answer
182 views

Jmeter XML API Response and JDBC response value matching order

Jmeter XML API Response and JDBC response value matching order. Do you think this order is correct? (Xpath reference name is using in jdbc request) more details given below
1
vote
2answers
389 views

JMeter - Pass http response values to jdbc request without using xpath extractor?

I'm using JMeter and I need to get the value of <productid> from an Http API response (productid = 001)[see Http API response screenshot] and pass it to a jdbc request [see JDBC request ...
0
votes
1answer
86 views

How to use xpath referance name in JDBC Request SQL Query?

How to use xpath reference name in JDBC request?below configuration i have tested but its not working. Is there any way to get this xml value[prodcutid] in to SQL Query? Jmeter DB Request XPATH ...
1
vote
3answers
151 views

How much SQL knowledge is needed to learn Selenium? [closed]

I want to learn to use Selenium in my tests. Do I need to know how to use SQL in order to effectively use Selenium in my tests? And would you be able to advise what online resources are freely ...
0
votes
1answer
37 views

SQL how to seprate 2 words [closed]

INSERT INTO PartyTable (Name ,City ,Department ,Age ,Gender ,Transport ,Food ,Drink) VALUES ('Ido', 'Ramla', 'management', '17', 'M', NULL, NULL, 'Vodka' 'Water'); i need the vodka and water in same ...
1
vote
2answers
74 views

How can I return values for 2 columns in my database? [closed]

thanks for reading. My scenario (possibly not the best way of doing things, but im still learning) I have a sql database, which houses in 1 table test data (A string value) and a boolean (expected ...
0
votes
1answer
115 views

How to automatically test TSQL?

I am not a tester, but SQL Developer. Can you advise me about more propper (in your opinion) way to make automatic testing of TSQL. I use SQL 2008R2 and SQL2012. I see that there is only one or two ...
1
vote
1answer
324 views

getting an error in selenium using java with mySQL: java.sql.SQLException: No suitable driver found

package SeleWeb; import org.openqa.selenium.WebDriver; import org.openqa.selenium.firefox.FirefoxDriver; import java.sql.*; public class seldata { public static void main(String[] args) ...
3
votes
4answers
1k views

How much SQL knowledge do I need to learn Selenium Testing

I have just started learning Selenium. I'd like to know how much knowledge of SQL I should have in order to be able to learn Selenium.
1
vote
1answer
35 views

My Application is in Php, Using XAMPP SQL [closed]

SQL have one field i.e. Date My application's UI have three drop down Day Month Year I inserted its value using CONCAT $c3date= @trim(stripslashes($_POST['c3year']. '-' . $_POST['c3month'] . '-' ...
3
votes
1answer
4k views

How to test CRUD operations in Database Testing?

C: Create R: Retrieve U: Update D: Delete How can a tester verify that CRUD operations are working fine in Web App/Database testing? Please explain with real examples!
1
vote
1answer
60 views

Excel worksheets: summarize a bunch of sheets using indirect [closed]

Current scenario I'm a data tester, and I test insurance contracts, and each policy has many "roles", "features", "history items" etc. A standard SQL query with all data joined will return 20-30 rows ...
1
vote
1answer
85 views

SQL - data testing - Oracle 11g lookup tables

issue summary I need to use my client table to lookup name, address, etc my client table has 2 million rows, but only 167,000 unique clients, so I need to find the most current "max" entry for each ...
3
votes
1answer
513 views

Conversion failed when converting the varchar value to data type int

I am writing this query in HP ALM 11.52 and facing the error "Conversion failed when converting the varchar value 'userid' to data type int" Query is select * from Testcycl join Audit_Log on ...
4
votes
3answers
610 views

Need guidance on how to prepare for an SQA interview

I am scheduled for a technical interview with a company next Wednesday, they provide an electronic payment system for healthcare providers, healthcare clients, and healthcare payers. I am told by the ...
1
vote
0answers
39 views

HPQC 9.2 compatibility with Microsoft SQL Server 2005 Service Pack 4

Does Quality centre 9.2 support Microsoft SQL Server 2005 Service Pack 4. Hi Friends, Need your help in understanding comptability between Quality center 9.2 and Microsoft SQL Server 2005 Service ...
2
votes
1answer
3k views

Selenium webdriver java with jdbc

I am using selenium webdriver with Java jdbc. Below are my queries. First: I am trying to login to the application with username and password from database (Using SQL Query). I am getting the ...
0
votes
1answer
91 views

Need SQL Injection Document? [duplicate]

i am trying to study SQL Injection nowadays & i am searching for good tutorial . any recommendation for written or videos tutorial ?
1
vote
1answer
175 views

Pre-load database for testing

I'm a bit new to mocking data for testing. I'm using ruby in conjunction with watir-webdriver and I have a local version of the app. I'd like to run a script which empties the tables of the local ...
3
votes
1answer
5k views

Selenium WebDriver (Java) with database [closed]

I want to validate application output result with Database using selenium webdriver (Java). Please let me know how this can be achieved. Or could you please let me know how to use selenium webdriver ...
2
votes
1answer
1k views

Simulating realistic latency to a WAN SQL server

Context: Our desktop application communicates with a SQL server, some clients use a WAN connection to reach this SQL server. When they complain something is very slow we ask a list of ping times to ...
1
vote
3answers
404 views

Tool for verifying MySQL data matches source file

I'm looking for an automated way to test an API to ensure incoming data is stored correctly in a MySQL db. Starting with an empty db I send large amounts of XML to the API which populates the db. ...
9
votes
5answers
2k views

Is it necessary to verify databases for functional automation testing?

Currently, after every action that adds or changes data, we verify that that data was successfully added/changed in the database by querying the tables directly. I feel this is redundant because that ...
1
vote
1answer
286 views

Loading test data from MySQL database

I use Ruby with Selenium to do test automation on a web application that has a MySQL DB behind it. I need a good way to load data into the DB from a Ruby script. So far in my research I have found ...
13
votes
3answers
17k views

What does a Software QA Person Need to Know to Perform Their Job (Essentially)?

I'm doing everything I can to learn about Software QA and Software Testing. I've got a decent understanding of SQL and I'm applying that to MySql as that seems to be the most popular. I understand ...
2
votes
2answers
5k views

Find the bugs related to test a run in Quality Center via database query

I'm able to query a HPQC database to retrieve execution information from the TEST and STEP tables. I'm also able to query for defect information from the BUG tab. But, I'm struggling to find a way ...
6
votes
3answers
5k views

MS-SQL server sql test automation

I'm looking to create a batch of automated tests in SQL on MS-SQL server, these will include tests like - insert some records, call stored procedure, check certain conditions in various tables. There ...
5
votes
6answers
5k views

Comparing Sqlite databases

I would like to compare Sqlite databases with each other, both schema and data. I know that a rather crude method exists by comparing the database dumps with each other. But are ther any other methods ...
3
votes
1answer
1k views

How to test an Excel macro that selects, groups, and counts data using SQL query?

This is the first time I encountered such a problem. There is an Excel table with a macro that selects data from the database using SQL query according to specific criteria. Data is grouped in ...
5
votes
2answers
2k views

What resources will help me understand the data model for QC 10.0 in order to write my SQL queries?

I am a fresher in Quality Center 10.0 HP software testing tool. As per my understanding in order to generate reports from QC and to troubleshoot the scenarios, we need to write SQL queries in the QC ...
4
votes
2answers
2k views

Data warehouse testing checklist

What are some best practice approaches such as: SCD type 1/2/3 nulls duplicates missing data extra data special characters FK/PK referential integrity.etc
8
votes
4answers
16k views

What proficiency should a software tester have in SQL?

Both in my current job and in my previous job, there are a number of areas of the application to test that require mining data from a relational database, specifically Microsoft SQL Server of various ...