r/javaexamples

free tutorial:

Hey guys, I made a for generating data on RDB for unit tests.

As an alternative of , Foxglove would try to generate data of columns automatically.

If you got some tedious or error-prone feeling when authoring INSERT INTO .. for unit tests on RDB, please check out this library.

Example:

import javax.sql.DataSource;

import guru.mikelue.foxglove.jdbc.JdbcTableFacet;
import guru.mikelue.foxglove.jdbc.JdbcDataGenerator;

// Generates 4 rows with "cr_brand "fixed to "Toyota" and
// 4 different values on "cr_model"
var facet = JdbcTableFacet.builder(TABLE_CAR)
    .numberOfRows(4)
    .column("cr_brand")
        .fixed("Toyota")
    .column("cr_model")
        .roundRobin("Corolla", "Camry", "RAV4", "Prius")
    .build();

new JdbcDataGenerator(getDataSource())
    .generate(facet);