// The first recorder, in record mode, creates "foo.iq".
ConnectionFactory postgres;
Config config = Config.empty()
  .withFile("foo.iq")
  .withMode(RECORD)
  .withConnectionFactory(postgres);
Recorder recorder = Recorder.create(config);
recorder.executeQuery("select count(*) from emp", "empCount", result -> {
    assertThat(result.getMetaData().getColumnCount(), is(1));
    assertThat(result.next(), is(true));
    assertThat(result.getInt(1), is(13));
  });
recorder.close();

// The second recorder, in play mode, reads "foo.iq" created by the first step.
Config config2 = Config.empty()
  .withFile("foo.iq")
  .withMode(PLAY);
Recorder recorder2 = Recorder.create(config);
recorder.executeQuery("select count(*) from emp", result -> {
    assertThat(result.getMetaData().getColumnCount(), is(1));
    assertThat(result.next(), is(true));
    assertThat(result.getInt(1), is(13));
  });
recorder2.close();

!use "postgres"

# empCount
select count(*) as c from emp;
c:int
======
13
!ok