Questions tagged [database-testing]

84 questions
1
vote
2 answers

DbUnit: how to assert generated IDs

I need an idea/tip how to use DbUnit to assert IDs, generated by a database (e.g. MySQL's auto increment column). I have very simple case, which yet, at the moment, I find problematic: 2 tables: main and related. main.id column is an auto-increment.…
Laimoncijus
  • 8,615
  • 10
  • 58
  • 81
1
vote
1 answer

phpunit database test after teardown

I want to execute several tests in a testcase / testsuite (via selenium) and hook a database test onto the end of every tearDown (with assert which can't be called in tearDown). So the workflow would be: Setup the Connection to the database and the…
0
votes
1 answer

Automatic Database Filler : ORM, Performance, ... testing purposes

I'm interested in software tool, which can fill up my database based on parameters with some random data. Doesn't matter if it is something based on desktop application, online tool What it should fulfill: Filling models based on HABTM, hasMany,…
Marek Sebera
  • 39,650
  • 37
  • 158
  • 244
0
votes
1 answer

VS2010 - DB unit tests for load testing

I've got problems with unit tests for load tests in VS2010 Ulimate. What I'd like to do is to test performance for Add and Remove (to/from DB) methods. AddCompany method returns added company, than I'd like to put it into a collection (arraylist)…
0
votes
0 answers

DB Procedure Test Aumation

I am from a JAVA background I have a requirement for a automated Testing Process or Framework that can be used to verify our stored procedures and functions in Aurora DB compatible with Mysql. We have Cypress which we use to automate in UI side of…
0
votes
0 answers

Database testing tool for AWS RDS proxy

I'm trying to use some automated database testing tool to run tests against RDS proxy, which is connected to an RDS database. I wonder if there is automated database testing tool that would be suitable for running tests against RDS proxy. Thank you…
0
votes
0 answers

Sequelize call thorws error in JEST test, how to make sequelize call in jest?

I want to test a controller which adds a record in the database, but I notice that even a select query throws an error, however when I add the record through my program, it is saved in the database. For example only this query does not return…
FaFa
  • 358
  • 2
  • 16
0
votes
0 answers

Which is the well-suited framework to perform Api testing along with database testing in automation?

As per the client's requirement, I need to perform automation testing on API and database with selenium web driver using java and also need to verify the API response with DB data. So which framework will be well-suited to perform the automation…
0
votes
0 answers

Is there a possibility of unit testing database functions using cmocka?

I am trying to make some unit tests for database functions in C language, but i am not aware is it possible with cmocka? I couldn't find any example on the internet for database testing using cmocka, so i wonder if someone has an example of testing…
jst
  • 1
  • 1
0
votes
1 answer

How to test file import timing scenario in JMeter

I came across one scenario to test in JMeter. There are multiple text files with multiple line data and need to import those in web application. I need to know How much time taken by every line and file to import in my application. Performance…
0
votes
1 answer

JMeter Unable to connect AWS RDS getting error java.sql.SQLException: Cannot create PoolableConnectionFactory (Communications link failure

I have to connect my JMeter script to AWS RDS database. When I am running my test with the below JDBC Connection configuration it is showing this error message: java.sql.SQLException: Cannot create PoolableConnectionFactory (Communications link…
0
votes
1 answer

How to define belongsTo relationship in Laravel factory?

I have a Post, User and Country model. A Post belongsTo as User . A User belongsTo a Country. Is there any way to call the User and Country factory from after the post factory ? Sort of like factory(Post::class,10) ->create() …
Aryan Ahmed Anik
  • 466
  • 1
  • 9
  • 23
0
votes
1 answer

Java Spring Boot Testing with MySQL Database

My tests for this CRUD operation in Spring Boot continue to fail where I get "java.util.NoSuchElementException: No Value Present" I understand that testCreateDemographic is creating a record, however, testFindDemographicsById is not able to find the…
coder3
  • 357
  • 1
  • 3
  • 14
0
votes
1 answer

Database-rider. Exclude columns from the specific table

My expected dataset contains several tables. Is it possible to exclude columns from the specific table?
0
votes
1 answer

FAILED: dbconnection com.microsoft.sqlserver.jdbc.SQLServerException: Could not find stored procedure while executing SQL query through Selenium

I have made the sql connection , and fetching the query from excel sheet. and after establishing db cooncetion, calling: result rs= st.executeQuery(query) statement is showing error as couldnot find storedprocedure.…