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.
48
questions
15
votes
4
answers
19k
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 ...
- 151
11
votes
5
answers
4k
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 ...
- 213
9
votes
4
answers
17k
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 ...
- 2,637
6
votes
3
answers
7k
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 ...
- 190
6
votes
8
answers
9k
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 ...
6
votes
2
answers
236
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 ...
- 11.4k
6
votes
1
answer
2k
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 ...
- 61
5
votes
2
answers
6k
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!
- 91
5
votes
2
answers
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
- 211
5
votes
2
answers
3k
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 ...
- 79
4
votes
3
answers
735
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 ...
- 41
3
votes
4
answers
2k
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.
- 41
3
votes
2
answers
1k
views
Should I store my test results in a database or google docs?
I'm currently trying to decide what is the better place to store my test results; database (sql/nosql) or in a spreadsheet placed in google docs.
I have the impression that storing it into a database ...
- 130
3
votes
1
answer
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 ...
- 163
3
votes
1
answer
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 ...
- 1,412
2
votes
1
answer
2k
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 ...
- 32.5k
2
votes
2
answers
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 ...
- 171
2
votes
1
answer
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 ...
- 510
2
votes
1
answer
82
views
How to test Oracle DB?
I have to test using SQL in Oracle if the data stored in the DB is completely correct or not. For example, make sure we are up to date, no future dates, no invalid characters on varchar columns, etc.
...
- 21
1
vote
1
answer
2k
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?
- 111
1
vote
3
answers
657
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.
...
- 176
1
vote
2
answers
13k
views
Cannot load JDBC driver class 'oracle.jdbc.OracleDriver' in JMeter
I have the problem with running a script in JMeter.
I get the following error message
Cannot load JDBC driver class 'oracle.jdbc.OracleDriver'
Does anyone know how to solve it?
1
vote
3
answers
954
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 ...
- 109
1
vote
2
answers
222
views
how to send the DB fetched values to frontend using selenium?
I wrote a program where values are coming from sql database.Now i want to send those values to frontend using selenium.
say it is an pincode i fetched from Database but now if locate the element where ...
- 37
1
vote
2
answers
1k
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 ...
- 567
1
vote
2
answers
94
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 ...
- 934
1
vote
1
answer
892
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) ...
- 87
1
vote
1
answer
83
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 ...
- 81
1
vote
1
answer
113
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
...
- 81
1
vote
1
answer
234
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 ...
- 163
1
vote
1
answer
391
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 ...
- 225
1
vote
1
answer
475
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
- 567
1
vote
1
answer
42
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'] . '-' ...
- 11
1
vote
0
answers
57
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 compatibility between Quality center 9.2 and Microsoft SQL Server 2005 Service ...
0
votes
1
answer
138
views
Running sql query via automation tests in Visual studio vs SQL server management studio returns different results
I am running some database automation tests in C#.The results of the same sql query are different in visual studio(executed via automation tests) and SQ Server Management studio(Manually).The ...
- 97
0
votes
2
answers
4k
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 ...
0
votes
2
answers
68
views
Testing GET API interactions with Oracle
We have some GET APIs written in Python which fetches some data from Oracle i.e. there are some SQLs written in Python APIs through which it fetches the data from Oracle. This is not consumed by an ...
- 185
0
votes
1
answer
164
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 ...
- 567
0
votes
1
answer
172
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 ...
- 165
0
votes
1
answer
104
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 ?
- 160
0
votes
1
answer
21
views
jmeter testing mysql and neo4j - neo4j gives me 0 latency and load time comparable to on database execution, but for mysql latency is as big as load
I am testing neo4j and mysql with queries that I want to compare later by latency and sample time considering jmeter as imitation of some web service. I am doing tests for 10000,100000,1000000 rows in ...
0
votes
1
answer
229
views
Validate Data completeness
Currently all database data is migrated from SQL/Oracle to snowflake( i.e. Extraction and Load only), basically a replica of Data so that later we can modify the data and Power Bi can fetch from ...
- 103
0
votes
1
answer
763
views
JDBC connection to databricks server is failing in JMeter
I have working JDBC connection to data bricks server in Java code.
I'm trying to make similar connection in my JMeter project (tried with apache-jmeter-5.3 and apache-jmeter-5.4.3) using same ...
0
votes
0
answers
242
views
How can I integrate database validation (queries, updates) in Ruby, Cucumber, Watir project in RubyMine
I have setup a project in RubyMine using Ruby with Cucumber, RSPEC, and Watir for UI automation of feature files. (I also have page objects implemented). In my step_definitions where the actual UI ...
- 1
0
votes
2
answers
417
views
How do you store test data into nosql document database for quick read?
I am currently migrating our currently test data that is stored in excel files to a database. Because the type of data in the test results are going to grow we decided to go with nosql instead of sql.
...
- 130
0
votes
2
answers
736
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
1
answer
46
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
votes
1
answer
1k
views
How to connect with Mysql db using Cypress 12?
I want to connect to Mysql DB in the server to delete several records. I have tried using some of the tutorials and answers available. Since all of them are regarding older versions of Cypress, I can'...
- 1,197