TCI - SQL Test Case Inserter

Owned by Kyle Erickson (Unlicensed)
Last updated: Jul 13, 2022 by Adam Paczuski (Unlicensed)
1 min read

The SQL Test Case Inserter (TCI) is a Java-based program that runs from the command line. It allows you to insert complex patient records into instances of SQL Server, Oracle, and Postgres without any SQL knowledge while guaranteeing all patient records match across all database platforms. The TCI was designed and developed to support the testing of PCORnet Menu-Driven Queries within PopMedNet, but it may be used with any data model to test any machine-generated, or human-written, SQL queries. Additionally, it can be used to in conjunction with other tools to create large databases in any of the three supported database platforms.

The TCI is free, open-source, and can be downloaded from the Test Case Inserter Program link below. The source-code and other information can be downloaded from our GitHub, here: https://github.com/PopMedNet-Team/Test-Case-Inserter .