Question : I am looking to introduce a test driven design style to writing my stored procedures for a postgresql […]
Tag: unit-test
truncate table in mysql 8.0 is slower than older version
Question : I have few hundreds of tests which use mysql. I was using Mysql 5.7 (percona) and I changed […]
Automated testing of SQL scripts
Question : I’d like to run some simple tests on SQL scripts in CI to just ensure the scripts are […]
EXPORT specific columns to INSERT statements
Question : Is there a way to export specific columns and a fixed number of rows from a table to […]
Sql Server Stored Procs vs Linq with C# and unit testing
Question : I’m going to run into a situation where I am, where the stored proc vs Linq is going […]
Are SQL unit tests supposed to be so long?
Question : I am writing stored procedures with some non-trivial business logic. I am trying to unit test them, but […]
How can I fake inet_client_addr() for unit tests in PostgreSQL?
Question : I have a simple stored procedure whose return value depends on the value of inet_client_addr(). How can I […]
What circumstances could a SQL DateTime column hold an invalid date?
Question : I have been asked to write a series of tests within SQL. Many of them are to test […]
Can PostgreSQL support integration test with some kind of throwaway overlay?
Question : It’s a common problem to write integration tests that include a database. If the test changes the database […]
Is there any way to clear all tables using Liquibase?
Question : I’m currently using Liquibase for creating test data in my database before each test run. I came across […]