org.bithon.server.metric.handler.SqlMetricMessageHandler Maven / Gradle / Ivy

Go to download
/*
 *    Copyright 2020 bithon.org
 *
 *    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
 *
 *        http://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 org.bithon.server.metric.handler;

import lombok.extern.slf4j.Slf4j;
import org.bithon.component.db.dao.EndPointType;
import org.bithon.server.common.utils.MiscUtils;
import org.bithon.server.meta.storage.IMetaStorage;
import org.bithon.server.metric.DataSourceSchemaManager;
import org.bithon.server.metric.input.MetricSet;
import org.bithon.server.metric.storage.IMetricStorage;
import org.springframework.stereotype.Service;

import java.io.IOException;

/**
 * @author [email protected]
 * @date 2021/3/21 21:37
 */
@Slf4j
@Service
public class SqlMetricMessageHandler extends AbstractMetricMessageHandler {
    public SqlMetricMessageHandler(IMetaStorage metaStorage,
                                   IMetricStorage metricStorage,
                                   DataSourceSchemaManager dataSourceSchemaManager) throws IOException {
        super("sql-metrics",
              metaStorage,
              metricStorage,
              dataSourceSchemaManager);
    }

    // TODO: cache the process result of connection string

    /**
     * connection string template:
     * jdbc:h2:mem:007af5e4-ee6e-4af5-a515-f961f0fd02a1;a=b
     * jdbc:mysql://localhost:3306/bithon?useUnicode=true&useSSL=false&autoReconnect=TRUE
     * jdbc:netezza://main:5490/sales;user=admin;password=password;loglevel=2
     */
    @Override
    protected boolean beforeProcess(MetricMessage metricObject) {
        long callCount = metricObject.getLong("callCount");
        if (callCount <= 0) {
            return false;
        }

        MiscUtils.ConnectionString conn = MiscUtils.parseConnectionString(metricObject.getString("connectionString"));
        metricObject.set("server", conn.getHostAndPort());
        metricObject.set("database", conn.getDatabase());
        metricObject.set("endpointType", conn.getEndPointType().name());
        return true;
    }

    @Override
    protected MetricSet extractEndpointLink(MetricMessage metricObject) {
        return EndPointMetricSetBuilder.builder()
                                       .timestamp(metricObject.getTimestamp())
                                       .srcEndpointType(EndPointType.APPLICATION)
                                       .srcEndpoint(metricObject.getApplicationName())
                                       .dstEndpointType(metricObject.getString("endpointType"))
                                       .dstEndpoint(metricObject.getString("server"))
                                       .interval(metricObject.getLong("interval"))
                                       .callCount(metricObject.getLong("callCount"))
                                       .errorCount(metricObject.getLong("errorCount"))
                                       .responseTime(metricObject.getLong("responseTime"))
                                       .minResponseTime(metricObject.getLong("minResponseTime"))
                                       .maxResponseTime(metricObject.getLong("maxResponseTime"))
                                       .build();
    }
}