com.taotao.cloud.p6spy.logger.P6spyLogFormat Maven / Gradle / Ivy
/*
* Copyright (c) 2020-2030, Shuigedeng ([email protected] & https://blog.taotaocloud.top/).
*
* Licensed under the Apache License, Version 2.0 (the "License");
* you may not use this file except in compliance with the License.
* You may obtain a copy of the License at
*
* https://www.apache.org/licenses/LICENSE-2.0
*
* Unless required by applicable law or agreed to in writing, software
* distributed under the License is distributed on an "AS IS" BASIS,
* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
* See the License for the specific language governing permissions and
* limitations under the License.
*/
package com.taotao.cloud.p6spy.logger;
import cn.hutool.db.sql.SqlFormatter;
import com.p6spy.engine.spy.appender.MessageFormattingStrategy;
/**
* P6spy SQL 日志格式化
*
* @author shuigedeng
* @version 2022.03
* @since 2020/10/14 09:37
*/
public class P6spyLogFormat implements MessageFormattingStrategy {
@Override
public String formatMessage(final int connectionId, final String now, final long elapsed,
final String category, final String prepared, final String sql, final String url) {
return """
Consume Time: %s Now: %s connectionId: %s category: %s
Execute SQL：%s
""".formatted(elapsed, now, connectionId, category,
SqlFormatter.format(sql.replaceAll("[\\s]+", " ")));
//return StringUtils.isNotBlank(sql) ? " Consume Time：" + elapsed
// + " ms " + now +
// "\n Execute SQL：" + SqlFormatter.format(sql.replaceAll("[\\s]+", " ")) + "\n" : "";
//
//return !"".equals(sql.trim()) ?
// LocalDateTime.now().format(CommonConstant.DATETIME_FORMATTER) + " | took " + elapsed
// + "ms | " + category + " | connection " + connectionId + "\n " + sql + ";" : "";
}
}