io.trino.verifier.QueryPairMapper Maven / Gradle / Ivy

Show more of this group Show more artifacts with this name
Show all versions of trino-verifier Show documentation
There is a newer version: 451
/*
 * 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 io.trino.verifier;

import com.google.common.collect.ImmutableList;
import com.google.common.collect.ImmutableMap;
import io.airlift.json.JsonCodec;
import org.jdbi.v3.core.mapper.RowMapper;
import org.jdbi.v3.core.statement.StatementContext;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.List;
import java.util.Map;

public class QueryPairMapper
        implements RowMapper
{
    private static final JsonCodec> propertiesJsonCodec = JsonCodec.mapJsonCodec(String.class, String.class);
    private static final JsonCodec> queriesJsonCodec = JsonCodec.listJsonCodec(String.class);

    @Override
    public QueryPair map(ResultSet resultSet, StatementContext context)
            throws SQLException
    {
        Map testSessionProperties = ImmutableMap.of();
        String testSessionPropertiesJson = resultSet.getString("test_session_properties_json");
        if (testSessionPropertiesJson != null) {
            testSessionProperties = propertiesJsonCodec.fromJson(testSessionPropertiesJson);
        }

        Map controlSessionProperties = ImmutableMap.of();
        String controlSessionPropertiesJson = resultSet.getString("control_session_properties_json");
        if (controlSessionPropertiesJson != null) {
            controlSessionProperties = propertiesJsonCodec.fromJson(controlSessionPropertiesJson);
        }

        return new QueryPair(
                resultSet.getString("suite"),
                resultSet.getString("name"),
                new Query(
                        resultSet.getString("test_catalog"),
                        resultSet.getString("test_schema"),
                        fromJsonString(resultSet.getString("test_prequeries")),
                        resultSet.getString("test_query"),
                        fromJsonString(resultSet.getString("test_postqueries")),
                        resultSet.getString("test_username"),
                        resultSet.getString("test_password"),
                        testSessionProperties),
                new Query(
                        resultSet.getString("control_catalog"),
                        resultSet.getString("control_schema"),
                        fromJsonString(resultSet.getString("control_prequeries")),
                        resultSet.getString("control_query"),
                        fromJsonString(resultSet.getString("control_postqueries")),
                        resultSet.getString("control_username"),
                        resultSet.getString("control_password"),
                        controlSessionProperties));
    }

    private static List fromJsonString(String jsonString)
    {
        return jsonString == null ? ImmutableList.of() : queriesJsonCodec.fromJson(jsonString);
    }
}