private void updateInsert(PreparedStatement insert, String id,
                                  String status,
                                  Timestamp timestamp) throws SQLException {
            //there has to be a more efficient way than this
            for (int i = 0; i < reportVariables.size(); i++) {
                String name = reportVariables.get(i);
                if (name.equals("timestamp")) {
                    insert.setTimestamp(i + 1, timestamp);
                } else if (name.equals("id")) {
                    insert.setString(i + 1, id);
                } else if (name.equals("status")) {
                    insert.setString(i + 1, status);
                } else {
                    throw new IllegalArgumentException("I expected one of (id, status, timestamp)" +
                            ", but I got: " + name);
                }
            }

        }
This sql will be called immediately after the connection is made. This was
initially added for setting pragmas on sqlite3, but may be used for other
connection configuration in other dbs. Note: This is called before the table is
created if it needs to be created.

@param postConnection
tika-pipes/tika-pipes-reporters/tika-pipes-reporter-jdbc/src/main/java/org/apache/tika/pipes/reporters/jdbc/JDBCPipesReporter.java