插入、更新操作时，通过JOOQ设置字段的默认值

怼烎@ 2023-06-18 12:55 25阅读 0赞

**背景：jooq3.12、JDK13、IDEA2019.2.4、postgres12**

**参考资料：[https://github.com/jOOQ/jOOQ/issues/1592][https_github.com_jOOQ_jOOQ_issues_1592]**

**方法1：通过DefaultRecordListener实现**

package com.zsx.listener;
    
    import org.jooq.*;
    import org.jooq.impl.DefaultExecuteListener;
    import org.jooq.tools.StopWatch;
    import org.slf4j.Logger;
    import org.slf4j.LoggerFactory;
    import org.springframework.stereotype.Component;
    
    import java.util.Arrays;
    import java.util.Optional;
    
    @Component("customizeExecuteListener")
    public class CustomizeExecuteListener extends DefaultExecuteListener implements ExecuteListenerProvider {
    
        private static final Logger LOGGER = LoggerFactory.getLogger(CustomizeExecuteListener.class);
    
        private StopWatch watch;
    
        @Override
        public ExecuteListener provide() {
            return this;
        }
    
        @Override
        public void executeStart(ExecuteContext ctx) {
            super.executeStart(ctx);
            watch = new StopWatch();
        }
    
        @Override
        public void executeEnd(ExecuteContext ctx) {
            try {
                super.executeEnd(ctx);
                //记录执行时间大于1ms(1s:1_000_000_000L)的操作
                if (watch.split() <= 1_000_000L) {
                    return;
                }
                ExecuteType type = ctx.type();
                StringBuffer sqlBuffer = new StringBuffer();
                if (type == ExecuteType.BATCH) {
                    Arrays.stream(ctx.batchQueries()).forEach(query->sqlBuffer.append(query.toString()));
                } else {
                    sqlBuffer.append(Optional.ofNullable(type).map(ExecuteType :: toString).orElse("ExecuteType is null"));
                }
                watch.splitInfo(String.format("The type of database interaction that is being executed with this context : { %s }", sqlBuffer.toString()));
            } catch (Exception e) {
                LOGGER.error(" SlowQueryListener.executeEnd.Exception ", e);
            }
        }
    
    }

**方法2：通过DefaultVisitListener实现**

package com.zsx.listener;
    
    import org.jooq.*;
    import org.jooq.impl.TableImpl;
    import org.springframework.stereotype.Component;
    
    import java.sql.Timestamp;
    import java.util.*;
    
    import static java.util.Arrays.asList;
    import static org.jooq.Clause.*;
    
    
    //@Component("customizeVisitListener")
    public class CustomizeVisitListener implements VisitListener, VisitListenerProvider {
    
        public static final String CREATED_AT = "created_at";
        private static final String CREATED_BY = "created_by";
        public static final String UPDATED_AT = "updated_at";
        private static final String UPDATED_BY = "updated_by";
        private static final String ADMIN = "admin2";
        private static final String AUDIT_FIELDS = "auditFields";
    
        @Override
        public VisitListener provide() {
            return this;
        }
    
        @Override
        public void clauseStart(VisitContext context) {
            if (context.clause() == INSERT || context.clause() == UPDATE) {
                push(context);
            }
        }
    
        @Override
        public void clauseEnd(VisitContext context) {
            var auditMap = auditFields(context);
            if (auditMap != null && !auditMap.isEmpty()) {
                if (context.queryPart() instanceof InsertQuery) {
                    InsertQuery<Record> insertQuery = (InsertQuery) context.queryPart();
                    insertQuery.addValue(auditMap.get(CREATED_AT), new Timestamp(System.currentTimeMillis()));
                    insertQuery.addValue(auditMap.get(CREATED_BY), ADMIN);
                    insertQuery.addValue(auditMap.get(UPDATED_AT), new Timestamp(System.currentTimeMillis()));
                    insertQuery.addValue(auditMap.get(UPDATED_BY), ADMIN);
                } else if (context.queryPart() instanceof UpdateQuery) {
                    UpdateQuery<Record> updateQuery = (UpdateQuery) context.queryPart();
                    updateQuery.addValue(auditMap.get(UPDATED_AT), new Timestamp(System.currentTimeMillis()));
                    updateQuery.addValue(auditMap.get(UPDATED_BY), ADMIN);
                }
            }
    
            if (context.clause() == INSERT || context.clause() == UPDATE) {
                pop(context);
            }
    
        }
    
        @Override
        public void visitStart(VisitContext context) {
            List<Clause> clauses = asList(context.clauses());
            if ((clauses.contains(INSERT) || clauses.contains(UPDATE))
                    && context.queryPart() instanceof TableImpl) {
                Table<?> table = (Table<?>) context.queryPart();
                Field<Timestamp> createdAtField = table.field(CREATED_AT, Timestamp.class);
                // 存在审计字段CREATED_AT，则默认其他几个审计也存在，反之亦然
                if (createdAtField == null) {
                    return;
                }
                Field<String> createdByField = table.field(CREATED_BY, String.class);
                Field<Timestamp> updatedAtField = table.field(UPDATED_AT, Timestamp.class);
                Field<String> updatedByField = table.field(UPDATED_BY, String.class);
                auditFields(context).putAll(Map.of(CREATED_AT, createdAtField, CREATED_BY,
                        createdByField, UPDATED_AT, updatedAtField, UPDATED_BY, updatedByField));
            }
        }
    
        @Override
        public void visitEnd(VisitContext context) {
    
        }
    
        private Map<String, Field> auditFields(VisitContext context) {
            return auditFieldsStack(context).peek();
        }
    
        /**
         * stack to keep `deleted` field.
         */
        private Deque<Map<String, Field>> auditFieldsStack(VisitContext context) {
            //noinspection unchecked
            Deque<Map<String, Field>> data = (Deque<Map<String, Field>>)
                    context.data(AUDIT_FIELDS);
            if (data == null) {
                data = new ArrayDeque<>();
                context.data(AUDIT_FIELDS, data);
            }
            return data;
        }
    
        private void push(VisitContext context) {
            auditFieldsStack(context).push(new HashMap<>());
        }
    
        private void pop(VisitContext context) {
            auditFieldsStack(context).pop();
        }
    
    }

**测试类**

package com.zsx.test.listener;
    
    import com.zsx.generator.jooq.tables.records.AuthorRecord;
    import com.zsx.listener.CustomizeRecordListener;
    import com.zsx.listener.CustomizeVisitListener;
    import org.jooq.DSLContext;
    import org.jooq.InsertValuesStep2;
    import org.jooq.UpdateConditionStep;
    import org.jooq.conf.ParamType;
    import org.jooq.impl.DSL;
    import org.jooq.impl.DefaultRecordListenerProvider;
    import org.jooq.impl.DefaultVisitListenerProvider;
    import org.junit.jupiter.api.Test;
    import org.junit.jupiter.api.extension.ExtendWith;
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.boot.test.context.SpringBootTest;
    import org.springframework.test.context.junit.jupiter.SpringExtension;
    
    import java.util.concurrent.TimeUnit;
    
    import static com.zsx.generator.jooq.tables.Author.AUTHOR;
    import static com.zsx.generator.jooq.tables.Book.BOOK;
    import static org.junit.jupiter.api.Assertions.*;
    
    @SpringBootTest
    @ExtendWith(SpringExtension.class)
    public class CustomizeRecordAndVisitListenerTest {
    
        @Autowired
        private DSLContext dslContext;
    
        @Test
        void testRecordListenerInsertInto() {
            dslContext.configuration().set(DefaultRecordListenerProvider.providers(new CustomizeRecordListener()));
            InsertValuesStep2<AuthorRecord, String, Integer> insertValuesStep2 = dslContext.insertInto(AUTHOR).columns(AUTHOR.FIRST_NAME, AUTHOR.AGE).values("zhangfei", 20);
            String sql = insertValuesStep2.getSQL(ParamType.INLINED);
            assertEquals(1, insertValuesStep2.execute());
            // 通过CustomizeRecordListener的实现方式，此处设置默认值不成功
            assertFalse(sql.contains(CustomizeRecordListener.CREATED_AT));
        }
    
        @Test
        void testVisitListenerInsertInto() {
            dslContext.configuration().set(DefaultVisitListenerProvider.providers(new CustomizeVisitListener()));
            InsertValuesStep2<AuthorRecord, String, Integer> insertValuesStep2 = dslContext.insertInto(AUTHOR).columns(AUTHOR.FIRST_NAME, AUTHOR.AGE).values("zhangfei", 20);
            String sql = insertValuesStep2.getSQL(ParamType.INLINED);
            assertEquals(1, insertValuesStep2.execute());
            // 通过CustomizeVisitListener的实现方式，此处设置默认值成功
            assertTrue(sql.contains(CustomizeVisitListener.CREATED_AT));
        }
    
        @Test
        void testInsert() {
            AuthorRecord author = dslContext.newRecord(AUTHOR);
            author.setFirstName("张飞");
            author.setAge(21);
            assertEquals(1, author.insert());
        }
    
        @Test
        void testStore() {
            AuthorRecord author = dslContext.newRecord(AUTHOR);
            author.setFirstName("赵云");
            author.setAge(18);
            assertEquals(1, author.store());
        }
    
        @Test
        void testInsertAndStore() {
            AuthorRecord author = dslContext.newRecord(AUTHOR);
            author.setFirstName("关羽");
            author.setAge(23);
            try {
                TimeUnit.SECONDS.sleep(2);
            } catch (InterruptedException e) {
                e.printStackTrace();
            }
            assertEquals(1, author.insert());
            author.setFirstName("项羽");
            assertEquals(1, author.store());
        }
    
        @Test
        void testUpdate() {
            InsertValuesStep2<AuthorRecord, String, Integer> values = dslContext.insertInto(AUTHOR).columns(AUTHOR.FIRST_NAME, AUTHOR.AGE).values("刘备", 30);
            AuthorRecord author = values.returning().fetchOne();
            assertNotNull(author);
            author.setLastName("小刘");
            assertEquals(1, author.update());
        }
    
        @Test
        void testRecordListenerUpdateExistsSubQuery() {
            dslContext.configuration().set(DefaultRecordListenerProvider.providers(new CustomizeRecordListener()));
            UpdateConditionStep<AuthorRecord> updateConditionStep = dslContext.update(AUTHOR).set(AUTHOR.REMARK, "test-update" +System.currentTimeMillis())
                    .where(AUTHOR.ID.in(DSL.select(BOOK.ID).from(BOOK).where(BOOK.ID.eq(1L))));
            String sql = updateConditionStep.getSQL(ParamType.INLINED);
            assertEquals(1, updateConditionStep.execute());
            // 通过CustomizeVisitListener的实现方式，此处设置默认值不成功
            assertFalse(sql.contains(CustomizeRecordListener.UPDATED_AT));
        }
    
        @Test
        void testVisitListenerUpdateExistsSubQuery() {
            dslContext.configuration().set(DefaultVisitListenerProvider.providers(new CustomizeVisitListener()));
            UpdateConditionStep<AuthorRecord> updateConditionStep = dslContext.update(AUTHOR).set(AUTHOR.REMARK, "test-update" +System.currentTimeMillis())
                    .where(AUTHOR.ID.in(DSL.select(BOOK.ID).from(BOOK).where(BOOK.ID.eq(1L))));
            String sql = updateConditionStep.getSQL(ParamType.INLINED);
            assertEquals(1, updateConditionStep.execute());
            // 通过CustomizeVisitListener的实现方式，此处设置默认值成功
            assertTrue(sql.contains(CustomizeVisitListener.UPDATED_AT));
        }
    }

**测试结果**

E:\jdk\jdk-13.0.1\bin\java.exe -ea -Didea.test.cyclic.buffer.size=1048576 "-javaagent:E:\JetBrains\IntelliJ IDEA 2019.2.3\lib\idea_rt.jar=55286:E:\JetBrains\IntelliJ IDEA 2019.2.3\bin" -Dfile.encoding=UTF-8 -classpath "E:\JetBrains\IntelliJ IDEA 2019.2.3\lib\idea_rt.jar;E:\JetBrains\IntelliJ IDEA 2019.2.3\plugins\junit\lib\junit-rt.jar;E:\JetBrains\IntelliJ IDEA 2019.2.3\plugins\junit\lib\junit5-rt.jar;F:\IdeaProjects\jooq\target\test-classes;F:\IdeaProjects\jooq\target\classes;E:\maven\repository\org\springframework\boot\spring-boot-starter-web\2.2.0.RELEASE\spring-boot-starter-web-2.2.0.RELEASE.jar;E:\maven\repository\org\springframework\boot\spring-boot-starter\2.2.0.RELEASE\spring-boot-starter-2.2.0.RELEASE.jar;E:\maven\repository\org\springframework\boot\spring-boot-starter-logging\2.2.0.RELEASE\spring-boot-starter-logging-2.2.0.RELEASE.jar;E:\maven\repository\ch\qos\logback\logback-classic\1.2.3\logback-classic-1.2.3.jar;E:\maven\repository\ch\qos\logback\logback-core\1.2.3\logback-core-1.2.3.jar;E:\maven\repository\org\apache\logging\log4j\log4j-to-slf4j\2.12.1\log4j-to-slf4j-2.12.1.jar;E:\maven\repository\org\apache\logging\log4j\log4j-api\2.12.1\log4j-api-2.12.1.jar;E:\maven\repository\org\slf4j\jul-to-slf4j\1.7.28\jul-to-slf4j-1.7.28.jar;E:\maven\repository\jakarta\annotation\jakarta.annotation-api\1.3.5\jakarta.annotation-api-1.3.5.jar;E:\maven\repository\org\yaml\snakeyaml\1.25\snakeyaml-1.25.jar;E:\maven\repository\org\springframework\boot\spring-boot-starter-json\2.2.0.RELEASE\spring-boot-starter-json-2.2.0.RELEASE.jar;E:\maven\repository\com\fasterxml\jackson\core\jackson-databind\2.10.0\jackson-databind-2.10.0.jar;E:\maven\repository\com\fasterxml\jackson\core\jackson-annotations\2.10.0\jackson-annotations-2.10.0.jar;E:\maven\repository\com\fasterxml\jackson\core\jackson-core\2.10.0\jackson-core-2.10.0.jar;E:\maven\repository\com\fasterxml\jackson\datatype\jackson-datatype-jdk8\2.10.0\jackson-datatype-jdk8-2.10.0.jar;E:\maven\repository\com\fasterxml\jackson\datatype\jackson-datatype-jsr310\2.10.0\jackson-datatype-jsr310-2.10.0.jar;E:\maven\repository\com\fasterxml\jackson\module\jackson-module-parameter-names\2.10.0\jackson-module-parameter-names-2.10.0.jar;E:\maven\repository\org\springframework\boot\spring-boot-starter-tomcat\2.2.0.RELEASE\spring-boot-starter-tomcat-2.2.0.RELEASE.jar;E:\maven\repository\org\apache\tomcat\embed\tomcat-embed-core\9.0.27\tomcat-embed-core-9.0.27.jar;E:\maven\repository\org\apache\tomcat\embed\tomcat-embed-el\9.0.27\tomcat-embed-el-9.0.27.jar;E:\maven\repository\org\apache\tomcat\embed\tomcat-embed-websocket\9.0.27\tomcat-embed-websocket-9.0.27.jar;E:\maven\repository\org\springframework\boot\spring-boot-starter-validation\2.2.0.RELEASE\spring-boot-starter-validation-2.2.0.RELEASE.jar;E:\maven\repository\jakarta\validation\jakarta.validation-api\2.0.1\jakarta.validation-api-2.0.1.jar;E:\maven\repository\org\hibernate\validator\hibernate-validator\6.0.17.Final\hibernate-validator-6.0.17.Final.jar;E:\maven\repository\org\springframework\spring-web\5.2.0.RELEASE\spring-web-5.2.0.RELEASE.jar;E:\maven\repository\org\springframework\spring-beans\5.2.0.RELEASE\spring-beans-5.2.0.RELEASE.jar;E:\maven\repository\org\springframework\spring-webmvc\5.2.0.RELEASE\spring-webmvc-5.2.0.RELEASE.jar;E:\maven\repository\org\springframework\spring-aop\5.2.0.RELEASE\spring-aop-5.2.0.RELEASE.jar;E:\maven\repository\org\springframework\spring-context\5.2.0.RELEASE\spring-context-5.2.0.RELEASE.jar;E:\maven\repository\org\springframework\spring-expression\5.2.0.RELEASE\spring-expression-5.2.0.RELEASE.jar;E:\maven\repository\org\springframework\boot\spring-boot-starter-test\2.2.0.RELEASE\spring-boot-starter-test-2.2.0.RELEASE.jar;E:\maven\repository\org\springframework\boot\spring-boot-test\2.2.0.RELEASE\spring-boot-test-2.2.0.RELEASE.jar;E:\maven\repository\org\springframework\boot\spring-boot-test-autoconfigure\2.2.0.RELEASE\spring-boot-test-autoconfigure-2.2.0.RELEASE.jar;E:\maven\repository\com\jayway\jsonpath\json-path\2.4.0\json-path-2.4.0.jar;E:\maven\repository\net\minidev\json-smart\2.3\json-smart-2.3.jar;E:\maven\repository\net\minidev\accessors-smart\1.2\accessors-smart-1.2.jar;E:\maven\repository\org\ow2\asm\asm\5.0.4\asm-5.0.4.jar;E:\maven\repository\org\slf4j\slf4j-api\1.7.28\slf4j-api-1.7.28.jar;E:\maven\repository\jakarta\xml\bind\jakarta.xml.bind-api\2.3.2\jakarta.xml.bind-api-2.3.2.jar;E:\maven\repository\org\junit\jupiter\junit-jupiter\5.5.2\junit-jupiter-5.5.2.jar;E:\maven\repository\org\junit\jupiter\junit-jupiter-params\5.5.2\junit-jupiter-params-5.5.2.jar;E:\maven\repository\org\junit\vintage\junit-vintage-engine\5.5.2\junit-vintage-engine-5.5.2.jar;E:\maven\repository\junit\junit\4.12\junit-4.12.jar;E:\maven\repository\org\mockito\mockito-junit-jupiter\3.1.0\mockito-junit-jupiter-3.1.0.jar;E:\maven\repository\org\assertj\assertj-core\3.13.2\assertj-core-3.13.2.jar;E:\maven\repository\org\hamcrest\hamcrest\2.1\hamcrest-2.1.jar;E:\maven\repository\org\mockito\mockito-core\3.1.0\mockito-core-3.1.0.jar;E:\maven\repository\net\bytebuddy\byte-buddy\1.10.1\byte-buddy-1.10.1.jar;E:\maven\repository\net\bytebuddy\byte-buddy-agent\1.10.1\byte-buddy-agent-1.10.1.jar;E:\maven\repository\org\objenesis\objenesis\2.6\objenesis-2.6.jar;E:\maven\repository\org\skyscreamer\jsonassert\1.5.0\jsonassert-1.5.0.jar;E:\maven\repository\com\vaadin\external\google\android-json\0.0.20131108.vaadin1\android-json-0.0.20131108.vaadin1.jar;E:\maven\repository\org\springframework\spring-core\5.2.0.RELEASE\spring-core-5.2.0.RELEASE.jar;E:\maven\repository\org\springframework\spring-jcl\5.2.0.RELEASE\spring-jcl-5.2.0.RELEASE.jar;E:\maven\repository\org\springframework\spring-test\5.2.0.RELEASE\spring-test-5.2.0.RELEASE.jar;E:\maven\repository\org\xmlunit\xmlunit-core\2.6.3\xmlunit-core-2.6.3.jar;E:\maven\repository\org\springframework\boot\spring-boot-starter-jooq\2.2.0.RELEASE\spring-boot-starter-jooq-2.2.0.RELEASE.jar;E:\maven\repository\org\springframework\boot\spring-boot-starter-jdbc\2.2.0.RELEASE\spring-boot-starter-jdbc-2.2.0.RELEASE.jar;E:\maven\repository\com\zaxxer\HikariCP\3.4.1\HikariCP-3.4.1.jar;E:\maven\repository\org\springframework\spring-jdbc\5.2.0.RELEASE\spring-jdbc-5.2.0.RELEASE.jar;E:\maven\repository\jakarta\activation\jakarta.activation-api\1.2.1\jakarta.activation-api-1.2.1.jar;E:\maven\repository\org\springframework\spring-tx\5.2.0.RELEASE\spring-tx-5.2.0.RELEASE.jar;E:\maven\repository\org\jooq\jooq\3.12.2\jooq-3.12.2.jar;E:\maven\repository\org\reactivestreams\reactive-streams\1.0.3\reactive-streams-1.0.3.jar;E:\maven\repository\org\springframework\boot\spring-boot-starter-data-jpa\2.2.0.RELEASE\spring-boot-starter-data-jpa-2.2.0.RELEASE.jar;E:\maven\repository\org\springframework\boot\spring-boot-starter-aop\2.2.0.RELEASE\spring-boot-starter-aop-2.2.0.RELEASE.jar;E:\maven\repository\org\aspectj\aspectjweaver\1.9.4\aspectjweaver-1.9.4.jar;E:\maven\repository\jakarta\persistence\jakarta.persistence-api\2.2.3\jakarta.persistence-api-2.2.3.jar;E:\maven\repository\jakarta\transaction\jakarta.transaction-api\1.3.3\jakarta.transaction-api-1.3.3.jar;E:\maven\repository\org\hibernate\hibernate-core\5.4.6.Final\hibernate-core-5.4.6.Final.jar;E:\maven\repository\org\jboss\logging\jboss-logging\3.4.1.Final\jboss-logging-3.4.1.Final.jar;E:\maven\repository\org\javassist\javassist\3.24.0-GA\javassist-3.24.0-GA.jar;E:\maven\repository\antlr\antlr\2.7.7\antlr-2.7.7.jar;E:\maven\repository\org\jboss\jandex\2.0.5.Final\jandex-2.0.5.Final.jar;E:\maven\repository\com\fasterxml\classmate\1.5.0\classmate-1.5.0.jar;E:\maven\repository\org\dom4j\dom4j\2.1.1\dom4j-2.1.1.jar;E:\maven\repository\org\hibernate\common\hibernate-commons-annotations\5.1.0.Final\hibernate-commons-annotations-5.1.0.Final.jar;E:\maven\repository\org\glassfish\jaxb\jaxb-runtime\2.3.2\jaxb-runtime-2.3.2.jar;E:\maven\repository\org\jvnet\staxex\stax-ex\1.8.1\stax-ex-1.8.1.jar;E:\maven\repository\com\sun\xml\fastinfoset\FastInfoset\1.2.16\FastInfoset-1.2.16.jar;E:\maven\repository\org\springframework\data\spring-data-jpa\2.2.0.RELEASE\spring-data-jpa-2.2.0.RELEASE.jar;E:\maven\repository\org\springframework\data\spring-data-commons\2.2.0.RELEASE\spring-data-commons-2.2.0.RELEASE.jar;E:\maven\repository\org\springframework\spring-orm\5.2.0.RELEASE\spring-orm-5.2.0.RELEASE.jar;E:\maven\repository\org\springframework\spring-aspects\5.2.0.RELEASE\spring-aspects-5.2.0.RELEASE.jar;E:\maven\repository\org\jooq\jooq-meta\3.12.2\jooq-meta-3.12.2.jar;E:\maven\repository\org\jooq\jooq-codegen\3.12.2\jooq-codegen-3.12.2.jar;E:\maven\repository\org\flywaydb\flyway-core\6.0.7\flyway-core-6.0.7.jar;E:\maven\repository\org\postgresql\postgresql\42.2.8\postgresql-42.2.8.jar;E:\maven\repository\org\glassfish\jaxb\jaxb-core\2.3.0.1\jaxb-core-2.3.0.1.jar;E:\maven\repository\javax\xml\bind\jaxb-api\2.3.1\jaxb-api-2.3.1.jar;E:\maven\repository\javax\activation\javax.activation-api\1.2.0\javax.activation-api-1.2.0.jar;E:\maven\repository\org\glassfish\jaxb\txw2\2.3.2\txw2-2.3.2.jar;E:\maven\repository\com\sun\istack\istack-commons-runtime\3.0.5\istack-commons-runtime-3.0.5.jar;E:\maven\repository\com\sun\xml\bind\jaxb-impl\2.3.2\jaxb-impl-2.3.2.jar;E:\maven\repository\org\projectlombok\lombok\1.18.10\lombok-1.18.10.jar;E:\maven\repository\net\jcip\jcip-annotations\1.0\jcip-annotations-1.0.jar;E:\maven\repository\org\junit\platform\junit-platform-launcher\1.5.2\junit-platform-launcher-1.5.2.jar;E:\maven\repository\org\apiguardian\apiguardian-api\1.1.0\apiguardian-api-1.1.0.jar;E:\maven\repository\org\junit\platform\junit-platform-engine\1.5.2\junit-platform-engine-1.5.2.jar;E:\maven\repository\org\opentest4j\opentest4j\1.2.0\opentest4j-1.2.0.jar;E:\maven\repository\org\junit\platform\junit-platform-commons\1.5.2\junit-platform-commons-1.5.2.jar;E:\maven\repository\org\junit\jupiter\junit-jupiter-engine\5.5.2\junit-jupiter-engine-5.5.2.jar;E:\maven\repository\org\junit\jupiter\junit-jupiter-api\5.5.2\junit-jupiter-api-5.5.2.jar;E:\maven\repository\org\springframework\boot\spring-boot-devtools\2.2.0.RELEASE\spring-boot-devtools-2.2.0.RELEASE.jar;E:\maven\repository\org\springframework\boot\spring-boot\2.2.0.RELEASE\spring-boot-2.2.0.RELEASE.jar;E:\maven\repository\org\springframework\boot\spring-boot-autoconfigure\2.2.0.RELEASE\spring-boot-autoconfigure-2.2.0.RELEASE.jar" com.intellij.rt.execution.junit.JUnitStarter -ideVersion5 -junit5 com.zsx.test.listener.CustomizeRecordAndVisitListenerTest
    17:16:08.201 [main] DEBUG org.springframework.test.context.BootstrapUtils - Instantiating CacheAwareContextLoaderDelegate from class [org.springframework.test.context.cache.DefaultCacheAwareContextLoaderDelegate]
    17:16:08.212 [main] DEBUG org.springframework.test.context.BootstrapUtils - Instantiating BootstrapContext using constructor [public org.springframework.test.context.support.DefaultBootstrapContext(java.lang.Class,org.springframework.test.context.CacheAwareContextLoaderDelegate)]
    17:16:08.235 [main] DEBUG org.springframework.test.context.BootstrapUtils - Instantiating TestContextBootstrapper for test class [com.zsx.test.listener.CustomizeRecordAndVisitListenerTest] from class [org.springframework.boot.test.context.SpringBootTestContextBootstrapper]
    17:16:08.246 [main] INFO org.springframework.boot.test.context.SpringBootTestContextBootstrapper - Neither @ContextConfiguration nor @ContextHierarchy found for test class [com.zsx.test.listener.CustomizeRecordAndVisitListenerTest], using SpringBootContextLoader
    17:16:08.250 [main] DEBUG org.springframework.test.context.support.AbstractContextLoader - Did not detect default resource location for test class [com.zsx.test.listener.CustomizeRecordAndVisitListenerTest]: class path resource [com/zsx/test/listener/CustomizeRecordAndVisitListenerTest-context.xml] does not exist
    17:16:08.250 [main] DEBUG org.springframework.test.context.support.AbstractContextLoader - Did not detect default resource location for test class [com.zsx.test.listener.CustomizeRecordAndVisitListenerTest]: class path resource [com/zsx/test/listener/CustomizeRecordAndVisitListenerTestContext.groovy] does not exist
    17:16:08.251 [main] INFO org.springframework.test.context.support.AbstractContextLoader - Could not detect default resource locations for test class [com.zsx.test.listener.CustomizeRecordAndVisitListenerTest]: no resource found for suffixes {-context.xml, Context.groovy}.
    17:16:08.251 [main] INFO org.springframework.test.context.support.AnnotationConfigContextLoaderUtils - Could not detect default configuration classes for test class [com.zsx.test.listener.CustomizeRecordAndVisitListenerTest]: CustomizeRecordAndVisitListenerTest does not declare any static, non-private, non-final, nested classes annotated with @Configuration.
    17:16:08.275 [main] DEBUG org.springframework.test.context.support.ActiveProfilesUtils - Could not find an 'annotation declaring class' for annotation type [org.springframework.test.context.ActiveProfiles] and class [com.zsx.test.listener.CustomizeRecordAndVisitListenerTest]
    17:16:08.323 [main] DEBUG org.springframework.context.annotation.ClassPathScanningCandidateComponentProvider - Identified candidate component class: file [F:\IdeaProjects\jooq\target\classes\com\zsx\JooqApplication.class]
    17:16:08.323 [main] INFO org.springframework.boot.test.context.SpringBootTestContextBootstrapper - Found @SpringBootConfiguration com.zsx.JooqApplication for test class com.zsx.test.listener.CustomizeRecordAndVisitListenerTest
    17:16:08.378 [main] DEBUG org.springframework.boot.test.context.SpringBootTestContextBootstrapper - @TestExecutionListeners is not present for class [com.zsx.test.listener.CustomizeRecordAndVisitListenerTest]: using defaults.
    17:16:08.378 [main] INFO org.springframework.boot.test.context.SpringBootTestContextBootstrapper - Loaded default TestExecutionListener class names from location [META-INF/spring.factories]: [org.springframework.boot.test.mock.mockito.MockitoTestExecutionListener, org.springframework.boot.test.mock.mockito.ResetMocksTestExecutionListener, org.springframework.boot.test.autoconfigure.restdocs.RestDocsTestExecutionListener, org.springframework.boot.test.autoconfigure.web.client.MockRestServiceServerResetTestExecutionListener, org.springframework.boot.test.autoconfigure.web.servlet.MockMvcPrintOnlyOnFailureTestExecutionListener, org.springframework.boot.test.autoconfigure.web.servlet.WebDriverTestExecutionListener, org.springframework.test.context.web.ServletTestExecutionListener, org.springframework.test.context.support.DirtiesContextBeforeModesTestExecutionListener, org.springframework.test.context.support.DependencyInjectionTestExecutionListener, org.springframework.test.context.support.DirtiesContextTestExecutionListener, org.springframework.test.context.transaction.TransactionalTestExecutionListener, org.springframework.test.context.jdbc.SqlScriptsTestExecutionListener, org.springframework.test.context.event.EventPublishingTestExecutionListener]
    17:16:08.388 [main] INFO org.springframework.boot.test.context.SpringBootTestContextBootstrapper - Using TestExecutionListeners: [org.springframework.test.context.web.ServletTestExecutionListener@1bae316d, org.springframework.test.context.support.DirtiesContextBeforeModesTestExecutionListener@147a5d08, org.springframework.boot.test.mock.mockito.MockitoTestExecutionListener@6676f6a0, org.springframework.boot.test.autoconfigure.SpringBootDependencyInjectionTestExecutionListener@7cbd9d24, org.springframework.test.context.support.DirtiesContextTestExecutionListener@1672fe87, org.springframework.test.context.transaction.TransactionalTestExecutionListener@5026735c, org.springframework.test.context.jdbc.SqlScriptsTestExecutionListener@1b45c0e, org.springframework.test.context.event.EventPublishingTestExecutionListener@11f0a5a1, org.springframework.boot.test.mock.mockito.ResetMocksTestExecutionListener@10f7f7de, org.springframework.boot.test.autoconfigure.restdocs.RestDocsTestExecutionListener@73a8da0f, org.springframework.boot.test.autoconfigure.web.client.MockRestServiceServerResetTestExecutionListener@50dfbc58, org.springframework.boot.test.autoconfigure.web.servlet.MockMvcPrintOnlyOnFailureTestExecutionListener@4416d64f, org.springframework.boot.test.autoconfigure.web.servlet.WebDriverTestExecutionListener@6bf08014]
    17:16:08.391 [main] DEBUG org.springframework.test.context.support.AbstractDirtiesContextTestExecutionListener - Before test class: context [DefaultTestContext@48d61b48 testClass = CustomizeRecordAndVisitListenerTest, testInstance = [null], testMethod = [null], testException = [null], mergedContextConfiguration = [WebMergedContextConfiguration@68d279ec testClass = CustomizeRecordAndVisitListenerTest, locations = '{}', classes = '{class com.zsx.JooqApplication}', contextInitializerClasses = '[]', activeProfiles = '{}', propertySourceLocations = '{}', propertySourceProperties = '{org.springframework.boot.test.context.SpringBootTestContextBootstrapper=true}', contextCustomizers = set[org.springframework.boot.test.context.filter.ExcludeFilterContextCustomizer@51f116b8, org.springframework.boot.test.json.DuplicateJsonObjectContextCustomizerFactory$DuplicateJsonObjectContextCustomizer@140c9f39, org.springframework.boot.test.mock.mockito.MockitoContextCustomizer@0, org.springframework.boot.test.web.client.TestRestTemplateContextCustomizer@69e1dd28, org.springframework.boot.test.autoconfigure.properties.PropertyMappingContextCustomizer@0, org.springframework.boot.test.autoconfigure.web.servlet.WebDriverContextCustomizerFactory$Customizer@22e357dc], resourceBasePath = 'src/main/webapp', contextLoader = 'org.springframework.boot.test.context.SpringBootContextLoader', parent = [null]], attributes = map['org.springframework.test.context.web.ServletTestExecutionListener.activateListener' -> true]], class annotated with @DirtiesContext [false] with mode [null].
    17:16:08.414 [main] DEBUG org.springframework.test.context.support.TestPropertySourceUtils - Adding inlined properties to environment: {spring.jmx.enabled=false, org.springframework.boot.test.context.SpringBootTestContextBootstrapper=true, server.port=-1}
    
      .   ____          _            __ _ _
     /\\ / ___'_ __ _ _(_)_ __  __ _ \ \ \ \
    ( ( )\___ | '_ | '_| | '_ \/ _` | \ \ \ \
     \\/  ___)| |_)| | | | | || (_| |  ) ) ) )
      '  |____| .__|_| |_|_| |_\__, | / / / /
     =========|_|==============|___/=/_/_/_/
     :: Spring Boot ::        (v2.2.0.RELEASE)
    
    2019-12-02 17:16:08.681  INFO 17764 --- [           main] .t.l.CustomizeRecordAndVisitListenerTest : Starting CustomizeRecordAndVisitListenerTest on DESKTOP-I29QKRP with PID 17764 (started by 18273 in F:\IdeaProjects\jooq)
    2019-12-02 17:16:08.682  INFO 17764 --- [           main] .t.l.CustomizeRecordAndVisitListenerTest : No active profile set, falling back to default profiles: default
    2019-12-02 17:16:09.104  INFO 17764 --- [           main] .s.d.r.c.RepositoryConfigurationDelegate : Bootstrapping Spring Data repositories in DEFAULT mode.
    2019-12-02 17:16:09.131  INFO 17764 --- [           main] .s.d.r.c.RepositoryConfigurationDelegate : Finished Spring Data repository scanning in 21ms. Found 0 repository interfaces.
    2019-12-02 17:16:09.423  INFO 17764 --- [           main] trationDelegate$BeanPostProcessorChecker : Bean 'org.springframework.transaction.annotation.ProxyTransactionManagementConfiguration' of type [org.springframework.transaction.annotation.ProxyTransactionManagementConfiguration] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
    2019-12-02 17:16:09.538  INFO 17764 --- [           main] o.f.c.internal.license.VersionPrinter    : Flyway Community Edition 6.0.7 by Redgate
    2019-12-02 17:16:09.542  WARN 17764 --- [           main] com.zaxxer.hikari.HikariConfig           : HikariPool-1 - idleTimeout has been set but has no effect because the pool is operating as a fixed size pool.
    2019-12-02 17:16:09.542  INFO 17764 --- [           main] com.zaxxer.hikari.HikariDataSource       : HikariPool-1 - Starting...
    2019-12-02 17:16:09.605  INFO 17764 --- [           main] com.zaxxer.hikari.HikariDataSource       : HikariPool-1 - Start completed.
    2019-12-02 17:16:09.620  INFO 17764 --- [           main] o.f.c.internal.database.DatabaseFactory  : Database: jdbc:postgresql://127.0.0.1:5432/mydb11 (PostgreSQL 12.0)
    2019-12-02 17:16:09.638  INFO 17764 --- [           main] o.f.core.internal.command.DbValidate     : Successfully validated 2 migrations (execution time 00:00.010s)
    2019-12-02 17:16:09.642  INFO 17764 --- [           main] o.f.core.internal.command.DbMigrate      : Current version of schema "jooq": 1
    2019-12-02 17:16:09.643  INFO 17764 --- [           main] o.f.core.internal.command.DbMigrate      : Schema "jooq" is up to date. No migration necessary.
    2019-12-02 17:16:09.734  INFO 17764 --- [           main] o.hibernate.jpa.internal.util.LogHelper  : HHH000204: Processing PersistenceUnitInfo [name: default]
    2019-12-02 17:16:09.783  INFO 17764 --- [           main] org.hibernate.Version                    : HHH000412: Hibernate Core {5.4.6.Final}
    2019-12-02 17:16:09.874  INFO 17764 --- [           main] o.hibernate.annotations.common.Version   : HCANN000001: Hibernate Commons Annotations {5.1.0.Final}
    2019-12-02 17:16:10.097  INFO 17764 --- [           main] org.hibernate.dialect.Dialect            : HHH000400: Using dialect: org.hibernate.dialect.PostgreSQL10Dialect
    2019-12-02 17:16:10.252  INFO 17764 --- [           main] o.h.e.t.j.p.i.JtaPlatformInitiator       : HHH000490: Using JtaPlatform implementation: [org.hibernate.engine.transaction.jta.platform.internal.NoJtaPlatform]
    2019-12-02 17:16:10.257  INFO 17764 --- [           main] j.LocalContainerEntityManagerFactoryBean : Initialized JPA EntityManagerFactory for persistence unit 'default'
    2019-12-02 17:16:10.408  WARN 17764 --- [           main] JpaBaseConfiguration$JpaWebConfiguration : spring.jpa.open-in-view is enabled by default. Therefore, database queries may be performed during view rendering. Explicitly configure spring.jpa.open-in-view to disable this warning
    2019-12-02 17:16:10.547  INFO 17764 --- [           main] o.s.s.concurrent.ThreadPoolTaskExecutor  : Initializing ExecutorService 'applicationTaskExecutor'
    2019-12-02 17:16:10.948  INFO 17764 --- [           main] .t.l.CustomizeRecordAndVisitListenerTest : Started CustomizeRecordAndVisitListenerTest in 2.527 seconds (JVM running for 3.176)
    
    WARNING: An illegal reflective access operation has occurred
    WARNING: Illegal reflective access by org.jooq.tools.reflect.Reflect (file:/E:/maven/repository/org/jooq/jooq/3.12.2/jooq-3.12.2.jar) to constructor java.lang.invoke.MethodHandles$Lookup(java.lang.Class)
    WARNING: Please consider reporting this to the maintainers of org.jooq.tools.reflect.Reflect
    WARNING: Use --illegal-access=warn to enable warnings of further illegal reflective access operations
    WARNING: All illegal access operations will be denied in a future release
    2019-12-02 17:16:11.204 DEBUG 17764 --- [           main] org.jooq.tools.LoggerListener            : Executing query          : insert into "jooq"."author" ("first_name", "age") values (?, ?)
    2019-12-02 17:16:11.205 DEBUG 17764 --- [           main] org.jooq.tools.LoggerListener            : -> with bind values      : insert into "jooq"."author" ("first_name", "age") values ('zhangfei', 20)
    2019-12-02 17:16:11.210 DEBUG 17764 --- [           main] org.jooq.tools.LoggerListener            : Affected row(s)          : 1
    2019-12-02 17:16:11.211  INFO 17764 --- [           main] org.jooq.tools.StopWatch                 : The type of database interaction that is being executed with this context : { WRITE }: Total: 1.525ms
    
    
    2019-12-02 17:16:11.230 DEBUG 17764 --- [           main] org.jooq.tools.LoggerListener            : Executing query          : insert into "jooq"."author" ("first_name", "age", "created_at", "created_by", "updated_at", "updated_by", "version") values (?, ?, cast(? as timestamp), ?, cast(? as timestamp), ?, ?) returning "jooq"."author"."id"
    2019-12-02 17:16:11.231 DEBUG 17764 --- [           main] org.jooq.tools.LoggerListener            : -> with bind values      : insert into "jooq"."author" ("first_name", "age", "created_at", "created_by", "updated_at", "updated_by", "version") values ('赵云', 18, timestamp '2019-12-02 17:16:11.228', 'admin', timestamp '2019-12-02 17:16:11.228', 'admin', 1) returning "jooq"."author"."id"
    2019-12-02 17:16:11.234  INFO 17764 --- [           main] org.jooq.tools.StopWatch                 : The type of database interaction that is being executed with this context : { WRITE }: Total: 2.229ms
    2019-12-02 17:16:11.243 DEBUG 17764 --- [           main] org.jooq.tools.LoggerListener            : Fetched result           : +----+
    2019-12-02 17:16:11.243 DEBUG 17764 --- [           main] org.jooq.tools.LoggerListener            :                          : |  id|
    2019-12-02 17:16:11.243 DEBUG 17764 --- [           main] org.jooq.tools.LoggerListener            :                          : +----+
    2019-12-02 17:16:11.243 DEBUG 17764 --- [           main] org.jooq.tools.LoggerListener            :                          : |  49|
    2019-12-02 17:16:11.243 DEBUG 17764 --- [           main] org.jooq.tools.LoggerListener            :                          : +----+
    2019-12-02 17:16:11.243 DEBUG 17764 --- [           main] org.jooq.tools.LoggerListener            : Fetched row(s)           : 1
    
    
    2019-12-02 17:16:13.250 DEBUG 17764 --- [           main] org.jooq.tools.LoggerListener            : Executing query          : insert into "jooq"."author" ("first_name", "age", "created_at", "created_by", "updated_at", "updated_by", "version") values (?, ?, cast(? as timestamp), ?, cast(? as timestamp), ?, ?) returning "jooq"."author"."id"
    2019-12-02 17:16:13.252 DEBUG 17764 --- [           main] org.jooq.tools.LoggerListener            : -> with bind values      : insert into "jooq"."author" ("first_name", "age", "created_at", "created_by", "updated_at", "updated_by", "version") values ('关羽', 23, timestamp '2019-12-02 17:16:13.247', 'admin', timestamp '2019-12-02 17:16:13.247', 'admin', 1) returning "jooq"."author"."id"
    2019-12-02 17:16:13.254 DEBUG 17764 --- [           main] org.jooq.tools.LoggerListener            : Fetched result           : +----+
    2019-12-02 17:16:13.254 DEBUG 17764 --- [           main] org.jooq.tools.LoggerListener            :                          : |  id|
    2019-12-02 17:16:13.254 DEBUG 17764 --- [           main] org.jooq.tools.LoggerListener            :                          : +----+
    2019-12-02 17:16:13.254 DEBUG 17764 --- [           main] org.jooq.tools.LoggerListener            :                          : |  50|
    2019-12-02 17:16:13.254 DEBUG 17764 --- [           main] org.jooq.tools.LoggerListener            :                          : +----+
    2019-12-02 17:16:13.254 DEBUG 17764 --- [           main] org.jooq.tools.LoggerListener            : Fetched row(s)           : 1
    2019-12-02 17:16:13.258 DEBUG 17764 --- [           main] org.jooq.tools.LoggerListener            : Executing query          : update "jooq"."author" set "first_name" = ?, "version" = ? where "jooq"."author"."id" = ?
    2019-12-02 17:16:13.258 DEBUG 17764 --- [           main] org.jooq.tools.LoggerListener            : -> with bind values      : update "jooq"."author" set "first_name" = '项羽', "version" = 2 where "jooq"."author"."id" = 50
    2019-12-02 17:16:13.277 DEBUG 17764 --- [           main] org.jooq.tools.LoggerListener            : Affected row(s)          : 1
    2019-12-02 17:16:13.277  INFO 17764 --- [           main] org.jooq.tools.StopWatch                 : The type of database interaction that is being executed with this context : { WRITE }: Total: 18.641ms
    
    
    2019-12-02 17:16:13.393 DEBUG 17764 --- [           main] org.jooq.tools.LoggerListener            : Executing query          : update "jooq"."author" set "remark" = ? where "jooq"."author"."id" in (select "jooq"."book"."id" from "jooq"."book" where "jooq"."book"."id" = ?)
    2019-12-02 17:16:13.394 DEBUG 17764 --- [           main] org.jooq.tools.LoggerListener            : -> with bind values      : update "jooq"."author" set "remark" = 'test-update1575278173281' where "jooq"."author"."id" in (select "jooq"."book"."id" from "jooq"."book" where "jooq"."book"."id" = 1)
    2019-12-02 17:16:13.395 DEBUG 17764 --- [           main] org.jooq.tools.LoggerListener            : Affected row(s)          : 1
    2019-12-02 17:16:13.395  INFO 17764 --- [           main] org.jooq.tools.StopWatch                 : The type of database interaction that is being executed with this context : { WRITE }: Total: 1.246ms
    
    
    2019-12-02 17:16:13.399 DEBUG 17764 --- [           main] org.jooq.tools.LoggerListener            : Executing query          : insert into "jooq"."author" ("first_name", "age", "created_at", "created_by", "updated_at", "updated_by", "version") values (?, ?, cast(? as timestamp), ?, cast(? as timestamp), ?, ?) returning "jooq"."author"."id"
    2019-12-02 17:16:13.400 DEBUG 17764 --- [           main] org.jooq.tools.LoggerListener            : -> with bind values      : insert into "jooq"."author" ("first_name", "age", "created_at", "created_by", "updated_at", "updated_by", "version") values ('张飞', 21, timestamp '2019-12-02 17:16:13.398', 'admin', timestamp '2019-12-02 17:16:13.398', 'admin', 1) returning "jooq"."author"."id"
    2019-12-02 17:16:13.401 DEBUG 17764 --- [           main] org.jooq.tools.LoggerListener            : Fetched result           : +----+
    2019-12-02 17:16:13.401 DEBUG 17764 --- [           main] org.jooq.tools.LoggerListener            :                          : |  id|
    2019-12-02 17:16:13.401 DEBUG 17764 --- [           main] org.jooq.tools.LoggerListener            :                          : +----+
    2019-12-02 17:16:13.401 DEBUG 17764 --- [           main] org.jooq.tools.LoggerListener            :                          : |  51|
    2019-12-02 17:16:13.401 DEBUG 17764 --- [           main] org.jooq.tools.LoggerListener            :                          : +----+
    2019-12-02 17:16:13.401 DEBUG 17764 --- [           main] org.jooq.tools.LoggerListener            : Fetched row(s)           : 1
    
    
    2019-12-02 17:16:13.412 DEBUG 17764 --- [           main] org.jooq.tools.LoggerListener            : Executing query          : insert into "jooq"."author" ("first_name", "age", "created_at", "created_by", "updated_at", "updated_by") values (?, ?, cast(? as timestamp), ?, cast(? as timestamp), ?)
    2019-12-02 17:16:13.416 DEBUG 17764 --- [           main] org.jooq.tools.LoggerListener            : -> with bind values      : insert into "jooq"."author" ("first_name", "age", "created_at", "created_by", "updated_at", "updated_by") values ('zhangfei', 20, timestamp '2019-12-02 17:16:13.415', 'admin2', timestamp '2019-12-02 17:16:13.415', 'admin2')
    2019-12-02 17:16:13.418 DEBUG 17764 --- [           main] org.jooq.tools.LoggerListener            : Affected row(s)          : 1
    2019-12-02 17:16:13.418  INFO 17764 --- [           main] org.jooq.tools.StopWatch                 : The type of database interaction that is being executed with this context : { WRITE }: Total: 1.088ms
    
    
    2019-12-02 17:16:13.423 DEBUG 17764 --- [           main] org.jooq.tools.LoggerListener            : Executing query          : update "jooq"."author" set "remark" = ?, "updated_at" = cast(? as timestamp), "updated_by" = ? where "jooq"."author"."id" in (select "jooq"."book"."id" from "jooq"."book" where "jooq"."book"."id" = ?)
    2019-12-02 17:16:13.424 DEBUG 17764 --- [           main] org.jooq.tools.LoggerListener            : -> with bind values      : update "jooq"."author" set "remark" = 'test-update1575278173421', "updated_at" = timestamp '2019-12-02 17:16:13.424', "updated_by" = 'admin2' where "jooq"."author"."id" in (select "jooq"."book"."id" from "jooq"."book" where "jooq"."book"."id" = 1)
    2019-12-02 17:16:13.427 DEBUG 17764 --- [           main] org.jooq.tools.LoggerListener            : Affected row(s)          : 1
    2019-12-02 17:16:13.427  INFO 17764 --- [           main] org.jooq.tools.StopWatch                 : The type of database interaction that is being executed with this context : { WRITE }: Total: 2.276ms
    
    
    2019-12-02 17:16:13.431 DEBUG 17764 --- [           main] org.jooq.tools.LoggerListener            : Executing query          : insert into "jooq"."author" ("first_name", "age", "created_at", "created_by", "updated_at", "updated_by") values (?, ?, cast(? as timestamp), ?, cast(? as timestamp), ?) returning "jooq"."author"."id", "jooq"."author"."first_name", "jooq"."author"."last_name", "jooq"."author"."age", "jooq"."author"."version", "jooq"."author"."created_at", "jooq"."author"."created_by", "jooq"."author"."updated_at", "jooq"."author"."updated_by", "jooq"."author"."remark"
    2019-12-02 17:16:13.434 DEBUG 17764 --- [           main] org.jooq.tools.LoggerListener            : -> with bind values      : insert into "jooq"."author" ("first_name", "age", "created_at", "created_by", "updated_at", "updated_by") values ('刘备', 30, timestamp '2019-12-02 17:16:13.433', 'admin2', timestamp '2019-12-02 17:16:13.433', 'admin2') returning "jooq"."author"."id", "jooq"."author"."first_name", "jooq"."author"."last_name", "jooq"."author"."age", "jooq"."author"."version", "jooq"."author"."created_at", "jooq"."author"."created_by", "jooq"."author"."updated_at", "jooq"."author"."updated_by", "jooq"."author"."remark"
    2019-12-02 17:16:13.435  INFO 17764 --- [           main] org.jooq.tools.StopWatch                 : The type of database interaction that is being executed with this context : { WRITE }: Total: 1.122ms
    2019-12-02 17:16:13.436 DEBUG 17764 --- [           main] org.jooq.tools.LoggerListener            : Fetched result           : +----+----------+---------+----+-------+----------------------+----------+----------------------+----------+------+
    2019-12-02 17:16:13.436 DEBUG 17764 --- [           main] org.jooq.tools.LoggerListener            :                          : |  id|first_name|last_name| age|version|created_at            |created_by|updated_at            |updated_by|remark|
    2019-12-02 17:16:13.436 DEBUG 17764 --- [           main] org.jooq.tools.LoggerListener            :                          : +----+----------+---------+----+-------+----------------------+----------+----------------------+----------+------+
    2019-12-02 17:16:13.437 DEBUG 17764 --- [           main] org.jooq.tools.LoggerListener            :                          : |  53|刘备        |{null}   |  30|      0|2019-12-02 17:16:13.43|admin2    |2019-12-02 17:16:13.43|admin2    |{null}|
    2019-12-02 17:16:13.437 DEBUG 17764 --- [           main] org.jooq.tools.LoggerListener            :                          : +----+----------+---------+----+-------+----------------------+----------+----------------------+----------+------+
    2019-12-02 17:16:13.437 DEBUG 17764 --- [           main] org.jooq.tools.LoggerListener            : Fetched row(s)           : 1
    2019-12-02 17:16:13.438 DEBUG 17764 --- [           main] org.jooq.tools.LoggerListener            : Executing query          : update "jooq"."author" set "last_name" = ?, "version" = ?, "updated_at" = cast(? as timestamp), "updated_by" = ? where "jooq"."author"."id" = ?
    2019-12-02 17:16:13.438 DEBUG 17764 --- [           main] org.jooq.tools.LoggerListener            : -> with bind values      : update "jooq"."author" set "last_name" = '小刘', "version" = 1, "updated_at" = timestamp '2019-12-02 17:16:13.438', "updated_by" = 'admin2' where "jooq"."author"."id" = 53
    2019-12-02 17:16:13.440 DEBUG 17764 --- [           main] org.jooq.tools.LoggerListener            : Affected row(s)          : 1
    2019-12-02 17:16:13.440  INFO 17764 --- [           main] org.jooq.tools.StopWatch                 : The type of database interaction that is being executed with this context : { WRITE }: Total: 1.113ms
    
    2019-12-02 17:16:13.449  INFO 17764 --- [extShutdownHook] o.s.s.concurrent.ThreadPoolTaskExecutor  : Shutting down ExecutorService 'applicationTaskExecutor'
    2019-12-02 17:16:13.450  INFO 17764 --- [extShutdownHook] j.LocalContainerEntityManagerFactoryBean : Closing JPA EntityManagerFactory for persistence unit 'default'
    2019-12-02 17:16:13.451  INFO 17764 --- [extShutdownHook] com.zaxxer.hikari.HikariDataSource       : HikariPool-1 - Shutdown initiated...
    2019-12-02 17:16:13.464  INFO 17764 --- [extShutdownHook] com.zaxxer.hikari.HikariDataSource       : HikariPool-1 - Shutdown completed.
    
    Process finished with exit code 0

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3pzeDE4MjczMTE3MDAz_size_16_color_FFFFFF_t_70][]

**从以上结果可以看出自定义默认值成功 **

[https_github.com_jOOQ_jOOQ_issues_1592]: https://github.com/jOOQ/jOOQ/issues/1592
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3pzeDE4MjczMTE3MDAz_size_16_color_FFFFFF_t_70]: https://img-blog.csdnimg.cn/20191202171847378.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3pzeDE4MjczMTE3MDAz,size_16,color_FFFFFF,t_70