/*
 * Copyright (c) 2020, WSO2 Inc. (http://www.wso2.org) All Rights Reserved.
 *
 * WSO2 Inc. 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.wso2.micro.integrator.business.messaging.hl7.store;

public class JDBCUtils {

    public static String getTableExistsQuery(String tableName) {
        return "SHOW TABLES LIKE '" + tableName + "';";
    }

    public static String getCreateTableQuery(String tableName) {
        return "CREATE TABLE " + tableName
                + " (id INT AUTO_INCREMENT, messageId VARCHAR(50), message TEXT, timestamp TIMESTAMP, PRIMARY KEY (id));";
    }

    public static String setMessage(String tableName, String messageId, String message) {
        return "INSERT INTO " + tableName + " (messageId, message) " + "VALUES (?, ?);";
    }

}
