/*
 * Licensed to the Apache Software Foundation (ASF) under one or more
 * contributor license agreements.  See the NOTICE file distributed with
 * this work for additional information regarding copyright ownership.
 * The ASF licenses this file to You 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.apache.hertzbeat.common.entity.job.protocol;

import static org.apache.hertzbeat.common.util.IpDomainUtil.validPort;
import static org.apache.hertzbeat.common.util.IpDomainUtil.validateIpDomain;

import lombok.AllArgsConstructor;
import lombok.Builder;
import lombok.Data;
import lombok.NoArgsConstructor;
import org.apache.commons.lang3.StringUtils;
import org.apache.hertzbeat.common.entity.job.SshTunnel;
import org.apache.hertzbeat.common.util.CommonUtil;

/**
 * Database configuration information implemented by the common jdbc specification
 */
@Data
@Builder
@AllArgsConstructor
@NoArgsConstructor
public class JdbcProtocol implements CommonRequestProtocol, Protocol {
    /**
     * IP ADDRESS OR DOMAIN NAME OF THE PEER HOST
     */
    private String host;
    /**
     * Port number
     */
    private String port;
    /**
     * Database user name (optional)
     */
    private String username;
    /**
     * Database Password (optional)
     */
    private String password;
    /**
     * Database
     */
    private String database;
    /**
     * TIME OUT PERIOD
     */
    private String timeout;
    /**
     * TYPE OF DATABASE mysql oracle ...
     */
    private String platform;
    /**
     * SQL query mode： oneRow, multiRow, columns, runScript
     */
    private String queryType;
    /**
     * sql
     */
    private String sql;
    /**
     * DATABASE LINK URL eg: jdbc:mysql://localhost:3306/usthe
     */
    private String url;
    /**
     * reuse connection session
     */
    private String reuseConnection = "true";
    /**
     * ssh tunnel
     */
    private SshTunnel sshTunnel;

    @Override
    public boolean isInvalid() {
        if (StringUtils.isBlank(url)) {
            if (!validateIpDomain(host) || !validPort(port)) {
                return true;
            }
        }
        if (StringUtils.isNotBlank(timeout) && !CommonUtil.isNumeric(timeout)) {
            return true;
        }
        if (StringUtils.isNotBlank(reuseConnection)
                && !"true".equalsIgnoreCase(reuseConnection)
                && !"false".equalsIgnoreCase(reuseConnection)) {
            return true;
        }
        return false;
    }
}
