{"repo":"quick-perf/quick-sql-test-data","free":true,"listed":false,"github":"https://github.com/quick-perf/quick-sql-test-data","clone":"git clone https://github.com/quick-perf/quick-sql-test-data.git","description":"Quickly create your SQL test data","language":"Java","stars":16,"topics":["sql","testing","test","database","java","postgresql","mariadb","mysql","mssql","h2"],"license":"Apache-2.0","category":"databases-storage","readme_excerpt":"Quick SQL test data         Why use Quick SQL test data ? Writing datasets with SQL may be tedious and time-consuming because of database integrity constraints. This Java library aims to ease the generation of datasets to test SQL queries. It produces INSERT statements taking account of integrity constraints. The library automatically: identifies NOT NULL columns and provides values by requesting the database adds rows of dependent tables in case of foreign key constraints sorts insert statements to accommodate foreign key constraints sorts insert statements following primary key values Another project provides a web page to ease the use of the Quick SQL test data library. Why use this library and not AI? - Correctness (real database constraints managed) - Deterministic (never hallucinates) - Faster than AI - No token costs - No data leakage (data stay local) How to use the library With Maven, you have to add the following dependency: You can generate the insert statements with the help of an instance of org.qstd.QuickSqlTestData class. Quick SQL test data works with: PostgreSQL Oracle MariaDB MySQL Microsoft SQL Server H2 HSQLDB Use cases This library can be helpful in the two following situations. Create a dataset before starting the writing of an SQL query This case happens when you develop SQL queries with Test-Driven Development (TDD). You can read below an example where we define a dataset row for which we generate the INSERT statement: The cons","default_branch":null,"files":null,"tree":[],"storefront":"/r/quick-perf","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/quick-perf/quick-sql-test-data/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}