@@ -0,0 +1,1279 @@
+package org.sfm.benchmark.db.jooq;%0A%0Aimport java.sql.SQLException;%0Aimport java.util.List;%0A%0Aimport org.jooq.DSLContext;%0Aimport org.jooq.impl.DSL;%0Aimport org.openjdk.jmh.annotations.Benchmark;%0Aimport org.openjdk.jmh.annotations.Param;%0Aimport org.openjdk.jmh.annotations.Scope;%0Aimport org.openjdk.jmh.annotations.Setup;%0Aimport org.openjdk.jmh.annotations.State;%0Aimport org.openjdk.jmh.infra.Blackhole;%0Aimport org.sfm.beans.SmallBenchmarkObject;%0Aimport org.sfm.benchmark.db.jmh.ConnectionParam;%0Aimport org.sfm.benchmark.db.jmh.DbTarget;%0Aimport org.sfm.benchmark.db.jmh.LimitParam;%0A%0A@State(Scope.Benchmark)%0Apublic class JooqBenchmark %7B%0A%0A%09@Param(value=%22MOCK%22)%0A%09private DbTarget db;%0A%09private DSLContext create;%0A%0A%09@Setup%0A%09public void init() throws SQLException %7B%0A%09%09ConnectionParam cp = new ConnectionParam();%0A%09%09cp.db = db;%0A%09%09cp.init();%0A%09%09create = DSL.using(cp.dataSource, db.getSqlDialect());%0A%09%7D%0A%09%0A%09@Benchmark%0A%09public void testQuery(LimitParam limit, final Blackhole blackhole, ConnectionParam connectionParam) throws Exception %7B%0A%09%09%0A        List%3CSmallBenchmarkObject%3E result = create.select().from(%22test_small_benchmark_object%22).limit(limit.limit).fetch().into(SmallBenchmarkObject.class);%0A        for(SmallBenchmarkObject o : result) %7B%0A        %09blackhole.consume(o);%0A        %7D%0A%09%7D%0A%09%0A%0A%09%0A%7D%0A

add Jooq benchmark