How to use org.javers.repository.sql.session

synchronized long nextValue(Session session) {
  if (recalculationNeeded()) {
    long currentSequenceValue = session.executeQueryForLong(
        new Select("SELECT next from seq "+ sequenceName,
        sequenceGenerator.nextFromSequenceAsSelect(sequenceName)));
    recalculate(currentSequenceValue);
  }
  return nextLocalValue();
}

public SessionFactory(DialectName dialectName, ConnectionProvider connectionProvider) {
  this.dialect = Dialects.fromName(dialectName);
  this.connectionProvider = connectionProvider;
  this.keyGenerator = dialect.getKeyGeneratorDefinition().createKeyGenerator();
}

  @Override
  void limit(SelectBuilder query, long limit, long offset) {
    if (limit == 0){
      return;
    }
    // if (offset == 0) {
    // query.wrap("select TOP "+limit.getLimit()+" * from (",") a");
    query.append("OFFSET ? ROWS FETCH NEXT ? ROWS ONLY", longParam(offset), longParam(limit));
  }
}

@Override
public long getKeyFromLastInsert(Session session) {
  return session.executeQueryForLong(new Select("last autoincrementDefinition id", autoincrementDefinition.lastInsertedAutoincrement()));
}

public Optional<BigDecimal> queryForOptionalBigDecimal(String queryName) {
  queryName(queryName);
  return session.executeQueryForOptionalBigDecimal(build());
}

public long queryForLong(String queryName) {
  queryName(queryName);
  return session.executeQueryForLong(build());
}

  public void execute() {
    session.executeInsert(getQueryName(), getParameters(), tableName, primaryKeyFieldName, sequenceName);
  }
}

Optional<BigDecimal> executeQueryForOptionalBigDecimal(Select select) {
  PreparedStatementExecutor executor = getOrCreatePreparedStatement(select);
  return executor.executeQueryForOptionalBigDecimal(select);
}

void addVoOwnerEntityFilter(String ownerTypeName, String fragment) {
  selectBuilder.and("o." + GLOBAL_ID_TYPE_NAME + " = ?", Parameter.stringParam(ownerTypeName))
         .and("g." + GLOBAL_ID_FRAGMENT + " = ?", Parameter.stringParam(fragment));
}

public SelectBuilder limit(int limit, int offset) {
  session.getDialect().limit(this, limit, offset);
  return this;
}

  public <T> List<T> executeQuery(ObjectMapper<T> objectMapper) {
    return session.executeQuery(build(), objectMapper);
  }
}

long executeQueryForLong(Select select) {
  PreparedStatementExecutor executor = getOrCreatePreparedStatement(select);
  return executor.executeQueryForLong(select);
}

private void execute(Insert insertQuery) {
  PreparedStatementExecutor executor = getOrCreatePreparedStatement(insertQuery);
  executor.execute(insertQuery);
}

<T> List<T> executeQuery(Select select, ObjectMapper<T> objectMapper) {
  PreparedStatementExecutor executor = getOrCreatePreparedStatement(select);
  return executor.executeQuery(select, objectMapper);
}

Optional<Long> executeQueryForOptionalLong(Select select) {
  PreparedStatementExecutor executor = getOrCreatePreparedStatement(select);
  return executor.executeQueryForOptionalLong(select);
}

synchronized long nextValue(Session session) {
  if (recalculationNeeded()) {
    long currentSequenceValue = session.executeQueryForLong(
        new Select("SELECT next from seq "+ sequenceName,
        sequenceGenerator.nextFromSequenceAsSelect(sequenceName)));
    recalculate(currentSequenceValue);
  }
  return nextLocalValue();
}

public SessionFactory(DialectName dialectName, ConnectionProvider connectionProvider) {
  this.dialect = Dialects.fromName(dialectName);
  this.connectionProvider = connectionProvider;
  this.keyGenerator = dialect.getKeyGeneratorDefinition().createKeyGenerator();
}

@Override
public long getKeyFromLastInsert(Session session) {
  return session.executeQueryForLong(new Select("last autoincrementDefinition id", autoincrementDefinition.lastInsertedAutoincrement()));
}

  @Override
  void limit(SelectBuilder query, long limit, long offset) {
    if (limit == 0){
      return;
    }
    // if (offset == 0) {
    // query.wrap("select TOP "+limit.getLimit()+" * from (",") a");
    query.append("OFFSET ? ROWS FETCH NEXT ? ROWS ONLY", longParam(offset), longParam(limit));
  }
}

  void limit(SelectBuilder query, long limit, long offset) {
    query.append("LIMIT ? OFFSET ?", longParam(limit), longParam(offset));
  }
}